useraccess


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
groupId INT 10 null
usergroup.id FKfodtrxu1gtvq6g3h2e7d7e0pn R
modifyFlag BIT 1 √ null
moduleName VARCHAR 256 null
viewFlag BIT 1 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FKfodtrxu1gtvq6g3h2e7d7e0pn Performance Asc groupId
userAccessModuleNameIdx Performance Asc moduleName

Relationships