TABLES
13
VIEWS
3
COLUMNS
124
Constraints
22
Anomalies
1
Routines
5
Database Properties
Database Type: PostgreSQL - 9.5.24
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| tbl_office_time_sheet | 4 | 1 | 12 | 204535 | Table | |
| tbl_office_time_sheet_entry | 1 | 3 | 7 | 854436 | Table | |
| tbl_staff_preferences | 0 | 1 | 11 | 2580 | Table | |
| tbl_task_group_matrix | 0 | 2 | 2 | 25288 | Table | |
| tbl_invoice_code_lookup | 2 | 2 | 8 | 14974 | Table | |
| tbl_staff_toil_adjustment_log | 0 | 4 | 9 | 290478 | Table | |
| tbl_staff_lookup | 11 | 1 | 14 | 2580 | Table | |
| tbl_staff_hols_adjustment | 0 | 2 | 6 | 11 | Table | |
| tbl_invoice_task_group | 2 | 0 | 1 | 35 | Table | |
| tbl_office_time_sheet_entry_details | 0 | 1 | 6 | 1945610 | Table | |
| tbl_invoice_group_matrix | 0 | 2 | 2 | 14991 | Table | |
| tbl_staff_toil_adjustment | 0 | 3 | 8 | 1797 | Table | |
| tbl_task_code_lookup | 2 | 0 | 2 | 21752 | Table | |
| view_time_report_ever | 0 | 0 | 10 | 0 | View | |
| view_time_report | 0 | 0 | 13 | 0 | View | |
| view_time_report_weekly | 0 | 0 | 13 | 0 | View |