SystemPredictionResolutions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
SystemPredictionLogId uuid 2147483647 null
SystemPredictionLogs.id SystemPredictionResolutions_SystemPredictionLogId_fkey C
JobId uuid 2147483647 null
Jobs.id SystemPredictionResolutions_JobId_fkey C
resolutionStatus enum_ReportResolutionStatus 2147483647 null
ResolverId uuid 2147483647 √ null
Users.id SystemPredictionResolutions_ResolverId_fkey N
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
SystemPredictionResolutions_pkey Primary key Asc id
SystemPredictionResolutions_JobId_idx Performance Asc JobId
SystemPredictionResolutions_ResolverId_idx Performance Asc ResolverId
SystemPredictionResolutions_SystemPredictionLogId_key Must be unique Asc SystemPredictionLogId

Relationships

Close relationships within degrees of separation