stockrotationstages

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
stage_id INT 10 null
stockrotationitems.stage_id stockrotationitems_sifkC
position INT 10 null
rota_id INT 10 null
stockrotationrotas.rota_id stockrotationstages_rifkC
branchcode_id VARCHAR 10 null
branches.branchcode stockrotationstages_bifkC
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