def |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ |
Кількість дзвінків кожного абонента |
Назва |
1 |
NULL
|
NO |
text |
65535 |
65535 |
NULL
|
NULL
|
NULL
|
utf8 |
utf8_general_ci |
text |
|
|
select,insert,update,references |
|
|
NULL
|
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 |
CVD |
MEDICAL_DEPARTMENTS |
DEPT_ID |
1 |
NULL
|
NO |
char |
9 |
36 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
char(9) |
PRI |
|
select,insert,update,references |
|
|
NULL
|
def |
CVD |
MEDICAL_DEPARTMENTS |
DEPT_NAME |
2 |
NULL
|
YES |
varchar |
50 |
200 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(50) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
CVD |
MEDICAL_DEPARTMENTS |
MANAGER_ID |
3 |
NULL
|
YES |
char |
9 |
36 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
char(9) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
CVD |
MEDICAL_DEPARTMENTS |
LOCATION_ID |
4 |
NULL
|
YES |
char |
9 |
36 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
char(9) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
CVD |
MEDICAL_HISTORY |
MEDICAL_HISTORY_ID |
1 |
NULL
|
NO |
char |
9 |
36 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
char(9) |
PRI |
|
select,insert,update,references |
|
|
NULL
|
def |
CVD |
MEDICAL_HISTORY |
PATIENT_ID |
2 |
NULL
|
NO |
char |
9 |
36 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
char(9) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
CVD |
MEDICAL_HISTORY |
DIAGNOSIS_DATE |
3 |
NULL
|
YES |
date |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
date |
|
|
select,insert,update,references |
|
|
NULL
|
def |
CVD |
MEDICAL_HISTORY |
DIAGNOSIS_CODE |
4 |
NULL
|
YES |
varchar |
10 |
40 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(10) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
CVD |
MEDICAL_HISTORY |
MEDICAL_CONDITION |
5 |
NULL
|
YES |
varchar |
100 |
400 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(100) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
CVD |
MEDICAL_HISTORY |
DEPT_ID |
6 |
NULL
|
YES |
char |
9 |
36 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
char(9) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
CVD |
MEDICAL_LOCATIONS |
LOCATION_ID |
1 |
NULL
|
NO |
char |
9 |
36 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
char(9) |
PRI |
|
select,insert,update,references |
|
|
NULL
|
def |
CVD |
MEDICAL_LOCATIONS |
DEPT_ID |
2 |
NULL
|
NO |
char |
9 |
36 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
char(9) |
PRI |
|
select,insert,update,references |
|
|
NULL
|
def |
CVD |
MEDICAL_LOCATIONS |
LOCATION_NAME |
3 |
NULL
|
YES |
varchar |
50 |
200 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(50) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
CVD |
MEDICAL_PROCEDURES |
PROCEDURE_ID |
1 |
NULL
|
NO |
char |
9 |
36 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
char(9) |
PRI |
|
select,insert,update,references |
|
|
NULL
|
def |
CVD |
MEDICAL_PROCEDURES |
PROCEDURE_NAME |
2 |
NULL
|
YES |
varchar |
30 |
120 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(30) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
CVD |
MEDICAL_PROCEDURES |
PROCEDURE_DATE |
3 |
NULL
|
YES |
date |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
date |
|
|
select,insert,update,references |
|
|
NULL
|
def |
CVD |
MEDICAL_PROCEDURES |
PATIENT_ID |
4 |
NULL
|
NO |
char |
9 |
36 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
char(9) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
CVD |
MEDICAL_PROCEDURES |
DEPT_ID |
5 |
NULL
|
YES |
char |
9 |
36 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
char(9) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
CVD |
PATIENTS |
PATIENT_ID |
1 |
NULL
|
NO |
char |
9 |
36 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
char(9) |
PRI |
|
select,insert,update,references |
|
|
NULL
|
def |
CVD |
PATIENTS |
FIRST_NAME |
2 |
NULL
|
NO |
varchar |
15 |
60 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(15) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
CVD |
PATIENTS |
LAST_NAME |
3 |
NULL
|
NO |
varchar |
15 |
60 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(15) |
|
|
select,insert,update,references |
|
|
NULL
|