v_fire_inspection_violation

v_fire_inspection_violation

Purpose

  1. Fire code violation records.

Relationships

  • f_fire_inspection: Many-to-One (N:1)

    • Many violations link to one inspection

    • Referenced through fire_inspection_id

  • v_occupancy: Many-to-One (N:1)

    • Many violations link to one location

    • Referenced through place_id

  • v_fire_inspection_item_result: Many-to-One (N:1)

    • Many violations link to one checklist result

    • Referenced through checklist_item_result_id



Table



Column

Type

Description

id

integer

Primary key

place_id

integer

Location reference

fire_inspection_id

integer

Inspection reference

preplan_id

integer

Pre-plan reference

checklist_item_result_id

integer

Result reference

violation_created_at

timestamp

Creation time

violation_resolved_at

timestamp

Resolution time

preplan_business_name

varchar

Business name

checklist_item_question

text

Violation item

checklist_item_remark

text

Comments

initial_status

varchar(30)

Initial status

current_status

varchar(30)

Current status

code

varchar(30)

Violation code

code_description

text

Code description

fire_inspection_type_name

varchar(255)

Inspection type

inspection_number

varchar(30)

Inspection number

location_cache

text

Location details

client_code

varchar(28)

Organization ID






    • Related Articles

    • f_fire_inspection

      Purpose Documents fire inspections and their results. Relationships 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 ...

    • v_occupancy

      Purpose Building and occupancy information. Relationships v_occupancy_contact: One-to-Many (1:N) One occupancy can have many contacts Referenced through place_id f_fire_inspection: One-to-Many (1:N) One occupancy can have many inspections Referenced ...

    • Inspection Record - Schedule Reinspection

      Purpose Statement The Schedule Reinspection feature enables fire prevention officers and inspection personnel to efficiently schedule follow-up inspections when violations or failed checklist items are identified during initial inspections. This ...

    • Inspection Record - Reinspection

      Purpose Statement To provide fire and EMS personnel with a comprehensive guide for documenting reinspections in the system. This process allows inspectors to efficiently track and resolve previous violations, ensuring compliance with fire safety ...

    • Inspection Record - Completing the Checklist

      Purpose Statement This guide demonstrates how to efficiently complete inspection checklists within the Inspection Record module. The checklist system enables fire and EMS personnel to conduct standardized inspections, document violations, add ...