Schema overview
Auto-generated from packages/db/src/schema/. Do not edit this page by hand.
Total: 23 tables across 8 domains.
Tables by domain
Auth & identity
| Table | Columns | FKs | Indexes |
|---|---|---|---|
otp_codes | 6 | 0 | 1 |
refresh_tokens | 7 | 1 | 2 |
users | 14 | 1 | 1 |
Organizations
| Table | Columns | FKs | Indexes |
|---|---|---|---|
agency_applications | 18 | 2 | 2 |
organizations | 31 | 0 | 0 |
Worker profiles
| Table | Columns | FKs | Indexes |
|---|---|---|---|
worker_availability | 12 | 1 | 1 |
worker_device_tokens | 7 | 1 | 0 |
worker_locations | 11 | 1 | 1 |
worker_profiles | 25 | 1 | 0 |
worker_ratings | 9 | 3 | 0 |
worker_reliability_scores | 14 | 1 | 0 |
worker_verifications | 31 | 3 | 0 |
Shifts & booking
| Table | Columns | FKs | Indexes |
|---|---|---|---|
shift_responses | 8 | 3 | 0 |
shifts | 36 | 3 | 0 |
Ratings
| Table | Columns | FKs | Indexes |
|---|---|---|---|
facility_agency_links | 8 | 2 | 0 |
facility_favourite_workers | 4 | 2 | 0 |
Messaging
| Table | Columns | FKs | Indexes |
|---|---|---|---|
chat_threads | 6 | 1 | 0 |
messages | 7 | 2 | 3 |
Audit
| Table | Columns | FKs | Indexes |
|---|---|---|---|
audit_events | 13 | 0 | 3 |
audit_notifications | 9 | 0 | 1 |
notifications_log | 12 | 1 | 2 |
Other
| Table | Columns | FKs | Indexes |
|---|---|---|---|
agency_roster | 7 | 2 | 0 |
verification_documents | 8 | 1 | 0 |