0 rows


Column Type Size Nulls Auto Default Children Parents Comments
stage_id INT 10 null
stockrotationitems.stage_id stockrotationitems_sifkC

Unique stage ID

position INT 10 null

The position of this stage within its rota

rota_id INT 10 null
stockrotationrotas.rota_id stockrotationstages_rifkC

The rota this stage belongs to

branchcode_id VARCHAR 10 null
branches.branchcode stockrotationstages_bifkC

Branch this stage relates to

duration INT 10 4

The number of days items shoud occupy this stage


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc stage_id
stockrotationstages_bifk Performance Asc branchcode_id
stockrotationstages_rifk Performance Asc rota_id