1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
| CREATE TABLE perso (
pe_code_pk Integer(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
pe_titre Enum('MR', 'ME', 'ML'),
pe_nom_marital NVarChar(20) COLLATE utf8_general_ci,
pe_prenom NVarChar(20) COLLATE utf8_general_ci,
pe_nom_naissance NVarChar(20) COLLATE utf8_general_ci,
pe_naissance Date NOT NULL,
pe_dep Enum('H', 'F', 'JH', 'JF') NOT NULL,
pe_situation Enum('C', 'D', 'K', 'M', 'S', 'V'),
pe_adresse1 NVarChar(40) COLLATE utf8_general_ci,
pe_adresse2 NVarChar(20) COLLATE utf8_general_ci,
pe_cp Integer(5),
pe_ville NVarChar(30) COLLATE utf8_general_ci,
pe_telville NVarChar(15) COLLATE utf8_general_ci,
pe_telpro NVarChar(15) COLLATE utf8_general_ci,
pe_telpor NVarChar(15) COLLATE utf8_general_ci,
pe_fax NVarChar(15) COLLATE utf8_general_ci,
pe_mail NVarChar(30) COLLATE utf8_general_ci,
pe_debut Date,
pe_statut Enum('A', 'D', 'I', 'M', 'P', 'R', 'S'),
pe_hote NVarChar(40) COLLATE utf8_general_ci,
pe_jour_sad Enum('DIM', 'LUN', 'MAR', 'MER', 'JEU', 'VEN', 'SAM'),
pe_depart NVarChar(20) COLLATE utf8_general_ci,
pe_etude_niveau NVarChar(10) COLLATE utf8_general_ci,
pe_etude_date_1 Date,
pe_etude_date_2 Date,
pe_etude_date_3 Date,
pe_etude_date_4 Date,
pe_etude_note Double,
pe_acsbn Integer(11),
pe_id_acsbn Integer(11),
pe_date_deces Date,
pe_user_fk Integer(11),
pe_created Date,
pe_updated Date
) |
Partager