CREATE TABLE "public"."qg_malfunction_reason" (
     "id" varchar(36)  NOT NULL,
     "code" varchar(50),
     "reason" varchar(200),
     "tenant_id" varchar(36),
     "create_time" timestamp(6),
     "creator" varchar(36),
     "updater" varchar(36),
     "update_time" timestamp(6),
     "remark" varchar(255),
     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"."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);

COMMENT ON COLUMN "public"."device"."director_id" IS '负责人id';


CREATE TABLE "public"."qg_repair_order" (
    "id" varchar(36)  NOT NULL,
    "device_id" varchar(36),
    "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),
    "remark" varchar(255),
    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,
    "order_id" varchar(36),
    "repair_date" timestamp(6),
    "repair_by" varchar(36),
    "description" varchar(500),
    "tenant_id" varchar(36),
    "create_time" timestamp(6),
    "creator" varchar(36),
    "updater" varchar(36),
    "update_time" timestamp(6),
    "remark" varchar(255),
    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),
    "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"."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),
    "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 '方案明细';

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),
    "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 '方案明细';

CREATE TABLE "public"."qg_inspection_record"
(
    "id"                 varchar(36) PRIMARY KEY,
    "code"               varchar(50) NOT NULL,
    "inspection_plan_id" varchar(36),
    "tenant_id"          varchar(36),
    "check_date"         timestamp(6),
    "record_result"      bool,
    "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"."tenant_id" IS '巡检人';
COMMENT ON COLUMN "public"."qg_inspection_record"."check_date" IS '巡检结果';
COMMENT ON COLUMN "public"."qg_inspection_record"."record_result" IS '巡检结果';

CREATE TABLE "public"."qg_inspection_details"
(
    "id"              varchar(36) PRIMARY KEY,
    "check_device_id" varchar(36),
    "plan_details"    varchar(255),
    "record_result"   bool,
    "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 '巡检结果';