LIST OF TABLES

---

1. 00_views
id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

view_name ~ Type: varchar(255) | Null: YES | Key: UNI | Default: | Extra:

---

view_query ~ Type: text | Null: YES | Key: | Default: | Extra:

---

n ~ Type: double | Null: NO | Key: | Default: 1 | Extra:

---

2. abstracts
id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

ledossier ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_code_abstract ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_pays ~ Type: varchar(100) | Null: YES | Key: | Default: Côte d’Ivoire | Extra:

---

m_nom ~ Type: varchar(100) | Null: YES | Key: | Default: - | Extra:

---

m_prenom ~ Type: varchar(100) | Null: YES | Key: | Default: - | Extra:

---

m_code ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:

---

m_cel_1 ~ Type: varchar(20) | Null: YES | Key: | Default: | Extra:

---

m_cel_2 ~ Type: varchar(20) | Null: YES | Key: | Default: | Extra:

---

m_email ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:

---

m_site_1 ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_site_2 ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_site_3 ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_site_4 ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_site_5 ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_site_6 ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_1_nom ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_1_prenom ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_1_role ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_1_site ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_2_nom ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_2_prenom ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_2_role ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_2_site ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_3_nom ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_3_prenom ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_3_role ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_3_site ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_4_nom ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_4_prenom ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_4_role ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_4_site ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_5_nom ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_5_prenom ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_5_role ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_5_site ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_6_nom ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_6_prenom ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_6_role ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_6_site ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_7_nom ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_7_prenom ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_7_role ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_7_site ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_8_nom ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_8_prenom ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_8_role ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_aut_8_site ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_abstract ~ Type: text | Null: YES | Key: | Default: | Extra:

---

m_spec ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_titre ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_mots ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_type ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_decision ~ Type: varchar(255) | Null: YES | Key: | Default: nouveau / new | Extra:

---

m_comment ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_present ~ Type: varchar(255) | 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:

---

3. activites_type
id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

act_type ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

act_type_en ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

act_type_code ~ Type: double | Null: YES | Key: | Default: | Extra:

---

4. actualites
id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

act_fr ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

act_en ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

periode ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

file_fr ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

file_en ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

descrip ~ Type: text | Null: YES | Key: | Default: | Extra:

---

periode_fin ~ Type: date | Null: YES | Key: | Default: | Extra:

---

descrip_en ~ Type: text | Null: YES | Key: | Default: | Extra:

---

video ~ Type: text | Null: YES | Key: | Default: | Extra:

---

lieu ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

act_type ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

act_type_en ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

act_type_code ~ Type: double | 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:

---

5. centres
id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

country ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:

---

state_region ~ Type: varchar(255) | Null: NO | Key: | Default: ---------- | Extra:

---

city ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:

---

centre ~ Type: varchar(255) | Null: NO | Key: | Default: Centre X | Extra:

---

centre_id ~ Type: varchar(50) | Null: YES | Key: UNI | Default: | Extra:

---

date_remplissage ~ Type: date | Null: YES | Key: | Default: | Extra:

---

centre_code ~ Type: varchar(50) | Null: YES | Key: UNI | Default: | Extra:

---

centre_address ~ Type: varchar(255) | Null: NO | Key: | Default: ---------- | Extra:

---

centre_telephone ~ Type: varchar(100) | Null: NO | Key: | Default: ---------- | Extra:

---

centre_fax ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

centre_email ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:

---

centre_note ~ Type: varchar(255) | 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:

---

6. centres_code_liste
id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

country ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

state_region ~ Type: varchar(255) | Null: NO | Key: | Default: ---------- | Extra:

---

city ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:

---

centre ~ Type: varchar(255) | Null: NO | Key: | Default: Centre X | Extra:

---

centre_code ~ Type: varchar(50) | Null: YES | Key: UNI | Default: | Extra:

---

code_du_centre ~ Type: varchar(50) | Null: YES | Key: UNI | Default: | Extra:

---

7. comites
id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

comite_fr ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

comite_en ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

periode ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

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:

---

8. congres
id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

ledossier ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

cong_fr ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

cong_en ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

sympo_fr ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

sympo_en ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

lieu_pays ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

lieu_ville ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

lieu_endroit ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

periode_du ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

periode_au ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

theme_fr ~ Type: text | Null: YES | Key: | Default: | Extra:

---

