Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| user_id | int4 | 10 | null |
|
|
|||||
| org | varchar | 100 | null |
|
|
|||||
| org_type | varchar | 4 | null |
|
|
|||||
| city | varchar | 100 | √ | null |
|
|
||||
| department | varchar | 100 | √ | null |
|
|
||||
| position | varchar | 100 | √ | null |
|
|
||||
| phone_number | varchar | 100 | √ | null |
|
|
||||
| country_id | int4 | 10 | √ | null |
|
|
||||
| last_frontend_login | timestamptz | 35,6 | √ | null |
|
|
||||
| accepted_montandon_license_terms | bool | 1 | null |
|
|
|||||
| limit_access_to_guest | bool | 1 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| api_profile_pkey | Primary key | Asc | user_id |
| api_profile_country_id_d438e32c | Performance | Asc | country_id |
Relationships
Close relationships within degrees of separation
