commodity

221 rows


Description

Linking material to material source

Columns

Column Type Size Nulls Auto Default Children Parents Comments
commodity_id INT 10 √ null
material_use.commodity_id material_use_ibfk_2 R

PK. Auto incrementing.
material_id INT 10 null
material.material_id commodity_ibfk_1 R

FK. Link to material.
material_source_id INT 10 null
material_source.material_source_id commodity_ibfk_2 R

FK. Link to material_source.

Indexes

Constraint Name Type Sort Column(s)
commodity_s_pk Primary key Asc commodity_id
fk_commodity_material Performance Asc material_id
material_source_id Performance Asc material_source_id
PRIMARY Must be unique Asc commodity_id

Relationships

Close relationships within degrees of separation