MySQL to Kingbase8.6.0 Table Conversion: t_iam_dept_txl

CREATE TABLE t_iam_dept_txl ("ID" varchar(32) COLLATE "pg_catalog"."default" NOT NULL COMMENT '主键UUID',"SERIAL_NUMBER" int4 NULL DEFAULT NULL COMMENT '主键UUID',"DEPT_CODE" varchar(255) COLLATE "pg_catalog"."default" NULL DEFAULT ''::character varying COMMENT '部门编码',"DEPT_NAME" varchar(255) COLLATE "pg_catalog"."default" NULL DEFAULT ''::character varying COMMENT '部门名称',"PARENT_ID" varchar(32) COLLATE "pg_catalog"."default" NULL DEFAULT '0'::character varying COMMENT '父级ID',"PARENT_NAME" varchar(255) COLLATE "pg_catalog"."default" NULL DEFAULT ''::character varying COMMENT '上级部门名称',"CORP_ID" varchar(32) COLLATE "pg_catalog"."default" NULL DEFAULT NULL::character varying COMMENT '所属单位ID（非空，自己为公司时存自身ID）',"CORP_NAME" varchar(255) COLLATE "pg_catalog"."default" NULL DEFAULT ''::character varying COMMENT '所属公司名称',"LEVEL_CODE" varchar(255) COLLATE "pg_catalog"."default" NULL DEFAULT ''::character varying COMMENT '部门层级编码',"LEVEL" int4 NULL DEFAULT 0 COMMENT '部门层级',"IS_CORP" int4 NULL DEFAULT 0 COMMENT '是否是公司(0：否1：是)',"HAS_CHILD" int4 NULL DEFAULT 1 COMMENT '是否有子(0：否；1：是)',"STATUS" int2 NULL DEFAULT 1 COMMENT '部门状态(1:正常；2：停用)',"IS_DELETE" int4 NULL DEFAULT 0 COMMENT '是否删除(0:否;1：是)',"ORGMANAGERID" varchar(32) COLLATE "pg_catalog"."default" NULL DEFAULT NULL::character varying COMMENT '正职领导ID',"SHOW_NUMBER" varchar(64) COLLATE "pg_catalog"."default" NULL DEFAULT '10'::character varying COMMENT '排序序列号',"CREATE_TIME" int8 NULL DEFAULT NULL COMMENT '创建时间',"UPDATE_TIME" int8 NULL DEFAULT NULL COMMENT '更新时间',"UNI_CODE" varchar(64) COLLATE "pg_catalog"."default" NULL DEFAULT ''::character varying COMMENT '外部系统唯一标识',"TMP1" varchar(255) COLLATE "pg_catalog"."default" NULL DEFAULT NULL::character varying,"TMP2" varchar(255) COLLATE "pg_catalog"."default" NULL DEFAULT NULL::character varying,"TMP3" varchar(255) COLLATE "pg_catalog"."default" NULL DEFAULT NULL::character varying,"TMP4" varchar(255) COLLATE "pg_catalog"."default" NULL DEFAULT NULL::character varying,"TMP5" varchar(255) COLLATE "pg_catalog"."default" NULL DEFAULT NULL::character varying,"TMP6" varchar(255) COLLATE "pg_catalog"."default" NULL DEFAULT NULL::character varying,"TMP7" varchar(255) COLLATE "pg_catalog"."default" NULL DEFAULT NULL::character varying,"TMP8" varchar(255) COLLATE "pg_catalog"."default" NULL DEFAULT NULL::character varying,"TMP9" varchar(255) COLLATE "pg_catalog"."default" NULL DEFAULT NULL::character varying,"TMP10" varchar(255) COLLATE "pg_catalog"."default" NULL DEFAULT NULL::character varying,"TMP11" bytea NULL,"TMP12" bytea NULL,"TMP13" bytea NULL,"TMP14" bytea NULL,"TMP15" bytea NULL,"TMP16" text COLLATE "pg_catalog"."default" NULL,"TMP17" text COLLATE "pg_catalog"."default" NULL,"TMP18" text COLLATE "pg_catalog"."default" NULL,"TMP19" text COLLATE "pg_catalog"."default" NULL,"TMP20" text COLLATE "pg_catalog"."default" NULL,"BO_ID" varchar(32) COLLATE "pg_catalog"."default" NULL DEFAULT 'v0'::character varying COMMENT '数据源id或者业务组织id',"BO_UNICODE" varchar(32) COLLATE "pg_catalog"."default" NULL DEFAULT NULL::character varying COMMENT '业务组向下同步织唯一编码',"DS_DEPT_ID" varchar(32) COLLATE "pg_catalog"."default" NULL DEFAULT NULL::character varying COMMENT '数据源的IamUserDeptRel类id,:用于业务组织用户关联数据源(ds)用户 ',"IS_SHOW" int2 NULL DEFAULT NULL COMMENT '是否展示',"DEPT_FULL_NAME" varchar(255) COLLATE "pg_catalog"."default" NULL DEFAULT NULL::character varying COMMENT '部门全称',PRIMARY KEY ("ID"),INDEX "SERIAL_NUMBER"("SERIAL_NUMBER"))WITH (OIDS = FALSE)TABLESPACE pg_default;ALTER TABLE t_iam_dept_txlOWNER to postgres;