programs_info/胡埭市场主体两张清单/ods检查数据/ods_007_sys_user.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 2.24.2.5
 Source Server Type    : PostgreSQL
 Source Server Version : 140017
 Source Host           : 2.24.2.5:5433
 Source Catalog        : postgres
 Source Schema         : public

 Target Server Type    : PostgreSQL
 Target Server Version : 140017
 File Encoding         : 65001

 Date: 28/03/2025 14:23:17
*/


-- ----------------------------
-- Table structure for ods_007_sys_user
-- ----------------------------
DROP TABLE IF EXISTS "public"."ods_007_sys_user";
CREATE TABLE "public"."ods_007_sys_user" (
  "id" varchar(60) COLLATE "pg_catalog"."default" NOT NULL,
  "create_user" varchar(50) COLLATE "pg_catalog"."default",
  "create_time" timestamp(6),
  "update_user" varchar(50) COLLATE "pg_catalog"."default",
  "update_time" timestamp(6),
  "order_num" int8,
  "del_flag" varchar(8) COLLATE "pg_catalog"."default",
  "username" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
  "password" varchar(100) COLLATE "pg_catalog"."default",
  "salt" varchar(20) COLLATE "pg_catalog"."default",
  "card_id" varchar(60) COLLATE "pg_catalog"."default",
  "email" varchar(100) COLLATE "pg_catalog"."default",
  "mobile" varchar(100) COLLATE "pg_catalog"."default",
  "status" int2,
  "dept_id" varchar(60) COLLATE "pg_catalog"."default",
  "nick_name" varchar(45) COLLATE "pg_catalog"."default",
  "position" varchar(45) COLLATE "pg_catalog"."default",
  "is_admin" int2,
  "login_time" timestamp(6),
  "error_num" int4,
  "is_lock" char(4) COLLATE "pg_catalog"."default",
  "token" varchar(50) COLLATE "pg_catalog"."default",
  "expire_time" timestamp(6),
  "identity_card" varchar(100) COLLATE "pg_catalog"."default",
  "dept_code" varchar(60) COLLATE "pg_catalog"."default",
  "fzjg" varchar(255) COLLATE "pg_catalog"."default",
  "sex_code" varchar(255) COLLATE "pg_catalog"."default",
  "ssztqc" varchar(255) COLLATE "pg_catalog"."default",
  "professional_name" varchar(255) COLLATE "pg_catalog"."default",
  "professional_rank_code" varchar(255) COLLATE "pg_catalog"."default",
  "nation_code" varchar(255) COLLATE "pg_catalog"."default",
  "highest_education_code" varchar(255) COLLATE "pg_catalog"."default",
  "profession" varchar(255) COLLATE "pg_catalog"."default",
  "personnel_nature_code" varchar(255) COLLATE "pg_catalog"."default",
  "is_jdry" varchar(255) COLLATE "pg_catalog"."default",
  "is_flzyzg" varchar(255) COLLATE "pg_catalog"."default",
  "is_wt" varchar(255) COLLATE "pg_catalog"."default",
  "is_sq" varchar(255) COLLATE "pg_catalog"."default",
  "need_psw_upt" int4,
  "is_completion" varchar(100) COLLATE "pg_catalog"."default",
  "serial_id" varchar(200) COLLATE "pg_catalog"."default",
  "sign_name" varchar(100) COLLATE "pg_catalog"."default",
  "pic_id" varchar(60) COLLATE "pg_catalog"."default",
  "face_id" text COLLATE "pg_catalog"."default",
  "fingerprint_id" text COLLATE "pg_catalog"."default",
  "zylb" varchar(20) COLLATE "pg_catalog"."default",
  "last_upt_psw_time" timestamp(6),
  "is_syn_data" int4,
  "improve_type" varchar(20) COLLATE "pg_catalog"."default",
  "INSERT_DATA_TIMESTAMP" timestamp(6)
)
;
COMMENT ON COLUMN "public"."ods_007_sys_user"."create_user" IS '创建人';
COMMENT ON COLUMN "public"."ods_007_sys_user"."create_time" IS '创建时间';
COMMENT ON COLUMN "public"."ods_007_sys_user"."update_user" IS '更新人';
COMMENT ON COLUMN "public"."ods_007_sys_user"."update_time" IS '最后修改时间';
COMMENT ON COLUMN "public"."ods_007_sys_user"."order_num" IS '状态  0：禁用   1：正常';
COMMENT ON COLUMN "public"."ods_007_sys_user"."del_flag" IS '删除标记  0 正常 -1 不正常';
COMMENT ON COLUMN "public"."ods_007_sys_user"."username" IS '用户名';
COMMENT ON COLUMN "public"."ods_007_sys_user"."password" IS '密码';
COMMENT ON COLUMN "public"."ods_007_sys_user"."salt" IS '盐';
COMMENT ON COLUMN "public"."ods_007_sys_user"."card_id" IS '证件号';
COMMENT ON COLUMN "public"."ods_007_sys_user"."email" IS '邮箱';
COMMENT ON COLUMN "public"."ods_007_sys_user"."mobile" IS '手机号';
COMMENT ON COLUMN "public"."ods_007_sys_user"."status" IS '状态  0：禁用   1：正常';
COMMENT ON COLUMN "public"."ods_007_sys_user"."dept_id" IS '部门ID';
COMMENT ON COLUMN "public"."ods_007_sys_user"."nick_name" IS '姓名';
COMMENT ON COLUMN "public"."ods_007_sys_user"."position" IS '职位';
COMMENT ON COLUMN "public"."ods_007_sys_user"."is_admin" IS '是否是管理员 1-是 0-否';
COMMENT ON COLUMN "public"."ods_007_sys_user"."login_time" IS '登陆时间';
COMMENT ON COLUMN "public"."ods_007_sys_user"."error_num" IS '登陆次数';
COMMENT ON COLUMN "public"."ods_007_sys_user"."is_lock" IS '是否锁定';
COMMENT ON COLUMN "public"."ods_007_sys_user"."token" IS '用户token';
COMMENT ON COLUMN "public"."ods_007_sys_user"."expire_time" IS '过期时间';
COMMENT ON COLUMN "public"."ods_007_sys_user"."identity_card" IS '身份证';
COMMENT ON COLUMN "public"."ods_007_sys_user"."dept_code" IS '部门code';
COMMENT ON COLUMN "public"."ods_007_sys_user"."fzjg" IS '发证机关';
COMMENT ON COLUMN "public"."ods_007_sys_user"."sex_code" IS '性别';
COMMENT ON COLUMN "public"."ods_007_sys_user"."ssztqc" IS '所属部门全称';
COMMENT ON COLUMN "public"."ods_007_sys_user"."professional_name" IS '职称';
COMMENT ON COLUMN "public"."ods_007_sys_user"."professional_rank_code" IS '职级';
COMMENT ON COLUMN "public"."ods_007_sys_user"."nation_code" IS '民族';
COMMENT ON COLUMN "public"."ods_007_sys_user"."highest_education_code" IS '最高学历';
COMMENT ON COLUMN "public"."ods_007_sys_user"."profession" IS '专业';
COMMENT ON COLUMN "public"."ods_007_sys_user"."personnel_nature_code" IS '人员性质';
COMMENT ON COLUMN "public"."ods_007_sys_user"."is_jdry" IS '是否监督人员（1是0否）';
COMMENT ON COLUMN "public"."ods_007_sys_user"."is_flzyzg" IS '是否具有法律职业资格（1是 0 否）';
COMMENT ON COLUMN "public"."ods_007_sys_user"."is_wt" IS '是否具有法律职业资格（1是 0 否）';
COMMENT ON COLUMN "public"."ods_007_sys_user"."is_sq" IS '是否授权（1是 0 否）';
COMMENT ON COLUMN "public"."ods_007_sys_user"."need_psw_upt" IS '是否需要密码修改（0 需要  1不需要)';
COMMENT ON COLUMN "public"."ods_007_sys_user"."is_completion" IS '是否补全（1是 0 否）';
COMMENT ON COLUMN "public"."ods_007_sys_user"."pic_id" IS '头像';
COMMENT ON COLUMN "public"."ods_007_sys_user"."face_id" IS '面容id';
COMMENT ON COLUMN "public"."ods_007_sys_user"."fingerprint_id" IS '指纹';
COMMENT ON COLUMN "public"."ods_007_sys_user"."zylb" IS '专业类别';
COMMENT ON COLUMN "public"."ods_007_sys_user"."last_upt_psw_time" IS '最后一次修改密码的时间 ';
COMMENT ON COLUMN "public"."ods_007_sys_user"."is_syn_data" IS '大数据数据同步 0 否 1 是';
COMMENT ON COLUMN "public"."ods_007_sys_user"."improve_type" IS '数据导入类型，是否是本系统生成的数据 默认0 ';
COMMENT ON TABLE "public"."ods_007_sys_user" IS '系统用户';

