dic_role

12 rows


Description

Dictionary of roles for people (e.g. architect, builder)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
role_id INT 10 √ null
person.role_id person_role_fk R
person_construction.role_id person_construction_ibfk_3 R
person_material_source.role_id person_material_source_ibfk_3 R
person_material_use.role_id person_material_use_ibfk_3 R
role VARCHAR 250 null

Role e.g. architect, builder, engineer

Indexes

Constraint Name Type Sort Column(s)
dic_role_s_pk Primary key Asc role_id
PRIMARY Must be unique Asc role_id

Relationships

Close relationships within degrees of separation