theme_en ~ Type: text | Null: YES | Key: | Default: | Extra:

---

inscrip_fr ~ Type: text | Null: YES | Key: | Default: | Extra:

---

inscrip_en ~ Type: text | Null: YES | Key: | Default: | Extra:

---

secret_fr ~ Type: text | Null: YES | Key: | Default: | Extra:

---

secret_en ~ Type: text | Null: YES | Key: | Default: | Extra:

---

progr_fr ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

progr_en ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

annonce_fr ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

annonce_en ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

booklet_fr ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

booklet_en ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

inscription ~ Type: varchar(10) | Null: YES | Key: | Default: 0 | Extra:

---

abstract ~ Type: date | Null: YES | Key: | Default: | Extra:

---

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:

---

9. congres_inscription
id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

ledossier ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_nom ~ Type: varchar(100) | Null: YES | Key: | Default: - | Extra:

---

m_prenom ~ Type: varchar(100) | Null: YES | Key: | Default: - | Extra:

---

m_tel_1 ~ Type: varchar(20) | Null: YES | Key: | Default: | Extra:

---

m_cel_1 ~ Type: varchar(20) | Null: YES | Key: | Default: | Extra:

---

m_email ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:

---

m_pays ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_adresse1 ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_ville ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_adresse2 ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

session_saemn ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:

---

session_diab ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:

---

session_alliance ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_membre_type ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:

---

session_am ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:

---

session_pm ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:

---

session_atelier ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:

---

session_buffet ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:

---

session_logement ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:

---

dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:

---

10. country
id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

Alpha2 ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:

---

country ~ Type: varchar(100) | Null: NO | Key: | Default: | Extra:

---

pays ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

continent ~ Type: varchar(20) | Null: NO | Key: | Default: Africa | Extra:

---

region ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:

---

continents ~ Type: varchar(50) | Null: NO | Key: | Default: Afrique | Extra:

---

membre ~ Type: double | Null: YES | Key: | Default: 0 | Extra:

---

images ~ Type: varchar(255) | Null: YES | Key: | Default: flag.png | Extra:

---

nouvel_image ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

n ~ Type: double | Null: YES | Key: | Default: 1 | Extra:

---

11. images_defilantes
id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

images ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

nouvel_image ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

n ~ Type: double | Null: NO | Key: | Default: 1 | Extra:

---

12. langues
id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

lang_rank ~ Type: float | Null: YES | Key: | Default: | Extra:

---

colonne ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

lang_fr ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

lang_en ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

13. lespartenaires
id ~ Type: double | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

folderid ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

descrip ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

photo ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

toremove ~ Type: varchar(10) | Null: NO | Key: | Default: no | Extra:

---

n ~ Type: double | Null: NO | Key: | Default: 1 | Extra:

---

14. membres
id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

m_code ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_code_profil ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_nom ~ Type: varchar(100) | Null: YES | Key: | Default: - | Extra:

---

m_prenom ~ Type: varchar(100) | Null: YES | Key: | Default: - | Extra:

---

m_sexe ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:

---

m_an ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:

---

m_tel_1 ~ Type: varchar(20) | Null: YES | Key: | Default: | Extra:

---

m_tel_2 ~ Type: varchar(20) | Null: YES | Key: | Default: | Extra:

---

m_cel_1 ~ Type: varchar(20) | Null: YES | Key: | Default: | Extra:

---

m_cel_2 ~ Type: varchar(20) | Null: YES | Key: | Default: | Extra:

---

m_email ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:

---

m_pays ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_centre ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_ville ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_centre2 ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_ville2 ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_centre_autre ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_membre_depuis ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:

---

m_membre_numero ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_membre_role ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

m_membre_type ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:

---

m_specialite ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

m_profil ~ Type: varchar(10) | Null: YES | Key: | Default: non | Extra:

---

m_commentaire ~ Type: varchar(255) | Null: YES | Key: | Default: membre | Extra:

---

m_level ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

m_registre ~ Type: varchar(100) | 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:

---

15. membres_type
id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

type_id ~ Type: varchar(11) | Null: YES | Key: | Default: | Extra:

---

type_fr ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:

---

type_en ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:

---

16. patients_biologie
id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

date_remplissage ~ Type: date | Null: YES | Key: | Default: | Extra:

---

patient_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:

---

autoac ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

glycemie_jeun ~ Type: float | Null: YES | Key: | Default: | Extra:

