qg.sql
3.93 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
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 '创建用户';