v_cc_burn_permit_question

v_cc_burn_permit_question

Purpose

  1. 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 text

answer

text

Answer text

permit_id

integer

Permit reference

permit_type_id

integer

Type reference

client_code

varchar(28)

Organization ID




    • Related Articles

    • 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 ...
    • Fixed Burn Permit Expiration Date

      Purpose To explain how to set a fixed expiration date for Burn Permits Video Directions 1. Navigate to Historic Permits Module 2. Click on Permit Types 3. Navigate to the Actions Column 4. Click on Edit 5. Update Permit Type Window will open 6. ...
    • v_permit_questions

      Purpose Fire department permit questions and answers. Relationships v_fd_permit: Many-to-One (N:1) Many questions link to one permit Referenced through fd_permit_id Table Column Type Description id integer Primary key fd_permit_custom_question text ...
    • v_fire_burn_ban_area

      Purpose 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) ...
    • Community Connect: Creating a New Burn Permit

      Purpose To explain to users how to create a new burn permit in the Community Connect Module Video Directions 1. Navigate to the Community Connect Module 2. Select Community Connect 3. Click on Burn Permits 4. The current Community Connect Permit List ...