Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | √ | null |
|
|
||||
| cell_number | varchar | 15 | √ | null |
|
|
||||
| title_id_id | int8 | 19 | √ | null |
|
|
||||
| user_id | int4 | 10 | null |
|
|
|||||
| user_role_type_id_id | int8 | 19 | √ | null |
|
|
||||
| picture | varchar | 100 | √ | null |
|
|
||||
| received_notif | bool | 1 | null |
|
|
|||||
| allowing_sanbi_to_expose_data | bool | 1 | null |
|
|
|||||
| hosting_through_sanbi_platforms | bool | 1 | null |
|
|
|||||
| use_of_data_by_sanbi_only | bool | 1 | null |
|
|
|||||
| current_organisation_id | int8 | 19 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| user_profile_pkey | Primary key | Asc | id |
| user_profile_current_organisation_id_46e2d249 | Performance | Asc | current_organisation_id |
| user_profile_title_id_id_ef9c1c80 | Performance | Asc | title_id_id |
| user_profile_user_id_key | Must be unique | Asc | user_id |
| user_profile_user_role_type_id_id_d7042f1a | Performance | Asc | user_role_type_id_id |
Relationships
Close relationships within degrees of separation
