ExPT8Zjn

1CREATE TABLE IF NOT EXISTS `Item_To_Item` (
2  `id` INT(11) NOT NULL AUTO_INCREMENT,
3  `item1_id` INT(11) NOT NULL,
4  `item2_id` INT(11) NOT NULL,
5  `relationship` ENUM('requires', 'mutually_requires', 'required_by', 'relates', 'excludes') NULL DEFAULT NULL,
6  `description` VARCHAR(1000) NULL DEFAULT NULL,
7  PRIMARY KEY (`id`),
8  CONSTRAINT `fk_Item1_Id`
9    FOREIGN KEY (`item1_id`)
10    REFERENCES `Item` (`id`)
11  CONSTRAINT `fk_Item2_Id`
12    FOREIGN KEY (`item2_id`)
13    REFERENCES `Item` (`id`)
14	
15CREATE TABLE IF NOT EXISTS `Relationship` (
16  `id` INT(11) NOT NULL AUTO_INCREMENT,
17  `relater_id` INT(11) NOT NULL,
18  `relatee_id` INT(11) NOT NULL,
19  `relationship` ENUM('requires', 'mutually_requires', 'required_by', 'relates', 'excludes') NULL DEFAULT NULL,
20  `description` VARCHAR(1000) NULL DEFAULT NULL,
21  `relater_type_id` INT(11) NULL,
22  `relatee_type_id` INT(11) NULL,
23  PRIMARY KEY (`id`),
24  INDEX `fk_Relatee_Id` (`relatee_id` ASC),
25  INDEX `fk_Relater_Id` (`relater_id` ASC),
26  CONSTRAINT `fk_Relater_Id`
27    FOREIGN KEY (`relater_id`)
28  CONSTRAINT `fk_Relatee_Id`
29    FOREIGN KEY (`relatee_id`)