Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | varchar | 255 | null |
|
|
Primary Key. |
|||||
| token | text | 2147483647 | √ | null |
|
|
Token provided by Identity Provider. |
||||
| type | enum_Identities_type | 2147483647 | null |
|
|
Identity Provider ENUM AuthenticationProviderTypes. |
|||||
| varchar | 255 | √ | null |
|
|
Email address of user. |
|||||
| firstName | varchar | 255 | √ | null |
|
|
First Name of User. |
||||
| lastName | varchar | 255 | √ | null |
|
|
Last Name of User. |
||||
| createdAt | timestamptz | 35,6 | null |
|
|
Entry creation date |
|||||
| updatedAt | timestamptz | 35,6 | null |
|
|
Datetime of last modification to any attribute |
|||||
| UserId | uuid | 2147483647 | √ | null |
|
|
Foreign Key to User Table. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| Identities_pkey | Primary key | Asc/Asc | id + type |
| Identities_UserId_idx | Performance | Asc | UserId |
Relationships
Close relationships within degrees of separation
