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