nested_groups

20 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT UNSIGNED 20 √ null
nested_groups.parent_nested_group_id nested_groups_parent_nested_group_id_foreignR
staff_operable_nested_groups.nested_group_id staff_operable_nested_groups_nested_group_id_foreignR
stores.nested_group_id stores_nested_group_id_foreignR

PK
company_id BIGINT UNSIGNED 20 null
companies.id nested_groups_company_id_foreignR

会社ID
parent_nested_group_id BIGINT UNSIGNED 20 √ null
nested_groups.id nested_groups_parent_nested_group_id_foreignR

親グループID
name VARCHAR 255 null

名称ラベル
created_at TIMESTAMP 26 √ null
updated_at TIMESTAMP 26 √ null
deleted_at TIMESTAMP 26 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
nested_groups_company_id_foreign Performance Asc company_id
nested_groups_parent_nested_group_id_foreign Performance Asc parent_nested_group_id

Relationships

Close relationships within degrees of separation