ExpertClassApplicationCSVExportRequests


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
exporterId uuid 2147483647 null
Users.id ExpertClassApplicationCSVExportRequests_exporterId_fkey C
fromDate timestamptz 35,6 null

This column is linked to the column updatedAt from ExpertClassApplications table
toDate timestamptz 35,6 null

This column is linked to the column updatedAt from ExpertClassApplications table
status enum_ExpertClassApplicationCSVExport_status 2147483647 'INITIATED'::"enum_ExpertClassApplicationCSVExport_status"
fileKey text 2147483647 √ null

File name linking to corresponding file in s3 bucket /expert-class/c2c-platform/class-applications-export
message text 2147483647 √ null
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
ExpertClassApplicationCSVExportRequests_pkey Primary key Asc id
ExpertClassApplicationCSVExportRequests_fileKey_key Must be unique Asc fileKey

Check Constraints

Constraint Name Constraint
ExpertClassApplicationCSVExportRequests_toDate_greater_than_fro (("fromDate" <= "toDate"))

Relationships

Close relationships within degrees of separation