#### Table qrtz_blob_triggers

Indexes | Field Name | Data Type | Description
--- | --- | --- | ---
* | sched_name | varchar( 120 ) |
* | trigger_name | varchar( 200 ) |
* | trigger_group | varchar( 200 ) |
| blob_data | blob |
Indexes
| pk_qrtz_blob_triggers | ON sched_name, trigger_name, trigger_group |
Foreign Keys
| qrtz_blob_triggers_ibfk_1 | ( sched_name, trigger_name, trigger_group ) ref qrtz_triggers (sched_name, trigger_name, trigger_group) |

#### Table qrtz_calendars

Indexes | Field Name | Data Type | Description
--- | --- | --- | ---
* | sched_name | varchar( 120 ) |
* | calendar_name | varchar( 200 ) |
* | calendar | blob |
Indexes
| pk_qrtz_calendars | ON sched_name, calendar_name |

#### Table qrtz_cron_triggers

Indexes | Field Name | Data Type | Description
--- | --- | --- | ---
* | sched_name | varchar( 120 ) |
* | trigger_name | varchar( 200 ) |
* | trigger_group | varchar( 200 ) |
* | cron_expression | varchar( 200 ) |
| time_zone_id | varchar( 80 ) |
Indexes
| pk_qrtz_cron_triggers | ON sched_name, trigger_name, trigger_group |
Foreign Keys
| qrtz_cron_triggers_ibfk_1 | ( sched_name, trigger_name, trigger_group ) ref qrtz_triggers (sched_name, trigger_name, trigger_group) |

#### Table qrtz_fired_triggers

Indexes | Field Name | Data Type | Description
--- | --- | --- | ---
* | sched_name | varchar( 120 ) |
* | entry_id | varchar( 95 ) |
* | trigger_name | varchar( 200 ) |
* | trigger_group | varchar( 200 ) |
* | instance_name | varchar( 200 ) |
* | fired_time | bigint |
* | sched_time | bigint |
* | priority | int |
* | state | varchar( 16 ) |
| job_name | varchar( 200 ) |
| job_group | varchar( 200 ) |
| is_nonconcurrent | varchar( 1 ) |
| requests_recovery | varchar( 1 ) |
Indexes
| pk_qrtz_fired_triggers | ON sched_name, entry_id |

#### Table qrtz_job_details

Indexes | Field Name | Data Type | Description
--- | --- | --- | ---
* | sched_name | varchar( 120 ) |
* | job_name | varchar( 200 ) |
* | job_group | varchar( 200 ) |
| description | varchar( 250 ) |
* | job_class_name | varchar( 250 ) |
* | is_durable | varchar( 1 ) |
* | is_nonconcurrent | varchar( 1 ) |
* | is_update_data | varchar( 1 ) |
* | requests_recovery | varchar( 1 ) |
| job_data | blob |
Indexes
| pk_qrtz_job_details | ON sched_name, job_name, job_group |

#### Table qrtz_locks

Indexes | Field Name | Data Type | Description
--- | --- | --- | ---
* | sched_name | varchar( 120 ) |
* | lock_name | varchar( 40 ) |
Indexes
| pk_qrtz_locks | ON sched_name, lock_name |

#### Table qrtz_paused_trigger_grps

Indexes | Field Name | Data Type | Description
--- | --- | --- | ---
* | sched_name | varchar( 120 ) |
* | trigger_group | varchar( 200 ) |
Indexes
| pk_qrtz_paused_trigger_grps | ON sched_name, trigger_group |

#### Table qrtz_scheduler_state

Indexes | Field Name | Data Type | Description
--- | --- | --- | ---
* | sched_name | varchar( 120 ) |
* | instance_name | varchar( 200 ) |
* | last_checkin_time | bigint |
* | checkin_interval | bigint |
Indexes
| pk_qrtz_scheduler_state | ON sched_name, instance_name |

#### Table qrtz_simple_triggers

Indexes | Field Name | Data Type | Description
--- | --- | --- | ---
* | sched_name | varchar( 120 ) |
* | trigger_name | varchar( 200 ) |
* | trigger_group | varchar( 200 ) |
* | repeat_count | bigint |
* | repeat_interval | bigint |
* | times_triggered | bigint |
Indexes
| pk_qrtz_simple_triggers | ON sched_name, trigger_name, trigger_group |
Foreign Keys
| qrtz_simple_triggers_ibfk_1 | ( sched_name, trigger_name, trigger_group ) ref qrtz_triggers (sched_name, trigger_name, trigger_group) |

#### Table qrtz_simprop_triggers

