v_occupancy: Many-to-One (N:1)
Many inspections can link to one occupancy
Referenced through place_id
v_fire_inspection_violation: One-to-Many (1:N)
One inspection can have many violations
Referenced through fire_inspection_id
v_personnel: Many-to-One (N:1)
Many inspections can be assigned to one personnel
Referenced through user_assigned_id
Column | Type | Description |
id | integer | Primary key |
client_code | varchar | Organization identifier |
place_id | integer | Location reference |
preplan_id | integer | Pre-plan reference |
user_assigned_id | integer | Assigned inspector |
team_id | integer | Inspection team |
user_completed_id | integer | Completing user |
place_location_cache | text | Location details |
fire_inspection_type_name | varchar | Inspection type |
fire_inspection_type_id | integer | Type reference |
fire_inspection_scheduled_at | timestamp | Schedule time |
fire_inspection_completed_at | timestamp | Completion time |
fire_inspection_schedule_type_code | varchar | Schedule type |
fire_inspection_reinspection_number | integer | Reinspection count |
fire_inspection_status_code | varchar | Status |
fire_inspection_notes | text | Notes |
is_printed | boolean | Print status |
has_recurring_scheduled | boolean | Recurrence flag |
fire_station | varchar | Station |
fire_station_id | integer | Station reference |
inspection_number | varchar | Inspection ID |
created_by | integer | Creator reference |
created_at | timestamp | Creation time |