-- ----------------------------
-- Table structure for srm_supplier
-- ----------------------------
DROP TABLE IF EXISTS "public"."srm_supplier";
CREATE TABLE "public"."srm_supplier" (
    "id"           VARCHAR(36) COLLATE "pg_catalog"."default"  NOT NULL PRIMARY KEY,
    "name"         VARCHAR(128) COLLATE "pg_catalog"."default" NOT NULL,
    "person"       VARCHAR(64) COLLATE "pg_catalog"."default",
    "phone"        VARCHAR(64) COLLATE "pg_catalog"."default",
    "address"      VARCHAR(128) COLLATE "pg_catalog"."default",
    "type"         VARCHAR(64) COLLATE "pg_catalog"."default",
    "mark"         VARCHAR(64) COLLATE "pg_catalog"."default",
    "remark"       VARCHAR(256) COLLATE "pg_catalog"."default",
    "image"        TEXT COLLATE "pg_catalog"."default",
    "product"      TEXT COLLATE "pg_catalog"."default",
    "state"        int4,
    "ext1"         VARCHAR(1024) COLLATE "pg_catalog"."default",
    "ext2"         VARCHAR(1024) COLLATE "pg_catalog"."default",
    "ext3"         TEXT COLLATE "pg_catalog"."default",
    "gmt_create"   TIMESTAMP(3)                                NOT NULL,
    "gmt_modified" TIMESTAMP(3)                                NOT NULL,
    "sys_id"       VARCHAR(36) COLLATE "pg_catalog"."default"  NOT NULL
);
COMMENT ON TABLE "public"."srm_supplier" IS '供应商信息表';
COMMENT ON COLUMN "public"."srm_supplier"."id" IS 'id';
COMMENT ON COLUMN "public"."srm_supplier"."name" IS '名称';
COMMENT ON COLUMN "public"."srm_supplier"."person" IS '联系人';
COMMENT ON COLUMN "public"."srm_supplier"."phone" IS '联系电话';
COMMENT ON COLUMN "public"."srm_supplier"."address" IS '联系地址';
COMMENT ON COLUMN "public"."srm_supplier"."type" IS '供应商类型';
COMMENT ON COLUMN "public"."srm_supplier"."mark" IS '评分';
COMMENT ON COLUMN "public"."srm_supplier"."remark" IS '备注';
COMMENT ON COLUMN "public"."srm_supplier"."image" IS '图片集合';
COMMENT ON COLUMN "public"."srm_supplier"."product" IS '产品集合';
COMMENT ON COLUMN "public"."srm_supplier"."state" IS '供应商状态';
COMMENT ON COLUMN "public"."srm_supplier"."ext1" IS '扩展字段1';
COMMENT ON COLUMN "public"."srm_supplier"."ext2" IS '扩展字段2';
COMMENT ON COLUMN "public"."srm_supplier"."ext3" IS '扩展字段3';
COMMENT ON COLUMN "public"."srm_supplier"."gmt_create" IS '创建时间';
COMMENT ON COLUMN "public"."srm_supplier"."gmt_modified" IS '更新时间';
COMMENT ON COLUMN "public"."srm_supplier"."sys_id" IS '系统ID';


-- ----------------------------
-- Table structure for srm_cooperate
-- ----------------------------
DROP TABLE IF EXISTS "public"."srm_cooperate";
CREATE TABLE "public"."srm_cooperate" (
    "id"           VARCHAR(36) COLLATE "pg_catalog"."default" NOT NULL PRIMARY KEY,
    "supplier_id"  VARCHAR(36) COLLATE "pg_catalog"."default" NOT NULL,
    "product"      VARCHAR(64) COLLATE "pg_catalog"."default",
    "content"      VARCHAR(2048) COLLATE "pg_catalog"."default",
    "time"         TIMESTAMP(3)                               NOT NULL,
    "ext1"         VARCHAR(1024) COLLATE "pg_catalog"."default",
    "ext2"         VARCHAR(1024) COLLATE "pg_catalog"."default",
    "ext3"         TEXT COLLATE "pg_catalog"."default",
    "gmt_create"   TIMESTAMP(3)                               NOT NULL,
    "gmt_modified" TIMESTAMP(3)                               NOT NULL,
    "sys_id"       VARCHAR(36) COLLATE "pg_catalog"."default" NOT NULL
);
COMMENT ON TABLE "public"."srm_cooperate" IS '供应商合作记录表';
COMMENT ON COLUMN "public"."srm_cooperate"."id" IS 'id';
COMMENT ON COLUMN "public"."srm_cooperate"."supplier_id" IS '供应商Id';
COMMENT ON COLUMN "public"."srm_cooperate"."product" IS '产品';
COMMENT ON COLUMN "public"."srm_cooperate"."content" IS '内容';
COMMENT ON COLUMN "public"."srm_cooperate"."time" IS '时间';
COMMENT ON COLUMN "public"."srm_cooperate"."ext1" IS '扩展字段1';
COMMENT ON COLUMN "public"."srm_cooperate"."ext2" IS '扩展字段2';
COMMENT ON COLUMN "public"."srm_cooperate"."ext3" IS '扩展字段3';
COMMENT ON COLUMN "public"."srm_cooperate"."gmt_create" IS '创建时间';
COMMENT ON COLUMN "public"."srm_cooperate"."gmt_modified" IS '更新时间';
COMMENT ON COLUMN "public"."srm_cooperate"."sys_id" IS '系统ID';