def |
STB |
Agences |
ID_Agence |
1 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
PRI |
auto_increment |
select,insert,update,references |
|
|
NULL
|
def |
STB |
Agences |
Nom_Agence |
2 |
NULL
|
NO |
varchar |
50 |
200 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(50) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
STB |
Agences |
Adresse_Agence |
3 |
NULL
|
YES |
varchar |
255 |
1020 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(255) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
STB |
Agences |
Telephone_Agence |
4 |
NULL
|
YES |
varchar |
15 |
60 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(15) |
UNI |
|
select,insert,update,references |
|
|
NULL
|
def |
STB |
Clients |
ID_Client |
1 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
PRI |
auto_increment |
select,insert,update,references |
|
|
NULL
|
def |
STB |
Clients |
Nom |
2 |
NULL
|
NO |
varchar |
50 |
200 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(50) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
STB |
Clients |
Prenom |
3 |
NULL
|
NO |
varchar |
50 |
200 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(50) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
STB |
Clients |
Adresse |
4 |
NULL
|
YES |
varchar |
255 |
1020 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(255) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
STB |
Clients |
Telephone |
5 |
NULL
|
YES |
varchar |
15 |
60 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(15) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
STB |
Clients |
Email |
6 |
NULL
|
YES |
varchar |
100 |
400 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(100) |
UNI |
|
select,insert,update,references |
|
|
NULL
|
def |
STB |
Clients |
CIN |
7 |
NULL
|
NO |
varchar |
8 |
32 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(8) |
UNI |
|
select,insert,update,references |
|
|
NULL
|
def |
STB |
Clients |
Date_Naissance |
8 |
NULL
|
YES |
date |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
date |
|
|
select,insert,update,references |
|
|
NULL
|
def |
STB |
Comptes |
ID_Compte |
1 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
PRI |
auto_increment |
select,insert,update,references |
|
|
NULL
|
def |
STB |
Comptes |
Numero_Compte |
2 |
NULL
|
NO |
varchar |
20 |
80 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(20) |
UNI |
|
select,insert,update,references |
|
|
NULL
|
def |
STB |
Comptes |
Type_Compte |
3 |
NULL
|
NO |
varchar |
20 |
80 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(20) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
STB |
Comptes |
Solde |
4 |
0.00 |
YES |
decimal |
NULL
|
NULL
|
15 |
2 |
NULL
|
NULL
|
NULL
|
decimal(15,2) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
STB |
Comptes |
Date_Ouverture |
5 |
NULL
|
NO |
date |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
date |
|
|
select,insert,update,references |
|
|
NULL
|
def |
STB |
Comptes |
ID_Client |
6 |
NULL
|
YES |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
MUL |
|
select,insert,update,references |
|
|
NULL
|
def |
STB |
Employes |
ID_Employe |
1 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
PRI |
auto_increment |
select,insert,update,references |
|
|
NULL
|
def |
STB |
Employes |
Nom |
2 |
NULL
|
NO |
varchar |
50 |
200 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(50) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
STB |
Employes |
Prenom |
3 |
NULL
|
NO |
varchar |
50 |
200 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(50) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
STB |
Employes |
Poste |
4 |
NULL
|
YES |
varchar |
50 |
200 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(50) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
STB |
Employes |
Salaire |
5 |
NULL
|
YES |
decimal |
NULL
|
NULL
|
10 |
2 |
NULL
|
NULL
|
NULL
|
decimal(10,2) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
STB |
Employes |
Date_Embauche |
6 |
NULL
|
YES |
date |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
date |
|
|
select,insert,update,references |
|
|
NULL
|
def |
STB |
Employes |
ID_Agence |
7 |
NULL
|
YES |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
MUL |
|
select,insert,update,references |
|
|
NULL
|