Database Properties
Database Type: PostgreSQL - 17.0 (Debian 17.0-1.pgdg110+1)
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| submission_contact | 1 | 2 | 10 | -1 | Table | The details of a contacts for each client’s location. |
| submission_status_code | 1 | 0 | 8 | -1 | Table | A code indicating the status of a client creation submission request. Examples of possible statuses include Approved, Rejected, and others. |
| client_type_code | 1 | 0 | 8 | -1 | Table | A code indicating the type of a client. Examples include, but are not limited to: Corporation, Individual, Association, and others. |
| submission_location_contact_xref | 0 | 2 | 2 | -1 | Table | Identifies the multiple addresses for a given client, as well as the many contacts that may belong to a given address. |
| submission_matching_detail | 0 | 1 | 9 | -1 | Table | The number of matches, if any, found in the legacy oracle database. These matches are determined through a combination of fuzzy search in specific fields and exact equality in others. |
| flyway_schema_history | 0 | 0 | 10 | -1 | Table | |
| submission | 4 | 2 | 8 | -1 | Table | A submission request to create a client. |
| submission_location | 1 | 4 | 15 | -1 | Table | The details of a client’s location. |
| province_code | 4 | 1 | 10 | -1 | Table | A list of provinces, states, departments or territories, serving as a reference for province-specific data. |
| email_log | 0 | 0 | 10 | -1 | Table | Stores email log information |
| submission_type_code | 1 | 0 | 8 | -1 | Table | A code indicating the type of a submission request. Examples of possible type are TBD. |
| district_code | 1 | 0 | 9 | -1 | Table | A list of Natural Resource Districts. |
| business_type_code | 1 | 0 | 8 | -1 | Table | A code indicating the business type of a client. It could be either Registered Business and Unregistered Business. |
| submission_detail | 0 | 7 | 21 | -1 | Table | The details of a submission request to create a client. |
| identification_type_code | 1 | 1 | 9 | -1 | Table | |
| contact_type_code | 1 | 0 | 8 | -1 | Table | A code indicating the role of a contact of a client. |
| country_code | 3 | 0 | 9 | -1 | Table | A list of countries, serving as a reference for country-specific data. |