TABLES
78
VIEWS
0
COLUMNS
1248
Constraints
41
Anomalies
16
Routines
10
Database Properties
Database Type: PostgreSQL - 14.13 (Debian 14.13-1.pgdg110+1)
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| EquipmentHours | 0 | 0 | 7 | 52651 | Table | |
| __EFMigrationsHistory | 0 | 0 | 2 | 53 | Table | |
| formation | 0 | 0 | 10 | 73328 | Table | |
| cplessonslearned | 0 | 1 | 4 | 722 | Table | |
| SyncWorkloadEntries | 3 | 0 | 8 | 0 | Table | |
| equipment_write_to_onec_history | 0 | 1 | 5 | 229451 | Table | |
| Customers | 0 | 0 | 3 | 206 | Table | |
| OperatedObjectClasses | 0 | 0 | 8 | 0 | Table | |
| ToolTypeSubGroups | 1 | 0 | 3 | 165 | Table | |
| Orders | 0 | 0 | 2 | 81 | Table | |
| plan_survey | 0 | 1 | 5 | 167276 | Table | |
| EquipmentClasses | 1 | 0 | 3 | 53 | Table | |
| equipmentmap_ald | 0 | 0 | 69 | 111 | Table | |
| insite_file_history | 0 | 0 | 7 | 2785 | Table | |
| Equipments | 0 | 6 | 15 | 52138 | Table | |
| EquipmentStatusLogs | 0 | 2 | 7 | 25186 | Table | |
| OperatedObjects | 0 | 0 | 36 | 0 | Table | |
| job | 7 | 1 | 95 | 7227 | Table | |
| SyncInsiteEntries | 1 | 2 | 16 | 0 | Table | |
| EquipmentChanges | 1 | 2 | 15 | 0 | Table | |
| Fields | 0 | 0 | 2 | 910 | Table | |
| onec_file_history | 1 | 0 | 3 | 105 | Table | |
| whitelist | 0 | 1 | 4 | 182 | Table | |
| EquipmentRelationships | 0 | 0 | 3 | 57472 | Table | |
| SyncInsiteEntryFiles | 0 | 1 | 6 | 0 | Table | |
| ToolTypeGroups | 1 | 0 | 3 | 35 | Table | |
| questions_run | 0 | 4 | 7 | 288859 | Table | |
| EquipmentStatuses | 4 | 0 | 2 | 12 | Table | |
| log_submit | 0 | 1 | 21 | 881903 | Table | |
| ToolTypeSizes | 1 | 0 | 3 | 10 | Table | |
| rop | 0 | 0 | 6 | 7707 | Table | |
| EquipmentsToWriteHistory | 0 | 0 | 22 | 112821 | Table | |
| surface_inventory | 0 | 0 | 28 | -1 | Table | |
| ToolTypes | 1 | 5 | 8 | 322 | Table | |
| insite_xml_base | 0 | 1 | 15 | 5414 | Table | |
| tot | 0 | 2 | 37 | 46642 | Table | |
| cam_sam | 0 | 2 | 7 | 7837 | Table | |
| bha | 0 | 0 | 24 | 699584 | Table | |
| EquipmentChangeHours | 0 | 1 | 14 | 0 | Table | |
| Users | 3 | 0 | 4 | 6 | Table | |
| EquipmentLocations | 1 | 0 | 5 | 8 | Table | |
| ServiceType | 1 | 0 | 2 | 4 | Table | |
| jr_key | 14 | 1 | 3 | 42725 | Table | |
| GenDatas | 0 | 0 | 18 | 7293 | Table | |
| equipment_info_onec | 0 | 0 | 11 | 52651 | Table | |
| EquipmentRelationshipLogs | 0 | 1 | 6 | 225 | Table | |
| ToolTypeServices | 1 | 0 | 3 | 6 | Table | |
| jcase | 0 | 0 | 16 | 26661 | Table | |
| SyncPipelineWorkloadEntries | 0 | 1 | 8 | 0 | Table | |
| equipmentdetails | 0 | 0 | 9 | 3264291 | Table | |
| UserSessions | 0 | 0 | 8 | 185 | Table | |
| Regions | 0 | 0 | 2 | 12 | Table | |
| EquipmentModels | 1 | 0 | 2 | 2267 | Table | |
| type_of_tool | 0 | 0 | 2 | -1 | Table | |
| surface_parameters | 0 | 2 | 7 | -1 | Table | |
| SyncDictionaryEntries | 3 | 0 | 9 | 0 | Table | |
| SyncSchedulerEntries | 0 | 0 | 12 | 0 | Table | |
| EquipmentStatusMaps | 0 | 1 | 3 | 47792 | Table | |
| cp2 | 0 | 1 | 58 | 2878 | Table | |
| cp1 | 0 | 1 | 23 | 1378 | Table | |
| cp4 | 0 | 1 | 13 | 979 | Table | |
| cp3 | 0 | 1 | 22 | 9707 | Table | |
| SyncPipelineDictionaryEntries | 0 | 1 | 8 | 0 | Table | |
| ToolTypeTAs | 1 | 0 | 3 | 17 | Table | |
| insite_xml_equipment | 0 | 2 | 14 | 165487 | Table | |
| run | 5 | 2 | 232 | 49328 | Table | |
| equipment_number_map_onec | 0 | 0 | 3 | 57472 | Table | |
| Questions | 2 | 0 | 2 | 49 | Table | |
| questions_job | 0 | 2 | 4 | 125310 | Table | |
| EquipmentsCBM | 0 | 0 | 10 | 196608 | Table | |
| actual_survey | 0 | 2 | 13 | 139449 | Table | |
| InventoryGroups | 1 | 0 | 3 | 433 | Table | |
| equipmentmap | 1 | 0 | 15 | 3212 | Table | |
| EquipmentRelationshipChanges | 1 | 0 | 8 | 33 | Table | |
| activity | 0 | 2 | 5 | 18592 | Table | |
| insite_health | 0 | 2 | 11 | 473445 | Table | |
| run_hist | 0 | 0 | 107 | 11947 | Table | |
| OperatedObjectNodes | 0 | 0 | 29 | 0 | Table |