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 ...
    • Client Data Sharing

      Directions To explain how to allow departments to view your First Due data. IMPORTANT: You are only able to share with departments located in the same county as you. To share data with departments outside of your county, please reach out to support. ...
    • 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 ...
    • Fire Investigations - Scene Information

      Purpose The purpose of this Knowledge Base Article is to instruct users on how to add Scene Information in the Fire Investigations module. Video Instructions 1. Navigate to the Fire Investigation Module. 2. Select the Investigations List. 3. Click on ...