authen.public

TABLES 37

COLUMNS 322

Constraints 50

Anomalies 4

Routines 143

Database Type: PostgreSQL - 18.3 (Debian 18.3-1.pgdg12+1)

standard public schema

Table / View	Children	Parents	Columns	Rows	Type	Comments
permission	12	1	8	246	Table	Available permissions
batch_report_items	0	2	7	1079	Table
service_token	0	2	12	395	Table
user_group	5	2	8	23	Table	User Group
oauth_token_audit	0	1	11	24	Table	Redacted audit log for OAuth token issuance.
otp	0	0	3	9	Table
group_permission	0	3	3	1998	Table	Group authorized permissions
sys_log	0	0	5	3	Table
oauth_client_redirect_uri	0	1	3	3	Table
user_property	0	2	4	680	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	14	Table
reports	3	1	8	141	Table
permission_category	0	0	2	0	Table
service	1	0	7	17	Table
data_export	0	0	10	2	Table
oauth_client_allowed_resource	0	1	5	2	Table
print_form	0	2	17	8	Table
group_permission_override	0	4	7	49	Table
language	0	0	6	183	Table
property	19	1	31	14	Table	Hotel / Property information
user_permission	0	4	4	158906	Table	User authorized permissions
apps	3	2	7	5	Table
configs	0	1	13	120	Table
oauth_authorization_code	0	1	18	29	Table	Short-lived one-time OAuth authorization codes; only SHA-256 hashes are stored.
user_roles	0	3	5	718	Table
sys_message	0	0	3	524	Table
sync_stamp	0	0	4	6	Table
t_log	0	0	17	402	Table
user_permission_override	0	4	7	8226	Table
oauth_client	4	0	6	2	Table	OAuth clients for Newsoft OAuth authorization service.
work_log	0	2	15	21855	Table
property_app	0	2	6	14	Table
users	7	1	19	75	Table	User Information
batch_report	1	1	7	35	Table
user_app_access	0	3	5	680	Table
v_daily_reports	0	1	8	0	View
v_active_reports	0	1	8	0	View