v_permit_questions

v_permit_questions

Purpose

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

Question text

is_mandatory_response

boolean

Required flag

show_on_cc

boolean

Community view

fd_permit_custom_answer

text

Answer text

client_code

varchar(28)

Organization ID

fd_permit_id

integer

Permit reference





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

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

      Purpose Fire department permit records. Relationships v_occupancy: Many-to-One (N:1) Many permits link to one location Referenced through address_id v_fd_permit_plan_review: One-to-Many (1:N) One permit can have many plan reviews Referenced through ...

    • v_fd_permit_plan_review

      Purpose Permit plan review records. Relationships v_fd_permit: Many-to-One (N:1) Many reviews link to one permit Referenced through fd_permit_id v_personnel: Many-to-One (N:1) Many reviews assigned to one personnel Referenced through assigned_to ...

    • Frequently Asked Questions- Reports

      What is the difference between Ad Hoc and the other module-specific (“Canned”) reports? Ad Hoc is a framework for creating customized reports around specific requirements and data sources. Canned reports provide a pre-built solution for common ...