m_loan_originator

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
m_loan_originator_mapping.originator_id FK_loan_originator_mapping_originator R
m_wc_loan_originator_mapping.originator_id FK_wc_loan_originator_mapping_originator R
external_id varchar 100 null
name varchar 255 √ null
status varchar 20 null
originator_type_cv_id int4 10 √ null
m_code_value.id FK_loan_originator_type_cv R
channel_type_cv_id int4 10 √ null
m_code_value.id FK_loan_originator_channel_cv R
created_on_utc timestamptz 35,6 null
created_by int8 19 null
m_appuser.id FK_loan_originator_created_by R
last_modified_on_utc timestamptz 35,6 null
last_modified_by int8 19 null
m_appuser.id FK_loan_originator_modified_by R

Indexes

Constraint Name Type Sort Column(s)
m_loan_originator_pkey Primary key Asc id
idx_loan_originator_status Performance Asc status
UQ_loan_originator_external_id Must be unique Asc external_id

Relationships

Close relationships within degrees of separation