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
| CREATE TABLE IF NOT EXISTS `agence` (
`ID_AGENCE` int(11) NOT NULL AUTO_INCREMENT,
`tel_agence` varchar(255) DEFAULT NULL,
`nom_agence` varchar(255) DEFAULT NULL,
`adresse_agence` varchar(255) DEFAULT NULL,
`num_agence` varchar(255) DEFAULT NULL,
`fax_agence` varchar(50) DEFAULT NULL,
`email_agence` varchar(50) DEFAULT NULL,
`rpe_agence` varchar(50) DEFAULT NULL,
PRIMARY KEY (`ID_AGENCE`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=131 ;
CREATE TABLE IF NOT EXISTS `budget` (
`ID_BUDGET` int(11) NOT NULL AUTO_INCREMENT,
`nbre_dep` int(11) DEFAULT NULL,
`risque_associe` varchar(255) DEFAULT NULL,
`Agence_id_Agence` int(11) DEFAULT NULL,
PRIMARY KEY (`ID_BUDGET`),
KEY `FK_budget_Agence_id_Agence` (`Agence_id_Agence`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
CREATE TABLE IF NOT EXISTS `credit` (
`IDCREDIT` int(11) NOT NULL AUTO_INCREMENT,
`TR30` float DEFAULT NULL,
`risque_associe` varchar(255) DEFAULT NULL,
`TR180` float DEFAULT NULL,
`TR90` float DEFAULT NULL,
`TPC` float DEFAULT NULL,
`Agence_id_Agence` int(11) DEFAULT NULL,
PRIMARY KEY (`IDCREDIT`),
KEY `FK_credit_Agence_id_Agence` (`Agence_id_Agence`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; |
Partager