stockrotationrotas

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
rota_id INT 10 null
stockrotationstages.rota_id stockrotationstages_rifk C

Stockrotation rota ID

title VARCHAR 100 null

Title for this rota

description TEXT 65535 null

Description for this rota

cyclical BIT 0 0

Should items on this rota keep cycling?

active BIT 0 0

Is this rota currently active?

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc rota_id
stockrotationrotas_title Must be unique Asc title

Relationships