ExpertClassApplications


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
ExpertClassApplicationClassCategories.expertClassApplicationId ExpertClassApplicationClassCatego_expertClassApplicationId_fkey C
ExpertClassApplicationExpertiseTopics.expertClassApplicationId ExpertClassApplicationExpertiseTo_expertClassApplicationId_fkey C
ExpertClassApplicationKeyLearnings.expertClassApplicationId ExpertClassApplicationKeyLearning_expertClassApplicationId_fkey C
ExpertClassApplicationOtherRejectionReasons.expertClassApplicationId ExpertClassApplicationOtherRejectionReasons_expertClassApplicat C
ExpertClassApplicationPromotions.expertClassApplicationId ExpertClassApplicationPromotions_expertClassApplicationId_fkey C
ExpertClassApplicationSelectedRejectionReasons.expertClassApplicationId ExpertClassApplicationSelectedRejectionReasons_applicationId_fk C
ExpertClassApplicationTargetAudiences.expertClassApplicationId ExpertClassApplicationTargetAudie_expertClassApplicationId_fkey C
ProposedExpertClassSchedules.expertClassApplicationId ProposedExpertClassSchedules_expertClassApplicationId_fkey C
shortId bpchar 8 null
expertId uuid 2147483647 null
Experts.id ExpertClassApplications_expertId_fkey C
expertClassLanguageId uuid 2147483647 √ null
ExpertClassLanguages.id ExpertClassApplications_expertClassLanguageId_fkey R
classTitle text 2147483647 √ null
classDescription text 2147483647 √ null
numberOfRelatedClasses int4 10 √ null
applicationStatus enum_ExpertClassApplicationStatus_type 2147483647 'EDITING'::"enum_ExpertClassApplicationStatus_type"
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
deletedAt timestamptz 35,6 √ null
dateOfSubmission timestamptz 35,6 √ null
classStatus enum_ExpertClassApplicationClassStatus_type 2147483647 √ null
grade enum_ExpertClassApplication_grade 2147483647 √ null
publishedExpertClassId uuid 2147483647 √ null
ExpertClasses.id ExpertClassApplications_publishedExpertClassId_fkey R
note text 2147483647 √ null
letterOfAgreementAcceptedAt timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
ExpertClassApplications_pkey Primary key Asc id
ExpertClassApplications_applicationStatus_idx Performance Asc applicationStatus
ExpertClassApplications_deletedAt_idx Performance Asc deletedAt
ExpertClassApplications_expertId_idx Performance Asc expertId
ExpertClassApplications_publishedExpertClassId_key Must be unique Asc publishedExpertClassId
ExpertClassApplications_shortId_key Must be unique Asc shortId
ExpertClassApplications_updatedAt_idx Performance Asc updatedAt

Check Constraints

Constraint Name Constraint
ExpertClassApplications_applicationStatus_check (((("classStatus" IS NOT NULL) AND ("applicationStatus" = 'APPROVED'::"enum_ExpertClassApplicationStatus_type")) OR (("classStatus" IS NULL) AND ("applicationStatus" <> 'APPROVED'::"enum_ExpertClassApplicationStatus_type"))))
ExpertClassApplications_numberOfRelatedClasses_check (("numberOfRelatedClasses" >= 0))

Relationships

Close relationships within degrees of separation