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

Close relationships within degrees of separation