TABLES
26
VIEWS
2
COLUMNS
228
Constraints
26
Anomalies
3
Routines
111
Database Properties
Database Type: PostgreSQL - 18.1 (Debian 18.1-1.pgdg12+2)
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| permission | 5 | 0 | 4 | 240 | Table | Available permissions |
| batch_report_items | 0 | 2 | 7 | 995 | Table | |
| service_token | 0 | 2 | 11 | 34 | Table | |
| user_group | 3 | 2 | 6 | 23 | Table | User Group |
| otp | 0 | 0 | 3 | 9 | Table | |
| group_permission | 0 | 2 | 2 | 1774 | Table | Group authorized permissions |
| sys_log | 0 | 0 | 5 | 0 | Table | |
| user_property | 0 | 2 | 4 | 394 | Table | Authorized properties for each user |
| property_group | 2 | 0 | 2 | 3 | Table | Hotel / Property Group |
| property_reports | 0 | 2 | 5 | 130 | Table | |
| dashboard | 0 | 3 | 6 | 10 | Table | |
| reports | 3 | 1 | 8 | 138 | Table | |
| permission_category | 0 | 0 | 2 | 0 | Table | |
| service | 1 | 0 | 5 | 12 | Table | |
| data_export | 0 | 0 | 10 | 2 | Table | |
| print_form | 0 | 2 | 17 | 8 | Table | |
| language | 0 | 0 | 6 | 183 | Table | |
| property | 11 | 1 | 30 | 9 | Table | Hotel / Property information |
| user_permission | 0 | 3 | 3 | 84918 | Table | User authorized permissions |
| configs | 0 | 1 | 13 | 43 | Table | |
| sys_message | 0 | 0 | 3 | 372 | Table | |
| sync_stamp | 0 | 0 | 4 | 2 | Table | |
| t_log | 0 | 0 | 17 | 0 | Table | |
| work_log | 0 | 2 | 14 | 17938 | Table | |
| users | 4 | 1 | 18 | 68 | Table | User Information |
| batch_report | 1 | 1 | 7 | 31 | Table | |
| v_daily_reports | 0 | 1 | 8 | 0 | View | |
| v_active_reports | 0 | 1 | 8 | 0 | View |