magic-api/db/magic-api-dm.sql

-- ----------------------------
-- CREATE SCHEMA "MAGIC";
-- ----------------------------
CREATE SCHEMA "MAGIC";

-- ----------------------------
-- Table structure for MAGIC_GROUP
-- ----------------------------
CREATE TABLE "MAGIC"."MAGIC_GROUP"
(
 "ID" VARCHAR(32) NOT NULL,
 "GROUP_NAME" VARCHAR(64) NULL,
 "GROUP_TYPE" VARCHAR(1) NULL,
 "GROUP_PATH" VARCHAR(64) NULL,
 "PARENT_ID" VARCHAR(32) NULL,
 "DELETED" CHAR(1) DEFAULT '0'
 NULL
);

-- ----------------------------
-- Table structure for MAGIC_API_INFO_HIS
-- ----------------------------
CREATE TABLE "MAGIC"."MAGIC_API_INFO_HIS"
(
 "ID" VARCHAR(32) NULL,
 "API_METHOD" VARCHAR(12) NULL,
 "API_PATH" VARCHAR(512) NULL,
 "API_SCRIPT" CLOB NULL,
 "API_PARAMETER" CLOB NULL,
 "API_OPTION" CLOB NULL,
 "API_NAME" VARCHAR(255) NULL,
 "API_GROUP_ID" VARCHAR(32) NULL,
 "API_REQUEST_BODY" CLOB NULL,
 "API_REQUEST_HEADER" CLOB NULL,
 "API_RESPONSE_BODY" CLOB NULL,
 "API_DESCRIPTION" VARCHAR(512) NULL,
 "API_CREATE_TIME" BIGINT NULL,
 "API_UPDATE_TIME" BIGINT NULL
);

-- ----------------------------
-- Table structure for MAGIC_API_INFO
-- ----------------------------
CREATE TABLE "MAGIC"."MAGIC_API_INFO"
(
 "ID" VARCHAR(32) NOT NULL,
 "API_METHOD" VARCHAR(12) NULL,
 "API_PATH" VARCHAR(512) NULL,
 "API_SCRIPT" CLOB NULL,
 "API_PARAMETER" CLOB NULL,
 "API_OPTION" CLOB NULL,
 "API_NAME" VARCHAR(255) NULL,
 "API_GROUP_ID" VARCHAR(32) NULL,
 "API_REQUEST_BODY" CLOB NULL,
 "API_REQUEST_HEADER" CLOB NULL,
 "API_RESPONSE_BODY" CLOB NULL,
 "API_DESCRIPTION" VARCHAR(512) NULL,
 "API_CREATE_TIME" BIGINT NULL,
 "API_UPDATE_TIME" BIGINT NULL
);

-- ----------------------------
-- CONSTRAINT
-- ----------------------------
ALTER TABLE "MAGIC"."MAGIC_GROUP" ADD CONSTRAINT  PRIMARY KEY("ID") ;

ALTER TABLE "MAGIC"."MAGIC_API_INFO" ADD CONSTRAINT  PRIMARY KEY("ID") ;

CREATE UNIQUE INDEX "PRIMARY"
ON "MAGIC"."MAGIC_GROUP"("ID");

-- ----------------------------
-- COMMENTS
-- ----------------------------
COMMENT ON TABLE "MAGIC"."MAGIC_GROUP" IS 'MagicAPI分组信息表';

COMMENT ON COLUMN "MAGIC"."MAGIC_GROUP"."GROUP_NAME" IS '组名';

COMMENT ON COLUMN "MAGIC"."MAGIC_GROUP"."GROUP_TYPE" IS '组类型，1：接口分组，2：函数分组';

COMMENT ON COLUMN "MAGIC"."MAGIC_GROUP"."GROUP_PATH" IS '分组路径';

COMMENT ON COLUMN "MAGIC"."MAGIC_GROUP"."PARENT_ID" IS '父级ID';

COMMENT ON COLUMN "MAGIC"."MAGIC_GROUP"."DELETED" IS '是否被删除，1：是，0：否';