---

glycemie_casuelle ~ Type: float | Null: YES | Key: | Default: | Extra:

---

hba1c ~ Type: float | Null: YES | Key: | Default: | Extra:

---

uree ~ Type: float | Null: YES | Key: | Default: | Extra:

---

creatinine ~ Type: float | Null: YES | Key: | Default: | Extra:

---

ionogramme_sanguin ~ Type: float | Null: YES | Key: | Default: | Extra:

---

c_peptidemie ~ Type: float | Null: YES | Key: | Default: | Extra:

---

urine_sucre ~ Type: float | Null: YES | Key: | Default: | Extra:

---

urine_acetone ~ Type: float | Null: YES | Key: | Default: | Extra:

---

biologie_autres_diabete ~ Type: varchar(255) | 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:

---

modif ~ Type: float | Null: NO | Key: | Default: 0 | Extra:

---

patient_note ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

17. patients_code
id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

patient_date_remplissage ~ Type: date | Null: YES | Key: | Default: | Extra:

---

patient_pays_identif ~ Type: varchar(50) | 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(100) | Null: YES | Key: | Default: | Extra:

---

dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:

---

18. patients_complications
id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

date_remplissage ~ Type: date | Null: YES | Key: | Default: | Extra:

---

patient_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:

---

metab_ceto_acid_cons ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

metab_ceto_acid_deshy ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

metab_ceto_acid_haleine ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

metab_ceto_acid_dyspnee ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

metab_ceto_acid_glycemie ~ Type: float | Null: YES | Key: | Default: | Extra:

---

metab_ceto_acid_acetonurie ~ Type: float | Null: YES | Key: | Default: | Extra:

---

metab_ceto_acid_glycosurie ~ Type: float | Null: YES | Key: | Default: | Extra:

---

metab_coma_hyper_glycemie ~ Type: float | Null: YES | Key: | Default: | Extra:

---

metab_coma_hyper_osmol ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

metab_coma_hyper_deshy ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

metab_coma_hypo_adren ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

metab_coma_hypo_neurogly ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

metab_coma_hypo_glycemie ~ Type: float | Null: YES | Key: | Default: | Extra:

---

metab_coma_acidose_lactiq ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

chron_micro_angio_neuro_poly ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

chron_micro_angio_neuro_mono ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

chron_micro_angio_neuro_veg ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

chron_micro_angio_retin_fond ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

chron_micro_angio_retin_exam ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

chron_micro_angio_retin_angio ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

chron_micro_angio_retin_classif ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

chron_micro_angio_retin_maculo ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

chron_micro_angio_nephro_micro ~ Type: float | Null: YES | Key: | Default: | Extra:

---

chron_micro_angio_nephro_macro ~ Type: float | Null: YES | Key: | Default: | Extra:

---

chron_micro_angio_nephro_classif ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

chron_macro_angio_aomi_ips ~ Type: float | Null: YES | Key: | Default: | Extra:

---

chron_macro_angio_aomi_classif ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

chron_macro_angio_aomi_echod ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

chron_macro_angio_avc_defic ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

chron_macro_angio_avc_tdm ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

chron_macro_angio_idm_angor ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

chron_macro_angio_idm_ecg ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

infect_orl_otite ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

infect_orl_autres ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

infect_poum_tuberculose ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

infect_poum_ pneumopathie ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

infect_poum_autres ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

infect_peau_furoncle ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

infect_peau_abces ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

infect_peau_furonculose ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

infect_peau_autres ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

infect_muq_anthrax ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

infect_muq_autres ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

infect_bouche_caries ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

infect_bouche_gingivite ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

infect_bouche_parond ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

infect_bouche_autres ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

infect_urin_cystite ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

infect_urin_pyelonephrite ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

infect_urin_autres ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

infect_pied_infec ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

infect_pied_ostetite ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

infect_pied_gangrene ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

infect_pied_autres ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

infect_pied_classif ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

infect_pied_germe ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

autre_malad ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

autre_autoimm ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

autre_nash ~ Type: varchar(100) | 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:

---

modif ~ Type: float | Null: NO | Key: | Default: 0 | Extra:

---

patient_note ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

19. patients_gestationnel
id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

date_remplissage ~ Type: date | Null: YES | Key: | Default: | Extra:

---

patient_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:

---

antec_diabete ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

antec_surpoids ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

