h3DBDXKT

1 -----------------------------------------------------
2-- Table `adapptrRetail`.`tbl_account`
3-- -----------------------------------------------------
4DROP TABLE IF EXISTS `adapptrRetail`.`tbl_account` ;
5
6CREATE  TABLE IF NOT EXISTS `adapptrRetail`.`tbl_account` (
7  `id` INT NOT NULL AUTO_INCREMENT ,
8  `name` VARCHAR(45) NULL ,
9  PRIMARY KEY (`id`) )
10ENGINE = InnoDB;
11
12
13
14
15
16-- -----------------------------------------------------
17-- Table `adapptrRetail`.`tbl_brand`
18-- -----------------------------------------------------
19DROP TABLE IF EXISTS `adapptrRetail`.`tbl_brand` ;
20
21CREATE  TABLE IF NOT EXISTS `adapptrRetail`.`tbl_brand` (
22  `id` INT NOT NULL AUTO_INCREMENT ,
23  `name` VARCHAR(45) NOT NULL ,
24  `account_id` INT NOT NULL ,
25  PRIMARY KEY (`id`) ,
26  INDEX `PK_account_id` (`account_id` ASC) ,
27  CONSTRAINT `PK_account_id`
28    FOREIGN KEY (`account_id` )
29    REFERENCES `adapptrRetail`.`tbl_account` (`id` )
30    ON DELETE NO ACTION
31    ON UPDATE NO ACTION)
32ENGINE = InnoDB;
33
34
35-- -----------------------------------------------------
36-- Table `adapptrRetail`.`tbl_product`
37-- -----------------------------------------------------
38DROP TABLE IF EXISTS `adapptrRetail`.`tbl_product` ;
39
40CREATE  TABLE IF NOT EXISTS `adapptrRetail`.`tbl_product` (
41  `id` INT NOT NULL AUTO_INCREMENT ,
42  `name` VARCHAR(45) NULL ,
43  PRIMARY KEY (`id`) )
44ENGINE = InnoDB;
45
46
47-- -----------------------------------------------------
48-- Table `adapptrRetail`.`tbl_productToBrand`
49-- -----------------------------------------------------
50DROP TABLE IF EXISTS `adapptrRetail`.`tbl_productToBrand` ;
51
52CREATE  TABLE IF NOT EXISTS `adapptrRetail`.`tbl_productToBrand` (
53  `product_id` INT NOT NULL ,
54  `brand_id` INT NOT NULL ,
55  PRIMARY KEY (`product_id`, `brand_id`) ,
56  INDEX `FK_brand_id` (`brand_id` ASC) ,
57  INDEX `FK_product_id` (`product_id` ASC) ,
58  CONSTRAINT `FK_product_id`
59    FOREIGN KEY (`product_id` )
60    REFERENCES `adapptrRetail`.`tbl_product` (`id` )
61    ON DELETE NO ACTION
62    ON UPDATE NO ACTION,
63  CONSTRAINT `FK_brand_id`
64    FOREIGN KEY (`brand_id` )
65    REFERENCES `adapptrRetail`.`tbl_brand` (`id` )
66    ON DELETE NO ACTION
67    ON UPDATE NO ACTION)
68ENGINE = InnoDB;