COMMENT ON TABLE "MAGIC"."MAGIC_API_INFO_HIS" IS 'MagicAPI接口历史记录';

COMMENT ON COLUMN "MAGIC"."MAGIC_API_INFO_HIS"."ID" IS 'api_id';

COMMENT ON COLUMN "MAGIC"."MAGIC_API_INFO_HIS"."API_METHOD" IS '请求方法';

COMMENT ON COLUMN "MAGIC"."MAGIC_API_INFO_HIS"."API_PATH" IS '请求路径';

COMMENT ON COLUMN "MAGIC"."MAGIC_API_INFO_HIS"."API_SCRIPT" IS '接口脚本';

COMMENT ON COLUMN "MAGIC"."MAGIC_API_INFO_HIS"."API_PARAMETER" IS '接口参数';

COMMENT ON COLUMN "MAGIC"."MAGIC_API_INFO_HIS"."API_OPTION" IS '接口选项';

COMMENT ON COLUMN "MAGIC"."MAGIC_API_INFO_HIS"."API_NAME" IS '接口名称';

COMMENT ON COLUMN "MAGIC"."MAGIC_API_INFO_HIS"."API_GROUP_ID" IS '分组ID';

COMMENT ON COLUMN "MAGIC"."MAGIC_API_INFO_HIS"."API_REQUEST_BODY" IS '请求体';

COMMENT ON COLUMN "MAGIC"."MAGIC_API_INFO_HIS"."API_REQUEST_HEADER" IS '请求Header';

COMMENT ON COLUMN "MAGIC"."MAGIC_API_INFO_HIS"."API_RESPONSE_BODY" IS '输出结果';

COMMENT ON COLUMN "MAGIC"."MAGIC_API_INFO_HIS"."API_DESCRIPTION" IS '接口描述';

COMMENT ON COLUMN "MAGIC"."MAGIC_API_INFO_HIS"."API_CREATE_TIME" IS '创建时间';

COMMENT ON COLUMN "MAGIC"."MAGIC_API_INFO_HIS"."API_UPDATE_TIME" IS '修改时间';

CREATE UNIQUE INDEX "INDEX26948817097900"
ON "MAGIC"."MAGIC_API_INFO"("ID");

COMMENT ON TABLE "MAGIC"."MAGIC_API_INFO" IS 'MagicAPI接口信息';

COMMENT ON COLUMN "MAGIC"."MAGIC_API_INFO"."API_METHOD" IS '请求方法';

COMMENT ON COLUMN "MAGIC"."MAGIC_API_INFO"."API_PATH" IS '请求路径';

COMMENT ON COLUMN "MAGIC"."MAGIC_API_INFO"."API_SCRIPT" IS '接口脚本';

COMMENT ON COLUMN "MAGIC"."MAGIC_API_INFO"."API_PARAMETER" IS '接口参数';

COMMENT ON COLUMN "MAGIC"."MAGIC_API_INFO"."API_OPTION" IS '接口选项';

COMMENT ON COLUMN "MAGIC"."MAGIC_API_INFO"."API_NAME" IS '接口名称';

COMMENT ON COLUMN "MAGIC"."MAGIC_API_INFO"."API_GROUP_ID" IS '分组ID';

COMMENT ON COLUMN "MAGIC"."MAGIC_API_INFO"."API_REQUEST_BODY" IS '请求体';

COMMENT ON COLUMN "MAGIC"."MAGIC_API_INFO"."API_REQUEST_HEADER" IS '请求Header';

COMMENT ON COLUMN "MAGIC"."MAGIC_API_INFO"."API_RESPONSE_BODY" IS '输出结果';

COMMENT ON COLUMN "MAGIC"."MAGIC_API_INFO"."API_DESCRIPTION" IS '接口描述';

COMMENT ON COLUMN "MAGIC"."MAGIC_API_INFO"."API_CREATE_TIME" IS '创建时间';

COMMENT ON COLUMN "MAGIC"."MAGIC_API_INFO"."API_UPDATE_TIME" IS '修改时间';