bonjour,
je suis étudiant en bts IG option développeur d'application. je voudrais pour les besoins de ma note de synthèse modeliser un site d'e-commerce avec Mérise.
Voici le schéma de ma base de données, mon problème est que j'ai du mal à passer du MLD au MCD.
Je vous remercie pour l'intérêt que vous voudrez porter à ma question
-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Mardi 04 Avril 2006 à 14:37
-- Version du serveur: 4.1.9
-- Version de PHP: 4.3.10
--
-- Base de données: `boutique`
--
-- --------------------------------------------------------
--
-- Structure de la table `bt_adm_menus`
--
CREATE TABLE `bt_adm_menus` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`langue` char(2) NOT NULL default 'fr',
`code` varchar(10) NOT NULL default '',
`libel` varchar(200) NOT NULL default '',
`description` mediumtext NOT NULL,
`programme` varchar(200) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `code` (`code`),
KEY `langue` (`langue`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
-- --------------------------------------------------------
--
-- Structure de la table `bt_categories`
--
CREATE TABLE `bt_categories` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`code` varchar(20) NOT NULL default '',
`libel` varchar(200) NOT NULL default '',
`langue` char(2) NOT NULL default 'fr',
`description` text NOT NULL,
`keywords` text NOT NULL,
PRIMARY KEY (`id`),
KEY `libel` (`libel`),
KEY `langue` (`langue`),
KEY `code` (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
-- --------------------------------------------------------
--
-- Structure de la table `bt_clients`
--
CREATE TABLE `bt_clients` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`nom` varchar(50) NOT NULL default '',
`prenom` varchar(50) NOT NULL default '',
`adresse` varchar(150) NOT NULL default '',
`adresse2` varchar(150) NOT NULL default '',
`code_postal` varchar(50) NOT NULL default '',
`ville` varchar(50) NOT NULL default '',
`etat` varchar(50) NOT NULL default '',
`pays` varchar(50) NOT NULL default '',
`code_pays` char(2) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`tel` varchar(50) NOT NULL default '',
`mot_passe` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `nom` (`nom`),
KEY `email` (`email`),
KEY `code_pays` (`code_pays`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Structure de la table `bt_commandes`
--
CREATE TABLE `bt_commandes` (
`id` int(10) unsigned NOT NULL auto_increment,
`dt` datetime NOT NULL default '0000-00-00 00:00:00',
`client_id` mediumint(8) unsigned NOT NULL default '0',
`montant_ht` double(16,4) unsigned NOT NULL default '0.0000',
`montant_ttc` double(16,2) unsigned NOT NULL default '0.00',
`mode_reglement` tinyint(3) unsigned NOT NULL default '0',
`mode_transport` tinyint(3) unsigned NOT NULL default '0',
`dt_paiement` date NOT NULL default '0000-00-00',
`statut` tinyint(4) NOT NULL default '0',
`livraison_nom` varchar(20) NOT NULL default '',
`livraison_prenom` varchar(20) NOT NULL default '',
`livraison_adr1` varchar(200) NOT NULL default '',
`livraison_adr2` varchar(200) NOT NULL default '',
`livraison_cp` varchar(10) NOT NULL default '',
`livraison_ville` varchar(20) NOT NULL default '',
`livraison_code_pays` char(2) NOT NULL default '',
`livraison_etat` varchar(20) NOT NULL default '',
`livraison_pays` varchar(20) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `dt` (`dt`),
KEY `client_id` (`client_id`),
KEY `statut` (`statut`),
KEY `livraison_code_pays` (`livraison_code_pays`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;
-- --------------------------------------------------------
--
-- Structure de la table `bt_commandes_details`
--
CREATE TABLE `bt_commandes_details` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`cde_id` mediumint(8) unsigned NOT NULL default '0',
`prd_id` mediumint(8) unsigned NOT NULL default '0',
`libel` varchar(250) NOT NULL default '',
`prix_ht` float(10,2) unsigned NOT NULL default '0.00',
`prix_ttc` float(10,2) unsigned NOT NULL default '0.00',
`quantite` mediumint(9) NOT NULL default '0',
`date_livraison` date default NULL,
PRIMARY KEY (`id`),
KEY `cde_id` (`cde_id`),
KEY `prd_id` (`prd_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;
-- --------------------------------------------------------
--
-- Structure de la table `bt_devises`
--
CREATE TABLE `bt_devises` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`devise` char(3) NOT NULL default '',
`cours` double NOT NULL default '0',
`dt` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `devise` (`devise`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structure de la table `bt_fournisseurs`
--
CREATE TABLE `bt_fournisseurs` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`nom` varchar(50) NOT NULL default '',
`adresse` text NOT NULL,
`code_postal` varchar(10) NOT NULL default '',
`ville` varchar(20) NOT NULL default '',
`pays` varchar(20) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`tel_fixe` varchar(15) NOT NULL default '',
`tel_mobile` varchar(15) NOT NULL default '',
`contact` varchar(20) NOT NULL default '',
`notes` mediumtext NOT NULL,
PRIMARY KEY (`id`),
KEY `nom` (`nom`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=47 ;
-- --------------------------------------------------------
--
-- Structure de la table `bt_panier`
--
CREATE TABLE `bt_panier` (
`id` int(10) unsigned NOT NULL auto_increment,
`sid` varchar(50) NOT NULL default '',
`prd_id` mediumint(8) unsigned NOT NULL default '0',
`libel` varchar(250) NOT NULL default '',
`prix_ht` float(10,2) unsigned NOT NULL default '0.00',
`prix_ttc` float(10,2) unsigned NOT NULL default '0.00',
`quantite` mediumint(8) unsigned NOT NULL default '0',
`date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`poids` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `sid` (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=39 ;
-- --------------------------------------------------------
--
-- Structure de la table `bt_parametres`
--
CREATE TABLE `bt_parametres` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`code` varchar(50) NOT NULL default '',
`langue` char(2) NOT NULL default '',
`valeur` mediumtext NOT NULL,
`infos` mediumtext NOT NULL,
PRIMARY KEY (`id`),
KEY `code` (`code`),
KEY `langue` (`langue`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
-- --------------------------------------------------------
--
-- Structure de la table `bt_pays`
--
CREATE TABLE `bt_pays` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`code` char(2) NOT NULL default '',
`pays` varchar(50) NOT NULL default '',
`langue` char(2) NOT NULL default 'fr',
`zone` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `code` (`code`),
KEY `pays` (`pays`),
KEY `langue` (`langue`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=244 ;
-- --------------------------------------------------------
--
-- Structure de la table `bt_prd_categories`
--
CREATE TABLE `bt_prd_categories` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`prd_id` mediumint(8) unsigned NOT NULL default '0',
`code_cat` varchar(20) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `prd_id` (`prd_id`),
KEY `code_cat` (`code_cat`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;
-- --------------------------------------------------------
--
-- Structure de la table `bt_prd_description`
--
CREATE TABLE `bt_prd_description` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`prd_id` mediumint(8) unsigned NOT NULL default '0',
`langue` char(2) NOT NULL default 'fr',
`libel` varchar(200) NOT NULL default '',
`description` mediumtext NOT NULL,
`keywords` mediumtext NOT NULL,
PRIMARY KEY (`id`),
KEY `prd_id` (`prd_id`),
KEY `langue` (`langue`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
-- --------------------------------------------------------
--
-- Structure de la table `bt_prd_index`
--
CREATE TABLE `bt_prd_index` (
`prd_id` mediumint(8) unsigned NOT NULL default '0',
`texte` text NOT NULL,
PRIMARY KEY (`prd_id`),
FULLTEXT KEY `texte` (`texte`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `bt_prd_infos`
--
CREATE TABLE `bt_prd_infos` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`prd_id` mediumint(8) unsigned NOT NULL default '0',
`cle` varchar(20) NOT NULL default '',
`texte` mediumtext NOT NULL,
PRIMARY KEY (`id`),
KEY `cle` (`cle`),
KEY `prd_id` (`prd_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structure de la table `bt_prd_photos`
--
CREATE TABLE `bt_prd_photos` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`prd_id` mediumint(8) unsigned NOT NULL default '0',
`nom` varchar(50) NOT NULL default '',
`largeur` smallint(5) unsigned NOT NULL default '0',
`hauteur` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `prd_id` (`prd_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
-- --------------------------------------------------------
--
-- Structure de la table `bt_produits`
--
CREATE TABLE `bt_produits` (
`prd_id` mediumint(8) unsigned NOT NULL auto_increment,
`date_entree` date NOT NULL default '0000-00-00',
`reference` varchar(20) default NULL,
`id_fourn` mediumint(8) unsigned NOT NULL default '0',
`ref_fourn` varchar(30) default NULL,
`prix_ht` float(10,2) unsigned NOT NULL default '0.00',
`prix_ttc` float(10,2) unsigned NOT NULL default '0.00',
`prix_promo` float(10,2) unsigned NOT NULL default '0.00',
`stock` mediumint(8) unsigned NOT NULL default '0',
`stock_mini` mediumint(8) unsigned NOT NULL default '0',
`delai` varchar(150) NOT NULL default '',
`poids` mediumint(8) unsigned NOT NULL default '0',
`taux_tva` tinyint(3) unsigned NOT NULL default '1',
`actif` tinyint(3) unsigned NOT NULL default '1',
`ventes` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`prd_id`),
KEY `date_entree` (`date_entree`),
KEY `actif` (`actif`),
KEY `ventes` (`ventes`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
-- --------------------------------------------------------
--
-- Structure de la table `bt_stats_trafic`
--
CREATE TABLE `bt_stats_trafic` (
`id` int(10) unsigned NOT NULL auto_increment,
`langue` char(2) NOT NULL default '',
`dt` datetime default NULL,
`ip` varchar(25) NOT NULL default '',
`referer` varchar(250) NOT NULL default '',
`page` varchar(250) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `ip` (`ip`),
KEY `referer` (`referer`),
KEY `page` (`page`),
KEY `dt` (`dt`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=623 ;
-- --------------------------------------------------------
--
-- Structure de la table `bt_statuts`
--
CREATE TABLE `bt_statuts` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`statut` tinyint(3) unsigned NOT NULL default '0',
`langue` char(2) NOT NULL default 'fr',
`libel` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `statut` (`statut`),
KEY `langue` (`langue`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
-- --------------------------------------------------------
--
-- Structure de la table `bt_tarifs_port`
--
CREATE TABLE `bt_tarifs_port` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`zone` mediumint(8) unsigned NOT NULL default '0',
`mode_transport` mediumint(8) unsigned NOT NULL default '0',
`poids_mini` mediumint(8) unsigned NOT NULL default '0',
`tarif` float(10,2) NOT NULL default '0.00',
PRIMARY KEY (`id`),
KEY `zone` (`zone`),
KEY `mode_transport` (`mode_transport`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
-- --------------------------------------------------------
--
-- Structure de la table `bt_zones`
--
CREATE TABLE `bt_zones` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`nom` varchar(20) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
Partager