SERVEUR

   Tables: Détails  
    Views: Détails  
   Tables & Views: Liste  
   Records  
  Actions  
  Files
TABLES: Détails
  1. activites
    2. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    act_type ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    act_type_code ~ Type: double | Null: YES | Key: | Default: | Extra:
    act_datedu ~ Type: date | Null: YES | Key: | Default: | Extra:
    act_dateau ~ Type: date | Null: YES | Key: | Default: | Extra:
    act_lieu ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    act_titre ~ Type: varchar(255) | Null: NO | Key: | Default: | Extra:
    act_descrip ~ Type: text | Null: YES | Key: | Default: | Extra:
    act_fichier ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    act_agenda ~ Type: float | Null: YES | Key: | Default: 1 | Extra:
    act_img1 ~ Type: varchar(255) | Null: YES | Key: | Default: sineph_pas_img.png | Extra:
    act_img2 ~ Type: varchar(255) | Null: YES | Key: | Default: sineph_pas_img.png | Extra:
    act_img3 ~ Type: varchar(255) | Null: YES | Key: | Default: sineph_pas_img.png | Extra:
    act_img4 ~ Type: varchar(255) | Null: YES | Key: | Default: sineph_pas_img.png | Extra:
    act_img5 ~ Type: varchar(255) | Null: YES | Key: | Default: sineph_pas_img.png | Extra:
    act_img6 ~ Type: varchar(255) | Null: YES | Key: | Default: sineph_pas_img.png | Extra:
    act_img7 ~ Type: varchar(255) | Null: YES | Key: | Default: sineph_pas_img.png | Extra:
    act_img8 ~ Type: varchar(255) | Null: YES | Key: | Default: sineph_pas_img.png | Extra:
    act_img9 ~ Type: varchar(255) | Null: YES | Key: | Default: sineph_pas_img.png | Extra:
    act_img10 ~ Type: varchar(255) | Null: YES | Key: | Default: sineph_pas_img.png | Extra:
    saisie_par ~ Type: varchar(100) | Null: YES | Key: | Default: N/A | Extra:
    modifie_par ~ Type: varchar(100) | Null: YES | Key: | Default: N/A | Extra:
    act_dossier ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
  2. activites_type
    3. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    act_type ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    act_type_code ~ Type: double | Null: YES | Key: | Default: | Extra:
  3. actualites
    4. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    act_type ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    act_type_code ~ Type: double | Null: YES | Key: | Default: | Extra:
    act_datedu ~ Type: date | Null: YES | Key: | Default: | Extra:
    act_dateau ~ Type: date | Null: YES | Key: | Default: | Extra:
    act_lieu ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    act_titre ~ Type: varchar(255) | Null: NO | Key: | Default: | Extra:
    act_descrip ~ Type: text | Null: YES | Key: | Default: | Extra:
    act_fichier ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    act_video ~ Type: text | Null: YES | Key: | Default: | Extra:
    saisie_par ~ Type: varchar(100) | Null: YES | Key: | Default: N/A | Extra:
    modifie_par ~ Type: varchar(100) | Null: YES | Key: | Default: N/A | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
  4. actualites_type
    5. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    act_type ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    act_type_code ~ Type: double | Null: YES | Key: | Default: | Extra:
  5. annee_indicateurs_publique
    6. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    annee_publique ~ Type: float | Null: YES | Key: | Default: | Extra:
    publique ~ Type: varchar(3) | Null: YES | Key: | Default: oui | Extra:
    saisie_par ~ Type: varchar(100) | Null: NO | Key: | Default: N/A | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
  6. attente_code_sineph
    7. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    patient_date_remplissage ~ Type: date | Null: YES | Key: | Default: | Extra:
    patient_identification_temporaire ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    patient_numero_identification ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    patient_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    centre_inclusion_code ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
  7. attente_identification_demographiques
    8. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    patient_date_remplissage ~ Type: date | Null: YES | Key: | Default: | Extra:
    patient_identification_temporaire ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    patient_numero_identification ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    patient_nom ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_prenom ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_date_naissance ~ Type: date | Null: YES | Key: | Default: | Extra:
    patient_age_remplissage ~ Type: float | Null: YES | Key: | Default: | Extra:
    patient_ville_naissance ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_pays_naissance ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_sexe ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:
    patient_commentaire ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    centre_inclusion_code ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    contexte_statut ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_epi ~ Type: varchar(50) | Null: YES | Key: | Default: PREVALENT | Extra:
    saisie_par ~ Type: varchar(100) | Null: NO | Key: | Default: N/A | Extra:
    modifie_par ~ Type: varchar(100) | Null: NO | Key: | Default: N/A | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
    date_modif ~ Type: date | Null: YES | Key: | Default: | Extra:
  8. bureaux
    9. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    bur_annee_du ~ Type: varchar(4) | Null: YES | Key: | Default: | Extra:
    bur_annee_au ~ Type: varchar(4) | Null: YES | Key: | Default: | Extra:
    bur_period ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    bur_descrip ~ Type: text | Null: YES | Key: | Default: | Extra:
    saisie_par ~ Type: varchar(100) | Null: YES | Key: | Default: N/A | Extra:
    modifie_par ~ Type: varchar(100) | Null: YES | Key: | Default: N/A | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
  9. centres
    10. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    pays ~ Type: varchar(50) | Null: NO | Key: | Default: Côte d’Ivoire | Extra:
    ville ~ Type: varchar(50) | Null: NO | Key: | Default: Abidjan | Extra:
    centre ~ Type: varchar(255) | Null: NO | Key: | Default: Centre X | Extra:
    centre_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    date_remplissage ~ Type: date | Null: YES | Key: | Default: | Extra:
    code_du_centre ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    type_centre ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    centre_generateurs ~ Type: double | Null: YES | Key: | Default: 0 | Extra:
    centre_generateurs_details ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    centre_nephrologues ~ Type: double | Null: YES | Key: | Default: 0 | Extra:
    centre_infirmiers ~ Type: double | Null: YES | Key: | Default: 0 | Extra:
    centre_aide_soignants ~ Type: double | Null: YES | Key: | Default: 0 | Extra:
    centre_techniciens ~ Type: double | Null: YES | Key: | Default: 0 | Extra:
    centre_patients ~ Type: double | Null: YES | Key: | Default: 0 | Extra:
    centre_adresse ~ Type: varchar(255) | Null: YES | Key: | Default: - | Extra:
    centre_telephone_1 ~ Type: varchar(11) | Null: YES | Key: | Default: | Extra:
    centre_telephone_2 ~ Type: varchar(11) | Null: YES | Key: | Default: | Extra:
    centre_fax ~ Type: varchar(11) | Null: YES | Key: | Default: | Extra:
    centre_email ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    centre_actif ~ Type: varchar(10) | Null: YES | Key: | Default: actif | Extra:
    centre_date_creation ~ Type: date | Null: YES | Key: | Default: | Extra:
    centre_services ~ Type: text | Null: YES | Key: | Default: | Extra:
    centre_saisie_public_nom ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    centre_saisie_public_email ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    centre_saisie_public_cel ~ Type: varchar(11) | Null: YES | Key: | Default: | Extra:
    centre_cmtaire ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    centre_modif_nom ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    centre_modif_email ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    centre_modif_cel ~ Type: varchar(11) | Null: YES | Key: | Default: | Extra:
    saisie_par ~ Type: varchar(100) | Null: NO | Key: | Default: N/A | Extra:
    modifie_par ~ Type: varchar(100) | Null: NO | Key: | Default: N/A | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
    date_modif ~ Type: date | Null: YES | Key: | Default: | Extra:
  10. centres_code_sineph
    11. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    ville ~ Type: varchar(50) | Null: NO | Key: | Default: Abidjan | Extra:
    centre ~ Type: varchar(255) | Null: NO | Key: | Default: Centre X | Extra:
    centre_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    code_du_centre ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    type_centre ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
  11. country
    12. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    country ~ Type: varchar(100) | Null: NO | Key: | Default: | Extra:
    pays ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    continent ~ Type: varchar(20) | Null: NO | Key: | Default: Africa | Extra:
    continents ~ Type: varchar(50) | Null: NO | Key: | Default: Afrique | Extra:
  12. deces
    13. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    causes_de décès_ERA-EDTA_Code_1995_Groupe ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    causes ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    code_1996 ~ Type: double | Null: YES | Key: | Default: | Extra:
    groupe ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    regroupement ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
  13. delai
    14. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    delai_modifier ~ Type: double | Null: YES | Key: | Default: | Extra:
    delai_supprimer ~ Type: double | Null: YES | Key: | Default: | Extra:
  14. emplois
    15. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    emploi ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    category ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
  15. infirmiers
    16. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    centre_code ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    inf_nom_prenoms ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    inf_contact_1 ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    inf_contact_2 ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    inf_whatsapp ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    inf_email ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    inf_actif ~ Type: varchar(100) | Null: YES | Key: | Default: actif | Extra:
    inf_code ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    saisie_par ~ Type: varchar(255) | Null: NO | Key: | Default: mmdo19852018 | Extra:
    dates ~ Type: datetime | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
    modifie_par ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    date_modif ~ Type: date | Null: YES | Key: | Default: | Extra:
  16. liens_utiles
    17. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    lien_nom ~ Type: varchar(50) | Null: NO | Key: | Default: | Extra:
    lien_lien ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    lien_type ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    lien_descrip ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    saisie_par ~ Type: varchar(100) | Null: YES | Key: | Default: N/A | Extra:
    modifie_par ~ Type: varchar(100) | Null: YES | Key: | Default: N/A | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
  17. medecins
    18. idd ~ Type: int(11) | Null: YES | Key: | Default: | Extra:
    id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    medecin_appelation ~ Type: varchar(4) | Null: NO | Key: | Default: - | Extra:
    medecin_nom ~ Type: varchar(100) | Null: NO | Key: | Default: - | Extra:
    medecin_prenom ~ Type: varchar(100) | Null: NO | Key: | Default: - | Extra:
    medecin_sexe ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:
    medecin_ddn ~ Type: date | Null: YES | Key: | Default: | Extra:
    num_onmci ~ Type: varchar(50) | Null: YES | Key: | Default: - | Extra:
    medecin_code ~ Type: varchar(100) | Null: NO | Key: | Default: - | Extra:
    medecin_statut ~ Type: varchar(100) | Null: NO | Key: | Default: inconnu | Extra:
    medecin_statut_autre ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    medecin_centre_code_1 ~ Type: varchar(100) | Null: YES | Key: | Default: Inconnu | Extra:
    medecin_centre_role_1 ~ Type: varchar(255) | Null: YES | Key: | Default: Inconnu | Extra:
    medecin_centre_code_2 ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    medecin_centre_role_2 ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    medecin_centre_code_3 ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    medecin_centre_role_3 ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    medecin_sineph ~ Type: varchar(100) | Null: NO | Key: | Default: inconnu | Extra:
    medecin_sineph_annee ~ Type: varchar(4) | Null: YES | Key: | Default: | Extra:
    medecin_sineph_role ~ Type: varchar(100) | Null: YES | Key: | Default: - | Extra:
    medecin_tel_1 ~ Type: varchar(20) | Null: YES | Key: | Default: | Extra:
    medecin_tel_2 ~ Type: varchar(20) | Null: YES | Key: | Default: | Extra:
    medecin_cel_1 ~ Type: varchar(20) | Null: YES | Key: | Default: | Extra:
    medecin_cel_2 ~ Type: varchar(20) | Null: YES | Key: | Default: | Extra:
    medecin_fax ~ Type: varchar(20) | Null: YES | Key: | Default: | Extra:
    medecin_email ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    medecin_profil ~ Type: varchar(10) | Null: YES | Key: | Default: non | Extra:
    medecin_inviter ~ Type: varchar(10) | Null: YES | Key: | Default: non | Extra:
    medecin_inviter_date ~ Type: date | Null: YES | Key: | Default: | Extra:
    medecin_code_invitation ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    commentaire ~ Type: varchar(255) | Null: YES | Key: | Default: N/A | Extra:
    medecin_actif ~ Type: varchar(50) | Null: YES | Key: | Default: Actif | Extra:
    saisie_public_nom ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    saisie_public_email ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    saisie_public_cel ~ Type: varchar(11) | Null: YES | Key: | Default: | Extra:
    modif_nom ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    modif_email ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    modif_cel ~ Type: varchar(11) | Null: YES | Key: | Default: | Extra:
    date_modif ~ Type: date | Null: YES | Key: | Default: | Extra:
    saisie_par ~ Type: varchar(50) | Null: YES | Key: | Default: N/A | Extra:
    modifie_par ~ Type: varchar(50) | Null: YES | Key: | Default: N/A | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
  18. medecins_cotisations
    19. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    medecin_code ~ Type: varchar(100) | Null: NO | Key: | Default: - | Extra:
    commentaire ~ Type: varchar(255) | Null: YES | Key: | Default: N/A | Extra:
    cotis_type ~ Type: varchar(50) | Null: YES | Key: | Default: Adhésion | Extra:
    cotis_annee ~ Type: varchar(4) | Null: YES | Key: | Default: | Extra:
    cotis_somme ~ Type: varchar(11) | Null: YES | Key: | Default: | Extra:
    cotis_date ~ Type: date | Null: YES | Key: | Default: | Extra:
    cotis_statut ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:
    saisie_public_nom ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    saisie_public_email ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    saisie_public_cel ~ Type: varchar(11) | Null: YES | Key: | Default: | Extra:
    modif_nom ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    modif_email ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    modif_cel ~ Type: varchar(11) | Null: YES | Key: | Default: | Extra:
    date_modif ~ Type: date | Null: YES | Key: | Default: | Extra:
    saisie_par ~ Type: varchar(50) | Null: YES | Key: | Default: N/A | Extra:
    modifie_par ~ Type: varchar(50) | Null: YES | Key: | Default: N/A | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
  19. patients_code_sineph
    20. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    patient_date_remplissage ~ Type: date | Null: YES | Key: | Default: | Extra:
    patient_identification_temporaire ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    patient_numero_identification ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    patient_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_consent ~ Type: varchar(255) | Null: YES | Key: | Default: oui | Extra:
    centre_inclusion_code ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
  20. patients_identification_centres
    21. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    patient_identification_temporaire ~ Type: varchar(100) | Null: YES | Key: UNI | Default: | Extra:
    patient_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_date_naissance ~ Type: date | Null: YES | Key: | Default: | Extra:
    patient_sexe ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:
    centre_inclusion_code ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
  21. patients_identification_demographiques
    22. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    patient_fiche_code ~ Type: int(1) | Null: YES | Key: | Default: 0 | Extra:
    patient_date_remplissage ~ Type: date | Null: YES | Key: | Default: | Extra:
    patient_identification_temporaire ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    patient_numero_identification ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    patient_nom ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_prenom ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_consent ~ Type: varchar(255) | Null: YES | Key: | Default: oui | Extra:
    patient_date_naissance ~ Type: date | Null: YES | Key: | Default: | Extra:
    patient_age_remplissage ~ Type: float | Null: YES | Key: | Default: | Extra:
    patient_ville_naissance ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_pays_naissance ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_sexe ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:
    patient_commentaire ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    centre_inclusion_code ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    centre_primaire ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    centre_secondaire ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    centre_transfert ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    centre_primaire_dossier ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    centre_secondaire_dossier ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    centre_transfert_dossier ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    contexte_statut ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_epi ~ Type: varchar(20) | Null: YES | Key: | Default: PREVALENT | Extra:
    patient_statut ~ Type: varchar(255) | Null: YES | Key: | Default: Déclaré | Extra:
    saisie_par ~ Type: varchar(100) | Null: NO | Key: | Default: N/A | Extra:
    modifie_par ~ Type: varchar(100) | Null: NO | Key: | Default: N/A | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
    date_modif ~ Type: date | Null: YES | Key: | Default: | Extra:
  22. patients_identification_demographiques_both
    23. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    patient_fiche_code ~ Type: int(1) | Null: YES | Key: | Default: 0 | Extra:
    patient_date_remplissage ~ Type: date | Null: YES | Key: | Default: | Extra:
    patient_identification_temporaire ~ Type: varchar(100) | Null: YES | Key: UNI | Default: | Extra:
    patient_numero_identification ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    patient_nom ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_prenom ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_consent ~ Type: varchar(255) | Null: YES | Key: | Default: oui | Extra:
    patient_date_naissance ~ Type: date | Null: YES | Key: | Default: | Extra:
    patient_age_remplissage ~ Type: float | Null: YES | Key: | Default: | Extra:
    patient_ville_naissance ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_pays_naissance ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_sexe ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:
    patient_commentaire ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    centre_inclusion_code ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    centre_primaire ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    centre_secondaire ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    centre_transfert ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    centre_primaire_dossier ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    centre_secondaire_dossier ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    contexte_statut ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_epi ~ Type: varchar(20) | Null: YES | Key: | Default: PREVALENT | Extra:
    patient_statut ~ Type: varchar(255) | Null: YES | Key: | Default: Déclaré | Extra:
    saisie_par ~ Type: varchar(100) | Null: NO | Key: | Default: N/A | Extra:
    modifie_par ~ Type: varchar(100) | Null: NO | Key: | Default: N/A | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
    date_modif ~ Type: date | Null: YES | Key: | Default: | Extra:
  23. patients_identification_demographiques_olds
    24. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    patient_fiche_code ~ Type: int(1) | Null: YES | Key: | Default: 0 | Extra:
    patient_date_remplissage ~ Type: date | Null: YES | Key: | Default: | Extra:
    patient_identification_temporaire ~ Type: varchar(100) | Null: YES | Key: UNI | Default: | Extra:
    patient_numero_identification ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    patient_nom ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_prenom ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_consent ~ Type: varchar(255) | Null: YES | Key: | Default: oui | Extra:
    patient_date_naissance ~ Type: date | Null: YES | Key: | Default: | Extra:
    patient_age_remplissage ~ Type: float | Null: YES | Key: | Default: | Extra:
    patient_ville_naissance ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_pays_naissance ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_sexe ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:
    patient_commentaire ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    centre_inclusion_code ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    centre_primaire ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    centre_secondaire ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    centre_transfert ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    centre_primaire_dossier ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    centre_secondaire_dossier ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    contexte_statut ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_epi ~ Type: varchar(20) | Null: YES | Key: | Default: PREVALENT | Extra:
    patient_statut ~ Type: varchar(255) | Null: YES | Key: | Default: Déclaré | Extra:
    saisie_par ~ Type: varchar(100) | Null: NO | Key: | Default: N/A | Extra:
    modifie_par ~ Type: varchar(100) | Null: NO | Key: | Default: N/A | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
    date_modif ~ Type: date | Null: YES | Key: | Default: | Extra:
  24. patients_initial
    25. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    patient_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_date_remplissage ~ Type: date | Null: YES | Key: | Default: | Extra:
    contexte_statut ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    date_premiere_traitement ~ Type: date | Null: YES | Key: | Default: | Extra:
    duree_dialyse_jours ~ Type: float | Null: YES | Key: | Default: | Extra:
    duree_dialyse_mois ~ Type: float | Null: YES | Key: | Default: | Extra:
    niveau_instruction ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    profession ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    activite_actuelle ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    situation_matrimoniale ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ville_habitation_actuelle ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    pays_habitation_actuelle ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ville_ancienne_habitation ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    pays_ancienne_habitation ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    couverture_sociale ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    premiere_consultatio_nephro_date ~ Type: datetime | Null: YES | Key: | Default: | Extra:
    premiere_creatininemie ~ Type: float | Null: YES | Key: | Default: | Extra:
    premiere_clairance_creatinine ~ Type: float | Null: YES | Key: | Default: | Extra:
    maladie_renale_initiale_PBR ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    maladie_renale_initiale_echo ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    maladie_renale_initiale_diagnostic ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    maladie_renale_initiale_diagnostic_compl ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    poids_kg ~ Type: float | Null: YES | Key: | Default: | Extra:
    taille_cm ~ Type: float | Null: YES | Key: | Default: | Extra:
    IMC ~ Type: float | Null: YES | Key: | Default: | Extra:
    hb_taux ~ Type: float | Null: YES | Key: | Default: | Extra:
    hb_date ~ Type: date | Null: YES | Key: | Default: | Extra:
    Comorb_tabagisme ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_diabete ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_insulinotherapie ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_HTA ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_Insuffisance_coronarienne ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_IDM ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_pericardite ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_trouble_rythme ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_insuffisance_cardiaque ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_AVC ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_arterite_mi ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_ag_hbs_positif ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_Ac_hvc_positif ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_cirrhose ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_vih ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_bpco ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_tuberculose ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_cancer ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_autre ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_autre_precisez ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    handicap_aucun ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_para_hemi ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_TSC ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_ami ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_tsv ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_cecite ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_ND ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_autre ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_autre_precisez ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    marche ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ped_perimetre_cranien ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ped_perimetre_brachial ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ped_taille_enfant ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ped_scolarise ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    traitement_actuel ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    traitement_actuel_non_traite_reason ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    non_traite_autre ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    non_traite_autre_precisez ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    non_traite_creatininemie ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    non_traite_clairance_creatinine ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    traitement_actuel_type ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_modalites ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_nbre_seance_semaine ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_duree_seance ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_circonstances_demarage ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_fav ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_pontage ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_kt_tunn ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_kt_temp ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_nd ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_projet_greffe ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    dia_peri_modalites ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    dia_peri_projet_greffe ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    greffe_ren_creatininemie ~ Type: float | Null: YES | Key: | Default: | Extra:
    greffe_ren_creatininemie_date ~ Type: date | Null: YES | Key: | Default: | Extra:
    greffe_ren_lieu_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    greffe_ren_lieu_ville ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    greffe_ren_lieu_pays ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    greffe_ren_type ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    greffe_ren_sexe_donneur ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:
    greffe_ren_datenaiss_donneur ~ Type: date | Null: YES | Key: | Default: | Extra:
    fiche_commentaire ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    patient_fiche ~ Type: varchar(50) | Null: YES | Key: | Default: identification initiale | Extra:
    patient_fiche_code ~ Type: int(1) | Null: YES | Key: | Default: 0 | Extra:
    saisie_par ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    modifie_par ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
    date_modif ~ Type: date | Null: YES | Key: | Default: | Extra:
  25. patients_initial_both
    26. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    patient_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_date_remplissage ~ Type: date | Null: YES | Key: | Default: | Extra:
    contexte_statut ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    date_premiere_traitement ~ Type: date | Null: YES | Key: | Default: | Extra:
    duree_dialyse_jours ~ Type: float | Null: YES | Key: | Default: | Extra:
    duree_dialyse_mois ~ Type: float | Null: YES | Key: | Default: | Extra:
    niveau_instruction ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    profession ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    activite_actuelle ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    situation_matrimoniale ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ville_habitation_actuelle ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    pays_habitation_actuelle ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ville_ancienne_habitation ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    pays_ancienne_habitation ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    couverture_sociale ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    premiere_consultatio_nephro_date ~ Type: datetime | Null: YES | Key: | Default: | Extra:
    premiere_creatininemie ~ Type: float | Null: YES | Key: | Default: | Extra:
    premiere_clairance_creatinine ~ Type: float | Null: YES | Key: | Default: | Extra:
    maladie_renale_initiale_PBR ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    maladie_renale_initiale_echo ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    maladie_renale_initiale_diagnostic ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    maladie_renale_initiale_diagnostic_compl ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    poids_kg ~ Type: float | Null: YES | Key: | Default: | Extra:
    taille_cm ~ Type: float | Null: YES | Key: | Default: | Extra:
    IMC ~ Type: float | Null: YES | Key: | Default: | Extra:
    hb_taux ~ Type: float | Null: YES | Key: | Default: | Extra:
    hb_date ~ Type: date | Null: YES | Key: | Default: | Extra:
    Comorb_tabagisme ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_diabete ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_insulinotherapie ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_HTA ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_Insuffisance_coronarienne ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_IDM ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_pericardite ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_trouble_rythme ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_insuffisance_cardiaque ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_AVC ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_arterite_mi ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_ag_hbs_positif ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_Ac_hvc_positif ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_cirrhose ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_vih ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_bpco ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_tuberculose ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_cancer ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_autre ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_autre_precisez ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    handicap_aucun ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_para_hemi ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_TSC ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_ami ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_tsv ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_cecite ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_ND ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_autre ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_autre_precisez ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    marche ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ped_perimetre_cranien ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ped_perimetre_brachial ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ped_taille_enfant ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ped_scolarise ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    traitement_actuel ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    traitement_actuel_non_traite_reason ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    non_traite_autre ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    non_traite_autre_precisez ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    non_traite_creatininemie ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    non_traite_clairance_creatinine ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    traitement_actuel_type ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_modalites ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_nbre_seance_semaine ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_duree_seance ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_circonstances_demarage ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_fav ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_pontage ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_kt_tunn ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_kt_temp ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_nd ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_projet_greffe ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    dia_peri_modalites ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    dia_peri_projet_greffe ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    greffe_ren_creatininemie ~ Type: float | Null: YES | Key: | Default: | Extra:
    greffe_ren_creatininemie_date ~ Type: date | Null: YES | Key: | Default: | Extra:
    greffe_ren_lieu_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    greffe_ren_lieu_ville ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    greffe_ren_lieu_pays ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    greffe_ren_type ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    greffe_ren_sexe_donneur ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:
    greffe_ren_datenaiss_donneur ~ Type: date | Null: YES | Key: | Default: | Extra:
    fiche_commentaire ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    patient_fiche ~ Type: varchar(50) | Null: YES | Key: | Default: identification initiale | Extra:
    patient_fiche_code ~ Type: int(1) | Null: YES | Key: | Default: 0 | Extra:
    saisie_par ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    modifie_par ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
    date_modif ~ Type: date | Null: YES | Key: | Default: | Extra:
  26. patients_initial_old
    27. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    patient_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_date_remplissage ~ Type: date | Null: YES | Key: | Default: | Extra:
    contexte_statut ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    date_premiere_traitement ~ Type: date | Null: YES | Key: | Default: | Extra:
    duree_dialyse_jours ~ Type: float | Null: YES | Key: | Default: | Extra:
    duree_dialyse_mois ~ Type: float | Null: YES | Key: | Default: | Extra:
    niveau_instruction ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    profession ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    activite_actuelle ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    situation_matrimoniale ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ville_habitation_actuelle ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    pays_habitation_actuelle ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ville_ancienne_habitation ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    pays_ancienne_habitation ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    couverture_sociale ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    premiere_consultatio_nephro_date ~ Type: datetime | Null: YES | Key: | Default: | Extra:
    premiere_creatininemie ~ Type: float | Null: YES | Key: | Default: | Extra:
    premiere_clairance_creatinine ~ Type: float | Null: YES | Key: | Default: | Extra:
    maladie_renale_initiale_PBR ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    maladie_renale_initiale_echo ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    maladie_renale_initiale_diagnostic ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    maladie_renale_initiale_diagnostic_compl ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    poids_kg ~ Type: float | Null: YES | Key: | Default: | Extra:
    taille_cm ~ Type: float | Null: YES | Key: | Default: | Extra:
    IMC ~ Type: float | Null: YES | Key: | Default: | Extra:
    hb_taux ~ Type: float | Null: YES | Key: | Default: | Extra:
    hb_date ~ Type: date | Null: YES | Key: | Default: | Extra:
    Comorb_tabagisme ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_diabete ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_insulinotherapie ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_HTA ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_Insuffisance_coronarienne ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_IDM ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_pericardite ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_trouble_rythme ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_insuffisance_cardiaque ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_AVC ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_arterite_mi ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_ag_hbs_positif ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_Ac_hvc_positif ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_cirrhose ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_vih ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_bpco ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_tuberculose ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_cancer ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_autre ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_autre_precisez ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    handicap_aucun ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_para_hemi ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_TSC ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_ami ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_tsv ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_cecite ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_ND ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_autre ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_autre_precisez ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    marche ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ped_perimetre_cranien ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ped_perimetre_brachial ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ped_taille_enfant ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ped_scolarise ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    traitement_actuel ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    traitement_actuel_non_traite_reason ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    non_traite_autre ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    non_traite_autre_precisez ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    non_traite_creatininemie ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    non_traite_clairance_creatinine ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    traitement_actuel_type ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_modalites ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_nbre_seance_semaine ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_duree_seance ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_circonstances_demarage ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_fav ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_pontage ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_kt_tunn ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_kt_temp ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_nd ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_projet_greffe ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    dia_peri_modalites ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    dia_peri_projet_greffe ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    greffe_ren_creatininemie ~ Type: float | Null: YES | Key: | Default: | Extra:
    greffe_ren_creatininemie_date ~ Type: date | Null: YES | Key: | Default: | Extra:
    greffe_ren_lieu_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    greffe_ren_lieu_ville ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    greffe_ren_lieu_pays ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    greffe_ren_type ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    greffe_ren_sexe_donneur ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:
    greffe_ren_datenaiss_donneur ~ Type: date | Null: YES | Key: | Default: | Extra:
    fiche_commentaire ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    patient_fiche ~ Type: varchar(50) | Null: YES | Key: | Default: identification initiale | Extra:
    patient_fiche_code ~ Type: int(1) | Null: YES | Key: | Default: 0 | Extra:
    saisie_par ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    modifie_par ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
    date_modif ~ Type: date | Null: YES | Key: | Default: | Extra:
  27. patients_notes
    28. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    note_id ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    patient_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    note ~ Type: text | Null: YES | Key: | Default: | Extra:
    note_type ~ Type: varchar(100) | Null: YES | Key: | Default: 0 | Extra:
    saisie_par ~ Type: varchar(100) | Null: NO | Key: | Default: N/A | Extra:
    modifie_par ~ Type: varchar(100) | Null: NO | Key: | Default: N/A | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
    date_modif ~ Type: date | Null: YES | Key: | Default: | Extra:
  28. patients_point_annuel
    29. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    patient_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    date_point_annuel ~ Type: date | Null: YES | Key: | Default: | Extra:
    patient_date_remplissage ~ Type: date | Null: YES | Key: | Default: | Extra:
    contexte_statut ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    date_premiere_traitement ~ Type: date | Null: YES | Key: | Default: | Extra:
    duree_dialyse_jours ~ Type: float | Null: YES | Key: | Default: | Extra:
    duree_dialyse_mois ~ Type: float | Null: YES | Key: | Default: | Extra:
    niveau_instruction ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    profession ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    activite_actuelle ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    situation_matrimoniale ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ville_habitation_actuelle ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    pays_habitation_actuelle ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ville_ancienne_habitation ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    pays_ancienne_habitation ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    couverture_sociale ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    poids_kg ~ Type: float | Null: YES | Key: | Default: | Extra:
    taille_cm ~ Type: float | Null: YES | Key: | Default: | Extra:
    IMC ~ Type: float | Null: YES | Key: | Default: | Extra:
    hb_taux ~ Type: float | Null: YES | Key: | Default: | Extra:
    hb_date ~ Type: date | Null: YES | Key: | Default: | Extra:
    Comorb_tabagisme ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_diabete ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_insulinotherapie ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_HTA ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_Insuffisance_coronarienne ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_IDM ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_pericardite ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_trouble_rythme ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_insuffisance_cardiaque ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_AVC ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_arterite_mi ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_ag_hbs_positif ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_Ac_hvc_positif ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_cirrhose ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_vih ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_bpco ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_tuberculose ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_cancer ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_autre ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_autre_precisez ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    handicap_aucun ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_para_hemi ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_TSC ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_ami ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_tsv ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_cecite ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_ND ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_autre ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_autre_precisez ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    marche ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ped_perimetre_cranien ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ped_perimetre_brachial ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ped_taille_enfant ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ped_scolarise ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    traitement_actuel ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    traitement_actuel_non_traite_reason ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    non_traite_autre ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    non_traite_autre_precisez ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    non_traite_creatininemie ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    non_traite_clairance_creatinine ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    traitement_actuel_type ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_modalites ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_nbre_seance_semaine ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_duree_seance ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_circonstances_demarage ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_fav ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_pontage ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_kt_tunn ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_kt_temp ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_nd ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_projet_greffe ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    dia_peri_modalites ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    dia_peri_projet_greffe ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    greffe_ren_creatininemie ~ Type: float | Null: YES | Key: | Default: | Extra:
    greffe_ren_creatininemie_date ~ Type: date | Null: YES | Key: | Default: | Extra:
    greffe_ren_lieu_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    greffe_ren_lieu_ville ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    greffe_ren_lieu_pays ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    greffe_ren_type ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    greffe_ren_sexe_donneur ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:
    greffe_ren_datenaiss_donneur ~ Type: date | Null: YES | Key: | Default: | Extra:
    fiche_commentaire ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    patient_fiche ~ Type: varchar(50) | Null: YES | Key: | Default: point annuel | Extra:
    patient_fiche_code ~ Type: int(1) | Null: YES | Key: | Default: 1 | Extra:
    saisie_par ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    modifie_par ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
    date_modif ~ Type: date | Null: YES | Key: | Default: | Extra:
  29. patients_sortie
    30. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    patient_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    date_debut_traitement ~ Type: date | Null: YES | Key: | Default: | Extra:
    patient_date_remplissage ~ Type: date | Null: YES | Key: | Default: | Extra:
    contexte_statut ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    numero_dossier_centre ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    contexte_centre_code ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    numero_dossier_centre_transfert ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    contexte_centre_code_transfert ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    evenement ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    date_transfert ~ Type: date | Null: YES | Key: | Default: | Extra:
    contexte_transfert ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    creatininemie_arret ~ Type: float | Null: YES | Key: | Default: | Extra:
    clairance_creatinine_arret ~ Type: float | Null: YES | Key: | Default: | Extra:
    date_deces ~ Type: date | Null: YES | Key: | Default: | Extra:
    lieu_deces ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    cause_deces ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    traitement_suppleance ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    traitement_suppleance_autre ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    fiche_commentaire ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    patient_fiche ~ Type: varchar(50) | Null: YES | Key: | Default: Sortie | Extra:
    patient_fiche_code ~ Type: int(1) | Null: YES | Key: | Default: 3 | Extra:
    saisie_par ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    modifie_par ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
    date_modif ~ Type: date | Null: YES | Key: | Default: | Extra:
  30. patients_traitement
    31. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    patient_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    date_debut_traitement ~ Type: date | Null: YES | Key: | Default: | Extra:
    patient_date_remplissage ~ Type: date | Null: YES | Key: | Default: | Extra:
    contexte_statut ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    traitement_actuel ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    traitement_actuel_non_traite_reason ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    non_traite_autre ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    non_traite_autre_precisez ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    non_traite_creatininemie ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    non_traite_clairance_creatinine ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    traitement_actuel_type ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_modalites ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_nbre_seance_semaine ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_duree_seance ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_circonstances_demarage ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_fav ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_pontage ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_kt_tunn ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_kt_temp ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_nd ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_projet_greffe ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    dia_peri_modalites ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    dia_peri_projet_greffe ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    greffe_ren_creatininemie ~ Type: float | Null: YES | Key: | Default: | Extra:
    greffe_ren_creatininemie_date ~ Type: date | Null: YES | Key: | Default: | Extra:
    greffe_ren_lieu_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    greffe_ren_lieu_ville ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    greffe_ren_lieu_pays ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    greffe_ren_type ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    greffe_ren_sexe_donneur ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:
    greffe_ren_datenaiss_donneur ~ Type: date | Null: YES | Key: | Default: | Extra:
    fiche_commentaire ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    patient_fiche ~ Type: varchar(50) | Null: YES | Key: | Default: changement de traitement | Extra:
    patient_fiche_code ~ Type: int(1) | Null: YES | Key: | Default: 2 | Extra:
    saisie_par ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    modifie_par ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
    date_modif ~ Type: date | Null: YES | Key: | Default: | Extra:
  31. pilot_code_sineph
    32. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    patient_date_remplissage ~ Type: date | Null: YES | Key: | Default: | Extra:
    patient_identification_temporaire ~ Type: varchar(100) | Null: YES | Key: UNI | Default: | Extra:
    patient_numero_identification ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    patient_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_consent ~ Type: varchar(255) | Null: YES | Key: | Default: oui | Extra:
    centre_inclusion_code ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
  32. pilot_evolution
    33. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    patient_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_date_remplissage ~ Type: date | Null: YES | Key: | Default: | Extra:
    contexte_statut ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    date_premiere_traitement ~ Type: date | Null: YES | Key: | Default: | Extra:
    duree_dialyse_jours ~ Type: float | Null: YES | Key: | Default: | Extra:
    duree_dialyse_mois ~ Type: float | Null: YES | Key: | Default: | Extra:
    niveau_instruction ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    profession ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    activite_actuelle ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    situation_matrimoniale ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ville_habitation_actuelle ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    pays_habitation_actuelle ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ville_ancienne_habitation ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    pays_ancienne_habitation ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    couverture_sociale ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    premiere_consultatio_nephro_date ~ Type: datetime | Null: YES | Key: | Default: | Extra:
    premiere_creatininemie ~ Type: float | Null: YES | Key: | Default: | Extra:
    premiere_clairance_creatinine ~ Type: float | Null: YES | Key: | Default: | Extra:
    maladie_renale_initiale_PBR ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    maladie_renale_initiale_echo ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    maladie_renale_initiale_diagnostic ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    maladie_renale_initiale_diagnostic_compl ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    poids_kg ~ Type: float | Null: YES | Key: | Default: | Extra:
    taille_cm ~ Type: float | Null: YES | Key: | Default: | Extra:
    IMC ~ Type: float | Null: YES | Key: | Default: | Extra:
    hb_taux ~ Type: float | Null: YES | Key: | Default: | Extra:
    hb_date ~ Type: date | Null: YES | Key: | Default: | Extra:
    Comorb_tabagisme ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_diabete ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_insulinotherapie ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_HTA ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_Insuffisance_coronarienne ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_IDM ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_pericardite ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_trouble_rythme ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_insuffisance_cardiaque ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_AVC ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_arterite_mi ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_ag_hbs_positif ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_Ac_hvc_positif ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_cirrhose ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_vih ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_bpco ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_tuberculose ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_cancer ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_autre ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_autre_precisez ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    handicap_aucun ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_para_hemi ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_TSC ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_ami ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_tsv ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_cecite ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_ND ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_autre ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_autre_precisez ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    marche ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ped_perimetre_cranien ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ped_perimetre_brachial ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ped_taille_enfant ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ped_scolarise ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    traitement_actuel ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    traitement_actuel_non_traite_reason ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    non_traite_autre ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    non_traite_autre_precisez ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    non_traite_creatininemie ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    non_traite_clairance_creatinine ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    traitement_actuel_type ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_modalites ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_nbre_seance_semaine ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_duree_seance ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_circonstances_demarage ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_fav ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_pontage ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_kt_tunn ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_kt_temp ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_nd ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_projet_greffe ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    dia_peri_modalites ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    dia_peri_projet_greffe ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    greffe_ren_creatininemie ~ Type: float | Null: YES | Key: | Default: | Extra:
    greffe_ren_creatininemie_date ~ Type: date | Null: YES | Key: | Default: | Extra:
    greffe_ren_lieu_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    greffe_ren_lieu_ville ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    greffe_ren_lieu_pays ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    greffe_ren_type ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    greffe_ren_sexe_donneur ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:
    greffe_ren_datenaiss_donneur ~ Type: date | Null: YES | Key: | Default: | Extra:
    fiche_commentaire ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    patient_fiche ~ Type: varchar(50) | Null: YES | Key: | Default: Evolution | Extra:
    patient_fiche_code ~ Type: int(1) | Null: YES | Key: | Default: 1 | Extra:
    saisie_par ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    modifie_par ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
    date_modif ~ Type: date | Null: YES | Key: | Default: | Extra:
    deces ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:
    date_deces ~ Type: date | Null: YES | Key: | Default: | Extra:
    lieu_deces ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    cause_deces ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    cause_deces_groupe ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
  33. pilot_identification_demographiques
    34. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    patient_fiche_code ~ Type: int(1) | Null: YES | Key: | Default: 0 | Extra:
    patient_date_remplissage ~ Type: date | Null: YES | Key: | Default: | Extra:
    patient_identification_temporaire ~ Type: varchar(100) | Null: YES | Key: UNI | Default: | Extra:
    patient_numero_identification ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    patient_nom ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_prenom ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_consent ~ Type: varchar(255) | Null: YES | Key: | Default: oui | Extra:
    patient_date_naissance ~ Type: date | Null: YES | Key: | Default: | Extra:
    patient_age_remplissage ~ Type: float | Null: YES | Key: | Default: | Extra:
    patient_ville_naissance ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_pays_naissance ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_sexe ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:
    patient_commentaire ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    centre_inclusion_code ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    centre_primaire ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    centre_secondaire ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    centre_transfert ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    centre_primaire_dossier ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    centre_secondaire_dossier ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    contexte_statut ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_epi ~ Type: varchar(20) | Null: YES | Key: | Default: PREVALENT | Extra:
    patient_statut ~ Type: varchar(255) | Null: YES | Key: | Default: Déclaré | Extra:
    saisie_par ~ Type: varchar(100) | Null: NO | Key: | Default: N/A | Extra:
    modifie_par ~ Type: varchar(100) | Null: NO | Key: | Default: N/A | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
    date_modif ~ Type: date | Null: YES | Key: | Default: | Extra:
  34. pilot_initial
    35. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    patient_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    patient_date_remplissage ~ Type: date | Null: YES | Key: | Default: | Extra:
    contexte_statut ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    date_premiere_traitement ~ Type: date | Null: YES | Key: | Default: | Extra:
    duree_dialyse_jours ~ Type: float | Null: YES | Key: | Default: | Extra:
    duree_dialyse_mois ~ Type: float | Null: YES | Key: | Default: | Extra:
    niveau_instruction ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    profession ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    activite_actuelle ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    situation_matrimoniale ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ville_habitation_actuelle ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    pays_habitation_actuelle ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ville_ancienne_habitation ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    pays_ancienne_habitation ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    couverture_sociale ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    premiere_consultatio_nephro_date ~ Type: datetime | Null: YES | Key: | Default: | Extra:
    premiere_creatininemie ~ Type: float | Null: YES | Key: | Default: | Extra:
    premiere_clairance_creatinine ~ Type: float | Null: YES | Key: | Default: | Extra:
    maladie_renale_initiale_PBR ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    maladie_renale_initiale_echo ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    maladie_renale_initiale_diagnostic ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    maladie_renale_initiale_diagnostic_compl ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    poids_kg ~ Type: float | Null: YES | Key: | Default: | Extra:
    taille_cm ~ Type: float | Null: YES | Key: | Default: | Extra:
    IMC ~ Type: float | Null: YES | Key: | Default: | Extra:
    hb_taux ~ Type: float | Null: YES | Key: | Default: | Extra:
    hb_date ~ Type: date | Null: YES | Key: | Default: | Extra:
    Comorb_tabagisme ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_diabete ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_insulinotherapie ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_HTA ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_Insuffisance_coronarienne ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_IDM ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_pericardite ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_trouble_rythme ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_insuffisance_cardiaque ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_AVC ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_arterite_mi ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_ag_hbs_positif ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_Ac_hvc_positif ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_cirrhose ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_vih ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_bpco ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_tuberculose ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_cancer ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_autre ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    Comorb_autre_precisez ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    handicap_aucun ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_para_hemi ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_TSC ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_ami ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_tsv ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_cecite ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_ND ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_autre ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    handicap_autre_precisez ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    marche ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ped_perimetre_cranien ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ped_perimetre_brachial ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ped_taille_enfant ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ped_scolarise ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    traitement_actuel ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    traitement_actuel_non_traite_reason ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    non_traite_autre ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    non_traite_autre_precisez ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    non_traite_creatininemie ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    non_traite_clairance_creatinine ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    traitement_actuel_type ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_modalites ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_nbre_seance_semaine ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_duree_seance ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_circonstances_demarage ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_fav ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_pontage ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_kt_tunn ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_kt_temp ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_voie_abord_act_nd ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    hemod_projet_greffe ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    dia_peri_modalites ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    dia_peri_projet_greffe ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    greffe_ren_creatininemie ~ Type: float | Null: YES | Key: | Default: | Extra:
    greffe_ren_creatininemie_date ~ Type: date | Null: YES | Key: | Default: | Extra:
    greffe_ren_lieu_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    greffe_ren_lieu_ville ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    greffe_ren_lieu_pays ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    greffe_ren_type ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    greffe_ren_sexe_donneur ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:
    greffe_ren_datenaiss_donneur ~ Type: date | Null: YES | Key: | Default: | Extra:
    fiche_commentaire ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    patient_fiche ~ Type: varchar(50) | Null: YES | Key: | Default: Identification | Extra:
    patient_fiche_code ~ Type: int(1) | Null: YES | Key: | Default: 0 | Extra:
    saisie_par ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    modifie_par ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
    date_modif ~ Type: date | Null: YES | Key: | Default: | Extra:
    deces ~ Type: varchar(10) | Null: NO | Key: | Default: S/O | Extra:
    date_deces ~ Type: date | Null: YES | Key: | Default: | Extra:
    lieu_deces ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    cause_deces ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    cause_deces_groupe ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
  35. pilot_notes
    36. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    note_id ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    patient_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    note ~ Type: text | Null: YES | Key: | Default: | Extra:
    note_type ~ Type: varchar(100) | Null: YES | Key: | Default: 0 | Extra:
    saisie_par ~ Type: varchar(100) | Null: NO | Key: | Default: N/A | Extra:
    modifie_par ~ Type: varchar(100) | Null: NO | Key: | Default: N/A | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
    date_modif ~ Type: date | Null: YES | Key: | Default: | Extra:
  36. professions
    37. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    profession ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    category ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    saisie_par ~ Type: varchar(20) | Null: YES | Key: | Default: | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
    modifie_par ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    date_modif ~ Type: date | Null: YES | Key: | Default: | Extra:
  37. pub
    38. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    rang ~ Type: int(11) | Null: YES | Key: | Default: 0 | Extra:
    act_type ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    act_type_code ~ Type: double | Null: YES | Key: | Default: | Extra:
    act_lien ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    act_titre ~ Type: varchar(255) | Null: NO | Key: | Default: | Extra:
    act_img ~ Type: varchar(255) | Null: YES | Key: | Default: sineph_pas_img.png | Extra:
    saisie_par ~ Type: varchar(100) | Null: YES | Key: | Default: N/A | Extra:
    modifie_par ~ Type: varchar(100) | Null: YES | Key: | Default: N/A | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
  38. publications
    39. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    pub_type ~ Type: varchar(50) | Null: YES | Key: | Default: Jounal | Extra:
    pub_type_code ~ Type: float | Null: YES | Key: | Default: 1 | Extra:
    pub_date ~ Type: date | Null: YES | Key: | Default: | Extra:
    pub_journal_conf ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    pub_volume_lieu ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    pub_pages ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    pub_authors ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    pub_titre ~ Type: varchar(255) | Null: NO | Key: | Default: | Extra:
    pub_lien ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    saisie_par ~ Type: varchar(100) | Null: YES | Key: | Default: N/A | Extra:
    modifie_par ~ Type: varchar(100) | Null: YES | Key: | Default: N/A | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
  39. questionsec
    40. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    questionsec ~ Type: varchar(255) | Null: NO | Key: | Default: | Extra:
  40. role
    41. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    role ~ Type: varchar(50) | Null: NO | Key: | Default: | Extra:
    membership_type ~ Type: varchar(50) | Null: NO | Key: | Default: | Extra:
    role_type ~ Type: varchar(50) | Null: NO | Key: | Default: | Extra:
  41. services
    42. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    services ~ Type: varchar(50) | Null: NO | Key: | Default: | Extra:
  42. suggestions
    43. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    saisie_par ~ Type: varchar(100) | Null: NO | Key: | Default: N/A | Extra:
    member_code ~ Type: varchar(100) | Null: NO | Key: | Default: N/A | Extra:
    lapage ~ Type: varchar(100) | Null: NO | Key: | Default: N/A | Extra:
    suggestion ~ Type: varchar(255) | Null: NO | Key: | Default: | Extra:
    action ~ Type: varchar(50) | Null: NO | Key: | Default: Suggérée | Extra:
    commentaire ~ Type: varchar(255) | Null: NO | Key: | Default: N/A | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
  43. tables_nom_prenom_code
    44. temp ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    nom ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    prenoms ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    NP_sexe ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    NP_DDN ~ Type: datetime | Null: YES | Key: | Default: | Extra:
  44. texte_recom
    45. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    text_type ~ Type: varchar(50) | Null: YES | Key: | Default: texte | Extra:
    text_date ~ Type: date | Null: YES | Key: | Default: | Extra:
    text_source ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    text_titre ~ Type: varchar(255) | Null: NO | Key: | Default: | Extra:
    text_descrip ~ Type: text | Null: YES | Key: | Default: | Extra:
    text_fichier ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    saisie_par ~ Type: varchar(100) | Null: YES | Key: | Default: N/A | Extra:
    modifie_par ~ Type: varchar(100) | Null: YES | Key: | Default: N/A | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
  45. total_visitors
    46. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    session ~ Type: text | Null: YES | Key: | Default: | Extra:
    time ~ Type: int(11) | Null: YES | Key: | Default: | Extra:
    codesineph ~ Type: varchar(50) | Null: YES | Key: | Default: --- | Extra:
    userip ~ Type: varchar(16) | Null: YES | Key: | Default: --- | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
  46. userlog
    47. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    email ~ Type: varchar(50) | Null: NO | Key: | Default: | Extra:
    userip ~ Type: varbinary(16) | Null: NO | Key: | Default: | Extra:
    loginTime ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
  47. userlog_attempt
    48. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    email ~ Type: varchar(50) | Null: NO | Key: | Default: | Extra:
    password ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    userip ~ Type: varbinary(16) | Null: NO | Key: | Default: | Extra:
    loginTime ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
  48. users
    49. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    pays ~ Type: varchar(50) | Null: NO | Key: | Default: Côte d’Ivoire | Extra:
    role ~ Type: varchar(50) | Null: NO | Key: | Default: | Extra:
    usercode ~ Type: varchar(10) | Null: YES | Key: | Default: inactif | Extra:
    password ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    first_name ~ Type: varchar(255) | Null: NO | Key: | Default: | Extra:
    last_name ~ Type: varchar(255) | Null: NO | Key: | Default: | Extra:
    email ~ Type: varchar(255) | Null: NO | Key: UNI | Default: | Extra:
    telephone ~ Type: varchar(20) | Null: YES | Key: | Default: | Extra:
    status ~ Type: int(11) | Null: NO | Key: | Default: 1 | Extra:
    sec_question ~ Type: varchar(255) | Null: NO | Key: | Default: | Extra:
    sec_answer ~ Type: varchar(255) | Null: NO | Key: | Default: | Extra:
    language ~ Type: varchar(20) | Null: NO | Key: | Default: fr | Extra:
    user_level ~ Type: varchar(50) | Null: NO | Key: | Default: medecin | Extra:
    member_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    membership_type ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    membership_date ~ Type: datetime | Null: YES | Key: | Default: | Extra:
    membership_end ~ Type: datetime | Null: YES | Key: | Default: | Extra:
    user_registre ~ Type: varchar(10) | Null: YES | Key: | Default: non | Extra:
    comment ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    active ~ Type: varchar(50) | Null: NO | Key: | Default: No | Extra:
    user_pilot ~ Type: varchar(11) | Null: NO | Key: | Default: no | Extra:
    userip ~ Type: varbinary(16) | Null: YES | Key: | Default: | Extra:
    logintime ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
    logoutime ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
    modifie_par ~ Type: varchar(50) | Null: YES | Key: | Default: N/A | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
  49. users_old
    50. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    pays ~ Type: varchar(50) | Null: NO | Key: | Default: Côte d’Ivoire | Extra:
    ville ~ Type: varchar(50) | Null: NO | Key: | Default: Abidjan | Extra:
    centre ~ Type: varchar(70) | Null: NO | Key: | Default: Centre de dialyse Treichville | Extra:
    role ~ Type: varchar(50) | Null: NO | Key: | Default: | Extra:
    usercode ~ Type: varchar(10) | Null: YES | Key: | Default: inactif | Extra:
    password ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    first_name ~ Type: varchar(255) | Null: NO | Key: | Default: | Extra:
    last_name ~ Type: varchar(255) | Null: NO | Key: | Default: | Extra:
    email ~ Type: varchar(255) | Null: NO | Key: UNI | Default: | Extra:
    telephone ~ Type: varchar(20) | Null: YES | Key: | Default: | Extra:
    status ~ Type: int(11) | Null: NO | Key: | Default: 1 | Extra:
    sec_question ~ Type: varchar(255) | Null: NO | Key: | Default: | Extra:
    sec_answer ~ Type: varchar(255) | Null: NO | Key: | Default: | Extra:
    language ~ Type: varchar(20) | Null: NO | Key: | Default: fr | Extra:
    user_level ~ Type: varchar(50) | Null: NO | Key: | Default: utilisateur | Extra:
    member_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    membership_type ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:
    membership_date ~ Type: datetime | Null: YES | Key: | Default: | Extra:
    membership_end ~ Type: datetime | Null: YES | Key: | Default: | Extra:
    comment ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:
    active ~ Type: varchar(50) | Null: NO | Key: | Default: No | Extra:
    userip ~ Type: varbinary(16) | Null: YES | Key: | Default: | Extra:
    logintime ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
    logoutime ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
    modifie_par ~ Type: varchar(50) | Null: YES | Key: | Default: N/A | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:
  50. villes
    51. id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment
    pays ~ Type: varchar(50) | Null: NO | Key: | Default: Côte d’Ivoire | Extra:
    ville ~ Type: varchar(50) | Null: NO | Key: UNI | Default: | Extra:
    longitude ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    latitude ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:
    ville_abbrev ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:
    saisie_par ~ Type: varchar(100) | Null: NO | Key: | Default: N/A | Extra:
    modifie_par ~ Type: varchar(100) | Null: NO | Key: | Default: N/A | Extra:
    dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:

© S.I.NEPH: Société Ivoirienne de Néphrologie

   

Altesse Data Consultant
© Dr Aïcha N. Traoré
WebMail