/*
 Navicat Premium Dump SQL

 Source Server         : localhost
 Source Server Type    : PostgreSQL
 Source Server Version : 160008 (160008)
 Source Host           : localhost:5432
 Source Catalog        : auth_db
 Source Schema         : public

 Target Server Type    : PostgreSQL
 Target Server Version : 160008 (160008)
 File Encoding         : 65001

 Date: 16/07/2025 10:03:02
*/


-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS "public"."sys_user";
CREATE TABLE "public"."sys_user" (
  "id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "username" varchar(100) COLLATE "pg_catalog"."default",
  "realname" varchar(100) COLLATE "pg_catalog"."default",
  "password" varchar(255) COLLATE "pg_catalog"."default",
  "salt" varchar(45) COLLATE "pg_catalog"."default",
  "avatar" varchar(255) COLLATE "pg_catalog"."default",
  "birthday" date,
  "sex" int2,
  "email" varchar(45) COLLATE "pg_catalog"."default",
  "phone" varchar(45) COLLATE "pg_catalog"."default",
  "org_code" varchar(64) COLLATE "pg_catalog"."default",
  "status" int2,
  "del_flag" int2,
  "third_id" varchar(100) COLLATE "pg_catalog"."default",
  "third_type" varchar(100) COLLATE "pg_catalog"."default",
  "activiti_sync" int2,
  "work_no" varchar(100) COLLATE "pg_catalog"."default",
  "telephone" varchar(45) COLLATE "pg_catalog"."default",
  "create_by" varchar(32) COLLATE "pg_catalog"."default",
  "create_time" timestamp(6),
  "update_by" varchar(32) COLLATE "pg_catalog"."default",
  "update_time" timestamp(6),
  "user_identity" int2,
  "depart_ids" varchar(1000) COLLATE "pg_catalog"."default",
  "client_id" varchar(64) COLLATE "pg_catalog"."default",
  "login_tenant_id" int4,
  "bpm_status" varchar(2) COLLATE "pg_catalog"."default"
)
;
COMMENT ON COLUMN "public"."sys_user"."id" IS '主键id';
COMMENT ON COLUMN "public"."sys_user"."username" IS '登录账号';
COMMENT ON COLUMN "public"."sys_user"."realname" IS '真实姓名';
COMMENT ON COLUMN "public"."sys_user"."password" IS '密码';
COMMENT ON COLUMN "public"."sys_user"."salt" IS 'md5密码盐';
COMMENT ON COLUMN "public"."sys_user"."avatar" IS '头像';
COMMENT ON COLUMN "public"."sys_user"."birthday" IS '生日';
COMMENT ON COLUMN "public"."sys_user"."sex" IS '性别(0-默认未知,1-男,2-女)';
COMMENT ON COLUMN "public"."sys_user"."email" IS '电子邮件';
COMMENT ON COLUMN "public"."sys_user"."phone" IS '电话';
COMMENT ON COLUMN "public"."sys_user"."org_code" IS '登录会话的机构编码';
COMMENT ON COLUMN "public"."sys_user"."status" IS '性别(1-正常,2-冻结)';
COMMENT ON COLUMN "public"."sys_user"."del_flag" IS '删除状态(0-正常,1-已删除)';
COMMENT ON COLUMN "public"."sys_user"."third_id" IS '第三方登录的唯一标识';
COMMENT ON COLUMN "public"."sys_user"."third_type" IS '第三方类型';
COMMENT ON COLUMN "public"."sys_user"."activiti_sync" IS '同步工作流引擎(1-同步,0-不同步)';
COMMENT ON COLUMN "public"."sys_user"."work_no" IS '工号，唯一键';
COMMENT ON COLUMN "public"."sys_user"."telephone" IS '座机号';
COMMENT ON COLUMN "public"."sys_user"."create_by" IS '创建人';
COMMENT ON COLUMN "public"."sys_user"."create_time" IS '创建时间';
COMMENT ON COLUMN "public"."sys_user"."update_by" IS '更新人';
COMMENT ON COLUMN "public"."sys_user"."update_time" IS '更新时间';
COMMENT ON COLUMN "public"."sys_user"."user_identity" IS '身份（1普通成员 2上级）';
COMMENT ON COLUMN "public"."sys_user"."depart_ids" IS '负责部门';
COMMENT ON COLUMN "public"."sys_user"."client_id" IS '设备ID';
COMMENT ON COLUMN "public"."sys_user"."login_tenant_id" IS '上次登录选择租户ID';
COMMENT ON COLUMN "public"."sys_user"."bpm_status" IS '流程入职离职状态';
COMMENT ON TABLE "public"."sys_user" IS '用户表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO "public"."sys_user" VALUES ('1714471285016895490', 'ceshi', '测试用户', 'a9932bb12d2cbc5a', 'AF4vhXUz', NULL, '2024-04-11', NULL, 'winter@jeecg.org', '15201111112', NULL, 1, 0, NULL, NULL, 1, '123', NULL, 'admin', '2023-10-18 10:39:42', 'ceshi', '2025-05-08 16:11:05', 1, '', NULL, 0, NULL);
INSERT INTO "public"."sys_user" VALUES ('3d464b4ea0d2491aab8a7bde74c57e95', 'zhangsan', '张三', '02ea098224c7d0d2077c14b9a3a1ed16', 'x5xRdeKB', 'https://static.jeecg.com/temp/jmlogo_1606575041993.png', '2024-04-11', NULL, '111@1.com', '13426411111', '财务部', 1, 0, NULL, NULL, 1, '0005', NULL, 'admin', '2020-05-14 21:26:24', 'admin', '2024-04-26 13:25:37', 1, '', NULL, NULL, NULL);
INSERT INTO "public"."sys_user" VALUES ('a75d45a015c44384a04449ee80dc3503', 'jeecg', 'jeecg', 'eee378a1258530cb', 'mIgiYJow', 'https://static.jeecg.com/temp/国炬软件logo_1606575029126.png', NULL, 1, '418799587@qq.com', '18611788525', 'A02A01', 1, 0, NULL, NULL, 1, '00002', NULL, 'admin', '2019-02-13 16:02:36', 'admin', '2023-10-18 13:51:36', 1, '', NULL, 1001, NULL);
INSERT INTO "public"."sys_user" VALUES ('e9ca23d68d884d4ebb19d07889727dae', 'admin', '管理员', 'cb362cfeefbf3d8d', 'RCGTeGiH', 'https://static.jeecg.com/temp/国炬软件logo_1606575029126.png', '1986-02-01', 1, 'jeecg@163.com', '18611111111', 'A01', 1, 0, NULL, NULL, 1, '00001', NULL, NULL, '2019-06-21 17:54:10', 'admin', '2025-05-19 16:06:43', 2, '', NULL, 0, NULL);
