server/like/models/system.py · java8dj/likeadmin(Python版)- MIT协议-免费任意商用- 管理后台_小程序_手机H5_PC端_uni-app

代码拉取完成,页面将自动刷新

扫描微信二维码支付

取消

支付完成

richgiteeai

Watch

不关注关注所有动态仅关注版本发行动态关注但不提醒动态

1 Star 0 Fork 431

java8dj/likeadmin(Python版)- MIT协议-免费任意商用- 管理后台_小程序_手机H5_PC端_uni-app

forked from likeadmin/likeadmin(Python版)- MIT协议-免费任意商用- 管理后台_小程序_手机H5_PC端_uni-app

代码 Issues 0 Pull Requests 0 Wiki 统计流水线

服务

加入 Gitee

与超过 1400万开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)

免费加入

已有帐号? 立即登录

文件

master

分支 (13)

标签 (4)

管理

master

develop

cherry-pick-1684465687

dev_hyc_v1.2

feat-admin

feat-split_deploy

feat-channel

cherry-pick-1675816700

dev_storage_morpheus

dev_hyc_dict

dev_cyx

dev_hyc1103

dev_hyc

1.2.0

1.1.0

1.0.1

1.0.0

克隆/下载

HTTPS SSH SVN SVN+SSH 下载ZIP

提示

下载代码请复制以下命令到终端执行

为确保你提交的代码身份被 Gitee 正确识别,请执行以下命令完成配置

git config --global user.name userName 
git config --global user.email userEmail

初次使用 SSH 协议进行代码克隆、推送等操作时,需按下述提示完成 SSH 配置

1 生成 RSA 密钥

2 获取 RSA 公钥内容,并配置到 SSH公钥中

在 Gitee 上使用 SVN,请访问使用指南

使用 HTTPS 协议时,命令行会出现如下账号密码验证步骤。基于安全考虑,Gitee 建议配置并使用私人令牌替代登录密码进行克隆、推送等操作

Username for 'https://gitee.com': userName

Password for 'https://userName@gitee.com': # 私人令牌

分支 13

标签 4

likeadmin_python

server

like

models

system.py

system.py 14.71 KB

from sqlalchemy import Column, String, Text, text
from sqlalchemy.dialects import mysql

from .base import Base, TimestampMixin

__all__ = [
 'SystemConfig', 'SystemAuthAdmin', 'SystemAuthMenu', 'SystemAuthPerm', 'SystemAuthRole', 'SystemLogLogin',
 'SystemLogOperate', 'SystemAuthDept', 'SystemAuthPost', "SystemLogSms",
 'system_config', 'system_auth_admin', 'system_auth_menu', 'system_auth_perm', 'system_auth_role',
 'system_log_login', 'system_log_operate', 'system_auth_post', 'system_auth_dept',
 "system_log_sms"
]

class SystemConfig(Base):
 """系统配置实体"""
 __tablename__ = 'la_system_config'
 __table_args__ = {
 'mysql_engine': 'InnoDB',
 'mysql_charset': 'utf8mb4',
 'mysql_collate': 'utf8mb4_general_ci',
 'mysql_row_format': 'Dynamic',
 'mysql_auto_increment': '1',
 'comment': '系统全局配置表',
 }

id = Column(mysql.INTEGER(10, unsigned=True), primary_key=True, comment='主键')
 type = Column(String(30), nullable=True, server_default='', comment='类型')
 name = Column(String(60), nullable=False, server_default='', comment='键')
 value = Column(Text, nullable=True, comment='值')
 create_time = Column(mysql.INTEGER(10, unsigned=True), nullable=True, server_default=text('0'), comment='创建时间')
 update_time = Column(mysql.INTEGER(10, unsigned=True), nullable=True, server_default=text('0'), comment='更新时间')

class SystemAuthAdmin(Base, TimestampMixin):
 """系统管理员实体"""
 __tablename__ = 'la_system_auth_admin'
 __table_args__ = {
 'mysql_engine': 'InnoDB',
 'mysql_charset': 'utf8mb4',
 'mysql_collate': 'utf8mb4_general_ci',
 'mysql_row_format': 'Dynamic',
 'mysql_auto_increment': '1',
 'comment': '系统管理成员表',
 }

