CREATE TABLE "public"."qg_malfunction_reason" (
     "id" varchar(36)  NOT NULL,
     "code" varchar(50),
     "reason" varchar(200),
     "status" varchar(50),
     "tenant_id" varchar(36),
     "create_time" timestamp(6),
     "creator" varchar(36),
     "updater" varchar(36),
     "update_time" timestamp(6),
     CONSTRAINT "qg_malfunction_reason_pkey" PRIMARY KEY ("id")
);

ALTER TABLE "public"."qg_malfunction_reason" OWNER TO "postgres";

COMMENT ON COLUMN "public"."qg_malfunction_reason"."id" IS '主键ID';
COMMENT ON COLUMN "public"."qg_malfunction_reason"."code" IS '故障编码';
COMMENT ON COLUMN "public"."qg_malfunction_reason"."reason" IS '故障原因';
COMMENT ON COLUMN "public"."qg_malfunction_reason"."status" IS '状态';
COMMENT ON COLUMN "public"."qg_malfunction_reason"."tenant_id" IS '租户ID';
COMMENT ON COLUMN "public"."qg_malfunction_reason"."create_time" IS '创建时间';
COMMENT ON COLUMN "public"."qg_malfunction_reason"."updater" IS '更新用户';
COMMENT ON COLUMN "public"."qg_malfunction_reason"."update_time" IS '更新时间';
COMMENT ON COLUMN "public"."qg_malfunction_reason"."creator" IS '创建用户';


ALTER TABLE device
    ADD COLUMN IF NOT EXISTS director_id varchar(36);
ALTER TABLE device
    ADD COLUMN IF NOT EXISTS category_id varchar(36);

COMMENT ON COLUMN "public"."device"."director_id" IS '负责人id';
COMMENT ON COLUMN "public"."device"."category_id" IS '设备类别id';


CREATE TABLE "public"."qg_repair_order" (
    "id" varchar(36)  NOT NULL,
    "device_id" varchar(36),
    "order_code" varchar(50),
    "report_date" timestamp(6),
    "report_by" varchar(36),
    "status" varchar(50),
    "emergency" bool,
    "situation_img" varchar(200),
    "description" varchar(500),
    "tenant_id" varchar(36),
    "create_time" timestamp(6),
    "creator" varchar(36),
    "updater" varchar(36),
    "update_time" timestamp(6),
    CONSTRAINT "qg_repair_order_pkey" PRIMARY KEY ("id")
);

ALTER TABLE "public"."qg_repair_order" OWNER TO "postgres";

COMMENT ON COLUMN "public"."qg_repair_order"."id" IS '主键ID';
COMMENT ON COLUMN "public"."qg_repair_order"."device_id" IS '设备id';
COMMENT ON COLUMN "public"."qg_repair_order"."report_date" IS '报修时间';
COMMENT ON COLUMN "public"."qg_repair_order"."report_by" IS '报修人';
COMMENT ON COLUMN "public"."qg_repair_order"."report_by" IS '报修人';
COMMENT ON COLUMN "public"."qg_repair_order"."status" IS '工单状态';
COMMENT ON COLUMN "public"."qg_repair_order"."emergency" IS '是否紧急';
COMMENT ON COLUMN "public"."qg_repair_order"."situation_img" IS 'situation_img';
COMMENT ON COLUMN "public"."qg_repair_order"."tenant_id" IS '租户ID';
COMMENT ON COLUMN "public"."qg_repair_order"."create_time" IS '创建时间';
COMMENT ON COLUMN "public"."qg_repair_order"."updater" IS '更新用户';
COMMENT ON COLUMN "public"."qg_repair_order"."update_time" IS '更新时间';
COMMENT ON COLUMN "public"."qg_repair_order"."creator" IS '创建用户';


CREATE TABLE "public"."qg_repair_record" (
    "id" varchar(36)  NOT NULL,
    "code" varchar(50),
    "order_id" varchar(36),
    "repair_date" timestamp(6),
    "repair_by" varchar(36),
    "description" varchar(500),
    "malfunction_reason_id" varchar(36),
    "tenant_id" varchar(36),
    "create_time" timestamp(6),
    "creator" varchar(36),
    "updater" varchar(36),
    "update_time" timestamp(6),
    CONSTRAINT "qg_repair_record_pkey" PRIMARY KEY ("id")
);

