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 "public"."qg_brain_device_category" (
"id" varchar(36)  NOT NULL,
"name" varchar(100),
"code" varchar(100),
"status" varchar(50),
"tenant_id" varchar(36),
"notes" varchar(500),
"create_time" timestamp(6),
"creator" varchar(36),
"updater" varchar(36),
"update_time" timestamp(6),
CONSTRAINT "qg_brain_device_category_pkey" PRIMARY KEY ("id")
);

COMMENT ON TABLE "public"."qg_brain_device_category" IS '设备类型';
COMMENT ON COLUMN "public"."qg_brain_device_category"."name" IS '设备类型名称';
COMMENT ON COLUMN "public"."qg_brain_device_category"."code" IS '设备类型编码';
COMMENT ON COLUMN "public"."qg_brain_device_category"."status" IS '状态';
COMMENT ON COLUMN "public"."qg_brain_device_category"."notes" IS '备注';

--存放位置
CREATE TABLE "public"."qg_brain_device_position" (
 "id" varchar(36)  NOT NULL,
 "position" varchar(500),
 "status" varchar(50),
 "tenant_id" varchar(36),
 "notes" varchar(500),
 "create_time" timestamp(6),
 "creator" varchar(36),
 "updater" varchar(36),
 "update_time" timestamp(6),
 CONSTRAINT "qg_brain_device_position_pkey" PRIMARY KEY ("id")
);

COMMENT ON TABLE "public"."qg_brain_device_position" IS '存放位置表';
COMMENT ON COLUMN "public"."qg_brain_device_position"."position" IS '存放位置';
COMMENT ON COLUMN "public"."qg_brain_device_position"."status" IS '状态';
COMMENT ON COLUMN "public"."qg_brain_device_position"."notes" IS '备注';

--设备台账
CREATE TABLE "public"."qg_brain_device" (
 "id" varchar(36)  NOT NULL,
 "name" varchar(100),
 "code" varchar(100),
 "model" varchar(100),
 "category_id" varchar(36),
 "position_id" varchar(36),
 "notes" varchar(1000),
 "status" varchar(20),
 "use_dep" varchar(36),
 "service_dep" varchar(36),
 "contact_info" varchar(50),
 "enable_time" timestamp(6),
 "pictures" varchar(500),
 "files" varchar(500),
 "tenant_id" varchar(36),
 "create_time" timestamp(6),
 "creator" varchar(36),
 "updater" varchar(36),
 "update_time" timestamp(6),
 CONSTRAINT "qg_brain_device_pkey" PRIMARY KEY ("id")
);

COMMENT ON TABLE "public"."qg_brain_device" IS '设备台账';
COMMENT ON COLUMN "public"."qg_brain_device"."name" IS '设备名称';
COMMENT ON COLUMN "public"."qg_brain_device"."code" IS '设备编码';
COMMENT ON COLUMN "public"."qg_brain_device"."model" IS '规格型号';
COMMENT ON COLUMN "public"."qg_brain_device"."category_id" IS '设备类型id';
COMMENT ON COLUMN "public"."qg_brain_device"."position_id" IS '存放位置id';
COMMENT ON COLUMN "public"."qg_brain_device"."notes" IS '备注';
COMMENT ON COLUMN "public"."qg_brain_device"."status" IS '当前状态';
COMMENT ON COLUMN "public"."qg_brain_device"."use_dep" IS '使用部门id';
COMMENT ON COLUMN "public"."qg_brain_device"."service_dep" IS '维保部门id';
COMMENT ON COLUMN "public"."qg_brain_device"."contact_info" IS '联系方式';
COMMENT ON COLUMN "public"."qg_brain_device"."enable_time" IS '启用日期';
COMMENT ON COLUMN "public"."qg_brain_device"."pictures" IS '图片ids';
COMMENT ON COLUMN "public"."qg_brain_device"."pictures" IS '文件ids';