| Entity name | Entity type | Primary key | # attributes |
| CONTRACT | independent | Contract_No | 30 |
| CONTRACT_CAT | independent | Code | 2 |
| CONTRACT_NOTES | independent | Contract_No, Note_ID | 8 |
| CONTRACT_TAX | dependent | Contract_No, Seq_No | 7 |
| CONTROL_INFO | independent | CTL_KEY | 46 |
| CUST_EQUIPMENT | independent | Customer, Address_ID, Model_ID, Serial_No | 40 |
| CUST_EQUIPMENT_METERS | independent | Customer, Address_ID, Model_ID, Serial_No | 54 |
| CUST_EQUIPMENT_NOTES | independent | Customer, Address_ID, Model_ID, Serial_No, Note_ID | 9 |
| EQP_MODEL | independent | Model ID | 39 |
| HISTORY_CONTRACT | independent | Contract_No, Contract_Seq_No | 32 |
| HISTORY_CONTRACT_NOTES | dependent | Contract_No, Contract_Seq_No, Note_ID | 9 |
| HISTORY_CONTRACT_TAX | dependent | Contract_No, Contract_Seq_No, Seq_No | 8 |
| HISTORY_CUST_EQUIPMENT | dependent | Customer, Contract_No, Contract_Seq_No, Address_ID, Model_ID, Serial_No | 31 |
| HISTORY_METER_READINGS | independent | Customer, Address_ID, Model_ID, Serial_No, READING_DATE, SEQ_NO | 22 |
| HISTORY_WO_ADDL_CHG | dependent | Task_Seq_No, Addl_Chg_Seq_No, Work_Order_No, Work_Order_Seq_No | 11 |
| HISTORY_WO_LABOR | dependent | Task_Seq_No, Lbr_Seq_No, Work_Order_No, Work_Order_Seq_No | 27 |
| HISTORY_WO_LABOR_NOTES | dependent | Task_Seq_No, Lbr_Seq_No, Note_ID, Work_Order_No, Work_Order_Seq_No | 11 |
| HISTORY_WO_NOTES | dependent | Work_Order_No, Work_Order_Seq_No, Note_ID | 9 |
| HISTORY_WO_PARTS | dependent | Task_Seq_No, Pts_Seq_No, Work_Order_No, Work_Order_Seq_No | 15 |
| HISTORY_WO_PARTS_SERIALS | independent | Work_Order_No, Work_Order_Seq_No, Task_Seq_No, Pts_Seq_No, Serial_No | 7 |
| HISTORY_WO_PMNT | dependent | Work_Order_No, Work_Order_Seq_No, Seq_No | 9 |
| HISTORY_WO_TASK | independent | Work_Order_No, Work_Order_Seq_No, Task_Seq_No | 18 |
| HISTORY_WO_TASK_NOTES | dependent | Task_Seq_No, Note_ID, Work_Order_No, Work_Order_Seq_No | 10 |
| HISTORY_WO_TAX | dependent | Work_Order_No, Work_Order_Seq_No, Seq_No | 8 |
| HISTORY_WORK_ORDER | independent | Work_Order_No, Work_Order_Seq_No | 55 |
| INVOICING_CODE | independent | Code | 68 |
| METER_READINGS | independent | Customer, Address_ID, Model_ID, Serial_No | 21 |
| PM_SCHED | independent | Schedule_ID | 39 |
| PREDEF_JOB | independent | Job_ID | 2 |
| PREDEF_JOB_ADDL_CHG | dependent | Job_ID, Task_Seq_No, Addl_Chg_Seq_No | 9 |
| PREDEF_JOB_LABOR | dependent | Job_ID, Task_Seq_No, Lbr_Seq_No | 13 |
| PREDEF_JOB_LABOR_NOTES | independent | Job_ID, Task_Seq_No, Lbr_Seq_No, Note_ID | 10 |
| PREDEF_JOB_NOTES | independent | Job_ID, Note_ID | 8 |
| PREDEF_JOB_PARTS | dependent | Job_ID, Task_Seq_No, Pts_Seq_No | 12 |
| PREDEF_JOB_TASK | independent | Job_ID, Task_Seq_No | 16 |
| PREDEF_JOB_TASK_NOTES | independent | Job_ID, Task_Seq_No, Note_ID | 9 |
| PREDEF_NOTES | independent | Note_ID | 6 |
| PRIORITY_CODE | independent | Code | 5 |
| PROBLEM_CODE | independent | Code | 5 |
| REFERRAL_SOURCE | independent | Code | 2 |
| SETUP_NOTES | independent | CODE_TYPE, CODE, Note_ID | 7 |
| SP_USER | independent | User_ID | 7 |
| STATUS_CODE | independent | Code | 10 |
| SVC_ADDRESS | independent | Customer, Address_ID | 25 |
| SVC_ADDRESS_NOTES | independent | Customer, Address_ID, Note_ID | 7 |
| SVC_TECH | independent | Tech ID | 16 |
| TAX_DEFAULT | independent | Tax_Code | 8 |
| TECH_CAT | independent | Code | 2 |
| USAGE_CODE | independent | Code | 15 |
| WARRANTY | independent | Warranty_ID | 20 |
| WO_ADDL_CHG | dependent | Work_Order_No, Task_Seq_No, Addl_Chg_Seq_No | 10 |
| WO_LABOR | dependent | Work_Order_No, Task_Seq_No, Lbr_Seq_No | 26 |
| WO_LABOR_NOTES | independent | Work_Order_No, Task_Seq_No, Lbr_Seq_No, Note_ID | 10 |
| WO_NOTES | independent | Work_Order_No, Note_ID | 8 |
| WO_PARTS | dependent | Work_Order_No, Task_Seq_No, Pts_Seq_No | 14 |
| WO_PARTS_SERIALS | independent | Work_Order_No, Task_Seq_No, Pts_Seq_No, Serial_No | 6 |
| WO_PMNT | independent | Work_Order_No, Seq_No | 8 |
| WO_TASK | independent | Work_Order_No, Task_Seq_No | 17 |
| WO_TASK_NOTES | independent | Work_Order_No, Task_Seq_No, Note_ID | 9 |
| WO_TAX | dependent | Work_Order_No, Seq_No | 7 |
| WORK_CAT | independent | Code | 2 |
| WORK_ORDER | independent | Work_Order_No | 51 |