m_rate

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
m_loan_rate.rate_id FK_M_LOAN_RATE_RATER
m_product_loan_rate.rate_id FK_M_PRODUCT_LOAN_RATE_RATER
name VARCHAR 250 null
percentage DECIMAL 10,2 null
active BIT 1 √ b'0'
product_apply SMALLINT 5 null
created_date DATETIME 19 √ NULL
createdby_id BIGINT 19 null
m_appuser.id FK_M_RATE_CREATE_USERR
lastmodifiedby_id BIGINT 19 null
lastmodified_date DATETIME 19 √ NULL
approve_user BIGINT 19 √ NULL
m_appuser.id FK_M_RATE_APPROVE_USERR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_M_RATE_APPROVE_USER Performance Asc approve_user
FK_M_RATE_CREATE_USER Performance Asc createdby_id

Relationships

Close relationships within degrees of separation