Database Properties
Database Type: PostgreSQL - 17.5 (Debian 17.5-1.pgdg120+1)
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| board | 4 | 0 | 10 | -1 | Table | Kanban boards that exist in ALCS |
| parcel_lookup | 0 | 0 | 14 | -1 | Table | Data from ParcelMapBC for use in the Portal |
| notice_of_intent_decision_document | 0 | 2 | 8 | -1 | Table | Links NOI decision document with the decision it’s saved to |
| application_decision | 6 | 9 | 38 | -1 | Table | Decisions saved to applications, incl. those linked to the recon/modification request |
| card_subtask_type | 1 | 0 | 10 | -1 | Table | Code table for possible subtask types |
| notice_of_intent_submission_to_submission_status | 0 | 2 | 4 | -1 | Table | Join table to link Notice of Intent Submissions to their Statuses |
| card_status | 2 | 0 | 8 | -1 | Table | Code table for possible kanban columns that cards can be in |
| application_reconsideration | 2 | 5 | 18 | -1 | Table | Application reconsideration requests linked to card and application |
| card | 13 | 4 | 13 | -1 | Table | Kanban board cards |
| notification_submission | 3 | 4 | 20 | -1 | Table | Portal Submissions for Notifications |
| application_decision_condition_card | 1 | 2 | 8 | -1 | Table | Links application decision conditions with cards |
| application_decision_condition_type | 1 | 0 | 20 | 29 | Table | Code table for the possible application decision condition types |
| application_parcel | 1 | 3 | 20 | -1 | Table | Parcels associated with application submissions |
| notice_of_intent_meeting_type | 1 | 0 | 8 | -1 | Table | Code table for possible action types that un/pause NOIs |
| document | 8 | 2 | 19 | -1 | Table | Attributes for documents including their ORCS classification |
| typeorm_metadata | 0 | 1 | 6 | 15 | Table | |
| board_status | 0 | 2 | 9 | 145 | Table | Columns on each kanban board |
| notice_of_intent_modified_decisions | 0 | 2 | 2 | -1 | Table | Links NOI modification requests with their resulting decisions |
| notice_of_intent_decision_component | 1 | 2 | 24 | -1 | Table | Decision Components for Notice of Intents |
| notice_of_intent_decision_condition | 3 | 3 | 14 | -1 | Table | Decision Conditions for Notice of Intents |
| planning_review_meeting | 0 | 2 | 9 | -1 | Table | Meeting schedule for Planning Reviews |
| notice_of_intent_subtype | 1 | 0 | 9 | -1 | Table | Code table for possible NOI subtypes |
| compliance_and_enforcement | 1 | 0 | 14 | -1 | Table | Compliance and enforcement file |
| local_government | 5 | 2 | 12 | 187 | Table | Status, type, BCeID, and contact info of local or first nation governments |
| notice_of_intent_submission_status_type | 1 | 0 | 13 | -1 | Table | The code table for Notice of Intent Submissions Statuses |
| application_decision_condition_financial_instrument | 0 | 1 | 20 | -1 | Table | Instrument for Financial Security Conditions |
| migrations | 0 | 1 | 3 | 477 | Table | Database migration history recorded by typeorm |
| application_submission_to_submission_status | 0 | 2 | 4 | -1 | Table | Join table that links submission with its status |
| application_modification | 2 | 3 | 13 | -1 | Table | Application modification requests linked to card and application |
| notice_of_intent_subtype_notice_of_intent_subtype | 0 | 2 | 2 | -1 | Table | Links NOI subtypes to the NOI it’s saved to (many to one relationship) |
| notice_of_intent_decision_condition_type | 1 | 0 | 20 | 29 | Table | Decision Condition Types Code Table for Notice of Intents |
| configuration | 48 | 0 | 2 | -1 | Table | Stores real time config values editable by ALCS Admin. |
| application_decision_condition_to_component_lot | 0 | 2 | 9 | -1 | Table | Join table to link approved subdivision lots between condition and components and provide plan numbers associated with survey plan per lot |
| naru_subtype | 2 | 0 | 8 | -1 | Table | Code table for possible subtypes of Non-Adhering Residential Use applications |
| planning_review_type | 1 | 0 | 12 | -1 | Table | Code table for possible Planning Review types |
| application_owner | 1 | 6 | 18 | -1 | Table | Contact information, type, and corporate summary document UUID for owner or primary contact |
| application_boundary_amendment | 1 | 0 | 12 | -1 | Table | Used by ALC GIS Staff to track Inclusion / Exclusion decisions and their ALR boundary impact over time |
| application_modified_decisions | 0 | 2 | 2 | -1 | Table | Links application modification requests with their resulting decisions |
| notice_of_intent_submission | 3 | 2 | 57 | -1 | Table | Portal intake form fields for NOIs |
| notification_document | 0 | 3 | 11 | -1 | Table | Documents for Notifications |
| card_subtask | 0 | 3 | 11 | -1 | Table | Attributes for card subtasks |
| application_reconsideration_type | 1 | 0 | 8 | -1 | Table | Code table for possible types of reconsiderations |
| notification_type | 1 | 0 | 13 | -1 | Table | Code table for possible Notification types |
| notice_of_intent_decision_condition_card | 1 | 2 | 8 | -1 | Table | Links notice of intent decision conditions with cards |
| application_modification_outcome_type | 1 | 0 | 8 | -1 | Table | Code table for possible application modification review outcomes |
| holiday_entity | 0 | 1 | 3 | 100 | Table | Holidays used by the application active day tracking function |
| application_ceo_criterion_code | 1 | 0 | 9 | -1 | Table | Code table for criteria under which the CEO can make a decision on an application |
| card_type | 3 | 0 | 9 | -1 | Table | Code table for possible card types |
| inquiry_document | 0 | 3 | 7 | -1 | Table | Stores inquiry documents |
| comment | 1 | 2 | 11 | -1 | Table | Attributes for card comments |
| notification_submission_status_type | 1 | 0 | 13 | -1 | Table | Statuses for Notification Submissions |
| inquiry_type | 1 | 0 | 12 | -1 | Table | Code table for possible inquiry types |
| message | 0 | 2 | 9 | -1 | Table | In-app messages |
| application_decision_outcome_code | 1 | 0 | 9 | -1 | Table | Code table for the possible application decision outcomes |
| planning_review_document | 0 | 3 | 10 | -1 | Table | Stores planning review documents |
| parcel_ownership_type | 3 | 0 | 8 | -1 | Table | Code table for possible land ownership types (Fee simple vs Crown) |
| planning_review_decision_document | 0 | 2 | 8 | -1 | Table | Links Planning Review decision document with the decision it’s saved to |
| notice_of_intent_modification_outcome_type | 1 | 0 | 8 | -1 | Table | Code table for possible NOI modification review outcomes |
| health_check | 0 | 0 | 2 | -1 | Table | Unix timestamp of the last time the connection from API to database was checked and succeeded |
| document_code | 5 | 0 | 10 | 63 | Table | Code table for possible document types |
| email_status | 0 | 0 | 9 | -1 | Table | Success or failure of emails sent by ALCS |
| notice_of_intent_owner | 1 | 6 | 18 | -1 | Table | Owners for Notice of Intent Submissions |
| notification | 3 | 4 | 15 | -1 | Table | Stores Notification Class Applications such as SRWs |
| planning_review_decision | 1 | 2 | 15 | -1 | Table | Links Planning Review decision document with the decision it’s saved to |
| application_decision_meeting | 0 | 1 | 8 | -1 | Table | Dates for application review discussions |
| notice_of_intent_parcel_owners_notice_of_intent_owner | 0 | 2 | 2 | -1 | Table | Join table that links Owners to Parcels |
| planning_review | 5 | 5 | 16 | -1 | Table | A review of a local government or municipalities plan |
| application_submission | 4 | 3 | 119 | -1 | Table | Portal intake form fields for applications |
| planning_referral | 0 | 2 | 13 | -1 | Table | Planning Referrals represent each pass of a Planning Review with their own cards |
| tag | 2 | 2 | 9 | 107 | Table | Tag. |
| application_parcel_owners_application_owner | 0 | 2 | 2 | -1 | Table | Links application parcels with their owners |
| notification_submission_to_submission_status | 0 | 2 | 3 | -1 | Table | Links Notifications to their Statuses with Dates |
| owner_type | 4 | 0 | 8 | -1 | Table | Code table for possible types of owners or primary contacts |
| inquiry_parcel | 0 | 1 | 12 | -1 | Table | Parcels associated with the inquiries |
| notice_of_intent_decision_outcome | 1 | 0 | 8 | -1 | Table | Code table for possible NOI decision outcomes |
| planning_review_meeting_type | 1 | 0 | 8 | -1 | Table | Meetings Types for Planning Review Meetings |
| application_decision_component_type | 1 | 0 | 8 | -1 | Table | Code table for the possible application decision component types |
| notice_of_intent | 8 | 4 | 33 | -1 | Table | Base data for Notice of Intents incl. the ID, key dates, and the date of the first decision |
| notice_of_intent_modification | 2 | 3 | 12 | -1 | Table | NOI modification requests linked to card and application |
| notice_of_intent_parcel | 1 | 3 | 20 | -1 | Table | Parcels that are linked to Notice of Intent Submissions |
| notice_of_intent_decision_condition_component | 0 | 2 | 2 | -1 | Table | Tracks Conditions links Components |
| notification_parcel | 0 | 2 | 15 | -1 | Table | Parcels Related to Notification Applications |
| application_reconsidered_decisions | 0 | 2 | 2 | -1 | Table | Links reconsideration requests with their resulting decisions |
| notification_transferee | 0 | 5 | 14 | -1 | Table | The Transferees related to Notification Applications |
| card_history | 0 | 1 | 11 | -1 | Table | History of card status i.e. the column history of the card’s journey on boards |
| application_decision_document | 0 | 2 | 8 | -1 | Table | Links application decision document with the decision it’s saved to |
| application_region | 6 | 0 | 8 | -1 | Table | Code table for possible administrative regions in the province |
| notice_of_intent_decision_condition_date | 0 | 1 | 10 | -1 | Table | Due/end dates for conditions |
| planning_review_decision_outcome_code | 1 | 0 | 8 | -1 | Table | Possible decision outcome types for Planning Review |
| board_allowed_card_types_card_type | 0 | 2 | 2 | 64 | Table | Card types allowed on each kanban board |
| covenant_transferee | 0 | 5 | 13 | -1 | Table | Stores Transferees for Restrictive Covenant Applications |
| application_meeting | 0 | 4 | 11 | -1 | Table | Actions that un/pause applications |
| notice_of_intent_parcel_ownership_type | 0 | 0 | 8 | -1 | Table | Parcel Ownership types used for NOI Parcels |
| application_decision_condition | 5 | 3 | 14 | -1 | Table | Fields present on the application decision conditions |
| application_decision_condition_component_plan_number | 0 | 2 | 3 | -1 | Table | Survey plan numbers associated with survey plan conditions on decision components |
| application_decision_condition_component | 0 | 2 | 2 | -1 | Table | Join table that links decision condition with decision components |
| notice_of_intent_decision_condition_financial_instrument | 0 | 1 | 20 | -1 | Table | Instrument for Financial Security Conditions |
| application_tag | 0 | 2 | 2 | -1 | Table | |
| application_decision_condition_date | 0 | 1 | 10 | -1 | Table | Due/end dates for conditions |
| application_type | 1 | 0 | 17 | 10 | Table | Code table for possible application types |
| application_decision_component_lot | 1 | 1 | 11 | -1 | Table | Approved lots on the subdivision decision component |
| application_submission_status_type | 1 | 0 | 13 | 13 | Table | Code table for possible application portal statuses |
| application_submission_review | 0 | 6 | 25 | -1 | Table | Portal local or first nation government review form fields |
| application | 11 | 4 | 36 | -1 | Table | Base data for applications including the ID, key dates, and the date of the first decision |
| notice_of_intent_tag | 0 | 2 | 2 | -1 | Table | |
| notice_of_intent_decision_component_type | 1 | 0 | 8 | -1 | Table | Decision Component Types Code Table for Notice of Intents |
| notice_of_intent_type | 1 | 0 | 15 | -1 | Table | Code table for possible NOI types |
| application_meeting_type | 1 | 0 | 8 | -1 | Table | Code table for possible action types that un/pause applications |
| notice_of_intent_decision | 5 | 6 | 31 | -1 | Table | Decisions saved to NOIs, linked to the modification request |
| application_boundary_amendments_to_components | 0 | 2 | 2 | -1 | Table | Links Boundary Amendments to the Decision Components they result from |
| notice_of_intent_meeting | 0 | 2 | 11 | -1 | Table | Actions that un/pause NOIs |
| compliance_and_enforcement_submitter | 0 | 2 | 9 | -1 | Table | Compliance and enforcement submitter |
| tag_category | 1 | 1 | 7 | -1 | Table | Tag category. |
| comment_mention | 0 | 2 | 9 | -1 | Table | Links comment mentions with the corresponding user |
| application_decision_chair_review_outcome_type | 1 | 0 | 8 | -1 | Table | Code table for the possible outcomes of the chair’s application decision review |
| application_decision_component | 4 | 3 | 28 | -1 | Table | Fields present on the application decision components |
| application_reconsideration_outcome_type | 2 | 0 | 8 | -1 | Table | Code table for possible application reconsideration review outcomes |
| board_create_card_types_card_type | 0 | 2 | 2 | 2 | Table | Contains the type of cards can be created from each board |
| user | 18 | 7 | 21 | -1 | Table | Authenticated users and their attributes |
| notice_of_intent_document | 2 | 3 | 9 | -1 | Table | Links NOI documents with the NOIs they’re saved to and logs other attributes |
| file_viewed | 0 | 0 | 4 | -1 | Table | Stores when the file(Application, NOI etc.) was last viewed. |
| inquiry | 3 | 7 | 22 | -1 | Table | Inquiries from the public or other agencies that require a response from the ALC. |
| staff_journal | 0 | 6 | 15 | -1 | Table | Staff journal entries saved to applications and NOIs, SRWs, Inquiries etc. |
| application_document | 2 | 3 | 10 | -1 | Table | Links application documents with the applications they’re saved to and logs other attributes |
| application_decision_maker_code | 1 | 0 | 9 | -1 | Table | Code table for the possible application decision makers |
| application_paused | 2 | 1 | 9 | -1 | Table | Date ranges responsible for un/pausing an application |
| inbox_notice_of_intent_submission_view | 0 | 0 | 12 | 0 | View | |
| public_notification_submission_search_view | 0 | 1 | 7 | 0 | View | |
| planning_review_search_view | 0 | 2 | 24 | 0 | View | |
| notice_of_intent_submission_search_view | 0 | 1 | 28 | 0 | View | |
| application_submission_status_search_view | 0 | 0 | 2 | 0 | View | |
| inbox_application_submission_view | 0 | 0 | 12 | 0 | View | |
| public_notice_of_intent_submission_search_view | 0 | 1 | 9 | 0 | View | |
| inbox_notification_submission_view | 0 | 0 | 11 | 0 | View | |
| public_application_submission_search_view | 0 | 1 | 9 | 0 | View | |
| noi_submission_status_search_view | 0 | 0 | 2 | 0 | View | |
| notification_submission_status_search_view | 0 | 0 | 2 | 0 | View | |
| application_submission_search_view | 0 | 1 | 10 | 0 | View | |
| inquiry_search_view | 0 | 3 | 21 | 0 | View | |
| notification_submission_search_view | 0 | 1 | 23 | 0 | View |