material_use_finish

715 rows


Description

Linking material use to one or more finishes

Columns

Column Type Size Nulls Auto Default Children Parents Comments
material_use_finish_id INT 10 √ null
material_use_id INT 10 null
material_use.material_use_id material_use_finish_ibfk_2 R

FK. Link to material use.
finish_id INT 10 null
dic_finish.finish_id material_use_finish_ibfk_1 R

FK. Link to dic_finish.

Indexes

Constraint Name Type Sort Column(s)
material_use_finish_s_pk Primary key Asc material_use_finish_id
finish_id Performance Asc finish_id
material_use_id Performance Asc material_use_id
PRIMARY Must be unique Asc material_use_finish_id

Relationships

Close relationships within degrees of separation