7.2 Estimate of Database Size (Green = Tenant DB,
|
TABLE NAME |
# ROWS |
RATE |
BYTES PER ROW |
TABLE SIZE (KB) |
BINARY SIZE (KB) |
3-YEAR STORAGE REQUIREMENT (KB) |
||||
|
FIXED |
Est. VARIABLE |
Est. |
||||||||
|
tbl_Tenant |
11,500 |
Annual |
|
0 |
|
|
|
|
||
|
tbl_Tenant_Invoice |
138,000 |
Annual |
|
0 |
|
|
|
|
||
|
tbl_Tenant_Receipt |
138,000 |
Annual |
|
0 |
|
|
|
|
||
|
tbl_Tenant_Question |
115,000 |
Annual |
|
0 |
|
|
|
|
||
|
tbl_Tenant_Conflict |
115,000 |
Annual |
|
0 |
|
|
|
|
||
|
tbl_Tenant_Notice |
115,000 |
Annual |
|
0 |
|
|
|
|
||
|
tbl_Tenant_Newsletter |
365 |
Annual |
|
0 |
|
|
|
|
||
|
tbl_Invoice |
5 |
Total |
|
0 |
|
|
|
|
||
|
tbl_Receipt |
5 |
Total |
|
0 |
|
|
|
|
||
|
tbl_Question |
50 |
Total |
|
0 |
|
|
|
|
||
|
tbl_Conflict |
50 |
Total |
|
0 |
|
|
|
|
||
|
tbl_Notice |
25 |
Total |
|
0 |
|
|
|
|
||
|
tbl_Rental_Unit |
9,000 |
Total |
|
0 |
|
|
|
|
||
|
tbl_Scheduled_Maintenance |
3,000 |
Annual |
|
0 |
|
|
|
|
||
|
tbl_Regular_Maintenance |
6 |
Total |
|
0 |
|
|
|
|
||
|
tbl_Tenant_Service_Request |
115,000 |
Annual |
|
0 |
|
|
|
|
||
|
tbl_Service_Request |
300 |
Total |
|
0 |
|
|
|
|
||
