1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96
| -- -----------------------------------------------------
-- Table `Compte`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Compte` (
`CompteId` INT NOT NULL ,
`CompteTitulaire` VARCHAR(45) NOT NULL ,
PRIMARY KEY (`CompteId`) )
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `Operation`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Operation` (
`OperId` INT NOT NULL ,
`CompteId` INT NOT NULL ,
`OprLibelle` VARCHAR(45) NOT NULL ,
`OperDateValeur` DATE NOT NULL ,
PRIMARY KEY (`OperId`) ,
INDEX `Operation_Compte_fk` (`CompteId` ASC) ,
CONSTRAINT `Operation_Compte_fk`
FOREIGN KEY (`CompteId` )
REFERENCES `Compte` (`CompteId` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `CategorieNoeud`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `CategorieNoeud` (
`CategNoeudId` INT NOT NULL ,
`CategNom` VARCHAR(45) NOT NULL ,
PRIMARY KEY (`CategNoeudId`) )
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `OprSansVentil`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `OprSansVentil` (
`OperId` INT NOT NULL ,
`OperMontant` INT NOT NULL ,
`CategNoeudId` INT NOT NULL ,
PRIMARY KEY (`OperId`) ,
INDEX `OprSansVentil_Operation_fk1` (`OperId` ASC) ,
INDEX `OprSansVentil_CategorieNoeud_fk1` (`CategNoeudId` ASC) ,
CONSTRAINT `OprSansVentil_Operation_fk1`
FOREIGN KEY (`OperId` )
REFERENCES `Operation` (`OperId` )
ON DELETE CASCADE
ON UPDATE NO ACTION,
CONSTRAINT `OprSansVentil_CategorieNoeud_fk1`
FOREIGN KEY (`CategNoeudId` )
REFERENCES `CategorieNoeud` (`CategNoeudId` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `DetailOper`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `DetailOper` (
`OperId` INT NOT NULL ,
`DetailId` VARCHAR(45) NOT NULL ,
`DetailMontant` INT NOT NULL ,
`DetailNote` VARCHAR(45) NOT NULL ,
`CategNoeudId` INT NOT NULL ,
PRIMARY KEY (`DetailId`, `OperId`) ,
INDEX `DetailOper_Operation_fk1` (`OperId` ASC) ,
INDEX `DetailOper_CategorieNoeud_fk1` (`CategNoeudId` ASC) ,
CONSTRAINT `DetailOper_Operation_fk1`
FOREIGN KEY (`OperId` )
REFERENCES `Operation` (`OperId` )
ON DELETE CASCADE
ON UPDATE NO ACTION,
CONSTRAINT `DetailOper_CategorieNoeud_fk1`
FOREIGN KEY (`CategNoeudId` )
REFERENCES `CategorieNoeud` (`CategNoeudId` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `SousCategorie`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `SousCategorie` (
`CategNoeudId` INT NOT NULL ,
`CategParenteId` INT NOT NULL ,
PRIMARY KEY (`CategNoeudId`) ,
INDEX `SousCategorie_CategorieNoeud_fk1` (`CategNoeudId` ASC) ,
INDEX `SousCategorie_CategorieNoeud_fk2` (`CategParenteId` ASC) ,
CONSTRAINT `SousCategorie_CategorieNoeud_fk1`
FOREIGN KEY (`CategNoeudId` )
REFERENCES `CategorieNoeud` (`CategNoeudId` )
ON DELETE CASCADE
ON UPDATE NO ACTION,
CONSTRAINT `SousCategorie_CategorieNoeud_fk2`
FOREIGN KEY (`CategParenteId` )
REFERENCES `CategorieNoeud` (`CategNoeudId` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB; |
Partager