Database Properties
Database Type: PostgreSQL - 18.3 (Debian 18.3-1.pgdg12+1)
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| permission | 10 | 1 | 8 | 417 | Table | Available permissions |
| batch_report_items | 0 | 2 | 7 | 1082 | Table | |
| service_token | 0 | 2 | 12 | 43 | Table | |
| user_group | 5 | 2 | 8 | 27 | Table | User Group |
| oauth_token_audit | 0 | 1 | 11 | 54 | Table | Redacted audit log for OAuth token issuance. |
| otp | 0 | 0 | 3 | 9 | Table | |
| group_permission | 0 | 3 | 3 | 2661 | Table | Group authorized permissions |
| sys_log | 0 | 0 | 5 | 46 | Table | |
| oauth_client_redirect_uri | 0 | 1 | 3 | 3 | Table | |
| user_property | 0 | 2 | 4 | 1056 | Table | Authorized properties for each user |
| property_group | 2 | 0 | 2 | 11 | Table | MIRROR of newsoft_erp.public.property_group (same ids), maintained by newsoft_erp rpc.fn_save_property_group over dblink. Do not edit by hand — create and rename groups from the Authen admin app, which writes the ERP master. |
| property_reports | 0 | 2 | 5 | 130 | Table | |
| dashboard | 0 | 3 | 6 | 19 | Table | |
| reports | 3 | 0 | 9 | 142 | Table | |
| permission_category | 0 | 0 | 2 | 0 | Table | |
| service | 1 | 0 | 8 | 20 | Table | |
| data_export | 0 | 0 | 10 | 2 | Table | |
| oauth_client_allowed_resource | 0 | 1 | 5 | 3 | Table | |
| print_form | 0 | 2 | 17 | 8 | Table | |
| group_permission_override | 0 | 4 | 7 | 62 | Table | |
| language | 0 | 0 | 6 | 183 | Table | |
| rpc_permission | 0 | 1 | 7 | 37 | Table | Which permission a generic RPC route requires. Read by the ERP gateway (newsoft-erp cmd/server). A function with no row here is not gated. |
| property | 23 | 1 | 32 | 22 | Table | Hotel / Property information |
| user_permission | 0 | 4 | 4 | 297504 | Table | User authorized permissions |
| apps | 7 | 2 | 13 | 9 | Table | |
| configs | 0 | 1 | 14 | 153 | Table | |
| oauth_authorization_code | 0 | 1 | 18 | 49 | Table | Short-lived one-time OAuth authorization codes; only SHA-256 hashes are stored. |
| user_roles | 0 | 3 | 5 | 753 | Table | |
| sys_message | 0 | 0 | 3 | 714 | Table | |
| sync_stamp | 0 | 0 | 4 | 6 | Table | |
| t_log | 0 | 0 | 17 | 251 | Table | |
| user_permission_override | 0 | 4 | 7 | 68955 | Table | |
| oauth_client | 4 | 0 | 6 | 3 | Table | OAuth clients for Newsoft OAuth authorization service. |
| work_log | 1 | 2 | 15 | 13179 | Table | |
| property_app | 0 | 2 | 6 | 28 | Table | |
| users | 14 | 1 | 19 | 86 | Table | User Information |
| batch_report | 1 | 1 | 7 | 41 | Table | |
| user_app_access | 0 | 3 | 7 | 1130 | Table | |
| v_daily_reports | 0 | 0 | 8 | 0 | View | |
| v_active_reports | 0 | 0 | 8 | 0 | View |