CompanyVerificationRequestStatusChangeLogs


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
companyVerificationRequestId uuid 2147483647 null
CompanyVerificationRequests.id CompanyVerificationRequestSta_companyVerificationRequestId_fkey C
previousStatus enum_CompanyVerificationRequests_status 2147483647 null
updatedStatus enum_CompanyVerificationRequests_status 2147483647 null
userId uuid 2147483647 √ null
Users.id CompanyVerificationRequestStatusChangeLogs_userId_fkey N
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
automationTrigger enum_AutomationTrigger_type 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
CompanyVerificationRequestStatusChangeLogs_pkey Primary key Asc id
CompanyVerificationRequestStatusChangeLogs_automationTrigger_id Performance Asc automationTrigger

Check Constraints

Constraint Name Constraint
previousStatus_and_updatedStatus_check (("previousStatus" <> "updatedStatus"))

Relationships

Close relationships within degrees of separation