Appearance
岗位管理
| sys_post | 岗位表 |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| id | bigint(20) | (NULL) | NO | PRI | (NULL) | 主键id | ||
| merchant_no | varchar(20) | utf8_general_ci | YES | (NULL) | 商户号 | |||
| post_code | varchar(50) | utf8mb4_unicode_ci | YES | (NULL) | 岗位编码 | |||
| post_name | varchar(50) | utf8mb4_unicode_ci | YES | (NULL) | 岗位名称 | |||
| post_sort | int(6) | (NULL) | YES | (NULL) | 排序 | |||
| status | tinyint(4) | (NULL) | YES | 1 | 状态（1正常 2停用） | |||
| creator | bigint(20) | (NULL) | YES | (NULL) | 创建人 | |||
| create_time | datetime | (NULL) | YES | (NULL) | 创建时间 | |||
| updater | bigint(20) | (NULL) | YES | (NULL) | 更新人 | |||
| update_time | datetime | (NULL) | YES | (NULL) | 更新时间 | |||
| del_flag | tinyint(4) | (NULL) | YES | 1 | 删除标记 1未删除 2已删除 |
| sys_user_post | 用户岗位关联表 |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| id | bigint(20) | (NULL) | NO | PRI | (NULL) | 主键id | ||
| merchant_no | varchar(20) | utf8_general_ci | YES | (NULL) | 商户号 | |||
| user_id | bigint(20) | (NULL) | YES | (NULL) | 用户id | |||
| post_id | bigint(20) | (NULL) | YES | (NULL) | 岗位id | |||
| creator | bigint(20) | (NULL) | YES | (NULL) | 创建人 | |||
| create_time | datetime | (NULL) | YES | (NULL) | 创建时间 | |||
| updater | bigint(20) | (NULL) | YES | (NULL) | 更新人 | |||
| update_time | datetime | (NULL) | YES | (NULL) | 更新时间 | |||
| del_flag | tinyint(4) | (NULL) | YES | 1 | 删除标记 1未删除 2已删除 |