id = Column(mysql.INTEGER(10, unsigned=True), primary_key=True, comment='主键')
 # dept_id = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='部门ID')
 # post_id = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='岗位ID')
 username = Column(String(32), nullable=False, server_default='', comment='用户账号')
 nickname = Column(String(32), nullable=False, server_default='', comment='用户昵称')
 password = Column(String(200), nullable=False, server_default='', comment='用户密码')
 avatar = Column(String(200), nullable=False, server_default='', comment='用户头像')
 # role = Column(String(200), nullable=False, server_default='', comment='角色主键')
 role_ids = Column(String(200), nullable=False, server_default='', comment='角色主键')
 dept_ids = Column(String(200), nullable=False, server_default='', comment='部门ID')
 post_ids = Column(String(200), nullable=False, server_default='', comment='岗位ID')
 salt = Column(String(20), nullable=False, server_default='', comment='加密盐巴')
 sort = Column(mysql.SMALLINT(5), nullable=False, server_default=text('0'), comment='排序编号')
 is_multipoint = Column(mysql.TINYINT(1, unsigned=True), nullable=False, server_default=text('0'),
 comment='多端登录: 0=否, 1=是')
 is_disable = Column(mysql.TINYINT(0, unsigned=True), nullable=False, server_default=text('0'),
 comment='是否禁用: [0=否, 1=是]')
 is_delete = Column(mysql.TINYINT(1, unsigned=True), nullable=False, server_default=text('0'),
 comment='是否删除: [0=否, 1=是]')
 last_login_ip = Column(String(30), nullable=False, server_default='', comment='最后登录IP')
 last_login_time = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'),
 comment='最后登录时间')

class SystemAuthMenu(Base):
 """系统菜单实体"""
 __tablename__ = 'la_system_auth_menu'
 __table_args__ = {
 'mysql_engine': 'InnoDB',
 'mysql_charset': 'utf8mb4',
 'mysql_collate': 'utf8mb4_general_ci',
 'mysql_row_format': 'Dynamic',
 'mysql_auto_increment': '1',
 'comment': '系统菜单管理表',
 }

id = Column(mysql.INTEGER(10, unsigned=True), primary_key=True, comment='主键')
 pid = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='上级菜单')
 menu_type = Column(mysql.CHAR(2), nullable=False, server_default='', comment='权限类型: M=目录,C=菜单,A=按钮')
 menu_name = Column(String(100), nullable=False, server_default='', comment='菜单名称')
 menu_icon = Column(String(100), nullable=False, server_default='', comment='菜单图标')
 menu_sort = Column(mysql.SMALLINT(5), nullable=False, server_default=text('0'), comment='菜单排序')
 perms = Column(String(100), nullable=False, server_default='', comment='权限标识')
 paths = Column(String(100), nullable=False, server_default='', comment='路由地址')
 component = Column(String(200), nullable=False, server_default='', comment='前端组件')
 selected = Column(String(200), nullable=False, server_default='', comment='选中路径')
 params = Column(String(200), nullable=False, server_default='', comment='路由参数')
 is_cache = Column(mysql.TINYINT(1, unsigned=True), nullable=False, server_default=text('0'),
 comment='是否缓存: 0=否, 1=是')
 is_show = Column(mysql.TINYINT(1, unsigned=True), nullable=False, server_default=text('1'),
 comment='是否显示: 0=否, 1=是')
 is_disable = Column(mysql.TINYINT(0, unsigned=True), nullable=False, server_default=text('0'),
 comment='是否禁用: 0=否, 1=是')
 create_time = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='创建时间')
 update_time = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='更新时间')

class SystemAuthPerm(Base):
 """系统角色菜单实体"""
 __tablename__ = 'la_system_auth_perm'
 __table_args__ = {
 'mysql_engine': 'InnoDB',
 'mysql_charset': 'utf8mb4',
 'mysql_collate': 'utf8mb4_general_ci',
 'mysql_row_format': 'Dynamic',
 'comment': '系统角色菜单表',
 }

id = Column(String(100), primary_key=True, server_default='', comment='主键')
 role_id = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='角色ID')
 menu_id = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='菜单ID')

