v_fire_burn_ban_area

v_fire_burn_ban_area

Purpose

  1. Fire burn ban area tracking.


Relationships

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

    • One ban area can affect many permits

    • Referenced through geographic relationship




Table


Column

Type

Description

area_id

integer

Primary key

area_name

varchar(255)

Area name

area_description

text

Description

area_status

boolean

Ban status

client_code

varchar(28)

Organization ID






    • Related Articles

    • Calculate Needed Fire Flow

      Purpose The purpose of this Knowledge Base Article is to demonstrate the process for calculating the Needed Fire Flow for an Occupancy. Video Instructions 1. Navigate to Admin then click on Roles. 2. Select edit for the Role to enable "Calculate ...
    • Calculate Needed Fire Flow

      Purpose The purpose of this Knowledge Base Article is to demonstrate the process for calculating the Needed Fire Flow for an Occupancy. Video Instructions 1. Navigate to Admin then click on Roles. 2. Select edit for the Role to enable "Calculate ...
    • v_cc_burn_permit

      Purpose Community burn permit records view. Relationships v_occupancy: Many-to-One (N:1) Many permits link to one location Referenced through place_id v_cc_burn_permit_question: One-to-Many (1:N) One permit can have many questions Referenced through ...
    • v_cc_burn_permit_question

      Purpose Burn permit questions and answers view. Relationships v_cc_burn_permit: Many-to-One (N:1) Many questions link to one permit Referenced through permit_id Table Column Type Description permit_answer_id integer Primary key question text Question ...
    • 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 ...