FuJianModelPlatform/create_service_table.sql

-- ----------------------------
-- Table structure for watershed_service
-- ----------------------------
DROP TABLE IF EXISTS "WATERSHED_SERVICE";
CREATE TABLE "WATERSHED_SERVICE" (
  "id" BIGINT NOT NULL IDENTITY(1,1),
  "name" VARCHAR(100) NOT NULL,
  "type" VARCHAR(50) NOT NULL,
  "url" VARCHAR(255) NOT NULL,
  "token_required" INT DEFAULT 0,
  "token" VARCHAR(255),
  "status" VARCHAR(20) NOT NULL DEFAULT 'NORMAL',
  "created_at" DATETIME,
  "updated_at" DATETIME,
  PRIMARY KEY ("id")
);

-- ----------------------------
-- Comments for WATERSHED_SERVICE
-- ----------------------------
COMMENT ON TABLE "WATERSHED_SERVICE" IS '自定义服务表';
COMMENT ON COLUMN "WATERSHED_SERVICE"."id" IS '服务ID';
COMMENT ON COLUMN "WATERSHED_SERVICE"."name" IS '服务名称';
COMMENT ON COLUMN "WATERSHED_SERVICE"."type" IS '服务类型';
COMMENT ON COLUMN "WATERSHED_SERVICE"."url" IS '服务URL';
COMMENT ON COLUMN "WATERSHED_SERVICE"."token_required" IS '是否需要token';
COMMENT ON COLUMN "WATERSHED_SERVICE"."token" IS '服务token';
COMMENT ON COLUMN "WATERSHED_SERVICE"."status" IS '服务状态';
COMMENT ON COLUMN "WATERSHED_SERVICE"."created_at" IS '创建时间';
COMMENT ON COLUMN "WATERSHED_SERVICE"."updated_at" IS '更新时间';