notice_of_intent_submission_to_submission_status

-1 rows


Description

Join table to link Notice of Intent Submissions to their Statuses

Columns

Column Type Size Nulls Auto Default Children Parents Comments
effective_date timestamptz 35,6 √ null
submission_uuid uuid 2147483647 null
notice_of_intent_submission.uuid FK_99fd3c0652099227d1ad64b44cf R
status_type_code text 2147483647 null
notice_of_intent_submission_status_type.code FK_d3f0150fc7dcc611898705ad81d R
email_sent_date timestamptz 35,6 √ null

Applicable only for ALCD(“Decision released”) status all others always set to null

Indexes

Constraint Name Type Sort Column(s)
PK_4aa66d524d633c477ae70e3db6f Primary key Asc/Asc submission_uuid + status_type_code

Relationships

Close relationships within degrees of separation