-- ----------------------------
-- Table structure for product_dir
-- ----------------------------
DROP TABLE IF EXISTS "public"."product_dir";
CREATE TABLE "public"."product_dir" (
    "id"           VARCHAR(36) COLLATE "pg_catalog"."default"  NOT NULL PRIMARY KEY,
    "code"           VARCHAR(128) COLLATE "pg_catalog"."default" NOT NULL,
    "name"         VARCHAR(128) COLLATE "pg_catalog"."default" NOT NULL,
    "parent_id"    VARCHAR(64) COLLATE "pg_catalog"."default",
    "path"         TEXT COLLATE "pg_catalog"."default" DEFAULT '[]',
    "image"        VARCHAR(64) COLLATE "pg_catalog"."default",
    "remark"       VARCHAR(256) COLLATE "pg_catalog"."default",
    "ext1"         VARCHAR(1024) COLLATE "pg_catalog"."default",
    "ext2"         VARCHAR(1024) COLLATE "pg_catalog"."default",
    "ext3"         TEXT COLLATE "pg_catalog"."default" 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"."product_dir" IS '产品目录表';
COMMENT ON COLUMN "public"."product_dir"."id" IS 'id';
COMMENT ON COLUMN "public"."product_dir"."code" IS '标识符';
COMMENT ON COLUMN "public"."product_dir"."name" IS '名称';
COMMENT ON COLUMN "public"."product_dir"."parent_id" IS '父目录Id';
COMMENT ON COLUMN "public"."product_dir"."path" IS '路径';
COMMENT ON COLUMN "public"."product_dir"."image" IS '图片';
COMMENT ON COLUMN "public"."product_dir"."remark" IS '备注';
COMMENT ON COLUMN "public"."product_dir"."ext1" IS '扩展字段1';
COMMENT ON COLUMN "public"."product_dir"."ext2" IS '扩展字段2';
COMMENT ON COLUMN "public"."product_dir"."ext3" IS '扩展字段3';
COMMENT ON COLUMN "public"."product_dir"."gmt_create" IS '创建时间';
COMMENT ON COLUMN "public"."product_dir"."gmt_modified" IS '更新时间';
COMMENT ON COLUMN "public"."product_dir"."sys_id" IS '系统ID';