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
) |