class SystemAuthRole(Base):
 """系统角色实体"""
 __tablename__ = 'la_system_auth_role'
 __table_args__ = {
 'mysql_engine': 'InnoDB',
 'mysql_charset': 'utf8mb4',
 'mysql_collate': 'utf8mb4_general_ci',
 'mysql_row_format': 'Dynamic',
 'mysql_auto_increment': '1',
 'comment': '系统角色管理表',
 }

id = Column(mysql.INTEGER(10, unsigned=True), primary_key=True, comment='主键')
 name = Column(String(100), nullable=False, server_default='', comment='角色名称')
 remark = Column(String(200), nullable=False, server_default='', comment='备注信息')
 is_disable = Column(mysql.TINYINT(0, unsigned=True), nullable=False, server_default=text('0'),
 comment='是否禁用: 0=否, 1=是')
 sort = Column(mysql.SMALLINT(5), nullable=False, server_default=text('0'), comment='角色排序')
 create_time = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='创建时间')
 update_time = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='更新时间')

class SystemLogLogin(Base):
 """系统登录日志实体"""
 __tablename__ = 'la_system_log_login'
 __table_args__ = {
 'mysql_engine': 'InnoDB',
 'mysql_charset': 'utf8mb4',
 'mysql_collate': 'utf8mb4_general_ci',
 'mysql_row_format': 'Dynamic',
 'mysql_auto_increment': '1',
 'comment': '系统登录日志表',
 }

class SystemLogOperate(Base):
 """系统操作日志实体"""
 __tablename__ = 'la_system_log_operate'
 __table_args__ = {
 'mysql_engine': 'InnoDB',
 'mysql_charset': 'utf8mb4',
 'mysql_collate': 'utf8mb4_general_ci',
 'mysql_row_format': 'Dynamic',
 'mysql_auto_increment': '1',
 'comment': '系统操作日志表',
 }

id = Column(mysql.INTEGER(10, unsigned=True), primary_key=True, comment='主键')
 admin_id = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='操作人ID')
 type = Column(String(30), nullable=False, server_default='', comment='请求类型: GET/POST/PUT')
 title = Column(String(30), server_default='', comment='操作标题')
 ip = Column(String(30), nullable=False, server_default='', comment='请求IP')
 url = Column(String(200), nullable=False, server_default='', comment='请求接口')
 method = Column(String(200), nullable=False, server_default='', comment='请求方法')
 args = Column(Text, comment='请求参数')
 error = Column(Text, comment='错误信息')
 status = Column(mysql.TINYINT(1, unsigned=True), nullable=False, server_default=text('1'),
 comment='执行状态: 1=成功, 2=失败')
 start_time = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='开始时间')
 end_time = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='结束时间')
 task_time = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='执行耗时')
 create_time = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='创建时间')

class SystemAuthDept(Base, TimestampMixin):
 __tablename__ = 'la_system_auth_dept'
 __table_args__ = {
 'mysql_engine': 'InnoDB',
 'mysql_charset': 'utf8mb4',
 'mysql_collate': 'utf8mb4_general_ci',
 'mysql_row_format': 'Dynamic',
 'mysql_auto_increment': '1',
 'comment': '系统部门管理表',
 }
 id = Column(mysql.INTEGER(10, unsigned=True), primary_key=True, comment='主键')
 pid = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='上级主键')
 name = Column(String(100), nullable=False, server_default='', comment='部门名称')
 duty = Column(String(30), nullable=False, server_default='', comment='负责人名')
 mobile = Column(String(30), nullable=False, server_default='', comment='联系电话')
 sort = Column(mysql.SMALLINT(5), nullable=False, server_default=text('0'), comment='排序编号')
 is_stop = Column(mysql.TINYINT(1, unsigned=True), nullable=False, server_default=text('0'),
 comment='是否停用: 0=否, 1=是')
 is_delete = Column(mysql.TINYINT(1, unsigned=True), nullable=False, server_default=text('0'),
 comment='是否删除: [0=否, 1=是]')

