user

-1 rows


Description

Authenticated users and their attributes

Columns

Column Type Size Nulls Auto Default Children Parents Comments
audit_deleted_date_at timestamptz 35,6 √ null
audit_created_at timestamptz 35,6 now()
audit_updated_at timestamptz 35,6 √ now()
audit_created_by varchar 2147483647 null
audit_updated_by varchar 2147483647 √ null
uuid uuid 2147483647 gen_random_uuid()
application_decision.flag_edited_by_uuid FK_93cde17558333a6f39d089928de R
application_decision.flagged_by_uuid FK_ba6fa8d1851029a9859afc35b03 R
application_submission.created_by_uuid FK_bf4913015d41f8bb129407e493e R
application_submission_review.created_by_uuid FK_9e40c625d904c15cc05b9a04ff9 R
card.assignee_uuid FK_e91ded29d40ce244c61402e65fe R
card_subtask.assignee_uuid FK_35829d0ec7a6e71391c2349188f R
comment.author_uuid FK_f2d86184a78b855225c1395dfd3 R
comment_mention.user_uuid FK_15ec79570aca5e00f9c102ae1a0 R
compliance_and_enforcement.assignee_uuid FK_1c1dc55d4f9379e09a3fae94a6f R
compliance_and_enforcement.chronology_closed_by_uuid FK_3a21caa5cf341465504a6c50fd9 R
compliance_and_enforcement_chronology_entry.author_uuid FK_164d6ce38ac2bc929aff05737ce R
document.uploaded_by_uuid FK_9b9254f412e8a5a07063209a08c R
inquiry.closed_by_uuid FK_3fcfda215d023cf892bf0b3048a R
message.actor_uuid FK_f9d295dbeac38c6b05f0994b415 R
message.receiver_uuid FK_23212dcb31290e8972bd4e8aa4d R
notice_of_intent_decision.flag_edited_by_uuid FK_8b3ab9ae1ef21da9ebe8b358a39 R
notice_of_intent_decision.flagged_by_uuid FK_9b50f52d4c843ff2656ce04e575 R
notice_of_intent_submission.created_by_uuid FK_ad65e20b0787e13906e0f36f1cf R
notification_submission.created_by_uuid FK_99aed25adf97bc0591103e246c2 R
planning_review.closed_by_uuid FK_84caebfef3502f3fb80e168ba44 R
staff_journal.author_uuid FK_e21493108139ef325ef10bcf7c1 R
email varchar 2147483647 √ null
display_name varchar 2147483647 null
configuration.name Implied Constraint R
identity_provider varchar 2147483647 null
preferred_username varchar 2147483647 null
name varchar 2147483647 √ null
configuration.name Implied Constraint R
given_name varchar 2147483647 √ null
configuration.name Implied Constraint R
family_name varchar 2147483647 √ null
configuration.name Implied Constraint R
idir_user_guid varchar 2147483647 √ null
idir_user_name varchar 2147483647 √ null
configuration.name Implied Constraint R
bceid_guid varchar 2147483647 √ null
bceid_user_name varchar 2147483647 √ null
configuration.name Implied Constraint R
client_roles _text 2147483647 '{}'::text[]
settings jsonb 2147483647 √ null
bceid_business_guid varchar 2147483647 √ null
business_name varchar 2147483647 √ null
configuration.name Implied Constraint R

Indexes

Constraint Name Type Sort Column(s)
PK_a95e949168be7b7ece1a2382fed Primary key Asc uuid
IDX_298a928993eee3de03067af610 Must be unique Asc bceid_guid
IDX_9b4bff420dc831713caf962716 Must be unique Asc idir_user_guid

Relationships

Close relationships within degrees of separation