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 |
MedicalPractice |
Appointment |
AppDate |
3 |
NULL
|
NO |
date |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
date |
|
|
select,insert,update,references |
|
|
NULL
|
def |
MedicalPractice |
Appointment |
Appointment_ID |
1 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
PRI |
auto_increment |
select,insert,update,references |
|
|
NULL
|
def |
MedicalPractice |
Appointment |
AppStartTime |
4 |
NULL
|
NO |
time |
NULL
|
NULL
|
NULL
|
NULL
|
0 |
NULL
|
NULL
|
time |
|
|
select,insert,update,references |
|
|
NULL
|
def |
MedicalPractice |
Appointment |
Patient_Ref |
5 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
MUL |
|
select,insert,update,references |
|
|
NULL
|
def |
MedicalPractice |
Appointment |
Practitioner_Ref |
2 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
MUL |
|
select,insert,update,references |
|
|
NULL
|
def |
MedicalPractice |
Availability |
Practitioner_Ref |
1 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
PRI |
|
select,insert,update,references |
|
|
NULL
|
def |
MedicalPractice |
Availability |
WeekDayName_Ref |
2 |
NULL
|
NO |
varchar |
9 |
27 |
NULL
|
NULL
|
NULL
|
utf8 |
utf8_general_ci |
varchar(9) |
PRI |
|
select,insert,update,references |
|
|
NULL
|
def |
MedicalPractice |
Patient |
DateOfBirth |
14 |
NULL
|
NO |
date |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
date |
|
|
select,insert,update,references |
|
|
NULL
|
def |
MedicalPractice |
Patient |
FirstName |
3 |
NULL
|
NO |
varchar |
50 |
150 |
NULL
|
NULL
|
NULL
|
utf8 |
utf8_general_ci |
varchar(50) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
MedicalPractice |
Patient |
Gender |
15 |
NULL
|
NO |
char |
20 |
60 |
NULL
|
NULL
|
NULL
|
utf8 |
utf8_general_ci |
char(20) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
MedicalPractice |
Patient |
HomePhone |
11 |
NULL
|
YES |
char |
11 |
33 |
NULL
|
NULL
|
NULL
|
utf8 |
utf8_general_ci |
char(11) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
MedicalPractice |
Patient |
HouseUnitLotNum |
6 |
NULL
|
YES |
varchar |
5 |
15 |
NULL
|
NULL
|
NULL
|
utf8 |
utf8_general_ci |
varchar(5) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
MedicalPractice |
Patient |
LastName |
5 |
NULL
|
NO |
varchar |
50 |
150 |
NULL
|
NULL
|
NULL
|
utf8 |
utf8_general_ci |
varchar(50) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
MedicalPractice |
Patient |
MedicareNumber |
13 |
NULL
|
YES |
char |
16 |
48 |
NULL
|
NULL
|
NULL
|
utf8 |
utf8_general_ci |
char(16) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
MedicalPractice |
Patient |
MiddleInitial |
4 |
NULL
|
YES |
char |
1 |
3 |
NULL
|
NULL
|
NULL
|
utf8 |
utf8_general_ci |
char(1) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
MedicalPractice |
Patient |
MobilePhone |
12 |
NULL
|
YES |
char |
11 |
33 |
NULL
|
NULL
|
NULL
|
utf8 |
utf8_general_ci |
char(11) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
MedicalPractice |
Patient |
Patient_ID |
1 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
PRI |
auto_increment |
select,insert,update,references |
|
|
NULL
|
def |
MedicalPractice |
Patient |
PostCode |
10 |
NULL
|
NO |
char |
4 |
12 |
NULL
|
NULL
|
NULL
|
utf8 |
utf8_general_ci |
char(4) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
MedicalPractice |
Patient |
State |
9 |
NULL
|
NO |
varchar |
3 |
9 |
NULL
|
NULL
|
NULL
|
utf8 |
utf8_general_ci |
varchar(3) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
MedicalPractice |
Patient |
Street |
7 |
NULL
|
NO |
varchar |
50 |
150 |
NULL
|
NULL
|
NULL
|
utf8 |
utf8_general_ci |
varchar(50) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
MedicalPractice |
Patient |
Suburb |
8 |
NULL
|
NO |
varchar |
50 |
150 |
NULL
|
NULL
|
NULL
|
utf8 |
utf8_general_ci |
varchar(50) |
|
|
select,insert,update,references |
|
|
NULL
|