CREATE TABLE `llx_rendez_vous_cdc_suivi_adm` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_rendez_vous_suivi_adm` int(11) NOT NULL DEFAULT 0,
  `fk_cahier_des_charges` int(11) NOT NULL,
  `intitule` varchar(500) DEFAULT NULL,
  `delais_alerte` int(11) NOT NULL,
  `delais_alerte_end` int(11) NOT NULL,
  `mandatory_file` int(11) NOT NULL DEFAULT 0,
  `file_name` mediumtext DEFAULT NULL,
  `indice` int(11) NOT NULL,
  `level_rank` int(11) NOT NULL DEFAULT 0,
  `fk_parent_level` int(11) DEFAULT 0,
  `dated` datetime DEFAULT NULL,
  `datef` datetime NOT NULL,
  `notes` mediumtext NOT NULL,
  `fk_user_author` int(11) NOT NULL,
  `datec` datetime NOT NULL,
  `fk_user_mod` int(11) NOT NULL,
  `tms` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `archive` smallint(6) NOT NULL DEFAULT 0,
  PRIMARY KEY (`rowid`),
  KEY `fk_cahier_des_charges` (`fk_cahier_des_charges`),
  KEY `fk_rendez_vous_suivi_adm` (`fk_rendez_vous_suivi_adm`),
  CONSTRAINT `fk_cahier_des_charges` FOREIGN KEY (`fk_cahier_des_charges`) REFERENCES `llx_rendez_vous_cahier_des_charges` (`rowid`),
  CONSTRAINT `fk_rendez_vous_suivi_adm` FOREIGN KEY (`fk_rendez_vous_suivi_adm`) REFERENCES `llx_rendez_vous_suivi_adm` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;