Database Audit

Administrative controls and system readiness tools for maintaining Signal Schedule.

6 JM
v6.2.0SystemDashboard shellLegacy app shell removed

System

Database Audit

v6.2.0 records the table naming contract discovered during live Postgres review: core identity tables are unprefixed while Schedule module tables use the schedule_ prefix.

Confirmed Naming Contract

Core Identity

employees, users, roles, user_roles, role_permissions

Schedule Modules

schedule_request_cases, schedule_leave_bank_balances, schedule_posts, schedule_published_versions, and related schedule_* tables.

Tenant Model

Agencies such as City of Fairview should be tenant records in one app database by default.

SQL Audit Snapshot