class SystemAuthPost(Base, TimestampMixin):
 __tablename__ = 'la_system_auth_post'
 __table_args__ = {
 'mysql_engine': 'InnoDB',
 'mysql_charset': 'utf8mb4',
 'mysql_collate': 'utf8mb4_general_ci',
 'mysql_row_format': 'Dynamic',
 'mysql_auto_increment': '1',
 'comment': '系统岗位管理表',
 }
 id = Column(mysql.INTEGER(10, unsigned=True), primary_key=True, comment='主键')
 code = Column(String(30), nullable=False, server_default=text('0'), comment='岗位编码')
 name = Column(String(30), nullable=False, server_default='', comment='岗位名称')
 remarks = Column(String(250), nullable=False, server_default='', comment='岗位备注')
 sort = Column(mysql.SMALLINT(5), nullable=False, server_default=text('0'), comment='排序编号')
 is_stop = Column(mysql.TINYINT(1, unsigned=True), nullable=False, server_default=text('0'),
 comment='是否停用: 0=否, 1=是')
 is_delete = Column(mysql.TINYINT(1, unsigned=True), nullable=False, server_default=text('0'),
 comment='是否删除: [0=否, 1=是]')

class SystemLogSms(Base, TimestampMixin):
 """
 系统短信日志表
 """
 __tablename__ = 'la_system_log_sms'
 __table_args__ = {
 'mysql_engine': 'InnoDB',
 'mysql_charset': 'utf8mb4',
 'mysql_collate': 'utf8mb4_general_ci',
 'mysql_row_format': 'Dynamic',
 'mysql_auto_increment': '1',
 'comment': '系统短信日志表',
 }
 id = Column(mysql.INTEGER(11, unsigned=True), primary_key=True, comment='主键')
 scene = Column(mysql.INTEGER(11, unsigned=True), nullable=False, server_default=text(''), comment='场景编号')
 mobile = Column(String(32), nullable=False, server_default='', comment='手机号码')
 content = Column(String(255), nullable=False, server_default='', comment='发送内容')
 status = Column(mysql.TINYINT(1, unsigned=True), nullable=False, server_default=text('0'),
 comment='发送状态:[0=发送中, 1=发送成功, 2=发送失败]')
 results = Column(Text, nullable=True, comment='短信结果')
 send_time = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='发送时间')
 create_time = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='创建时间')
 update_time = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='更新时间')

system_config = SystemConfig.__table__
system_auth_admin = SystemAuthAdmin.__table__
system_auth_menu = SystemAuthMenu.__table__
system_auth_perm = SystemAuthPerm.__table__
system_auth_role = SystemAuthRole.__table__
system_log_login = SystemLogLogin.__table__
system_log_operate = SystemLogOperate.__table__
system_auth_post = SystemAuthPost.__table__
system_auth_dept = SystemAuthDept.__table__
system_log_sms = SystemLogSms.__table__

一键复制编辑原始数据按行查看历史

geeknonerd 提交于 2023年03月17日 08:55 +08:00 . feat: 更新最新版SystemAuthAdmin实体,并更新"当前管理员"接口

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271

from sqlalchemy import Column, String, Text, text
from sqlalchemy.dialects import mysql

from .base import Base, TimestampMixin

__all__ = [
 'SystemConfig', 'SystemAuthAdmin', 'SystemAuthMenu', 'SystemAuthPerm', 'SystemAuthRole', 'SystemLogLogin',
 'SystemLogOperate', 'SystemAuthDept', 'SystemAuthPost', "SystemLogSms",
 'system_config', 'system_auth_admin', 'system_auth_menu', 'system_auth_perm', 'system_auth_role',
 'system_log_login', 'system_log_operate', 'system_auth_post', 'system_auth_dept',
 "system_log_sms"
]


class SystemConfig(Base):
 """系统配置实体"""
 __tablename__ = 'la_system_config'
 __table_args__ = {
 'mysql_engine': 'InnoDB',
 'mysql_charset': 'utf8mb4',
 'mysql_collate': 'utf8mb4_general_ci',
 'mysql_row_format': 'Dynamic',
 'mysql_auto_increment': '1',
 'comment': '系统全局配置表',
 }

 id = Column(mysql.INTEGER(10, unsigned=True), primary_key=True, comment='主键')
 type = Column(String(30), nullable=True, server_default='', comment='类型')
 name = Column(String(60), nullable=False, server_default='', comment='键')
 value = Column(Text, nullable=True, comment='值')
 create_time = Column(mysql.INTEGER(10, unsigned=True), nullable=True, server_default=text('0'), comment='创建时间')
 update_time = Column(mysql.INTEGER(10, unsigned=True), nullable=True, server_default=text('0'), comment='更新时间')


