dic_status

3 rows


Description

Dictionary of status for material sources (e.g. active, inactive)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
status_id INT 10 √ null
material_source.status_id material_source_ibfk_5 R
status VARCHAR 250 null

Status of a quarry e.g. active, inactive
status_definition TEXT 65535 √ NULL

Definition of terms

Indexes

Constraint Name Type Sort Column(s)
dic_status_s_pk Primary key Asc status_id
PRIMARY Must be unique Asc status_id

Relationships

Close relationships within degrees of separation