ALTER TABLE "public"."qg_repair_record" OWNER TO "postgres";

COMMENT ON COLUMN "public"."qg_repair_record"."id" IS '主键ID';
COMMENT ON COLUMN "public"."qg_repair_record"."order_id" IS '维修工单id';
COMMENT ON COLUMN "public"."qg_repair_record"."repair_date" IS '维修时间';
COMMENT ON COLUMN "public"."qg_repair_record"."repair_by" IS '维修人';
COMMENT ON COLUMN "public"."qg_repair_record"."description" IS '维修情况说明';
COMMENT ON COLUMN "public"."qg_repair_record"."tenant_id" IS '租户ID';
COMMENT ON COLUMN "public"."qg_repair_record"."create_time" IS '创建时间';
COMMENT ON COLUMN "public"."qg_repair_record"."updater" IS '更新用户';
COMMENT ON COLUMN "public"."qg_repair_record"."update_time" IS '更新时间';
COMMENT ON COLUMN "public"."qg_repair_record"."creator" IS '创建用户';

CREATE TABLE "public"."qg_inspection_plan"
(
    "id"          varchar(36) PRIMARY KEY,
    "code"        varchar(50) NOT NULL,
    "name"        varchar(50) NOT NULL,
    "status"      varchar(50) NOT NULL,
    "start_time"  timestamp(6),
    "end_time"    timestamp(6),
    "tenant_id"   varchar(36),
    "create_time" timestamp(6),
    "creator"     varchar(36),
    "updater"     varchar(36),
    "update_time" timestamp(6),
    "remark"      varchar(255)
);

COMMENT ON TABLE "public"."qg_inspection_plan" IS '巡检计划';
COMMENT ON COLUMN "public"."qg_inspection_plan"."id" IS '主键ID';
COMMENT ON COLUMN "public"."qg_inspection_plan"."code" IS '计划编号';
COMMENT ON COLUMN "public"."qg_inspection_plan"."name" IS '计划名称';
COMMENT ON COLUMN "public"."qg_inspection_plan"."status" IS '计划状态';
COMMENT ON COLUMN "public"."qg_inspection_plan"."start_time" IS '开始日期';
COMMENT ON COLUMN "public"."qg_inspection_plan"."end_time" IS '结束日期';
COMMENT ON COLUMN "public"."qg_inspection_plan"."tenant_id" IS '租户ID';
COMMENT ON COLUMN "public"."qg_inspection_plan"."remark" IS '计划备注';

CREATE TABLE "public"."qg_check_plan"
(
    "id"           varchar(36) PRIMARY KEY,
    "code"         varchar(50) NOT NULL,
    "name"         varchar(50) NOT NULL,
    "type"         varchar(50),
    "status"       varchar(50),
    "plan_details" varchar(255),
    "tenant_id"    varchar(36),
    "create_time"  timestamp(6),
    "creator"      varchar(36),
    "updater"      varchar(36),
    "update_time"  timestamp(6)
);

COMMENT ON TABLE "public"."qg_check_plan" IS '巡检/保养方案';
COMMENT ON COLUMN "public"."qg_check_plan"."id" IS '主键ID';
COMMENT ON COLUMN "public"."qg_check_plan"."code" IS '方案编号';
COMMENT ON COLUMN "public"."qg_check_plan"."name" IS '方案名称';
COMMENT ON COLUMN "public"."qg_check_plan"."type" IS '方案类型';
COMMENT ON COLUMN "public"."qg_check_plan"."status" IS '状态';
COMMENT ON COLUMN "public"."qg_check_plan"."plan_details" IS '方案明细';
COMMENT ON COLUMN "public"."qg_check_plan"."tenant_id" IS '租户ID';

CREATE TABLE "public"."qg_check_details"
(
    "id"                 varchar(36) PRIMARY KEY,
    "code"               varchar(50) NOT NULL,
    "check_device_id"    varchar(36) NOT NULL,
    "check_plan_id"      varchar(36),
    "inspection_plan_id" varchar(36),
    "plan_details"       varchar(255),
    "show_order"         int4,
    "tenant_id"          varchar(36),
    "create_time"        timestamp(6),
    "creator"            varchar(36),
    "updater"            varchar(36),
    "update_time"        timestamp(6)
);

