ExpertClassCertificateTokens


Columns

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

Primary Key.
ExpertClassId uuid 2147483647 null
ExpertClasses.id ExpertClassCertificateTokens_ExpertClassId_fkey R

Foreign Key to Expert class Table.
usedBy uuid 2147483647 √ null
Users.id ExpertClassCertificateTokens_usedBy_fkey R

Foreign Key to User Table, when this is null means this token is not used yet
email varchar 255 null

Emails of expert class attendees, may not be in the database already
token text 2147483647 null

Unique token for every email class id pair
createdAt timestamptz 35,6 now()

Entry creation date
updatedAt timestamptz 35,6 √ null

Datetime of last modification to any attribute

Indexes

Constraint Name Type Sort Column(s)
ExpertClassCertificateTokens_pkey Primary key Asc id
ExpertClassCertificateTokens_token_key Must be unique Asc token

Relationships

Close relationships within degrees of separation