CREATE TABLE `llx_rendez_vous` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_soc` int(11) DEFAULT NULL,
  `fk_projet` int(11) DEFAULT NULL,
  `fk_statut` int(11) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `numero` int(11) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `date_demo` datetime DEFAULT NULL,
  `date_livraison` datetime DEFAULT NULL,
  `hebergement` mediumtext DEFAULT NULL,
  `objet` varchar(255) DEFAULT NULL,
  `objectif_client` mediumtext DEFAULT NULL,
  `besoin_client` mediumtext DEFAULT NULL,
  `reponse_besoin_client` mediumtext DEFAULT NULL,
  `compte_rendu` mediumtext DEFAULT NULL,
  `model_pdf` varchar(255) DEFAULT NULL,
  `datec` timestamp NOT NULL DEFAULT current_timestamp(),
  `fk_user` int(11) DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `llx_rendez_vous_llx_user_FK` (`fk_user`),
  KEY `llx_rendez_vous_llx_projet_FK` (`fk_projet`),
  CONSTRAINT `llx_rendez_vous_llx_projet_FK` FOREIGN KEY (`fk_projet`) REFERENCES `llx_projet` (`rowid`),
  CONSTRAINT `llx_rendez_vous_llx_user_FK` FOREIGN KEY (`fk_user`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;