COMMENT ON TABLE "public"."qg_check_details" IS '巡检明细';
COMMENT ON COLUMN "public"."qg_check_details"."id" IS '主键ID';
COMMENT ON COLUMN "public"."qg_check_details"."code" IS '明细编号';
COMMENT ON COLUMN "public"."qg_check_details"."check_device_id" IS '巡检设备';
COMMENT ON COLUMN "public"."qg_check_details"."check_plan_id" IS '巡检方案';
COMMENT ON COLUMN "public"."qg_check_details"."inspection_plan_id" IS '巡检计划';
COMMENT ON COLUMN "public"."qg_check_details"."plan_details" IS '方案明细';
COMMENT ON COLUMN "public"."qg_check_details"."show_order" IS '排序';
COMMENT ON COLUMN "public"."qg_check_details"."tenant_id" IS '租户ID';

CREATE TABLE "public"."qg_inspection_record"
(
    "id"                 varchar(36) PRIMARY KEY,
    "code"               varchar(50) NOT NULL,
    "inspection_plan_id" varchar(36),
    "inspector_id"       varchar(36),
    "check_date"         timestamp(6),
    "record_result"      bool,
    "tenant_id"          varchar(36),
    "create_time"        timestamp(6),
    "creator"            varchar(36),
    "updater"            varchar(36),
    "update_time"        timestamp(6)
);

COMMENT ON TABLE "public"."qg_inspection_record" IS '巡检记录';
COMMENT ON COLUMN "public"."qg_inspection_record"."id" IS '主键ID';
COMMENT ON COLUMN "public"."qg_inspection_record"."code" IS '记录编号';
COMMENT ON COLUMN "public"."qg_inspection_record"."inspection_plan_id" IS '巡检计划';
COMMENT ON COLUMN "public"."qg_inspection_record"."inspector_id" IS '巡检人';
COMMENT ON COLUMN "public"."qg_inspection_record"."check_date" IS '巡检日期';
COMMENT ON COLUMN "public"."qg_inspection_record"."record_result" IS '巡检结果';
COMMENT ON COLUMN "public"."qg_inspection_record"."tenant_id" IS '租户ID';

CREATE TABLE "public"."qg_inspection_details"
(
    "id"                   varchar(36) PRIMARY KEY,
    "check_device_id"      varchar(36),
    "plan_details"         varchar(255),
    "record_result"        bool,
    "show_order"           int4,
    "inspection_record_id" varchar(36),
    "tenant_id"            varchar(36),
    "create_time"          timestamp(6),
    "creator"              varchar(36),
    "updater"              varchar(36),
    "update_time"          timestamp(6)
);

COMMENT ON TABLE "public"."qg_inspection_details" IS '巡检记录明细';
COMMENT ON COLUMN "public"."qg_inspection_details"."id" IS '主键ID';
COMMENT ON COLUMN "public"."qg_inspection_details"."check_device_id" IS '巡检设备';
COMMENT ON COLUMN "public"."qg_inspection_details"."plan_details" IS '巡检内容';
COMMENT ON COLUMN "public"."qg_inspection_details"."record_result" IS '巡检结果';
COMMENT ON COLUMN "public"."qg_inspection_details"."show_order" IS '排序';
COMMENT ON COLUMN "public"."qg_inspection_details"."inspection_record_id" IS '巡检记录';
COMMENT ON COLUMN "public"."qg_inspection_details"."tenant_id" IS '租户ID';

CREATE TABLE "public"."qg_preserve_detail" (
   "id" varchar(36)  NOT NULL,
   "detail_code" varchar(50),
   "preserve_detail" varchar(200),
   "preserve_plan_id" varchar(36),
   "device_id" varchar(36),
   "check_plan_id" varchar(36),
   "detail_status" varchar(50),
   "tenant_id" varchar(36),
   "create_time" timestamp(6),
   "creator" varchar(36),
   "updater" varchar(36),
   "update_time" timestamp(6),
   CONSTRAINT "qg_preserve_detail_pkey" PRIMARY KEY ("id")
);

