material_fossil

53 rows


Description

Linking materials to one or more fossils

Columns

Column Type Size Nulls Auto Default Children Parents Comments
material_id INT 10 null
material.material_id material_fossil_material R

PK/FK. Link to material
fossil_id INT 10 null
dic_fossil.fossil_id material_fossil_dic_fossil R

PK/FK. Link to dic_fossil

Indexes

Constraint Name Type Sort Column(s)
material_fossil_s_pk Primary key Asc/Asc material_id + fossil_id
fossil_id Performance Asc fossil_id
PRIMARY Must be unique Asc/Asc material_id + fossil_id

Relationships

Close relationships within degrees of separation