CREATE TABLE `Entity` (
	`Id` int,
	`Name` varchar(255),
	`TypeId` int,
	FOREIGN KEY(`TypeId`) REFERENCES `EntityType` (`Id`)
);
CREATE TABLE `State` (
	`Id` int,
	`Name` varchar(255),
	`EntityTypeId` int,
	FOREIGN KEY(`EntityTypeId`) REFERENCES `EntityType` (`Id`)
);
CREATE TABLE `EntityType` (
	`Id` int PRIMARY KEY,
	`Name` varchar(255)
);
CREATE TABLE `StartState` (
	`StateId` int PRIMARY KEY,
	FOREIGN KEY(`StateId`) REFERENCES `State` (`Id`)
);
CREATE TABLE `DecisionState` (
	`StateId` int PRIMARY KEY,
	`TrueStateId` int,
	`FalseStateId` int,
	`DecisionExpression` varchar(255),
	FOREIGN KEY(`StateId`) REFERENCES `State` (`Id`),
	FOREIGN KEY(`TrueStateId`) REFERENCES `State` (`Id`),
	FOREIGN KEY(`FalseStateId`) REFERENCES `State` (`Id`)
);
CREATE TABLE `SimpleState` (
	`StateId` int PRIMARY KEY,
	`NextStateId` int,
	FOREIGN KEY(`StateId`) REFERENCES `State` (`Id`),
	FOREIGN KEY(`NextStateId`) REFERENCES `State` (`Id`)
);
CREATE TABLE `LifePath` (
	`Id` int PRIMARY KEY,
	`EntityId` int,
	`StateId` int,
	`ParentStateId` int,
	FOREIGN KEY(`EntityId`) REFERENCES `Entity` (`Id`),
	FOREIGN KEY(`StateId`) REFERENCES `State` (`Id`),
	FOREIGN KEY(`ParentStateId`) REFERENCES `LifePath` (`Id`)
);