class SystemAuthAdmin(Base, TimestampMixin):
 """系统管理员实体"""
 __tablename__ = 'la_system_auth_admin'
 __table_args__ = {
 'mysql_engine': 'InnoDB',
 'mysql_charset': 'utf8mb4',
 'mysql_collate': 'utf8mb4_general_ci',
 'mysql_row_format': 'Dynamic',
 'mysql_auto_increment': '1',
 'comment': '系统管理成员表',
 }

 id = Column(mysql.INTEGER(10, unsigned=True), primary_key=True, comment='主键')
 # dept_id = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='部门ID')
 # post_id = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='岗位ID')
 username = Column(String(32), nullable=False, server_default='', comment='用户账号')
 nickname = Column(String(32), nullable=False, server_default='', comment='用户昵称')
 password = Column(String(200), nullable=False, server_default='', comment='用户密码')
 avatar = Column(String(200), nullable=False, server_default='', comment='用户头像')
 # role = Column(String(200), nullable=False, server_default='', comment='角色主键')
 role_ids = Column(String(200), nullable=False, server_default='', comment='角色主键')
 dept_ids = Column(String(200), nullable=False, server_default='', comment='部门ID')
 post_ids = Column(String(200), nullable=False, server_default='', comment='岗位ID')
 salt = Column(String(20), nullable=False, server_default='', comment='加密盐巴')
 sort = Column(mysql.SMALLINT(5), nullable=False, server_default=text('0'), comment='排序编号')
 is_multipoint = Column(mysql.TINYINT(1, unsigned=True), nullable=False, server_default=text('0'),
 comment='多端登录: 0=否, 1=是')
 is_disable = Column(mysql.TINYINT(0, unsigned=True), nullable=False, server_default=text('0'),
 comment='是否禁用: [0=否, 1=是]')
 is_delete = Column(mysql.TINYINT(1, unsigned=True), nullable=False, server_default=text('0'),
 comment='是否删除: [0=否, 1=是]')
 last_login_ip = Column(String(30), nullable=False, server_default='', comment='最后登录IP')
 last_login_time = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'),
 comment='最后登录时间')


class SystemAuthMenu(Base):
 """系统菜单实体"""
 __tablename__ = 'la_system_auth_menu'
 __table_args__ = {
 'mysql_engine': 'InnoDB',
 'mysql_charset': 'utf8mb4',
 'mysql_collate': 'utf8mb4_general_ci',
 'mysql_row_format': 'Dynamic',
 'mysql_auto_increment': '1',
 'comment': '系统菜单管理表',
 }

 id = Column(mysql.INTEGER(10, unsigned=True), primary_key=True, comment='主键')
 pid = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='上级菜单')
 menu_type = Column(mysql.CHAR(2), nullable=False, server_default='', comment='权限类型: M=目录,C=菜单,A=按钮')
 menu_name = Column(String(100), nullable=False, server_default='', comment='菜单名称')
 menu_icon = Column(String(100), nullable=False, server_default='', comment='菜单图标')
 menu_sort = Column(mysql.SMALLINT(5), nullable=False, server_default=text('0'), comment='菜单排序')
 perms = Column(String(100), nullable=False, server_default='', comment='权限标识')
 paths = Column(String(100), nullable=False, server_default='', comment='路由地址')
 component = Column(String(200), nullable=False, server_default='', comment='前端组件')
 selected = Column(String(200), nullable=False, server_default='', comment='选中路径')
 params = Column(String(200), nullable=False, server_default='', comment='路由参数')
 is_cache = Column(mysql.TINYINT(1, unsigned=True), nullable=False, server_default=text('0'),
 comment='是否缓存: 0=否, 1=是')
 is_show = Column(mysql.TINYINT(1, unsigned=True), nullable=False, server_default=text('1'),
 comment='是否显示: 0=否, 1=是')
 is_disable = Column(mysql.TINYINT(0, unsigned=True), nullable=False, server_default=text('0'),
 comment='是否禁用: 0=否, 1=是')
 create_time = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='创建时间')
 update_time = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='更新时间')


