TABLES
19
VIEWS
3
COLUMNS
183
Constraints
26
Anomalies
6
Routines
21
Database Properties
Database Type: PostgreSQL - 9.5.24
Schema public
standard public schema
Tables
Table / View | Children | Parents | Columns | Rows | Type | Comments |
---|---|---|---|---|---|---|
tbl_cost_centre | 5 | 0 | 11 | 11 | Table | |
tbl_payroll | 1 | 0 | 3 | 5 | Table | |
tbl_positions | 3 | 0 | 2 | 47 | Table | |
tbl_staff_payroll_centre | 0 | 3 | 6 | 4278 | Table | |
tbl_skill_class | 1 | 0 | 1 | 19 | Table | |
tbl_staff_location | 0 | 3 | 6 | 4778 | Table | |
tbl_departments | 4 | 0 | 1 | 23 | Table | |
tbl_staff | 16 | 3 | 29 | 2563 | Table | |
tbl_foreign_experience | 0 | 1 | 6 | 0 | Table | |
tbl_staff_cost_centre | 0 | 3 | 6 | 4415 | Table | |
tbl_spinal_type | 2 | 0 | 1 | 2 | Table | |
tbl_contact_details | 0 | 1 | 10 | 0 | Table | |
tbl_employment_history | 0 | 5 | 10 | 1186 | Table | |
tbl_skills_entry | 0 | 3 | 6 | 0 | Table | |
tbl_spinal_points | 0 | 0 | 3 | 121 | Table | |
tbl_staff_positions | 0 | 3 | 7 | 6033 | Table | |
tbl_location | 3 | 0 | 2 | 8 | Table | |
tbl_hr_details | 0 | 1 | 3 | 0 | Table | |
tbl_skills_breakdown | 1 | 1 | 6 | 337 | Table | |
view_staff_details | 0 | 5 | 37 | 0 | View | |
view_staff | 0 | 1 | 4 | 0 | View | |
view_staff_details_it | 0 | 3 | 23 | 0 | View |