Workshopallocation Scheduled Table Schema (workshopallocation_scheduled)


Description

Stores the allocation settings for the scheduled allocator

workshopallocation_scheduled table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
workshopid BIGINT 19 null
workshop.id Implied Constraint R

workshop id we are part of
enabled TINYINT 3 0

Is the scheduled allocation enabled
submissionend BIGINT 19 null

What was the workshop's submissionend when this record was created or modified
timeallocated BIGINT 19 √ null

When was the last scheduled allocation executed
settings LONGTEXT 2147483647 √ null

The pre-defined settings for the underlying random allocation to run it with
resultstatus BIGINT 19 √ null

The resulting status of the most recent execution
resultmessage VARCHAR 1333 √ null

Optional short message describing the resulting status
resultlog LONGTEXT 2147483647 √ null

The log of the most recent execution

Table contained -1 rows

workshopallocation_scheduled table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
worksche_wor_uix Must be unique Asc workshopid

workshopallocation_scheduled table relationships

Close relationships within degrees of separation