qg.sql
9.38 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
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
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),
"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';