antec_sopk ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

antec_diab_gest ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

antec_macromosie ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

antec_mort_in_utero ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

antec_malformation_foetale ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

antec_hydramnios ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

antec_ddr ~ Type: date | Null: YES | Key: | Default: | Extra:

---

antec_age_gestationnel ~ Type: float | Null: YES | Key: | Default: | Extra:

---

antec_terme_probable ~ Type: date | Null: YES | Key: | Default: | Extra:

---

antec_gestite ~ Type: float | Null: YES | Key: | Default: | Extra:

---

antec_parite ~ Type: float | Null: YES | Key: | Default: | Extra:

---

antec_poids_anterieur ~ Type: float | Null: YES | Key: | Default: | Extra:

---

exam_poids ~ Type: float | Null: YES | Key: | Default: | Extra:

---

exam_prise_poids ~ Type: float | Null: YES | Key: | Default: | Extra:

---

exam_taille ~ Type: float | Null: YES | Key: | Default: | Extra:

---

exam_ta_systo ~ Type: float | Null: YES | Key: | Default: | Extra:

---

exam_ta_diasto ~ Type: float | Null: YES | Key: | Default: | Extra:

---

exam_temp ~ Type: float | Null: YES | Key: | Default: | Extra:

---

exam_glycemie_cap ~ Type: float | Null: YES | Key: | Default: | Extra:

---

exam_albumine ~ Type: float | Null: YES | Key: | Default: | Extra:

---

exam_sucre ~ Type: float | Null: YES | Key: | Default: | Extra:

---

exam_gross_risque ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

conduite_hgpo ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

conduite_patho_hgpo ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

conduite_diagnostic ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

conduite_autres ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

consult_gynecologue ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

consult_diabetologue ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

consult_pediatre ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

consult_dieteticien ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

consult_psycho_sociologue ~ Type: varchar(100) | 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:

---

modif ~ Type: float | Null: NO | Key: | Default: 0 | Extra:

---

patient_note ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

lesexe ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:

---

20. patients_identification
id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

patient_date_remplissage ~ Type: date | 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_consent_raison ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

patient_date_naissance ~ Type: date | Null: YES | Key: | Default: | Extra:

---

patient_age_diagnostic ~ Type: float | Null: YES | Key: | Default: | Extra:

---

patient_ville_identif ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:

---

patient_pays_identif ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:

---

patient_sexe ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:

---

centre_inclusion_code ~ Type: varchar(100) | 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:

---

type_diabete ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

patient_decouverte ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

patient_statut ~ Type: varchar(255) | Null: YES | Key: | Default: Vivant|Alive | Extra:

---

annee_diagnostic ~ Type: float | 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:

---

modif ~ Type: float | Null: NO | Key: | Default: 0 | Extra:

---

patient_note ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

21. patients_paraclin
id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

date_remplissage ~ Type: date | Null: YES | Key: | Default: | Extra:

---

patient_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:

---

para_ecg ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

para_echo_card ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

para_radio_pulm ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

para_echo_abdo ~ Type: varchar(100) | 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:

---

modif ~ Type: float | Null: NO | Key: | Default: 0 | Extra:

---

patient_note ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

22. patients_risque
id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

date_remplissage ~ Type: date | Null: YES | Key: | Default: | Extra:

---

patient_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:

---

famille_diabete ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

famille_surpoids ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

famille_idm_mort_subite ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

famille_autre ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

risque_age_sex_h ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

risque_age_sex_f ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

risque_pere_frere_55 ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

risque_mere_soeur_55 ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

risque_dyslipidemie ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

risque_hdlc ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

risque_obesite_androide ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

risque_obesite_androide_tour_taille ~ Type: float | Null: YES | Key: | Default: | Extra:

---

risque_syndrome_metab ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

risque_tabagisme ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

risque_hta ~ Type: varchar(100) | 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:

---

modif ~ Type: float | Null: NO | Key: | Default: 0 | Extra:

---

patient_note ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

23. patients_sociales
id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

date_remplissage ~ Type: date | Null: YES | Key: | Default: | Extra:

---

patient_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:

---

patient_ville ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:

---

patient_matrimoniale ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

patient_education ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

patient_activite ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

patient_profession ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

patient_statut ~ Type: varchar(255) | Null: YES | Key: | Default: Vivant|Alive | Extra:

---

date_statut ~ Type: date | 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:

