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_fire_inspection_item_result

      Purpose Fire inspection checklist results. Relationships f_fire_inspection: Many-to-One (N:1) Many results link to one inspection Referenced through fire_inspection_id v_personnel: Many-to-One (N:1) Many results created by one personnel Referenced ...

    • v_asset_inspection_completed

      Purpose Completed asset inspection records view. Relationships v_apparatus: Many-to-One (N:1) Many inspections link to one apparatus Referenced through apparatus_id v_equipment: Many-to-One (N:1) Many inspections link to one equipment item Referenced ...

    • Inspection Type - Part 2: Creating and Editing an Inspection Checklist

      Purpose To demonstrate how to create and edit an Inspection Checklist. Related Articles Inspection Type - Part 1: Creating and Editing Inspection Type Inspection Type - Part 3: Forms Inspection Type - Part 4: Email Inspection Type - Part 5: Billing ...

    • 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 ...