v_fd_permit

v_fd_permit

Purpose

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

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

    • Many permits assigned to one personnel

    • Referenced through assigned_to




Table


Column

Type

Description

id

integer

Primary key

notes

text

Permit notes

created_at

timestamp

Creation time

submit_date

date

Submission date

start_date

date

Start date

expiration_date

date

Expiration date

permit_number

varchar(32)

Permit number

user_creator_public_name

varchar(255)

Creator name

fd_permit_status_code

varchar(32)

Status code

fd_permit_status_name

text

Status name

is_archived

boolean

Archive status

workflow_name

text

Workflow name

fd_permit_type_name

varchar(255)

Permit type

user_assigned_public_name

varchar(255)

Assigned to

response_deadline_date

date

Due date

authority_name

varchar(255)

Authority

project_name

varchar(255)

Project name

address_id

integer

Location reference

location_cache

text

Location details

business_name

varchar(128)

Business name




    • Related Articles

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

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

    • Permits: Creating a New Permit

      Purpose Statement The Create a New Permit feature allows authorized users to initiate and manage fire department permits within the First Due platform. This functionality streamlines the permit application process, enables efficient tracking of ...

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