roles

48 rows


Description

Stores Roles

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT UNSIGNED 20 √ null
name VARCHAR 125 null
guard_name VARCHAR 125 null
roletype_id VARCHAR 36 √ null
lesson_field_name VARCHAR 255 √ null
type TINYINT 3 √ null
status TINYINT 3 √ 1

0:Inactive,1:Active

superset_type TINYINT 3 √ null
description VARCHAR 100 √ null
need_approval TINYINT 3 0

0:No,1:Yes

state_lead INT 10 √ 0
finance_lead INT 10 √ 0
vti_poc INT 10 √ 0
m_and_e_team INT 10 √ 0
tenant_id VARCHAR 36 √ null
created_at TIMESTAMP 19 √ CURRENT_TIMESTAMP
updated_at TIMESTAMP 19 √ CURRENT_TIMESTAMP
updated_by VARCHAR 36 √ null
deleted_by VARCHAR 36 √ null
created_by VARCHAR 36 √ null
deleted_at TIMESTAMP 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
roles_id_IDX Performance Asc id
roles_tenant_id_IDX Performance Asc tenant_id
roles_type_IDX Performance Asc type
updated_at_index Performance Asc updated_at

Relationships