m_savings_officer_assignment_history

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
account_id BIGINT 19 null
m_savings_account.id fk_m_savings_officer_assignment_history_0001R
savings_officer_id BIGINT 19 √ NULL
m_staff.id fk_m_savings_officer_assignment_history_0002R
start_date DATE 10 null
end_date DATE 10 √ NULL
createdby_id BIGINT 19 √ NULL
created_date DATETIME 19 √ NULL
lastmodified_date DATETIME 19 √ NULL
lastmodifiedby_id BIGINT 19 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
fk_m_savings_officer_assignment_history_0001 Performance Asc account_id
fk_m_savings_officer_assignment_history_0002 Performance Asc savings_officer_id

Relationships

Close relationships within degrees of separation