stockrotationstages - testsql

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

stage_id

INT

10

√

null

stockrotationitems.stage_id

stockrotationitems_sifk C

position

INT

10

null

rota_id

INT

10

null

stockrotationrotas.rota_id

stockrotationstages_rifk C

branchcode_id

VARCHAR

10

null

branches.branchcode

stockrotationstages_bifk C

duration

INT

10

4

The number of days items shoud occupy this stage

Showing 1 to 5 of 5 entries

Table contained 0 rows

Indexes

Search:

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

Showing 1 to 3 of 3 entries

Relationships

Close relationships within degrees of separation

One
Two degrees