isE4ky6F

1CREATE TABLE IF NOT EXISTS `mydb`.`Event` (
2  `eventId` INT NOT NULL AUTO_INCREMENT,
3  `timestamp` DATETIME NOT NULL,
4  `comment` VARCHAR(45) NULL,
5  `eventTypeId` INT NOT NULL,
6  `amount` INT NULL,
7  `productId` INT NULL,
8  `duration` INT NULL,
9  `activityTypeId` INT NULL,
10  `userId` INT NOT NULL,
11  PRIMARY KEY (`eventId`),
12  INDEX `fk_eventTypeId_idx` (`eventTypeId` ASC),
13  INDEX `fk_userId_idx` (`userId` ASC),
14  INDEX `fk_activityTypeId_idx` (`activityTypeId` ASC),
15  INDEX `fk_productId_idx` (`productId` ASC),
16  CONSTRAINT `fk_productId`
17    FOREIGN KEY (`productId`)
18    REFERENCES `mydb`.`Product` (`productId`)
19    ON DELETE NO ACTION
20    ON UPDATE NO ACTION,
21  CONSTRAINT `fk_activityTypeId`
22    FOREIGN KEY (`activityTypeId`)
23    REFERENCES `mydb`.`ActivityType` (`activityTypeId`)
24    ON DELETE NO ACTION
25    ON UPDATE NO ACTION,
26  CONSTRAINT `fk_userId`
27    FOREIGN KEY (`userId`)
28    REFERENCES `mydb`.`User` (`userId`)
29    ON DELETE NO ACTION
30    ON UPDATE NO ACTION,
31  CONSTRAINT `fk_eventTypeId`
32    FOREIGN KEY (`eventTypeId`)
33    REFERENCES `mydb`.`EventType` (`eventTypeId`)
34    ON DELETE NO ACTION
35    ON UPDATE NO ACTION)
36ENGINE = InnoDB;