COMMENT ON TABLE "public"."qg_preserve_detail" IS '保养明细';
COMMENT ON COLUMN "public"."qg_preserve_detail"."detail_code" IS '保养明细编码';
COMMENT ON COLUMN "public"."qg_preserve_detail"."preserve_detail" IS '方案明细';
COMMENT ON COLUMN "public"."qg_preserve_detail"."preserve_plan_id" IS '保养计划id';
COMMENT ON COLUMN "public"."qg_preserve_detail"."device_id" IS '设备id';
COMMENT ON COLUMN "public"."qg_preserve_detail"."check_plan_id" IS '方案id';
COMMENT ON COLUMN "public"."qg_preserve_detail"."detail_status" IS '状态';

CREATE TABLE "public"."qg_preserve_plan" (
   "id" varchar(36)  NOT NULL,
   "preserve_code" varchar(50),
   "preserve_name" varchar(200),
   "status" varchar(50),
   "times" int4,
   "frequency" varchar(50),
   "tenant_id" varchar(36),
   "create_time" timestamp(6),
   "creator" varchar(36),
   "updater" varchar(36),
   "update_time" timestamp(6),
   CONSTRAINT "qg_preserve_plan_pkey" PRIMARY KEY ("id")
);

COMMENT ON TABLE "public"."qg_preserve_plan" IS '保养计划';
COMMENT ON COLUMN "public"."qg_preserve_plan"."preserve_code" IS '保养计划编码';
COMMENT ON COLUMN "public"."qg_preserve_plan"."preserve_name" IS '保养计划名称';
COMMENT ON COLUMN "public"."qg_preserve_plan"."status" IS '状态';
COMMENT ON COLUMN "public"."qg_preserve_plan"."times" IS '次数';
COMMENT ON COLUMN "public"."qg_preserve_plan"."frequency" IS '频率';

CREATE TABLE "public"."qg_preserve_record" (
    "id" varchar(36)  NOT NULL,
    "record_code" varchar(50),
    "preserve_plan_id" varchar(36),
    "preserve_date" timestamp(6),
    "preserve_by" varchar(36),
    "preserve_status" varchar(50),
    "tenant_id" varchar(36),
    "create_time" timestamp(6),
    "creator" varchar(36),
    "updater" varchar(36),
    "update_time" timestamp(6),
    CONSTRAINT "qg_preserve_record_pkey" PRIMARY KEY ("id")
);

COMMENT ON TABLE "public"."qg_preserve_record" IS '保养记录';
COMMENT ON COLUMN "public"."qg_preserve_record"."record_code" IS '保养记录编码';
COMMENT ON COLUMN "public"."qg_preserve_record"."preserve_plan_id" IS '保养计划id';
COMMENT ON COLUMN "public"."qg_preserve_record"."preserve_date" IS '保养日期';
COMMENT ON COLUMN "public"."qg_preserve_record"."preserve_by" IS '保养日期';
COMMENT ON COLUMN "public"."qg_preserve_record"."preserve_status" IS '状态';

CREATE TABLE "public"."qg_device_cagegory" (
  "id" varchar(36)  NOT NULL,
  "name" varchar(50),
  "parent_id" varchar(36),
  "cagegory_order" int4,
  "path_id" varchar(500),
  "tenant_id" varchar(36),
  "create_time" timestamp(6),
  "creator" varchar(36),
  "updater" varchar(36),
  "update_time" timestamp(6),
CONSTRAINT "qg_device_cagegory_pkey" PRIMARY KEY ("id")
);

COMMENT ON TABLE "public"."qg_device_cagegory" IS '设备分类';
COMMENT ON COLUMN "public"."qg_device_cagegory"."name" IS '保养记录编码';
COMMENT ON COLUMN "public"."qg_device_cagegory"."parent_id" IS '保养计划id';
COMMENT ON COLUMN "public"."qg_device_cagegory"."order" IS '排序';

CREATE TABLE "public"."qg_device_account" (
    "id" varchar(36)  NOT NULL,
    "name" varchar(50),
    "code" varchar(50),
    "category_id" varchar(36),
    "status" varchar(50),
    "director_id" varchar(36),
    "installLocation_id" varchar(36),
    "is_online" bool,
    "brand" varchar(50),
    "model_num" varchar(50),
    "specifications" varchar(50),
    "manufacturer" varchar(50),
    "buy_date" timestamp(6),
    "price" float8,
    "product_date" timestamp(6),
    "receive_date" timestamp(6),
    "registe_date" timestamp(6),
    "supplier_id" varchar(36),
    "device_img" varchar(100),
    "description" varchar(200),
    "tenant_id" varchar(36),
    "create_time" timestamp(6),
    "creator" varchar(36),
    "updater" varchar(36),
    "update_time" timestamp(6),
    CONSTRAINT "qg_device_account_pkey" PRIMARY KEY ("id")
);