class SystemAuthPerm(Base):
 """系统角色菜单实体"""
 __tablename__ = 'la_system_auth_perm'
 __table_args__ = {
 'mysql_engine': 'InnoDB',
 'mysql_charset': 'utf8mb4',
 'mysql_collate': 'utf8mb4_general_ci',
 'mysql_row_format': 'Dynamic',
 'comment': '系统角色菜单表',
 }

 id = Column(String(100), primary_key=True, server_default='', comment='主键')
 role_id = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='角色ID')
 menu_id = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='菜单ID')


class SystemAuthRole(Base):
 """系统角色实体"""
 __tablename__ = 'la_system_auth_role'
 __table_args__ = {
 'mysql_engine': 'InnoDB',
 'mysql_charset': 'utf8mb4',
 'mysql_collate': 'utf8mb4_general_ci',
 'mysql_row_format': 'Dynamic',
 'mysql_auto_increment': '1',
 'comment': '系统角色管理表',
 }

 id = Column(mysql.INTEGER(10, unsigned=True), primary_key=True, comment='主键')
 name = Column(String(100), nullable=False, server_default='', comment='角色名称')
 remark = Column(String(200), nullable=False, server_default='', comment='备注信息')
 is_disable = Column(mysql.TINYINT(0, unsigned=True), nullable=False, server_default=text('0'),
 comment='是否禁用: 0=否, 1=是')
 sort = Column(mysql.SMALLINT(5), nullable=False, server_default=text('0'), comment='角色排序')
 create_time = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='创建时间')
 update_time = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='更新时间')


class SystemLogLogin(Base):
 """系统登录日志实体"""
 __tablename__ = 'la_system_log_login'
 __table_args__ = {
 'mysql_engine': 'InnoDB',
 'mysql_charset': 'utf8mb4',
 'mysql_collate': 'utf8mb4_general_ci',
 'mysql_row_format': 'Dynamic',
 'mysql_auto_increment': '1',
 'comment': '系统登录日志表',
 }

 id = Column(mysql.INTEGER(10, unsigned=True), primary_key=True, comment='主键')
 admin_id = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='管理员ID')
 username = Column(String(32), nullable=False, server_default='', comment='登录账号')
 ip = Column(String(30), nullable=False, server_default='', comment='登录地址')
 os = Column(String(100), nullable=False, server_default='', comment='操作系统')
 browser = Column(String(100), nullable=False, server_default='', comment='浏览器')
 status = Column(mysql.TINYINT(1, unsigned=True), nullable=False, server_default=text('0'),
 comment='操作状态: 1=成功, 2=失败')
 create_time = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='创建时间')


class SystemLogOperate(Base):
 """系统操作日志实体"""
 __tablename__ = 'la_system_log_operate'
 __table_args__ = {
 'mysql_engine': 'InnoDB',
 'mysql_charset': 'utf8mb4',
 'mysql_collate': 'utf8mb4_general_ci',
 'mysql_row_format': 'Dynamic',
 'mysql_auto_increment': '1',
 'comment': '系统操作日志表',
 }

 id = Column(mysql.INTEGER(10, unsigned=True), primary_key=True, comment='主键')
 admin_id = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='操作人ID')
 type = Column(String(30), nullable=False, server_default='', comment='请求类型: GET/POST/PUT')
 title = Column(String(30), server_default='', comment='操作标题')
 ip = Column(String(30), nullable=False, server_default='', comment='请求IP')
 url = Column(String(200), nullable=False, server_default='', comment='请求接口')
 method = Column(String(200), nullable=False, server_default='', comment='请求方法')
 args = Column(Text, comment='请求参数')
 error = Column(Text, comment='错误信息')
 status = Column(mysql.TINYINT(1, unsigned=True), nullable=False, server_default=text('1'),
 comment='执行状态: 1=成功, 2=失败')
 start_time = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='开始时间')
 end_time = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='结束时间')
 task_time = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='执行耗时')
 create_time = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='创建时间')