---

modif ~ Type: float | Null: NO | Key: | Default: 0 | Extra:

---

patient_note ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

24. patients_symptom
id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

date_remplissage ~ Type: date | Null: YES | Key: | Default: | Extra:

---

patient_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:

---

polyurie ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

polydipsie ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

polyphagie ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

amaigrissement ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

insulinoresistance ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

poids ~ Type: float | Null: YES | Key: | Default: | Extra:

---

tour_taille ~ Type: float | Null: YES | Key: | Default: | Extra:

---

imc ~ Type: float | Null: YES | Key: | Default: | Extra:

---

consultation_annonce ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

date_consultation_annonce ~ Type: date | 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:

---

modif ~ Type: float | Null: NO | Key: | Default: 0 | Extra:

---

patient_note ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

25. patients_traitement
id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

date_remplissage ~ Type: date | Null: YES | Key: | Default: | Extra:

---

patient_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:

---

tabac ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

alcool ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

activie_ physique ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

regime_diab_glucides ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

regime_diab_protides ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

regime_diab_lipides ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

connais_diab ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

connais_aliment ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

connais_urgences_diab ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

carnet_surv ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

traitement_vie ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

recours_insuline ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

medic_ado_metformine ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

medic_ado_sulfamide ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

medic_ado_idpp4 ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

medic_ado_isglt2 ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

medic_autre ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

injec_actrapid ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

injec_novorapidInsulatard ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

injec_insulet ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

injec_mixtard ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

injec_novomix ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

injec_lantus ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

injec_autre ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

autre_analog_glp1_liraglutide ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

autre_anti_hta ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

autre_iec ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

autre_sartan ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

autre_autre ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

diur_iec_amlodipine_diur ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

diur_sartan_amlodipine_diur ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

diur_autre ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

statines_atorvastatine ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

statines_simvastatine ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

statines_rosuvastatine ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

statines_autre ~ Type: varchar(100) | 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:

---

modif ~ Type: float | Null: NO | Key: | Default: 0 | Extra:

---

patient_note ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

26. pays
id ~ Type: double | Null: NO | Key: | Default: | Extra:

---

Alpha2 ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

country ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

27. population
id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

Alpha2 ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:

---

pop_year ~ Type: double | Null: YES | Key: | Default: | Extra:

---

annee_year ~ Type: float | Null: YES | Key: | Default: | Extra:

---

28. questions
id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

form ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:

---

question ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

q_code ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

q_fr ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

q_en ~ Type: varchar(100) | Null: YES | Key: | Default: | Extra:

---

29. questionsec
id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

questionsec ~ Type: varchar(255) | Null: NO | Key: | Default: | Extra:

---

questionsec_en ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

30. region
id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

Alpha2 ~ Type: varchar(10) | Null: YES | Key: | Default: | Extra:

---

country ~ Type: varchar(100) | Null: NO | Key: | Default: | Extra:

---

pays ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

region ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:

---

n ~ Type: double | Null: YES | Key: | Default: 1 | Extra:

---

31. suggestions
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:

---

32. tbl_session_lang
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:

---

session_lang ~ Type: varchar(50) | Null: YES | Key: | Default: fr | Extra:

---

userip ~ Type: varchar(16) | Null: YES | Key: | Default: --- | Extra:

---

dates ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:

---

33. userlog
id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

userwho ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:

---

userip ~ Type: varbinary(16) | Null: NO | Key: | Default: | Extra:

---

loginTime ~ Type: timestamp | Null: NO | Key: | Default: CURRENT_TIMESTAMP | Extra:

---

34. users
id ~ Type: int(11) | Null: NO | Key: PRI | Default: | Extra: auto_increment

---

usercode ~ Type: varchar(10) | Null: YES | Key: | Default: inactif | Extra:

---

password ~ Type: varchar(255) | Null: YES | Key: | Default: | Extra:

---

email ~ Type: varchar(255) | Null: NO | Key: UNI | 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:

---

user_level ~ Type: varchar(50) | Null: NO | Key: | Default: membre | Extra:

---

member_code ~ Type: varchar(50) | Null: YES | Key: | Default: | Extra:

---

user_registre ~ Type: varchar(10) | Null: YES | Key: | Default: non | 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:

---

LIST OF VIEWS in MySQL

---

LIST OF VIEWS Recorded

---

Historique

Modifier

---

Français