def |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ |
Кількість дзвінків кожного абонента |
Кількість дзвінків |
2 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ |
Кількість дзвінків кожного абонента |
Назва |
1 |
NULL
|
NO |
text |
65535 |
65535 |
NULL
|
NULL
|
NULL
|
utf8 |
utf8_general_ci |
text |
|
|
select,insert,update,references |
|
|
NULL
|
def |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ |
Тарифна сітка |
Тип даних |
2 |
NULL
|
NO |
text |
65535 |
65535 |
NULL
|
NULL
|
NULL
|
utf8 |
utf8_general_ci |
text |
|
|
select,insert,update,references |
|
|
NULL
|
def |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ |
Тарифна сітка |
Ім'я поля |
1 |
NULL
|
NO |
text |
65535 |
65535 |
NULL
|
NULL
|
NULL
|
utf8 |
utf8_general_ci |
text |
|
|
select,insert,update,references |
|
|
NULL
|
def |
HospitalDB |
consists_of |
staff_no |
1 |
NULL
|
NO |
char |
3 |
12 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
char(3) |
PRI |
|
select,insert,update,references |
|
|
NULL
|
def |
HospitalDB |
consists_of |
team_code |
2 |
NULL
|
NO |
char |
3 |
12 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
char(3) |
MUL |
|
select,insert,update,references |
|
|
NULL
|
def |
HospitalDB |
doctor |
doctor_name |
2 |
NULL
|
YES |
varchar |
20 |
80 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(20) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
HospitalDB |
doctor |
position |
3 |
NULL
|
YES |
varchar |
20 |
80 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(20) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
HospitalDB |
doctor |
staff_no |
1 |
NULL
|
NO |
char |
3 |
12 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
char(3) |
PRI |
|
select,insert,update,references |
|
|
NULL
|
def |
HospitalDB |
drug |
drug_code |
1 |
NULL
|
NO |
char |
3 |
12 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
char(3) |
PRI |
|
select,insert,update,references |
|
|
NULL
|
def |
HospitalDB |
drug |
drug_name |
2 |
NULL
|
YES |
varchar |
20 |
80 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(20) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
HospitalDB |
drug |
price |
4 |
NULL
|
YES |
decimal |
NULL
|
NULL
|
5 |
2 |
NULL
|
NULL
|
NULL
|
decimal(5,2) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
HospitalDB |
drug |
type |
3 |
NULL
|
YES |
varchar |
20 |
80 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(20) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
HospitalDB |
nurse |
nurse_name |
2 |
NULL
|
YES |
varchar |
20 |
80 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(20) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
HospitalDB |
nurse |
staff_no |
1 |
NULL
|
NO |
char |
3 |
12 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
char(3) |
PRI |
|
select,insert,update,references |
|
|
NULL
|
def |
HospitalDB |
nurse |
ward_no |
3 |
NULL
|
NO |
char |
2 |
8 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
char(2) |
MUL |
|
select,insert,update,references |
|
|
NULL
|
def |
HospitalDB |
occupying |
patient_id |
1 |
NULL
|
NO |
char |
3 |
12 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
char(3) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
HospitalDB |
occupying |
patient_name |
2 |
NULL
|
YES |
varchar |
20 |
80 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(20) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
HospitalDB |
occupying |
ward_name |
3 |
NULL
|
YES |
varchar |
20 |
80 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(20) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
HospitalDB |
patient |
gender |
3 |
NULL
|
YES |
char |
1 |
4 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
char(1) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
HospitalDB |
patient |
height |
4 |
NULL
|
YES |
decimal |
NULL
|
NULL
|
4 |
1 |
NULL
|
NULL
|
NULL
|
decimal(4,1) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
HospitalDB |
patient |
patient_id |
1 |
NULL
|
NO |
char |
3 |
12 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
char(3) |
PRI |
|
select,insert,update,references |
|
|
NULL
|
def |
HospitalDB |
patient |
patient_name |
2 |
NULL
|
YES |
varchar |
20 |
80 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(20) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
HospitalDB |
patient |
staff_no |
6 |
NULL
|
NO |
char |
3 |
12 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
char(3) |
MUL |
|
select,insert,update,references |
|
|
NULL
|
def |
HospitalDB |
patient |
ward_no |
7 |
NULL
|
NO |
char |
2 |
8 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
char(2) |
MUL |
|
select,insert,update,references |
|
|
NULL
|