Indexes | Field Name | Data Type | Description
--- | --- | --- | ---
* | sched_name | varchar( 120 ) |
* | trigger_name | varchar( 200 ) |
* | trigger_group | varchar( 200 ) |
| str_prop_1 | varchar( 512 ) |
| str_prop_2 | varchar( 512 ) |
| str_prop_3 | varchar( 512 ) |
| int_prop_1 | int |
| int_prop_2 | int |
| long_prop_1 | bigint |
| long_prop_2 | bigint |
| dec_prop_1 | decimal( 13, 4 ) |
| dec_prop_2 | decimal( 13, 4 ) |
| bool_prop_1 | varchar( 1 ) |
| bool_prop_2 | varchar( 1 ) |
Indexes
| pk_qrtz_simprop_triggers | ON sched_name, trigger_name, trigger_group |
Foreign Keys
| qrtz_simprop_triggers_ibfk_1 | ( sched_name, trigger_name, trigger_group ) ref qrtz_triggers (sched_name, trigger_name, trigger_group) |

#### Table qrtz_triggers

Indexes | Field Name | Data Type | Description
--- | --- | --- | ---
* | sched_name | varchar( 120 ) |
* | trigger_name | varchar( 200 ) |
* | trigger_group | varchar( 200 ) |
* | job_name | varchar( 200 ) |
* | job_group | varchar( 200 ) |
| description | varchar( 250 ) |
| next_fire_time | bigint |
| prev_fire_time | bigint |
| priority | int |
* | trigger_state | varchar( 16 ) |
* | trigger_type | varchar( 8 ) |
* | start_time | bigint |
| end_time | bigint |
| calendar_name | varchar( 200 ) |
| misfire_instr | smallint |
| job_data | blob |
Indexes
| pk_qrtz_triggers | ON sched_name, trigger_name, trigger_group |
| sched_name | ON sched_name, job_name, job_group |
Foreign Keys
| qrtz_triggers_ibfk_1 | ( sched_name, job_name, job_group ) ref qrtz_job_details (sched_name, job_name, job_group) |

#### Table sys_dept

Indexes | Field Name | Data Type | Description
--- | --- | --- | ---
* | dept_id | int AUTOINCREMENT | 部门id
| parent_id | int DEFAULT 0 | 父部门id
| dept_name | varchar( 30 ) DEFAULT '' | 部门名称
| order_num | int DEFAULT 0 | 显示顺序
| leader | varchar( 20 ) DEFAULT '' | 负责人
| phone | varchar( 20 ) DEFAULT '' | 联系电话
| email | varchar( 20 ) DEFAULT '' | 邮箱
| status | int DEFAULT 0 | 部门状态:0正常,1停用
| create_by | varchar( 64 ) DEFAULT '' | 创建者
* | create_time | timestamp DEFAULT CURRENT_TIMESTAMP | 创建时间
| update_by | varchar( 64 ) DEFAULT '' | 更新者
* | update_time | timestamp DEFAULT '0000-00-00 00:00:00' | 更新时间
Indexes
| pk_sys_dept | ON dept_id |

#### Table sys_dict_data

Indexes | Field Name | Data Type | Description
--- | --- | --- | ---
* | dict_code | int AUTOINCREMENT | 字典编码
| dict_sort | int DEFAULT 0 | 字典排序
| dict_label | varchar( 100 ) DEFAULT '' | 字典标签
| dict_value | varchar( 100 ) DEFAULT '' | 字典键值
| dict_type | varchar( 100 ) DEFAULT '' | 字典类型
| status | int DEFAULT 0 | 状态（0正常 1禁用）
| create_by | varchar( 64 ) DEFAULT '' | 创建者
* | create_time | timestamp DEFAULT CURRENT_TIMESTAMP | 创建时间
| update_by | varchar( 64 ) DEFAULT '' | 更新者
* | update_time | timestamp DEFAULT '0000-00-00 00:00:00' | 更新时间
| remark | varchar( 500 ) DEFAULT '' | 备注
Indexes
| pk_sys_dict_data | ON dict_code |

#### Table sys_dict_type

Indexes | Field Name | Data Type | Description
--- | --- | --- | ---
* | dict_id | int AUTOINCREMENT | 字典主键
| dict_name | varchar( 100 ) DEFAULT '' | 字典名称
| dict_type | varchar( 100 ) DEFAULT '' | 字典类型
| status | int DEFAULT 0 | 状态（0正常 1禁用）
| create_by | varchar( 64 ) DEFAULT '' | 创建者
* | create_time | timestamp DEFAULT CURRENT_TIMESTAMP | 创建时间
| update_by | varchar( 64 ) DEFAULT '' | 更新者
* | update_time | timestamp DEFAULT '0000-00-00 00:00:00' | 更新时间
| remark | varchar( 500 ) DEFAULT '' | 备注
Indexes
| pk_sys_dict_type | ON dict_id |
| dict_type | ON dict_type |

#### Table sys_job

