Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | null |
|
|
Unique Identifier of the Certificate |
||||
| issuedAt | timestamp | 29,6 | √ | null |
|
|
The date and time the Certificate was created |
|||
| expirationDate | timestamp | 29,6 | √ | null |
|
|
The date and time the Certificate was created |
|||
| progressWasReset | bool | 1 | false |
|
|
The progress was reset of the Certificate |
||||
| companyId | uuid | 2147483647 | null |
|
|
The ID of the learning site |
||||
| resourceId | uuid | 2147483647 | √ | null |
|
|
The ID of the Resource associated with the Certificate |
|||
| resourceType | varchar | 32 | √ | null |
|
|
The resource type of the Certificate |
|||
| url | text | 2147483647 | √ | null |
|
|
The url of the Certificate |
|||
| userId | uuid | 2147483647 | null |
|
|
The ID of the User associated with the Certificate |
||||
| title | text | 2147483647 | √ | null |
|
|
The Certificate title |
|||
| identifier | varchar | 255 | √ | null |
|
|
The Certificate identifier |
|||
| updatedAt | timestamp | 29,6 | √ | null |
|
|
Table contained 0 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| certificates_pkey | Primary key | Asc | id |
| certificates_userId_idx | Performance | Asc | userId |
Relationships
Close relationships within degrees of separation
