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 97 98 99
|
CREATE TABLE `compte_bancaire` (
`id_cb` tinyint(3) unsigned NOT NULL auto_increment,
`nom_complet_cb` varchar(150) NOT NULL default '',
`nom_abrege_cb` varchar(20) NOT NULL default '',
`solde_initial_cb` decimal(10,2) NOT NULL default '0.00',
`device_cb` tinyint(1) NOT NULL default '0',
`swift_code` varchar(20) NOT NULL default '',
`iban` varchar(50) NOT NULL default '',
`aba` varchar(9) NOT NULL default '',
`numero_compte` varchar(15) NOT NULL default '',
`rib` varchar(50) NOT NULL default '',
`booking_affichage` enum('Y','N') NOT NULL default 'N',
`banque_id` tinyint(2) unsigned NOT NULL default '0',
PRIMARY KEY (`id_cb`),
KEY `device_cb` (`device_cb`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;
--
-- Structure de la table `t_operation`
--
CREATE TABLE `t_operation` (
`id_operation` int(11) unsigned NOT NULL auto_increment,
`OperLibelle` varchar(50) NOT NULL,
`OperationDateValeur` date NOT NULL,
`cb_id` tinyint(3) unsigned NOT NULL,
PRIMARY KEY (`id_operation`),
KEY `cb_id` (`cb_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Contraintes pour les tables exportees
--
--
-- Contraintes pour la table `t_operation`
--
ALTER TABLE `t_operation`
ADD CONSTRAINT `t_operation_ibfk_1` FOREIGN KEY (`cb_id`) REFERENCES `compte_bancaire` (`id_cb`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Structure de la table `operation_sans_ventillation`
--
CREATE TABLE `operation_sans_ventillation` (
`id_operation` int(11) unsigned NOT NULL auto_increment,
`categorie_id` smallint(6) unsigned NOT NULL,
`operation_montant` decimal(10,2) NOT NULL,
PRIMARY KEY (`id_operation`),
KEY `categorie_id` (`categorie_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Contraintes pour les tables exportees
--
--
-- Contraintes pour la table `operation_sans_ventillation`
--
ALTER TABLE `operation_sans_ventillation`
ADD CONSTRAINT `operation_sans_ventillation_ibfk_1` FOREIGN KEY (`id_operation`) REFERENCES `t_operation` (`id_operation`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `operation_sans_ventillation_ibfk_2` FOREIGN KEY (`categorie_id`) REFERENCES `categorie` (`id_categorie`) ON DELETE NO ACTION ON UPDATE CASCADE;
--
-- Structure de la table `t_detail_operation`
--
CREATE TABLE `t_detail_operation` (
`id_detail_operation` int(11) unsigned NOT NULL auto_increment,
`categorie_id` smallint(6) unsigned NOT NULL,
`operation_id` int(10) unsigned NOT NULL,
`do_montant` decimal(10,2) NOT NULL,
`do_note` varchar(100) NOT NULL,
PRIMARY KEY (`id_detail_operation`),
KEY `operation_id` (`operation_id`),
KEY `categorie_id` (`categorie_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Contraintes pour les tables exportees
--
--
-- Contraintes pour la table `t_detail_operation`
--
ALTER TABLE `t_detail_operation`
ADD CONSTRAINT `t_detail_operation_ibfk_1` FOREIGN KEY (`categorie_id`) REFERENCES `categorie` (`id_categorie`) ON DELETE NO ACTION ON UPDATE CASCADE,
ADD CONSTRAINT `t_detail_operation_ibfk_2` FOREIGN KEY (`operation_id`) REFERENCES `t_operation` (`id_operation`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Structure de la table `categorie`
--
CREATE TABLE `categorie` (
`id_categorie` smallint(6) unsigned NOT NULL auto_increment,
`nom_categorie` varchar(100) NOT NULL,
PRIMARY KEY (`id_categorie`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
Partager