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

    • Permits: Creating a New Permit

      Purpose To provide instructions on how to Create a New Permit in the First Due Platform. Video Instructions 1. Click on Permits. 2. Click on Permits. 3. Click on New Permit. 4. Enter and select the correct address. 5. Select the correct date for ...

    • Permit: Add/Edit Custom Data Fields

      Purpose To demonstrate how to add Custom Data Fields to a Permit Type Related Articles Create and Edit Permit Type Permit: Form Builder - Adding Custom Data Fields Video Instructions NOTE: Adding Custom Data Fields to a Permit is a Module Admin ...

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