COMMENT ON TABLE "public"."qg_device_account" IS '设备台账';
COMMENT ON COLUMN "public"."qg_device_account"."name" IS '设备名称';
COMMENT ON COLUMN "public"."qg_device_account"."code" IS '设备名称';
COMMENT ON COLUMN "public"."qg_device_account"."category_id" IS '设备名称';
COMMENT ON COLUMN "public"."qg_device_account"."status" IS '状态';
COMMENT ON COLUMN "public"."qg_device_account"."director_id" IS '负责人id';
COMMENT ON COLUMN "public"."qg_device_account"."installLocation_id" IS '安装地点id';
COMMENT ON COLUMN "public"."qg_device_account"."is_online" IS '是否连网';
COMMENT ON COLUMN "public"."qg_device_account"."brand" IS '品牌';
COMMENT ON COLUMN "public"."qg_device_account"."model_num" IS '型号';
COMMENT ON COLUMN "public"."qg_device_account"."specifications" IS '规格';
COMMENT ON COLUMN "public"."qg_device_account"."manufacturer" IS '生产厂家';
COMMENT ON COLUMN "public"."qg_device_account"."buy_date" IS '购买时间';
COMMENT ON COLUMN "public"."qg_device_account"."price" IS '价格';
COMMENT ON COLUMN "public"."qg_device_account"."product_date" IS '出厂日期';
COMMENT ON COLUMN "public"."qg_device_account"."receive_date" IS '验收日期';
COMMENT ON COLUMN "public"."qg_device_account"."registe_date" IS '登记日期';
COMMENT ON COLUMN "public"."qg_device_account"."supplier_id" IS '供应商id';
COMMENT ON COLUMN "public"."qg_device_account"."device_img" IS '图片';
COMMENT ON COLUMN "public"."qg_device_account"."description" IS '备注';

CREATE TABLE "public"."qg_supplier" (
   "id" varchar(36)  NOT NULL,
   "name" varchar(50),
   "code" varchar(50),
   "contacts" varchar(50),
   "contacts_mobile" varchar(50),
   "tenant_id" varchar(36),
   "create_time" timestamp(6),
   "creator" varchar(36),
   "updater" varchar(36),
   "update_time" timestamp(6),
   CONSTRAINT "qg_supplier_pkey" PRIMARY KEY ("id")
);

CREATE TABLE "public"."qg_preserve_detail_status" (
 "id" varchar(36)  NOT NULL,
 "preserve_record_id" varchar(36),
 "preserve_detail_id" varchar(36),
 "status" varchar(50),
 "tenant_id" varchar(36),
 "create_time" timestamp(6),
 "creator" varchar(36),
 "updater" varchar(36),
 "update_time" timestamp(6),
 CONSTRAINT "qg_preserve_detail_status_pkey" PRIMARY KEY ("id")
);

COMMENT ON TABLE "public"."qg_preserve_detail_status" IS '保养记录明细状态';

