| id |
int(11)
|
|
|
|
| full_name |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| address |
text
|
utf8mb4_general_ci
|
|
|
| birth_date |
date
|
|
|
|
| sexe |
enum('Homme', 'Femme')
|
utf8mb4_general_ci
|
|
|
| id_card_number |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| email |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| phone |
varchar(15)
|
utf8mb4_general_ci
|
|
|
| profile_picture |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| certificate_path |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| nature |
enum('Diplôme', 'Attestation de réussite')
|
utf8mb4_general_ci
|
|
|
| token |
varchar(64)
|
utf8mb4_general_ci
|
|
|
| ip_address |
varchar(45)
|
utf8mb4_general_ci
|
|
|
| browser_info |
text
|
utf8mb4_general_ci
|
|
|
| device_type |
enum('Android', 'PC', 'Other')
|
utf8mb4_general_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
| country_id |
int(11)
|
|
|
|
| level_id |
int(11)
|
|
|
|