departments

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
department_id CHAR 36 null
company_video_department_association.department_id company_video_department_association_department_foreignR
departments.parent_department_id departments_parent_department_id_foreignR
roles.department_id roles_department_id_foreignR
organization_id VARCHAR 100 null
organizations.id departments_organization_id_foreignR
parent_department_id CHAR 36 √ null
departments.department_id departments_parent_department_id_foreignR
name VARCHAR 255 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc department_id
departments_organization_id_foreign Performance Asc organization_id
departments_parent_department_id_foreign Performance Asc parent_department_id

Relationships

Close relationships within degrees of separation