-- ----------------------------
-- Records of ods_007_sys_user
-- ----------------------------
INSERT INTO "public"."ods_007_sys_user" VALUES ('1108623568066846721', NULL, '2019-03-21 14:57:11', '1030293251357044737', '2024-04-11 14:45:39', 1, '0', 'daiguoquan', 'DDJI0Dm7Feuuu29iU3ex', 'DDJI0Dm7Feuuu29iU3ex', 'JSZF02063945', NULL, '18068285633', 0, '1002768486673940482', '戴国权', '中队长', 0, '2022-01-26 16:30:15', 0, '1   ', NULL, NULL, '350104197004200130', '320211090000', '无锡市滨湖区人民政府', '1', '无锡市滨湖区胡埭镇人民政府', '副局长', '21', '1', '21', '行政管理', '03', '1', '1', '0', '1', 0, '1', NULL, NULL, NULL, NULL, NULL, '安全生产类-安全工程', '2021-06-09 14:32:31', 0, '0', '2025-03-27 21:55:47');
INSERT INTO "public"."ods_007_sys_user" VALUES ('1108623802767515649', NULL, '2019-03-21 14:58:06', '1030293251357044737', '2024-04-11 14:45:39', 2, '0', 'jinyong', 'e6ae6a334c16801bbb2e061a0934d8504b624143325ff828736cb1ec08a96cbb', 'DDJI0Dm7Feuuu29iU3ex', 'JSZF02063969', NULL, '13814229997', 0, '1002768486673940482', '金勇', '副中队长', 0, '2022-04-26 19:22:13', 0, '1   ', NULL, NULL, '360103197804102212', '320211090000', '无锡市滨湖区人民政府', '1', '滨湖区应急管理局', '公务员', '20', '1', '21', '指挥与管理', '01', '0', '1', '0', '1', 0, '1', NULL, NULL, NULL, NULL, NULL, '其他类', '2021-06-09 14:27:12', 0, '0', '2025-03-27 21:55:47');
INSERT INTO "public"."ods_007_sys_user" VALUES ('1108624023077527553', NULL, '2019-03-21 14:58:59', '1030289598793543681', '2025-03-26 09:47:40', 4, '0', 'zhangqi', '3322d756e23f47b4ef9ac0f8208099061b762a593ce3d0394ea56bc81d10a301', 'qTN2IrilV8xyUNjQlFUC', '10020397039', NULL, '18068285138', 1, '1002768486673940482', '张祺', '副中队长', 0, '2025-03-26 09:47:40', 0, '1   ', NULL, NULL, '320202198408140010', '320211090000', '滨湖区人民政府', '1', '无锡市滨湖区胡埭镇人民政府', '无', '21', '1', '21', '安全工程', '03', '1', '1', '0', '1', 1, '1', NULL, NULL, NULL, NULL, NULL, '安全生产类-安全工程', '2022-07-22 09:21:04', 0, '0', '2025-03-27 21:55:47');
INSERT INTO "public"."ods_007_sys_user" VALUES ('1108624293882765314', NULL, '2019-03-21 15:00:04', '1030289598793543681', '2025-03-13 10:06:04', 10, '0', 'zhouxu', 'f50e5e97fae359b5a07268daa443aaedc1884439f04749166fce1556d308be44', '2ij9FxKT5K034e0rs5bC', '10020397033', NULL, '18068285338', 1, '1002768486673940482', '周勖', '科员', 0, '2025-03-13 10:06:04', 0, '1   ', NULL, NULL, '320282199502204734', '320211090000', '滨湖区人民政府', '1', '无锡市滨湖区胡埭镇人民政府', '管理九级', '0', '1', '14', '无机化学', '03', '1', '1', '0', '1', 1, '1', NULL, NULL, NULL, NULL, NULL, '化学工程类-化学工程其他类', '2022-07-22 09:05:45', 0, '0', '2025-03-27 21:55:47');
INSERT INTO "public"."ods_007_sys_user" VALUES ('1164434523501490177', NULL, '2019-08-22 15:09:59', '1040490128264482817', '2024-04-11 14:45:39', 5, '0', 'xujun', '0c380313d08d6da1f34de97e7be04f0b9294ef7fa2f260f5dc1956d8dddf8a45', 'VRvxI8v2mTVcZo8K58xK', '10020397036', NULL, '18068286538', 0, '1002768486673940482', '许珺', '副中队长', 0, '2023-07-17 15:08:58', 0, '1   ', NULL, NULL, '320203199004170329', '320211090000', '滨湖区人民政府', '2', '无锡市滨湖区胡埭镇人民政府', '无', '21', '1', '21', '安全工程', '03', '1', '1', '0', '1', 1, '1', NULL, NULL, NULL, NULL, NULL, '安全生产类-安全工程', '2023-07-17 15:08:46', 0, '0', '2025-03-27 21:55:47');
INSERT INTO "public"."ods_007_sys_user" VALUES ('USER320200335399333673308160', '996683071453937665', '2020-08-12 12:37:14', '1040490128264482817', '2024-04-11 14:45:39', 8, '0', 'shenxian', '8c9ac6b85c4aec8d96a0dde23a72e131cb582167b8942cd3bfa86988a2e95684', 'Z5qHyno7o7aueeMbwGmy', 'JSZF02060393', '', '18068285955', 0, '1002768486673940482', '沈显', '科员', 0, '2023-07-19 09:49:59', 0, '1   ', '1', NULL, '341002198809091671', '320211090000', '江阴市司法局', '1', '无锡市滨湖区应急管理局', '无', '0', '1', '21', '资源环境与城乡规划管理', '03', '1', '1', '1', '1', 0, '1', NULL, NULL, NULL, NULL, NULL, '其他类', '2022-07-22 09:06:02', 0, '0', '2025-03-27 21:55:47');
INSERT INTO "public"."ods_007_sys_user" VALUES ('USER320200568467475931336704', '1030293251357044737', '2022-05-17 16:06:49', '1032459208328597505', '2025-03-27 08:53:52', 9999, '0', 'feilin', 'd41d986a2b419b4167851c15dcc5af1d3b352fca9f4dc78a17ba0d78334fc650', 'FFqf5TworUUfz9VGQWVL', '10020397026', '', '18068286233', 1, '1002768486673940482', '费琳', '科员', 0, '2025-03-27 08:53:52', 0, '1   ', '1', NULL, '320201198908053021', '320211090000', '滨湖区人民政府', '2', '无锡市滨湖区应急管理局', '无', '21', '1', '21', '统计学', '03', '1', '1', '0', '1', 1, '1', NULL, NULL, NULL, NULL, NULL, '其他类', '2022-07-25 09:30:37', 0, '0', '2025-03-27 21:55:47');
INSERT INTO "public"."ods_007_sys_user" VALUES ('USER320200570625014768865280', 'USER320200384017288099008512', '2022-05-23 15:00:06', '1', '2025-03-27 11:06:55', 9999, '0', 'liuxingchen', '825cdad7dbbc7f7341427e39f51758fad3acabf7c45d4b767e1cd9aa2d293155', 'hrNsu2YYmTNPf4H1pAay', '10020397042', '', '18068285765', 1, '1002768486673940482', '刘星辰', '科员', 0, '2025-03-27 11:06:55', 0, '1   ', '1', NULL, '320212199707120519', '320211090000', '无锡市滨湖区司法局', '1', '无锡市滨湖区应急管理局', '职称', '0', '1', '21', '建筑电气与智能化', '03', '1', '1', '0', '1', 1, '1', NULL, NULL, NULL, NULL, NULL, '其他类', '2022-07-22 09:04:47', 0, '0', '2025-03-27 21:55:47');
INSERT INTO "public"."ods_007_sys_user" VALUES ('USER320200591194130105765888', 'USER320200384017288099008512', '2022-07-19 09:14:25', '1030289598793543681', '2024-12-09 15:58:27', 4, '0', 'huajianjun', 'd03822a7676e611cd2f985b9b1e12cff4967595cc35f43a282e47ecae2ca96c8', '6X33qN8xV8cib1UgN0sA', '10020324005', '', '13196557550', 1, '1002768486673940482', '华建军', '区安委办副主任', 0, '2024-07-15 15:42:56', 0, '1   ', '1', NULL, '32021119830801251X', '320211090000', '无锡市滨湖区政府', '1', '无锡市滨湖区应急管理局', '无', '10', '1', '14', '检测技术与自动化装置', '01', '1', '1', '1', '1', 1, '1', NULL, NULL, NULL, NULL, NULL, '机械电气类-自动化', '2022-08-06 11:39:39', 0, '0', '2025-03-27 21:55:47');
INSERT INTO "public"."ods_007_sys_user" VALUES ('USER320200635419133365719040', 'USER320200384017288099008512', '2022-11-18 10:08:48', '1030289598793543681', '2024-04-11 14:45:39', 9999, '0', 'zhaoyilin', 'a96642dfe028f298596f08cb54e641c0b26afa98c899e3132d44c292e4555049', 'pDEMCPv6JcVwHFsLCb8G', '10020397025', '', '17826101062', 0, '1002768486673940482', '赵一霖', '副中队长', 0, '2023-11-01 10:46:33', 0, '1   ', '1', NULL, '370683198808026865', '320211090000', '无锡市滨湖区人民政府', '2', '无锡市滨湖区应急管理局', '无', '0', '1', '14', '食品工程', '03', '1', '1', '1', '1', 1, '1', NULL, NULL, NULL, NULL, NULL, '其他类', '2022-11-21 09:55:09', 0, '0', '2025-03-27 21:55:47');
INSERT INTO "public"."ods_007_sys_user" VALUES ('USER320200635488148930957312', 'USER320200384017288099008512', '2022-11-18 14:43:03', '1030289598793543681', '2024-04-11 14:45:39', 9999, '0', 'luoxi', '07203a24dc7c53d8d68686fdb4d1eebeaca9af00901f859189de64e8a1c0caeb', 'KDK5rgVe3H0bnSNeiEap', '10020397032', '', '18068286278', 0, '1002768486673940482', '罗熙', '科员', 0, '2023-11-01 10:46:20', 0, '1   ', '1', NULL, '362401199410224916', '320211090000', '无锡市滨湖区人民政府', '1', '无锡市滨湖区应急管理局', '无', '0', '1', '14', '中文', '03', '1', '1', '1', '1', 1, '1', NULL, NULL, NULL, NULL, NULL, '其他类', '2022-11-21 09:57:43', 0, '0', '2025-03-27 21:55:47');
INSERT INTO "public"."ods_007_sys_user" VALUES ('USER320200740652311688253440', '1', '2023-09-04 19:27:53', 'USER320200740652311688253440', '2025-03-27 10:36:25', 9999, '0', 'yuanyi95', '08eb2400fa1c9cb24916ea3df303806e47f2b5c65bb8921e006dacbc333e3524', 'IqtJfIh8eCof5ju2IRfk', '10999997295', '', '18012462985', 1, '1002768486673940482', '袁逸', '科员', 0, '2025-03-27 10:36:25', 0, '1   ', '1', NULL, '320212199911040516', '320211090000', '滨湖区人民政府', '1', '无锡市滨湖区应急管理局', '管理九级', '0', '1', '21', '法学', '03', '1', '1', '1', '1', 1, '1', NULL, NULL, NULL, NULL, NULL, '法律类', '2023-09-05 09:11:05', 0, '0', '2025-03-27 21:55:47');
INSERT INTO "public"."ods_007_sys_user" VALUES ('USER320200938494984280084480', '1', '2025-03-03 18:04:02', 'USER320200938494984280084480', '2025-03-24 14:31:59', 9999, '0', 'xuyitong', '59ee6f5c8ebfbac55eae08c4100843f7d1c300d197dfe9e31755e6bee645e428', '9CvKFYIzy3ThRIpT6CRx', '10020397054', '', '13858039196', 1, '1002768486673940482', '徐意童', '科员', 0, '2025-03-24 14:31:59', 0, '1   ', '1', NULL, '320282200009062571', '320211090000', '无锡市滨湖区司法局', '1', '无锡市滨湖区应急管理局', '管理九级', '21', '1', '21', '经济学', '03', '1', '1', '0', '1', 1, '1', NULL, NULL, NULL, NULL, NULL, '其他类', '2025-03-05 09:27:00', 0, '0', '2025-03-27 21:55:47');
INSERT INTO "public"."ods_007_sys_user" VALUES ('USER320200938495403576266752', '1', '2025-03-03 18:05:42', 'USER320200938495403576266752', '2025-03-26 11:25:31', 9999, '0', 'zhuqiutan', 'f398e1987d4c7fe14c325654320f11e46dcf40ef65c5a54781486a2ef7f0ca11', 'dkzzhLNW6O5u7Uah5BAL', '10020397053', '', '17706732282', 1, '1002768486673940482', '朱秋潭', '科员', 0, '2025-03-26 11:25:31', 0, '1   ', '1', NULL, '320982199809250039', '320211090000', '滨湖区人民政府', '1', '无锡市滨湖区应急管理局', '管理九级', '0', '1', '21', '财务管理', '03', '1', '1', '1', '1', 1, '1', NULL, NULL, NULL, NULL, NULL, '其他类', '2025-03-05 09:13:04', 0, '0', '2025-03-27 21:55:47');

-- ----------------------------
-- Indexes structure for table ods_007_sys_user
-- ----------------------------
CREATE INDEX "
username" ON "public"."ods_007_sys_user" USING btree (
  "username" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "card_id" ON "public"."ods_007_sys_user" USING btree (
  "card_id" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);