 CREATE TABLE `pdc_client` (
  `id_prisme` int(11) unsigned DEFAULT NULL COMMENT 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX',
  `id_client_partenaire` varchar(50) DEFAULT NULL COMMENT 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX',
  `collaborateur` int(11) unsigned DEFAULT NULL,
  `nom` varchar(50) DEFAULT NULL,
  `prenom` varchar(50) DEFAULT NULL,
  `civilite` varchar(10) DEFAULT NULL,
  `adresse` varchar(150) DEFAULT NULL,
  `adresse2` varchar(150) DEFAULT NULL,
  `cp` varchar(10) DEFAULT NULL,
  `ville` varchar(50) DEFAULT NULL,
  `pays` varchar(25) DEFAULT NULL,
  `partenaire` int(11) unsigned NOT NULL,
  `cgp` int(11) unsigned NOT NULL,
  `date_naissance` date DEFAULT NULL,
  `affiche_sans_situs` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX',
  UNIQUE KEY `id_client_partenaire_2` (`id_client_partenaire`,`partenaire`,`cgp`),
  KEY `id_prisme` (`id_prisme`),
  KEY `cgp` (`cgp`),
  KEY `partenaire` (`partenaire`),
  KEY `collaborateur` (`collaborateur`),
  CONSTRAINT `pdc_client_ibfk_1` FOREIGN KEY (`cgp`) REFERENCES `cgp` (`id`),
  CONSTRAINT `pdc_client_ibfk_2` FOREIGN KEY (`partenaire`) REFERENCES `partenaires` (`id`),
  CONSTRAINT `pdc_client_ibfk_3` FOREIGN KEY (`collaborateur`) REFERENCES `collaborateur` (`id`),
  CONSTRAINT `pdc_client_ibfk_4` FOREIGN KEY (`id_prisme`) REFERENCES `personne` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
