v_cc_burn_permit

v_cc_burn_permit

Purpose

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



Table


Column

Type

Description

permit_id

integer

Primary key

client_code

varchar(28)

Organization ID

address

text

Permit address

contact_name

varchar(255)

Contact name

contact_phone

char(12)

Contact phone

contact_email

varchar(255)

Contact email

permit_type_name

varchar(255)

Permit type

permit_type

integer

Type reference

burn_permit_status

varchar(128)

Status

issue_date

date

Issue date

start_date

date

Start date

expiration_date

date

Expiration date

rejected_date

date

Rejection date

admin_account_type_code

varchar(20)

Admin type

place_id

integer

Location reference





    • Related Articles

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

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

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