m_client_transfer_details

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
client_id BIGINT 19 null
m_client.id FK_m_client_transfer_details_m_clientR
from_office_id BIGINT 19 null
m_office.id FK_m_client_transfer_details_m_officeR
to_office_id BIGINT 19 null
m_office.id FK_m_client_transfer_details_m_office_2R
proposed_transfer_date DATE 10 √ NULL
transfer_type TINYINT 3 null
submitted_on DATE 10 null
submitted_by BIGINT 19 null
m_appuser.id FK_m_client_transfer_details_m_appuserR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_m_client_transfer_details_m_appuser Performance Asc submitted_by
FK_m_client_transfer_details_m_client Performance Asc client_id
FK_m_client_transfer_details_m_office Performance Asc from_office_id
FK_m_client_transfer_details_m_office_2 Performance Asc to_office_id

Relationships

Close relationships within degrees of separation