backflow_master
The backflow_master contains information generated during Back Flow Inventory Maintenance.
Notes:
For information about interpreting EDIFICE Tables, see Understanding EDIFICE Tables.
To view other EDIFICE Tables, see the EDIFICE Database Overview.
backflow_master |
||
Field |
Type |
Previous Name |
BackFlow_ID |
varchar(17) |
|
Row_Index |
int(11) |
|
Connection_ID |
varchar(14) |
|
Primary_Service_Code |
int(11) |
|
Series_Type |
int(11) |
|
Dial_Count |
int(11) |
|
Outside_Num |
varchar(10) |
|
Manufacturer_Name |
varchar(12) |
|
Model |
varchar(10) |
|
Serial_Num |
varchar(10) |
|
BackFlow_Size |
varchar(10) |
|
Sec_BackFlow_Num |
varchar(10) |
|
Reset_Date |
date |
|
Installed_Date |
date |
|
Removed_Date |
date |
|
Last_Test_Date |
date |
|
Purchase_Date |
date |
|
Purchase_Price |
decimal(14,2) |
|
Maintenance_Code |
int(11) |
|
Install_Reading_A |
decimal(19,5) |
|
Install_Reading_B |
decimal(19,5) |
|
Install_Reading_C |
decimal(19,5) |
|
Removal_Reading_A |
decimal(19,5) |
|
Removal_Reading_B |
decimal(19,5) |
|
Removal_Reading_C |
decimal(19,5) |
|
Memo1 |
varchar(40) |
|
Memo2 |
varchar(40) |
|
Radio_MIU_Num |
varchar(20) |
|
Battery_Installed_Date |
date |
|
Billing_Type_ID |
varchar(10) |
|
Message_ID |
varchar(5) |
|
Testing_Frequency |
int(11) |
|
Last_Test_Status |
int(11) |
|
Testing_Sequence_Flag |
int(11) |
|
Testing_Monthly_Calendar_ID |
varchar(20) |
|
Memo3 |
varchar(100) |
|
Inspection_Frequency |
int(11) |
|
Type |
varchar(5) |
|
State_Code |
varchar(5) |
|