Indexes | Field Name | Data Type | Description
--- | --- | --- | ---
* | job_id | int AUTOINCREMENT | 任务ID
* | job_name | varchar( 64 ) DEFAULT '' | 任务名称
* | job_group | varchar( 64 ) DEFAULT '' | 任务组名
| method_name | varchar( 500 ) DEFAULT '' | 任务方法
| params | varchar( 200 ) DEFAULT '' | 方法参数
| cron_expression | varchar( 255 ) DEFAULT '' | cron执行表达式
| status | int DEFAULT 0 | 状态（0正常 1暂停）
| create_by | varchar( 64 ) DEFAULT '' | 创建者
* | create_time | timestamp DEFAULT CURRENT_TIMESTAMP | 创建时间
| update_by | varchar( 64 ) DEFAULT '' | 更新者
* | update_time | timestamp DEFAULT '0000-00-00 00:00:00' | 更新时间
| remark | varchar( 500 ) DEFAULT '' | 备注信息
Indexes
| pk_sys_job | ON job_id, job_name, job_group |

#### Table sys_job_log

Indexes | Field Name | Data Type | Description
--- | --- | --- | ---
* | job_log_id | int AUTOINCREMENT | 任务日志ID
* | job_name | varchar( 64 ) | 任务名称
* | job_group | varchar( 64 ) | 任务组名
| method_name | varchar( 500 ) | 任务方法
| params | varchar( 200 ) DEFAULT '' | 方法参数
| job_message | varchar( 500 ) | 日志信息
| is_exception | int DEFAULT 0 | 是否异常
| exception_info | text | 异常信息
* | create_time | timestamp DEFAULT CURRENT_TIMESTAMP | 创建时间
Indexes
| pk_sys_job_log | ON job_log_id |

#### Table sys_logininfor

Indexes | Field Name | Data Type | Description
--- | --- | --- | ---
* | info_id | int AUTOINCREMENT | 访问ID
| login_name | varchar( 50 ) DEFAULT '' | 登录账号
| ipaddr | varchar( 50 ) DEFAULT '' | 登录IP地址
| browser | varchar( 50 ) DEFAULT '' | 浏览器类型
| os | varchar( 50 ) DEFAULT '' | 操作系统
| status | int DEFAULT 0 | 登录状态 0成功 1失败
| msg | varchar( 255 ) DEFAULT '' | 提示消息
* | login_time | timestamp DEFAULT CURRENT_TIMESTAMP | 访问时间
Indexes
| pk_sys_logininfor | ON info_id |

#### Table sys_menu

Indexes | Field Name | Data Type | Description
--- | --- | --- | ---
* | menu_id | int AUTOINCREMENT | 菜单ID
* | menu_name | varchar( 50 ) | 菜单名称
| parent_id | int DEFAULT 0 | 父菜单ID
| order_num | int | 显示顺序
| url | varchar( 200 ) DEFAULT '' | 请求地址
| menu_type | char( 1 ) DEFAULT '' | 类型:M目录,C菜单,F按钮
| visible | int DEFAULT 0 | 菜单状态:0显示,1隐藏
| perms | varchar( 100 ) DEFAULT '' | 权限标识
| icon | varchar( 100 ) DEFAULT '' | 菜单图标
| create_by | varchar( 64 ) DEFAULT '' | 创建者
* | create_time | timestamp DEFAULT CURRENT_TIMESTAMP | 创建时间
| update_by | varchar( 64 ) DEFAULT '' | 更新者
* | update_time | timestamp DEFAULT '0000-00-00 00:00:00' | 更新时间
| remark | varchar( 500 ) DEFAULT '' | 备注
Indexes
| pk_sys_menu | ON menu_id |

#### Table sys_oper_log

Indexes | Field Name | Data Type | Description
--- | --- | --- | ---
* | oper_id | int AUTOINCREMENT | 日志主键
| title | varchar( 50 ) DEFAULT '' | 模块标题
| action | varchar( 100 ) DEFAULT '' | 功能请求
| method | varchar( 100 ) DEFAULT '' | 方法名称
| channel | varchar( 20 ) DEFAULT '' | 来源渠道
| login_name | varchar( 50 ) DEFAULT '' | 登录账号
| dept_name | varchar( 50 ) DEFAULT '' | 部门名称
| oper_url | varchar( 255 ) DEFAULT '' | 请求URL
| oper_ip | varchar( 30 ) DEFAULT '' | 主机地址
| oper_param | varchar( 255 ) DEFAULT '' | 请求参数
| status | int DEFAULT 0 | 操作状态 0正常 1异常
| error_msg | varchar( 2000 ) DEFAULT '' | 错误消息
* | oper_time | timestamp DEFAULT CURRENT_TIMESTAMP | 操作时间
Indexes
| pk_sys_oper_log | ON oper_id |

