CREATE TABLE `llx_rendez_vous_cahier_des_charges` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_projet` int(11) DEFAULT NULL,
  `fk_source_cdc` int(11) DEFAULT NULL,
  `fk_statut` int(11) DEFAULT NULL,
  `version` varchar(100) DEFAULT NULL,
  `date_creation` datetime DEFAULT NULL,
  `date_demo` datetime DEFAULT NULL,
  `date_livraison` datetime DEFAULT NULL,
  `nb_rdv_amont` varchar(100) DEFAULT NULL,
  `nb_rdv_aval` varchar(100) DEFAULT NULL,
  `nb_jours_formations` varchar(100) DEFAULT NULL,
  `intro_contexte_projet` mediumtext DEFAULT NULL,
  `intro_objectifs_globaux` mediumtext DEFAULT NULL,
  `intro_presentation_client` mediumtext DEFAULT NULL,
  `perimetre_projet_delimitation` mediumtext DEFAULT NULL,
  `perimetre_projet_def_processus` mediumtext DEFAULT NULL,
  `besoins_processus_par_site` mediumtext DEFAULT NULL,
  `besoins_fonctionnels_user` mediumtext DEFAULT NULL,
  `architecture_solutions` mediumtext DEFAULT NULL,
  `architecture_modules` mediumtext DEFAULT NULL,
  `architecture_infrastructure` mediumtext DEFAULT NULL,
  `process_av_vente` mediumtext DEFAULT NULL,
  `flux_logistiques` mediumtext DEFAULT NULL,
  `prod_et_qualite` mediumtext DEFAULT NULL,
  `commandes_et_expeditions` mediumtext DEFAULT NULL,
  `creation_recettes` mediumtext DEFAULT NULL,
  `reporting_analyse` mediumtext DEFAULT NULL,
  `ux_roles` mediumtext DEFAULT NULL,
  `ux_interfaces` mediumtext DEFAULT NULL,
  `ux_kpi_client` mediumtext DEFAULT NULL,
  `formation_programme` mediumtext DEFAULT NULL,
  `formation_documentation` mediumtext DEFAULT NULL,
  `maintenance_support` mediumtext DEFAULT NULL,
  `maintenance_mises_a_jour` mediumtext DEFAULT NULL,
  `deploiement_calendrier` mediumtext DEFAULT NULL,
  `deploiement_jalons` mediumtext DEFAULT NULL,
  `succes_kpi` mediumtext DEFAULT NULL,
  `succes_suivi` mediumtext DEFAULT NULL,
  `budget_previsionnel` mediumtext DEFAULT NULL,
  `modifs_recommandations` mediumtext DEFAULT NULL,
  `mentions_confidentialite` mediumtext DEFAULT NULL,
  `mentions_propriete` mediumtext DEFAULT NULL,
  `mentions_conditions_modification` mediumtext DEFAULT NULL,
  `model_pdf` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `llx_rendez_vous_cahier_des_charges_llx_projet_FK` (`fk_projet`),
  CONSTRAINT `llx_rendez_vous_cahier_des_charges_llx_projet_FK` FOREIGN KEY (`fk_projet`) REFERENCES `llx_projet` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;