permissions

122 rows


Description

Stores Permissions Master Data

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT UNSIGNED 20 √ null
name VARCHAR 125 null
guard_name VARCHAR 125 √ web
type TINYINT 3 √ 0

0:Normal Permission,1:Administrative Permission

usertype VARCHAR 36 √ null
title VARCHAR 125 √ null
sub_group VARCHAR 125 √ null

For UI Purpose

parent_group VARCHAR 125 √ null

For UI Purpose

group TINYINT 3 √ null

1:create;2:update;3:Read;4:Delete;5:Miscellaneous

tenant_id VARCHAR 36 √ a287c91d-c8ff-4448-8d96-906d4654b6f2
created_at TIMESTAMP 19 √ null
updated_at TIMESTAMP 19 √ null
superset_key VARCHAR 50 √ null
updated_by VARCHAR 36 √ null
deleted_by VARCHAR 36 √ null
created_by VARCHAR 36 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
permissions_guard_name_IDX Performance Asc guard_name
permissions_name_guard_name_unique Must be unique Asc/Asc name + guard_name
permissions_name_IDX Performance Asc name
updated_at_index Performance Asc updated_at

Relationships