workshopallocation_scheduled

0 rows


Description

Stores the allocation settings for the scheduled allocator

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
workshopid BIGINT 19 null
workshop.id worksche_wor_fkR

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

Indexes

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

Relationships