CREATE TABLE "qg_db_connect" (
 "id"          varchar(36) PRIMARY KEY,
 "name"               varchar(50)  NOT NULL,
 "type"               varchar(20)  NOT NULL,
 "ip"                 varchar(20)  NOT NULL,
 "port"               varchar(20)  NOT NULL,
 "db_name"            varchar(50)  NOT NULL,
 "user_name"          varchar(50)  NOT NULL,
 "password"           varchar(50)  NOT NULL,
 "url"                varchar(200) NOT NULL,
 "open_ssh"           bool         NOT NULL DEFAULT false,
 "open_ssl"           bool         NOT NULL DEFAULT false,
 "max_pool_size"      int4                  DEFAULT 50,
 "min_idle"           int4                  DEFAULT 0,
 "connect_test_query" varchar(200),
 "connect_timeout"    int4                  DEFAULT 30000,
 "tenant_id"          varchar(36),
 "create_time"        timestamp(6),
 "creator"            varchar(36) NULL,
 "updater"            varchar(36) NULL,
 "update_time"        timestamp(6)
);
COMMENT ON TABLE qg_db_connect IS '数据库链接信息';
COMMENT ON COLUMN qg_db_connect.tenant_id IS '租户ID';
COMMENT ON COLUMN qg_db_connect.name IS '自定义数据库名称';
COMMENT ON COLUMN qg_db_connect.type IS '数据库类型';
COMMENT ON COLUMN qg_db_connect.ip IS '主机ip';
COMMENT ON COLUMN qg_db_connect.port IS '端口号';
COMMENT ON COLUMN qg_db_connect.db_name IS '数据库名称';
COMMENT ON COLUMN qg_db_connect.user_name IS '用户名';
COMMENT ON COLUMN qg_db_connect.password IS '密码';
COMMENT ON COLUMN qg_db_connect.url IS 'url';
COMMENT ON COLUMN qg_db_connect.open_ssh IS '是否启用ssh，默认false';
COMMENT ON COLUMN qg_db_connect.open_ssl IS '是否启用ssl，默认false';
COMMENT ON COLUMN qg_db_connect.max_pool_size IS '最大活动链接数，默认50';
COMMENT ON COLUMN qg_db_connect.min_idle IS '最小空闲连接数，默认0';
COMMENT ON COLUMN qg_db_connect.connect_test_query IS '链接校验语句，默认为：SELECT 1';
COMMENT ON COLUMN qg_db_connect.connect_timeout IS '最大等待时间(毫秒)，默认为：30000毫秒';

CREATE TABLE "qg_db_connect_ssh" (
 "id"            varchar(36) PRIMARY KEY,
 "connect_id"    varchar(36)  NOT NULL,
 "ip"            varchar(20),
 "port"          varchar(20),
 "ssh_name"      varchar(50),
 "ssh_password"  varchar(50),
 "verify_method" varchar(200),
 "private_key"   varchar(200),
 "tenant_id"     varchar(36),
 "create_time"   timestamp(6),
 "creator"       varchar(36) NULL,
 "updater"       varchar(36) NULL,
 "update_time"   timestamp(6)
);
COMMENT ON TABLE qg_db_connect_ssh IS 'SSH通道配置信息';
COMMENT ON COLUMN qg_db_connect.tenant_id IS '租户ID';
COMMENT ON COLUMN qg_db_connect.connect_id IS '数据库链接信息id';
COMMENT ON COLUMN qg_db_connect_ssh.ip IS 'ssh的ip';
COMMENT ON COLUMN qg_db_connect_ssh.port IS 'ssh的port';
COMMENT ON COLUMN qg_db_connect_ssh.ssh_name IS '用户名';
COMMENT ON COLUMN qg_db_connect_ssh.ssh_password IS '密码/密码短语';
COMMENT ON COLUMN qg_db_connect_ssh.verify_method IS '验证方式（PASSWORD：密码；PUBLIC_KEY：公钥）';
COMMENT ON COLUMN qg_db_connect_ssh.private_key IS '私钥文件';

CREATE TABLE "qg_db_connect_ssl" (
 "id"             varchar(36) PRIMARY KEY,
 "connect_id"     varchar(36) NOT NULL,
 "ca_cert"        varchar(50),
 "verify_ca_cert" bool        NOT NULL DEFAULT FALSE,
 "client_key"     varchar(50),
 "client_cert"    varchar(50),
 "tenant_id"      varchar(36),
 "create_time"    timestamp(6),
 "creator"        varchar(36) NULL,
 "updater"        varchar(36) NULL,
 "update_time"    timestamp(6)
);
COMMENT ON TABLE qg_db_connect_ssl IS 'SSL通道配置信息';
COMMENT ON COLUMN qg_db_connect_ssl.tenant_id IS '租户ID';
COMMENT ON COLUMN qg_db_connect_ssl.connect_id IS '数据库链接信息id';
COMMENT ON COLUMN qg_db_connect_ssl.ca_cert IS 'CA证书';
COMMENT ON COLUMN qg_db_connect_ssl.verify_ca_cert IS '验证CA证书';
COMMENT ON COLUMN qg_db_connect_ssl.client_key IS '客户端秘钥';
COMMENT ON COLUMN qg_db_connect_ssl.client_cert IS '客户端证书';