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 |
INFS1200_RELEASE |
Address |
AddressID |
1 |
NULL
|
NO |
varchar |
4 |
16 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(4) |
PRI |
|
select,insert,update,references |
|
|
NULL
|
def |
INFS1200_RELEASE |
Address |
Country |
7 |
NULL
|
YES |
varchar |
50 |
200 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(50) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
INFS1200_RELEASE |
Address |
Number |
3 |
NULL
|
YES |
varchar |
10 |
40 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(10) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
INFS1200_RELEASE |
Address |
Postcode |
5 |
NULL
|
YES |
varchar |
10 |
40 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(10) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
INFS1200_RELEASE |
Address |
State |
6 |
NULL
|
YES |
varchar |
10 |
40 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(10) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
INFS1200_RELEASE |
Address |
StreetName |
2 |
NULL
|
YES |
varchar |
255 |
1020 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(255) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
INFS1200_RELEASE |
Address |
Suburb |
4 |
NULL
|
YES |
varchar |
255 |
1020 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(255) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
INFS1200_RELEASE |
Customer |
AddressID |
6 |
NULL
|
YES |
varchar |
4 |
16 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(4) |
MUL |
|
select,insert,update,references |
|
|
NULL
|
def |
INFS1200_RELEASE |
Customer |
CustomerID |
1 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
PRI |
|
select,insert,update,references |
|
|
NULL
|
def |
INFS1200_RELEASE |
Customer |
DateOfBirth |
3 |
NULL
|
YES |
date |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
date |
|
|
select,insert,update,references |
|
|
NULL
|
def |
INFS1200_RELEASE |
Customer |
Email |
4 |
NULL
|
YES |
varchar |
255 |
1020 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(255) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
INFS1200_RELEASE |
Customer |
Name |
2 |
NULL
|
YES |
varchar |
255 |
1020 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(255) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
INFS1200_RELEASE |
Customer |
Occupation |
5 |
NULL
|
YES |
varchar |
255 |
1020 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(255) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
INFS1200_RELEASE |
Policy |
CustomerID |
2 |
NULL
|
YES |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
MUL |
|
select,insert,update,references |
|
|
NULL
|
def |
INFS1200_RELEASE |
Policy |
Excess |
6 |
NULL
|
YES |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
INFS1200_RELEASE |
Policy |
PolicyID |
1 |
NULL
|
NO |
varchar |
6 |
24 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(6) |
PRI |
|
select,insert,update,references |
|
|
NULL
|
def |
INFS1200_RELEASE |
Policy |
PolicyPurchaseDate |
5 |
NULL
|
YES |
date |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
date |
|
|
select,insert,update,references |
|
|
NULL
|
def |
INFS1200_RELEASE |
Policy |
PolicyStartYear |
4 |
NULL
|
YES |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
INFS1200_RELEASE |
Policy |
Premium |
7 |
NULL
|
YES |
decimal |
NULL
|
NULL
|
10 |
2 |
NULL
|
NULL
|
NULL
|
decimal(10,2) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
INFS1200_RELEASE |
Policy |
VehicleID |
3 |
NULL
|
YES |
varchar |
6 |
24 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(6) |
MUL |
|
select,insert,update,references |
|
|
NULL
|
def |
INFS1200_RELEASE |
Vehicle |
EstYearlyKm |
4 |
NULL
|
YES |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
|
|
select,insert,update,references |
|
|
NULL
|