· 7 years ago · Nov 18, 2018, 08:24 PM
1CREATE TABLE IF NOT EXISTS `beerdata`.`intersect_beer_brewery` (
2 `beerid` VARCHAR(36) NOT NULL,
3 `breweryid` VARCHAR(36) NOT NULL,
4 `beerbreweryid` VARCHAR(36) NOT NULL,
5 PRIMARY KEY (`beerbreweryid`),
6 UNIQUE INDEX `unique_contraint` (`beerid` ASC, `breweryid` ASC) VISIBLE,
7 CONSTRAINT `beerid_fk`
8 FOREIGN KEY (`beerid` , `beerid` , `beerid` , `beerid` , `beerid` , `beerid` , `beerid` , `beerid` , `beerid`)
9 REFERENCES `beerdata`.`beers` (`beerid` , `beerid` , `beerid` , `beerid` , `beerid` , `beerid` , `beerid` , `beerid` , `beerid`)
10 ON DELETE CASCADE
11 ON UPDATE NO ACTION)