TABLES
26
VIEWS
0
COLUMNS
210
Constraints
27
Anomalies
3
Routines
99
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 | 3 | 0 | 4 | 236 | Table | Available permissions |
| batch_report_items | 0 | 2 | 7 | 986 | Table | |
| service_token | 0 | 2 | 11 | 24 | Table | |
| user_group | 3 | 2 | 6 | 23 | Table | User Group |
| otp | 0 | 0 | 3 | 9 | Table | |
| group_permission | 0 | 2 | 2 | 1740 | Table | Group authorized permissions |
| sys_log | 0 | 0 | 5 | 5 | Table | |
| user_property | 0 | 2 | 4 | 230 | Table | Authorized properties for each user |
| property_group | 2 | 0 | 2 | 3 | Table | Hotel / Property Group |
| property_reports | 0 | 2 | 5 | 125 | Table | |
| dashboard | 0 | 3 | 6 | 6 | Table | |
| reports | 3 | 1 | 8 | 136 | Table | |
| permission_category | 0 | 0 | 2 | 0 | Table | |
| service | 1 | 0 | 5 | 9 | Table | |
| data_export | 0 | 0 | 10 | 2 | Table | |
| print_form | 0 | 2 | 17 | 8 | Table | |
| language | 1 | 0 | 6 | 183 | Table | |
| property | 11 | 1 | 29 | 6 | Table | Hotel / Property information |
| user_permission | 0 | 3 | 3 | 39709 | Table | User authorized permissions |
| configs | 0 | 1 | 13 | 30 | Table | |
| sys_message | 0 | 0 | 3 | 353 | Table | |
| sync_stamp | 0 | 0 | 4 | 1 | Table | |
| t_log | 0 | 0 | 17 | 1237 | Table | |
| work_log | 0 | 2 | 14 | 18805 | Table | |
| users | 4 | 2 | 17 | 66 | Table | User Information |
| batch_report | 1 | 1 | 7 | 20 | Table |