/
Common OneGov Tables

Common OneGov Tables

Mar 28, 2018

Due to the amount of customization available on OneGov, table names and fields are often times different however, there are a number of consistencies:

  • appstatus

    • This table contains information on all of the default and custom statuses used in the site

    • Includes (but not limited to)

      • Status ID (Unique Primary Key)

      • Status Name

  • appvaluesbytypeid

    • For each of the applications set up in your OneGov site, there is a corresponding appvaluesbytypeid table

    • Each appvaluesbytypeid table ends in a number that is determined by the Type ID

    • These tables contains all of the applicant supplied values for each application whether or not the application was completed

  • contacts

    • This table contains all of the information from the Contact Data Types in all of the applications

    • Includes (but not limited to)

      • Contact ID (Unique Primary Key)

      • Application ID (Foreign Key)

      • Field ID (Foreign Key)

      • Contact Name

      • Contact Email

  • permitappfieldcustomoptions

    • This table contains information about the selection from a single select or drop down data type

    • Includes (but not limited to)

      • Application ID (Foreign Key)

      • Field ID (Foreign Key)

      • Custom Table ID (Foreign Key)

      • Custom Record ID (Foreign Key)

  • permitappfieldselectedoptions

    • This table contains information about selections from a multi-select data type

    • Includes (but not limited to)

      • Application ID (Foreign Key)

      • Field ID (Foreign Key)

      • Option ID (Foreign Key)

  • permitappfieldvalues

    • This table contains the information from a majority of the custom fields in each of the applications

    • Includes (but not limited to)

      • Application ID (Foreign Key)

      • Field ID (Foreign Key)

      • Field Value

  • permitapps

    • This table contains the information from all of the started applications

    • Includes (but not limited to)

      • Application ID (Unique Primary Key)

      • permittypeid (Foreign Key)

      • Statusid (Foreign Key)

      • Userid (Foreign Key)

      • Date/Time application started

      • Date/Time application last modified

      • Date/Time application approved (If Applicable)

      • Date/Time application canceled

  • permitappsignatures

    • Contains information about the signatures on an application

    • Includes (but not limited to)

      • Signature ID (Unique Primary Key)

      • Application ID (Foreign Key)

      • Userid (Foreign Key)

      • Approval Name

      • Signature Date