system_permissions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
system_role_default_permissions.system_permission_id FKmw3yotap1vbj8iyexm9prwpax C
action VARCHAR 100 null
category VARCHAR 50 null
controller VARCHAR 255 √ null
created_at DATETIME 26 null
created_by VARCHAR 100 √ null
description TEXT 65535 √ null
endpoint VARCHAR 255 √ null
http_method VARCHAR 10 √ null
is_active BIT 1 null
resource VARCHAR 100 null
updated_at DATETIME 26 null
updated_by VARCHAR 100 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
UKf7p1e5ggouk4a0v2ljpp8jcpv Must be unique Asc/Asc resource + action

Relationships

Close relationships within degrees of separation