v_incident_report_prevention_fields
Table Name: v_incident_report_prevention_fields
Last Updated: June 01, 2026 at 01:22 AM
Columns
| Column Name | Data Type | Nullable | Default |
|---|---|---|---|
| id | integer | Yes | - |
| client_code | character | Yes | - |
| smoke_alarm_presence | text | Yes | - |
| smoke_alarm_type | text[] | Yes | - |
| smoke_alarm_operation | text | Yes | - |
| smoke_alarm_operation_action | text | Yes | - |
| smoke_alarm_operation_fail | text | Yes | - |
| fire_alarm_presence | text | Yes | - |
| fire_alarm_operation | text | Yes | - |
| other_alarm_presence | text | Yes | - |
| other_alarm_type | text | Yes | - |
| fire_suppression_presence | text | Yes | - |
| fire_suppression_type | text[] | Yes | - |
| fire_suppression_operation | text | Yes | - |
| fire_suppression_operation_sprinkler | integer | Yes | - |
| fire_suppression_operation_failure | text | Yes | - |
| cooking_fire_suppression_presence | text | Yes | - |
| cooking_fire_suppression_type | text[] | Yes | - |
| incident_report_id | integer | Yes | - |
| smoke_alarm_presence_name | character | Yes | - |
| smoke_alarm_type_names | text | Yes | - |
| smoke_alarm_operation_name | character | Yes | - |
| smoke_alarm_operation_action_name | character | Yes | - |
| smoke_alarm_operation_fail_name | character | Yes | - |
| fire_alarm_presence_name | character | Yes | - |
| fire_alarm_operation_name | character | Yes | - |
| other_alarm_presence_name | character | Yes | - |
| other_alarm_type_name | character | Yes | - |
| fire_suppression_presence_name | character | Yes | - |
| fire_suppression_type_names | text | Yes | - |
| fire_suppression_operation_name | character | Yes | - |
| fire_suppression_operation_failure_name | character | Yes | - |
| cooking_fire_suppression_presence_name | character | Yes | - |
| cooking_fire_suppression_type_names | text | Yes | - |
This documentation is automatically generated from the ODBC Data Warehouse schema.