m_savings_officer_assignment_history

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
account_id int8 19 null
m_savings_account.id fk_m_savings_officer_assignment_history_0001 R
savings_officer_id int8 19 √ null
m_staff.id fk_m_savings_officer_assignment_history_0002 R
start_date date 13 null
end_date date 13 √ null
created_by int8 19 null
m_appuser.id FK_savings_officer_assignment_history_created_by R
created_date timestamp 29,6 √ null
lastmodified_date timestamp 29,6 √ null
last_modified_by int8 19 null
m_appuser.id FK_savings_officer_assignment_history_last_modified_by R
created_on_utc timestamptz 35,6 null
last_modified_on_utc timestamptz 35,6 null

Indexes

Constraint Name Type Sort Column(s)
m_savings_officer_assignment_history_pkey 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