work_status

0 rows


Description

This table stores user-definable work status messages that can be applied to various data tables. They are used to indicate the current status of editor curation for the data entry.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
work_status_id INT UNSIGNED 10 √ null
artefact_status.work_status_id fk_artefact_status_to_work_status_idR
work_status_message VARCHAR 255 ''

A status message on the ccurrent state of work.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc work_status_id
unique_status_message Must be unique Asc work_status_message

Relationships

Close relationships within degrees of separation