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 |
NEW_EWMP |
Appraisals |
appraisal_id |
1 |
NULL
|
NO |
bigint |
NULL
|
NULL
|
20 |
0 |
NULL
|
NULL
|
NULL
|
bigint(20) unsigned |
PRI |
auto_increment |
select,insert,update,references |
|
|
NULL
|
def |
NEW_EWMP |
Appraisals |
property_id |
2 |
NULL
|
YES |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
NEW_EWMP |
Appraisals |
appraised_value |
3 |
NULL
|
YES |
decimal |
NULL
|
NULL
|
15 |
2 |
NULL
|
NULL
|
NULL
|
decimal(15,2) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
NEW_EWMP |
Appraisals |
appraisal_date |
4 |
NULL
|
YES |
date |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
date |
|
|
select,insert,update,references |
|
|
NULL
|
def |
NEW_EWMP |
Appraisals |
appraiser_name |
5 |
NULL
|
YES |
varchar |
150 |
600 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(150) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
NEW_EWMP |
Appraisals |
comments |
6 |
NULL
|
YES |
text |
65535 |
65535 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
text |
|
|
select,insert,update,references |
|
|
NULL
|
def |
NEW_EWMP |
GeospatialData |
geospatial_id |
1 |
NULL
|
NO |
bigint |
NULL
|
NULL
|
20 |
0 |
NULL
|
NULL
|
NULL
|
bigint(20) unsigned |
PRI |
auto_increment |
select,insert,update,references |
|
|
NULL
|
def |
NEW_EWMP |
GeospatialData |
property_id |
2 |
NULL
|
YES |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
NEW_EWMP |
GeospatialData |
neighborhood_rating |
3 |
NULL
|
YES |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
NEW_EWMP |
GeospatialData |
proximity_to_schools |
4 |
NULL
|
YES |
decimal |
NULL
|
NULL
|
5 |
2 |
NULL
|
NULL
|
NULL
|
decimal(5,2) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
NEW_EWMP |
GeospatialData |
proximity_to_public_transportation |
5 |
NULL
|
YES |
decimal |
NULL
|
NULL
|
5 |
2 |
NULL
|
NULL
|
NULL
|
decimal(5,2) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
NEW_EWMP |
GeospatialData |
flood_risk |
6 |
NULL
|
YES |
varchar |
50 |
200 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(50) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
NEW_EWMP |
GeospatialData |
earthquake_risk |
7 |
NULL
|
YES |
varchar |
50 |
200 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(50) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
NEW_EWMP |
GeospatialData |
crime_rate |
8 |
NULL
|
YES |
varchar |
50 |
200 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(50) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
NEW_EWMP |
MaintenanceAndRepair |
maintenance_id |
1 |
NULL
|
NO |
bigint |
NULL
|
NULL
|
20 |
0 |
NULL
|
NULL
|
NULL
|
bigint(20) unsigned |
PRI |
auto_increment |
select,insert,update,references |
|
|
NULL
|
def |
NEW_EWMP |
MaintenanceAndRepair |
property_id |
2 |
NULL
|
YES |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
NEW_EWMP |
MaintenanceAndRepair |
maintenance_type |
3 |
NULL
|
YES |
varchar |
100 |
400 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(100) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
NEW_EWMP |
MaintenanceAndRepair |
cost |
4 |
NULL
|
YES |
decimal |
NULL
|
NULL
|
15 |
2 |
NULL
|
NULL
|
NULL
|
decimal(15,2) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
NEW_EWMP |
MaintenanceAndRepair |
maintenance_date |
5 |
NULL
|
YES |
date |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
date |
|
|
select,insert,update,references |
|
|
NULL
|
def |
NEW_EWMP |
MaintenanceAndRepair |
contractor_name |
6 |
NULL
|
YES |
varchar |
150 |
600 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(150) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
NEW_EWMP |
MaintenanceAndRepair |
description |
7 |
NULL
|
YES |
text |
65535 |
65535 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
text |
|
|
select,insert,update,references |
|
|
NULL
|