Data Dictionary Information

Data Dictionary Information

Introduction


This data dictionary provides comprehensive documentation for all database tables, including their columns, data types, descriptions, and relationships. Tables are listed in alphabetical order for easy reference.



How to Use This Dictionary


Each table entry includes:

  • Table name and description

  • Complete column listing with data types and descriptions

  • All relationships with other tables, including cardinality (1:1, 1:N, N:M)

  • Related keys and foreign key references





    • Related Articles

    • Inspection Data Sharing

      Purpose The purpose of this Knowledge Base Article is to demonstrate how to share and view in-progress and completed inspection for another First Due Client. The feature is active only in client accounts with data sharing active. Related Article User ...
    • Permit Data Sharing

      Purpose The purpose of this Knowledge Base Article is to demonstrate how to share and view Permits for another First Due Client. The feature is active only in client accounts with data sharing active. Related Article User Data Sharing Video ...
    • Documenting an Exposure - Information Section

      Purpose The purpose of this article is to explain and demonstrate the Information section when completing an Exposure. Video Directions 1. When documenting an Exposure select on the Information section. 2. There are three required fields when ...
    • Ad-Hoc Reporting: Data Source Configuration

      Purpose This article will review the Ad-Hoc Data Source Configuration within the Reports module. In this section of generating an Ad-Hoc report, you’ll be able to choose the specific data you want to retrieve. This selection will then query the ...
    • Importing NFIRS Data into a Fire Investigation

      Purpose The purpose of this article is to demonstrate how to import NFIRS Data into a Fire Investigation Video Instructions 1. Click on Investigations List 2. Click on Add Fire Investigation 3. Click on Import NFIRS Data 4. Click on the incident ...