#### Table sys_post

Indexes | Field Name | Data Type | Description
--- | --- | --- | ---
* | post_id | int AUTOINCREMENT | 岗位ID
* | post_code | varchar( 64 ) | 岗位编码
* | post_name | varchar( 100 ) | 岗位名称
* | post_sort | int | 显示顺序
* | status | int | 状态（0正常 1停用）
| create_by | varchar( 64 ) DEFAULT '' | 创建者
* | create_time | timestamp DEFAULT CURRENT_TIMESTAMP | 创建时间
| update_by | varchar( 64 ) DEFAULT '' | 更新者
* | update_time | timestamp DEFAULT '0000-00-00 00:00:00' | 更新时间
| remark | varchar( 500 ) DEFAULT '' | 备注
Indexes
| pk_sys_post | ON post_id |

#### Table sys_role

Indexes | Field Name | Data Type | Description
--- | --- | --- | ---
* | role_id | int AUTOINCREMENT | 角色ID
* | role_name | varchar( 30 ) | 角色名称
* | role_key | varchar( 100 ) | 角色权限字符串
* | role_sort | int | 显示顺序
| status | int DEFAULT 0 | 角色状态:0正常,1禁用
| create_by | varchar( 64 ) DEFAULT '' | 创建者
* | create_time | timestamp DEFAULT CURRENT_TIMESTAMP | 创建时间
| update_by | varchar( 64 ) DEFAULT '' | 更新者
* | update_time | timestamp DEFAULT '0000-00-00 00:00:00' | 更新时间
| remark | varchar( 500 ) DEFAULT '' | 备注
Indexes
| pk_sys_role | ON role_id |

#### Table sys_role_menu

Indexes | Field Name | Data Type | Description
--- | --- | --- | ---
* | role_id | int | 角色ID
* | menu_id | int | 菜单ID
Indexes
| pk_sys_role_menu | ON role_id, menu_id |

#### Table sys_user

Indexes | Field Name | Data Type | Description
--- | --- | --- | ---
* | user_id | int AUTOINCREMENT | 用户ID
| dept_id | int | 部门ID
| login_name | varchar( 30 ) DEFAULT '' | 登录账号
| user_name | varchar( 30 ) DEFAULT '' | 用户昵称
| email | varchar( 100 ) DEFAULT '' | 用户邮箱
| phonenumber | varchar( 20 ) DEFAULT '' | 手机号码
| password | varchar( 100 ) DEFAULT '' | 密码
| salt | varchar( 100 ) DEFAULT '' | 盐加密
| user_type | char( 1 ) DEFAULT 'N' | 类型:Y默认用户,N非默认用户
| status | int DEFAULT 0 | 帐号状态:0正常,1禁用
| refuse_des | varchar( 500 ) DEFAULT '' | 拒绝登录描述
| create_by | varchar( 64 ) DEFAULT '' | 创建者
* | create_time | timestamp DEFAULT CURRENT_TIMESTAMP | 创建时间
| update_by | varchar( 64 ) DEFAULT '' | 更新者
* | update_time | timestamp DEFAULT '0000-00-00 00:00:00' | 更新时间
Indexes
| pk_sys_user | ON user_id |

#### Table sys_user_online

Indexes | Field Name | Data Type | Description
--- | --- | --- | ---
* | sessionId | varchar( 50 ) DEFAULT '' | 用户会话id
| login_name | varchar( 50 ) DEFAULT '' | 登录账号
| dept_name | varchar( 50 ) DEFAULT '' | 部门名称
| ipaddr | varchar( 50 ) DEFAULT '' | 登录IP地址
| browser | varchar( 50 ) DEFAULT '' | 浏览器类型
| os | varchar( 50 ) DEFAULT '' | 操作系统
| status | varchar( 10 ) DEFAULT '' | 在线状态on_line在线off_line离线
* | start_timestsamp | timestamp DEFAULT CURRENT_TIMESTAMP | session创建时间
* | last_access_time | timestamp DEFAULT '0000-00-00 00:00:00' | session最后访问时间
| expire_time | int DEFAULT 0 | 超时时间，单位为分钟
Indexes
| pk_sys_user_online | ON sessionId |

#### Table sys_user_post

Indexes | Field Name | Data Type | Description
--- | --- | --- | ---
* | user_id | varchar( 64 ) | 用户ID
* | post_id | varchar( 64 ) | 岗位ID
Indexes
| pk_sys_user_post | ON user_id, post_id |

#### Table sys_user_role

Indexes | Field Name | Data Type | Description
--- | --- | --- | ---
* | user_id | int | 用户ID
* | role_id | int | 角色ID
Indexes
| pk_sys_user_role | ON user_id, role_id |

Powered by DbSchema