ExpertApplications


Description

Records in this table are not meant to be deleted. A rule has been added to avoid records to be deleted

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
ExpertApplicationOtherRejectionReasons.expertApplicationId ExpertApplicationOtherRejectionReasons_expertApplicationId_fkey C
ExpertApplicationSelectedRejectionReasons.expertApplicationId ExpertApplicationSelectedRejectionReasons_expertApplicationId_f C
ExpertApplicationStatusNotifications.expertApplicationId ExpertApplicationStatusNotifications_expertApplicationId_fkey C
userId uuid 2147483647 √ null
Users.id ExpertApplications_userId_fkey N
additionalInformationId uuid 2147483647 null
ExpertApplicationAdditionalInformation.id ExpertApplications_additionalInformationId_fkey C
status enum_ExpertApplication_status 2147483647 'EDITING'::"enum_ExpertApplication_status"
dateOfSubmission timestamptz 35,6 √ null
grade enum_ExpertApplication_grade 2147483647 √ null
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
dateOfApproval timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
ExpertApplications_pkey Primary key Asc id
ExpertApplications_additionalInformationId_key Must be unique Asc additionalInformationId
ExpertApplications_userId_key Must be unique Asc userId

Relationships

Close relationships within degrees of separation