forked from floraachy/xiuos_IoT
76 lines
2.4 KiB
SQL
76 lines
2.4 KiB
SQL
/*
|
|
Navicat Premium Data Transfer
|
|
|
|
Source Server : localdsd
|
|
Source Server Type : PostgreSQL
|
|
Source Server Version : 120012
|
|
Source Host : localhost:5432
|
|
Source Catalog : xiuosiot
|
|
Source Schema : public
|
|
|
|
Target Server Type : PostgreSQL
|
|
Target Server Version : 120012
|
|
File Encoding : 65001
|
|
|
|
Date: 01/12/2022 09:45:33
|
|
*/
|
|
|
|
|
|
-- ----------------------------
|
|
-- Table structure for qjdq_electric
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS "public"."qjdq_electric";
|
|
CREATE TABLE "public"."qjdq_electric" (
|
|
"id" int4 NOT NULL,
|
|
"electric2" numeric(32,2),
|
|
"electric3" numeric(32,2),
|
|
"electric4" numeric(32,2),
|
|
"electric5" numeric(32,2),
|
|
"electric6" numeric(32,2),
|
|
"electric7" numeric(32,2),
|
|
"electric8" numeric(32,2),
|
|
"electric9" numeric(32,2),
|
|
"electric10" numeric(32,2),
|
|
"electric11" numeric(32,2),
|
|
"electric12" numeric(32,2),
|
|
"electric13" numeric(32,2),
|
|
"electric14" numeric(32,2),
|
|
"electric15" numeric(32,2),
|
|
"electric16" numeric(32,2),
|
|
"electric17" numeric(32,2),
|
|
"electric18" numeric(32,2),
|
|
"electric19" numeric(32,2),
|
|
"electric20" numeric(32,2),
|
|
"electric21" numeric(32,2),
|
|
"electric22" numeric(32,2),
|
|
"electric23" numeric(32,2),
|
|
"electric24" numeric(32,2),
|
|
"electric25" numeric(32,2),
|
|
"electric26" numeric(32,2),
|
|
"electric27" numeric(32,2),
|
|
"electric28" numeric(32,2),
|
|
"electric29" numeric(32,2),
|
|
"electric30" numeric(32,2),
|
|
"electric31" numeric(32,2),
|
|
"electric32" numeric(32,2),
|
|
"electric33" numeric(32,2),
|
|
"electric34" numeric(32,2),
|
|
"electric35" numeric(32,2),
|
|
"electric36" numeric(32,2),
|
|
"electric37" numeric(32,2),
|
|
"electric38" numeric(32,2),
|
|
"electric39" numeric(32,2),
|
|
"electric40" numeric(32,2)
|
|
)
|
|
;
|
|
|
|
-- ----------------------------
|
|
-- Records of qjdq_electric
|
|
-- ----------------------------
|
|
INSERT INTO "public"."qjdq_electric" VALUES (1, 431.06, 4333.21, 300.82, 950.45, 419.11, 739.29, 834.95, 1081.94, 225.48, 347.95, 1046.34, 479.82, 360.72, 597.59, 324.69, 819.82, 357.55, 598.83, 704.66, 738.77, 534.65, 628.55, 298.17, 714.69, 380.91, 238.44, 461.27, 857.35, 1102.83, 334.41, 778.34, 243.03, 1086.05, 876.30, 316.14, 863.24, 241.05, 515.37, 395.21);
|
|
|
|
-- ----------------------------
|
|
-- Primary Key structure for table qjdq_electric
|
|
-- ----------------------------
|
|
ALTER TABLE "public"."qjdq_electric" ADD CONSTRAINT "qjdq_electric_pkey" PRIMARY KEY ("id");
|