rkz_fy-master/02-script/sql/V1.1__20240725_createOrgIm.sql

CREATE TABLE "org_im"(
    "id"          BIGINT        NOT NULL,
    "im_id"       VARCHAR(64)   NOT NULL,
    "minto_id"    VARCHAR(64)   NOT NULL,
    "type"        VARCHAR(64)   NOT NULL,
    "create_time" TIMESTAMP     NOT NULL,
    "update_time" TIMESTAMP     NOT NULL,
    CONSTRAINT    "org_im_pkey" NOT CLUSTER PRIMARY KEY ("id")
);
COMMENT ON COLUMN "org_im"."im_id"  IS  'IM系统内的数据id';
COMMENT ON COLUMN "org_im"."minto_id" IS '系统内的数据id';
COMMENT ON COLUMN "org_im"."type" IS '类型';
COMMENT ON COLUMN "org_im"."create_time" IS '创建时间';
COMMENT ON COLUMN "org_im"."update_time" IS '更新时间';