stockrotationstages

0 rows


Columns

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

Unique stage ID

position INT 10 null

The position of this stage within its rota

rota_id INT 10 null
stockrotationrotas.rota_id stockrotationstages_rifk C

The rota this stage belongs to

branchcode_id VARCHAR 10 null
branches.branchcode stockrotationstages_bifk C

Branch this stage relates to

duration INT 10 4

The number of days items shoud occupy this stage

Indexes

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

Relationships