ExpertClassCertificates


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()
ExpertClassCertificateGeneratedNotifications.expertClassCertificateId ExpertClassCertificateGeneratedNotifications_expertClassCertifi C

Primary key
UserId uuid 2147483647 null
Users.id ExpertClassCertificates_UserId_fkey R

Referencing user
ExpertClassId uuid 2147483647 null
ExpertClasses.id ExpertClassCertificates_ExpertClassId_fkey R

Referencing expert class
jpgUrl text 2147483647 null

URL of certificate image in jpeg format
pdfUrl text 2147483647 null

URL of certificate image in pdf format
createdAt timestamptz 35,6 now()

Created time
updatedAt timestamptz 35,6 √ null

Updated time

Indexes

Constraint Name Type Sort Column(s)
ExpertClassCertificates_pkey Primary key Asc id
unique_userid_expertclassid Must be unique Asc/Asc UserId + ExpertClassId

Relationships

Close relationships within degrees of separation