Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | public.gen_random_uuid() |
|
|
Primary Key. |
|||||
| title | varchar | 255 | √ | null |
|
|
Name of the experience entry, in its respective context. |
||||
| notes | text | 2147483647 | √ | null |
|
|
Additional notes about that entry, usually the description. |
||||
| startDate | timestamptz | 35,6 | √ | null |
|
|
Start Date of this experience. |
||||
| endDate | timestamptz | 35,6 | √ | null |
|
|
End Date of this experience. |
||||
| organization | varchar | 255 | √ | null |
|
|
Organisation related to the experience (eg. Company in work experience). |
||||
| createdAt | timestamptz | 35,6 | null |
|
|
Entry creation date |
|||||
| updatedAt | timestamptz | 35,6 | null |
|
|
Datetime of last modification to any attribute |
|||||
| type | enum_Experiences_type | 2147483647 | null |
|
|
Type of experience (ie. WORK, CCA, EDUCATION, AWARD). |
|||||
| activity | varchar | 255 | √ | null |
|
|
Activity description, application to CCA type experiences. |
||||
| achievement | varchar | 255 | √ | null |
|
|
Achievement description, applicable to AWARD type experiences. |
||||
| UserId | uuid | 2147483647 | √ | null |
|
|
Foreign Key to User Table. |
||||
| SchoolId | uuid | 2147483647 | √ | null |
|
|
Foreign Key to School Table. |
||||
| DegreeId | uuid | 2147483647 | √ | null |
|
|
Foreign Key to Degrees Table. |
||||
| StudyId | uuid | 2147483647 | √ | null |
|
|
Foreign Key to Studies Table. |
||||
| isPresent | bool | 1 | √ | null |
|
|
Is this experience still ongoing |
||||
| educationLevel | enum_education_level_type | 2147483647 | √ | null |
|
|
|||||
| migratedToCandidateExperiencesAt | timestamptz | 35,6 | √ | null |
|
|
Denotes the timestamp for when the record was migrated to the CandidateExperiences table |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| Experiences_pkey | Primary key | Asc | id |
| Experiences_createdAt_idx | Performance | Asc | createdAt |
| Experiences_id_type_key | Must be unique | Asc/Asc | id + type |
| Experiences_UserId_idx | Performance | Asc | UserId |
| Experiences_work_title_trgm_idx | Performance | Asc | title |
Relationships
Close relationships within degrees of separation
