def |
gym |
gym_answer_supplement |
id |
1 |
NULL | NO |
int |
NULL | NULL | 10 |
0 |
NULL | NULL | NULL | int(15) unsigned |
PRI |
auto_increment |
select,insert,update,references |
自动增长id主键 |
def |
gym |
gym_answer_supplement |
supplement_key |
2 |
NULL | NO |
varchar |
100 |
400 |
NULL | NULL | NULL | utf8mb4 |
utf8mb4_general_ci |
varchar(100) |
| | select,insert,update,references |
补充的键名 |
def |
gym |
gym_answer_supplement |
create_time |
3 |
NULL | NO |
varchar |
100 |
400 |
NULL | NULL | NULL | utf8mb4 |
utf8mb4_general_ci |
varchar(100) |
| | select,insert,update,references |
创建的时间 |
def |
gym |
gym_answer_supplement |
answer_id |
4 |
NULL | NO |
int |
NULL | NULL | 10 |
0 |
NULL | NULL | NULL | int(15) unsigned |
MUL |
| select,insert,update,references |
答案的id |
def |
gym |
gym_auth_group |
id |
1 |
NULL | NO |
int |
NULL | NULL | 10 |
0 |
NULL | NULL | NULL | int(11) unsigned |
PRI |
auto_increment |
select,insert,update,references |
自动增长的id内容 |
def |
gym |
gym_auth_group |
title |
2 |
| NO |
char |
100 |
400 |
NULL | NULL | NULL | utf8mb4 |
utf8mb4_general_ci |
char(100) |
| | select,insert,update,references |
用户组的名称不代表用户组真实的名称 |
def |
gym |
gym_auth_group |
status |
3 |
1 |
NO |
tinyint |
NULL | NULL | 3 |
0 |
NULL | NULL | NULL | tinyint(1) |
| | select,insert,update,references |
用户组当前的状态 |
def |
gym |
gym_auth_group |
description |
4 |
| NO |
varchar |
255 |
1020 |
NULL | NULL | NULL | utf8mb4 |
utf8mb4_general_ci |
varchar(255) |
| | select,insert,update,references |
说明 |
def |
gym |
gym_auth_group |
listorder |
5 |
0 |
NO |
int |
NULL | NULL | 10 |
0 |
NULL | NULL | NULL | int(11) |
| | select,insert,update,references |
用户组的排序 |
def |
gym |
gym_auth_group_relation |
uid |
1 |
NULL | NO |
char |
64 |
256 |
NULL | NULL | NULL | utf8mb4 |
utf8mb4_general_ci |
char(64) |
| | select,insert,update,references |
用户的id |
def |
gym |
gym_auth_group_relation |
group_id |
2 |
NULL | NO |
int |
NULL | NULL | 10 |
0 |
NULL | NULL | NULL | int(11) unsigned |
MUL |
| select,insert,update,references |
用户组的id |
def |
gym |
gym_auth_group_relation |
id |
3 |
NULL | NO |
int |
NULL | NULL | 10 |
0 |
NULL | NULL | NULL | int(15) unsigned |
PRI |
auto_increment |
select,insert,update,references |
主键 |
def |
gym |
gym_auth_rule |
id |
1 |
NULL | NO |
int |
NULL | NULL | 10 |
0 |
NULL | NULL | NULL | int(11) unsigned |
PRI |
auto_increment |
select,insert,update,references |
自动增长id |
def |
gym |
gym_auth_rule |
pid |
2 |
0 |
NO |
int |
NULL | NULL | 10 |
0 |
NULL | NULL | NULL | int(11) unsigned |
| | select,insert,update,references |
父级id |
def |
gym |
gym_auth_rule |
title |
3 |
| NO |
char |
20 |
80 |
NULL | NULL | NULL | utf8mb4 |
utf8mb4_general_ci |
char(20) |
| | select,insert,update,references |
规则中文名称 |
def |
gym |
gym_auth_rule |
module |
4 |
| NO |
varchar |
45 |
180 |
NULL | NULL | NULL | utf8mb4 |
utf8mb4_general_ci |
varchar(45) |
| | select,insert,update,references |
模块 |
def |
gym |
gym_auth_rule |
controller |
5 |
| NO |
varchar |
45 |
180 |
NULL | NULL | NULL | utf8mb4 |
utf8mb4_general_ci |
varchar(45) |
UNI |
| select,insert,update,references |
控制器 |
def |
gym |
gym_auth_rule |
action |
6 |
| NO |
varchar |
45 |
180 |
NULL | NULL | NULL | utf8mb4 |
utf8mb4_general_ci |
varchar(45) |
| | select,insert,update,references |
行为 |
def |
gym |
gym_auth_rule |
status |
7 |
1 |
NO |
tinyint |
NULL | NULL | 3 |
0 |
NULL | NULL | NULL | tinyint(1) |
| | select,insert,update,references |
状态:1为正常,0为禁用 |
def |
gym |
gym_auth_rule |
ismenu |
8 |
1 |
NO |
tinyint |
NULL | NULL | 3 |
0 |
NULL | NULL | NULL | tinyint(1) unsigned |
| | select,insert,update,references |
菜单显示 |
def |
gym |
gym_auth_rule |
condition |
9 |
| NO |
char |
100 |
400 |
NULL | NULL | NULL | utf8mb4 |
utf8mb4_general_ci |
char(100) |
| | select,insert,update,references |
附加的权限条件 |
def |
gym |
gym_auth_rule |
icon |
10 |
| NO |
varchar |
45 |
180 |
NULL | NULL | NULL | utf8mb4 |
utf8mb4_general_ci |
varchar(45) |
| | select,insert,update,references |
图标 |
def |
gym |
gym_auth_rule |
listorder |
11 |
9999 |
NO |
int |
NULL | NULL | 10 |
0 |
NULL | NULL | NULL | int(11) |
MUL |
| select,insert,update,references |
排序 |
def |
gym |
gym_auth_rule |
group_id |
12 |
1 |
NO |
varchar |
255 |
1020 |
NULL | NULL | NULL | utf8mb4 |
utf8mb4_general_ci |
varchar(255) |
| | select,insert,update,references |
用户组的id |
def |
gym |
gym_boss_point_rule |
id |
1 |
NULL | NO |
int |
NULL | NULL | 10 |
0 |
NULL | NULL | NULL | int(8) |
PRI |
auto_increment |
select,insert,update,references |
|