m_client_identifier

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
client_id int8 19 null
m_client.id FK_m_client_document_m_client R
document_type_id int4 10 null
m_code_value.id FK_m_client_document_m_code_value R
document_key varchar 50 null
status int4 10 300
active int4 10 √ null
description varchar 500 √ null
created_by int8 19 null
m_appuser.id FK_client_identifier_created_by R
last_modified_by int8 19 null
m_appuser.id FK_client_identifier_last_modified_by R
created_date timestamp 29,6 √ null
lastmodified_date timestamp 29,6 √ null
created_on_utc timestamptz 35,6 null
last_modified_on_utc timestamptz 35,6 null
issuance_date date 13 √ null
expiry_date date 13 √ null

Indexes

Constraint Name Type Sort Column(s)
m_client_identifier_pkey Primary key Asc id
FK_m_client_document_m_client Performance Asc client_id
FK_m_client_document_m_code_value Performance Asc document_type_id
unique_active_client_identifier Must be unique Asc/Asc/Asc client_id + document_type_id + active
unique_identifier_key Must be unique Asc/Asc document_type_id + document_key

Relationships

Close relationships within degrees of separation