Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | √ | null |
|
|
|||||
| client_id | int8 | 19 | null |
|
|
||||||
| from_office_id | int8 | 19 | null |
|
|
||||||
| to_office_id | int8 | 19 | null |
|
|
||||||
| proposed_transfer_date | date | 13 | √ | null |
|
|
|||||
| transfer_type | int2 | 5 | null |
|
|
||||||
| submitted_on | date | 13 | null |
|
|
||||||
| submitted_by | int8 | 19 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| m_client_transfer_details_pkey | 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
