TABLES
43
VIEWS
0
COLUMNS
502
Constraints
86
Anomalies
2
Routines
8
Database Properties
Database Type: PostgreSQL - 16.15
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| ai_candidate_decision_batch | 2 | 6 | 10 | -1 | Table | |
| worker_import_row | 0 | 4 | 13 | -1 | Table | |
| task_transition_history | 0 | 4 | 9 | -1 | Table | |
| audit_event | 0 | 1 | 13 | -1 | Table | |
| event_consumption | 0 | 2 | 5 | -1 | Table | |
| worker_import_commit_idempotency | 0 | 2 | 6 | -1 | Table | |
| ai_run | 10 | 3 | 16 | -1 | Table | |
| flyway_schema_history | 0 | 0 | 10 | 58 | Table | |
| worker | 16 | 1 | 15 | -1 | Table | |
| document_ocr_run | 0 | 8 | 24 | -1 | Table | |
| worker_document_upload_idempotency | 0 | 4 | 7 | -1 | Table | |
| ai_question | 0 | 6 | 12 | -1 | Table | |
| worker_response | 2 | 3 | 9 | -1 | Table | |
| worker_archive | 0 | 4 | 6 | -1 | Table | |
| task_checklist_item | 0 | 4 | 12 | -1 | Table | |
| ai_attempt | 4 | 2 | 23 | -1 | Table | |
| worker_response_upload | 0 | 4 | 3 | -1 | Table | |
| notification_preference | 0 | 2 | 6 | -1 | Table | |
| approval_request | 0 | 6 | 22 | -1 | Table | |
| user_account | 55 | 1 | 18 | -1 | Table | |
| outbox_manual_retry | 0 | 4 | 13 | -1 | Table | |
| task | 21 | 10 | 22 | -1 | Table | |
| user_login_event | 0 | 2 | 5 | -1 | Table | |
| worker_document | 6 | 7 | 18 | -1 | Table | |
| worker_import_job | 4 | 5 | 18 | -1 | Table | |
| stored_file | 8 | 5 | 14 | -1 | Table | |
| document_request_draft | 1 | 3 | 9 | -1 | Table | |
| ai_candidate_decision_task | 0 | 4 | 5 | -1 | Table | |
| refresh_token | 2 | 4 | 12 | -1 | Table | |
| ai_candidate_decision | 2 | 6 | 7 | -1 | Table | |
| company | 13 | 0 | 6 | -1 | Table | |
| company_settings | 0 | 1 | 10 | -1 | Table | |
| ai_candidate | 2 | 6 | 11 | -1 | Table | |
| task_evidence | 0 | 4 | 9 | -1 | Table | |
| document_request_draft_type | 0 | 1 | 2 | -1 | Table | |
| notification | 0 | 1 | 10 | -1 | Table | |
| user_agreement_consent | 0 | 2 | 8 | -1 | Table | |
| password_reset_token | 0 | 2 | 9 | -1 | Table | |
| workflow_case | 3 | 5 | 12 | -1 | Table | |
| external_submission | 0 | 4 | 8 | -1 | Table | |
| worker_link | 6 | 11 | 17 | -1 | Table | |
| event_publication | 4 | 1 | 22 | -1 | Table | |
| stay_verification_case | 0 | 6 | 16 | -1 | Table |