class SystemAuthDept(Base, TimestampMixin):
 __tablename__ = 'la_system_auth_dept'
 __table_args__ = {
 'mysql_engine': 'InnoDB',
 'mysql_charset': 'utf8mb4',
 'mysql_collate': 'utf8mb4_general_ci',
 'mysql_row_format': 'Dynamic',
 'mysql_auto_increment': '1',
 'comment': '系统部门管理表',
 }
 id = Column(mysql.INTEGER(10, unsigned=True), primary_key=True, comment='主键')
 pid = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='上级主键')
 name = Column(String(100), nullable=False, server_default='', comment='部门名称')
 duty = Column(String(30), nullable=False, server_default='', comment='负责人名')
 mobile = Column(String(30), nullable=False, server_default='', comment='联系电话')
 sort = Column(mysql.SMALLINT(5), nullable=False, server_default=text('0'), comment='排序编号')
 is_stop = Column(mysql.TINYINT(1, unsigned=True), nullable=False, server_default=text('0'),
 comment='是否停用: 0=否, 1=是')
 is_delete = Column(mysql.TINYINT(1, unsigned=True), nullable=False, server_default=text('0'),
 comment='是否删除: [0=否, 1=是]')


class SystemAuthPost(Base, TimestampMixin):
 __tablename__ = 'la_system_auth_post'
 __table_args__ = {
 'mysql_engine': 'InnoDB',
 'mysql_charset': 'utf8mb4',
 'mysql_collate': 'utf8mb4_general_ci',
 'mysql_row_format': 'Dynamic',
 'mysql_auto_increment': '1',
 'comment': '系统岗位管理表',
 }
 id = Column(mysql.INTEGER(10, unsigned=True), primary_key=True, comment='主键')
 code = Column(String(30), nullable=False, server_default=text('0'), comment='岗位编码')
 name = Column(String(30), nullable=False, server_default='', comment='岗位名称')
 remarks = Column(String(250), nullable=False, server_default='', comment='岗位备注')
 sort = Column(mysql.SMALLINT(5), nullable=False, server_default=text('0'), comment='排序编号')
 is_stop = Column(mysql.TINYINT(1, unsigned=True), nullable=False, server_default=text('0'),
 comment='是否停用: 0=否, 1=是')
 is_delete = Column(mysql.TINYINT(1, unsigned=True), nullable=False, server_default=text('0'),
 comment='是否删除: [0=否, 1=是]')


class SystemLogSms(Base, TimestampMixin):
 """
 系统短信日志表
 """
 __tablename__ = 'la_system_log_sms'
 __table_args__ = {
 'mysql_engine': 'InnoDB',
 'mysql_charset': 'utf8mb4',
 'mysql_collate': 'utf8mb4_general_ci',
 'mysql_row_format': 'Dynamic',
 'mysql_auto_increment': '1',
 'comment': '系统短信日志表',
 }
 id = Column(mysql.INTEGER(11, unsigned=True), primary_key=True, comment='主键')
 scene = Column(mysql.INTEGER(11, unsigned=True), nullable=False, server_default=text(''), comment='场景编号')
 mobile = Column(String(32), nullable=False, server_default='', comment='手机号码')
 content = Column(String(255), nullable=False, server_default='', comment='发送内容')
 status = Column(mysql.TINYINT(1, unsigned=True), nullable=False, server_default=text('0'),
 comment='发送状态:[0=发送中, 1=发送成功, 2=发送失败]')
 results = Column(Text, nullable=True, comment='短信结果')
 send_time = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='发送时间')
 create_time = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='创建时间')
 update_time = Column(mysql.INTEGER(10, unsigned=True), nullable=False, server_default=text('0'), comment='更新时间')


system_config = SystemConfig.__table__
system_auth_admin = SystemAuthAdmin.__table__
system_auth_menu = SystemAuthMenu.__table__
system_auth_perm = SystemAuthPerm.__table__
system_auth_role = SystemAuthRole.__table__
system_log_login = SystemLogLogin.__table__
system_log_operate = SystemLogOperate.__table__
system_auth_post = SystemAuthPost.__table__
system_auth_dept = SystemAuthDept.__table__
system_log_sms = SystemLogSms.__table__

误判申诉

此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。

如您确认内容无涉及不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。

取消

提交

简介

🚀🚀🚀li‌keadmin这套框架专为快速开发业务项目而生,含管理后台、微信小程序、手机 H5、PC 端等,集成常见业务场景,助你高效打造项目产品。Python3、FastAPI、TypeScript、Vue3、vite2、Element Plus1.2(ElementUI)。后台管理系统、Python管理后台、前后端分离管理后台、Vue.js管理后台、Element UI管理后台。

暂无标签

0 Stars

1 Watching

431 Forks

取消