140 lines
10 KiB
SQL
140 lines
10 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: 18/04/2023 15:07:48
|
|
*/
|
|
|
|
|
|
-- ----------------------------
|
|
-- Table structure for fz_device_info
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS "public"."fz_device_info";
|
|
CREATE TABLE "public"."fz_device_info" (
|
|
"fz_device_no" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
|
|
"fz_device_status" varchar(32) COLLATE "pg_catalog"."default",
|
|
"fz_device_type" varchar(64) COLLATE "pg_catalog"."default",
|
|
"fz_device_user" varchar(64) COLLATE "pg_catalog"."default",
|
|
"fz_outtime" varchar(255) COLLATE "pg_catalog"."default",
|
|
"fz_remark" varchar(255) COLLATE "pg_catalog"."default"
|
|
)
|
|
;
|
|
COMMENT ON COLUMN "public"."fz_device_info"."fz_device_no" IS '设备编号';
|
|
COMMENT ON COLUMN "public"."fz_device_info"."fz_device_status" IS '设备状态';
|
|
COMMENT ON COLUMN "public"."fz_device_info"."fz_device_type" IS '设备类型';
|
|
COMMENT ON COLUMN "public"."fz_device_info"."fz_device_user" IS '设备使用人';
|
|
COMMENT ON COLUMN "public"."fz_device_info"."fz_outtime" IS '设备出库时间';
|
|
COMMENT ON COLUMN "public"."fz_device_info"."fz_remark" IS '备注信息
|
|
';
|
|
|
|
-- ----------------------------
|
|
-- Records of fz_device_info
|
|
-- ----------------------------
|
|
INSERT INTO "public"."fz_device_info" VALUES ('3559A 5G-3', '', '矽灵通RISCV', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('3559A 5G-4', '盒在', '矽灵通RISCV', '部署杭萧', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('3559A 5G-5', '', '矽灵通RISCV', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('3559A 5G-6', '售出', '矽灵通RISCV', '山东大学', '20220602', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('3559A 5G-7', '盒在', '矽灵通RISCV', '展架', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('3559A 5G-8', '', '矽灵通RISCV', '毕志勇', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('3559A 5G-9', '盒在', '矽灵通RISCV', '部署杭萧', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('3559A 5G-10', '', '矽灵通RISCV', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('3559A 4G-1', '', '矽灵通ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('3559A 4G-2', '', '矽灵通ARN', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('3559A 4G-3', '', '矽灵通ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('3559A 4G-4', '', '矽灵通ARM', '毕志勇', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('3559A 4G-5', '', '矽灵通ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('3559A 4G-6', '', '矽灵通ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('3559A 4G-7', '', '矽灵通ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('3559A 4G-8', '', '矽灵通ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('3559A 4G-9', '', '矽灵通ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('3559A 4G-10', '', '矽灵通ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('M7 A7 5G-1', '', '矽望通', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('M7 A7 5G-2', '', '矽望通', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('M7 A7 5G-3', '', '矽望通', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('M7 A7 5G-4', '', '矽望通', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('M7 A7 5G-5', '', '矽望通', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('M7 A7 5G-6', '', '矽望通', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('M7 A7 5G-7', '', '矽望通', '刘伟超', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('M7 A7 5G-8', '', '矽望通', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('M7 A7 5G-9', '', '矽望通', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('M7 A7 5G-10', '', '矽望通', '薛', '20220818', '江西师范');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('MLU220 5G-1', '售出', '矽慧通', '山东大学', '20220602', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('MLU220 5G-2', '售出', '矽慧通', '山东大学', '20220602', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('MLU220 5G-3', '', '矽望通', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('MLU220 5G-4', '', '矽望通', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('MLU220 5G-5', '', '矽望通', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('MLU220 5G-6', '', '矽望通', '郭琦康', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('MLU220 5G-7', '', '矽望通', '薛栋梁', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('MLU220 5G-8', '', '矽望通', '刘永恺', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('MLU220 5G-9', '', '矽望通', '', '', '坏');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('MLU220 5G-10', '', '矽望通', '郭琦康', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('RISCV 4G-1', '', '矽达通RISCV', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('RISCV 4G-2', '', '矽达通RISCV', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('RISCV 4G-3', '', '矽达通RISCV', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('RISCV 4G-4', '', '矽达通RISCV', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('RISCV 4G-5', '', '矽达通RISCV', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('RISCV 4G-6', '', '矽达通RISCV', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('RISCV 4G-7', '', '矽达通RISCV', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('RISCV 4G-8', '', '矽达通RISCV', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('RISCV 4G-9', '', '矽达通RISCV', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('RISCV 4G-10', '', '矽达通RISCV', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('ARM 4G-1', '', '矽达通ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('ARM 4G-2', '', '矽达通ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('ARM 4G-3', '', '矽达通ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('ARM 4G-4', '', '矽达通ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('ARM 4G-5', '', '矽达通ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('ARM 4G-6', '', '矽达通ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('ARM 4G-7', '', '矽达通ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('ARM 4G-8', '', '矽达通ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('ARM 4G-9', '', '矽达通ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('ARM 4G-10', '', '矽达通ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('RISCV-1', '', 'AIIT-RISCV', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('ARM-1', '', 'AIIT-ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('ARM-2', '', 'AIIT-ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('ARM-3', '', 'AIIT-ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('ARM-4', '', 'AIIT-ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('ARM-5', '', 'AIIT-ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('ARM-6', '', 'AIIT-ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('ARM-7', '', 'AIIT-ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('ARM-8', '', 'AIIT-ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('ARM-9', '', 'AIIT-ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('ARM-10', '', 'AIIT-ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('CR1', '', '教学型RISCV', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('CR2', '', '教学型RISCV', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('CR3', '', '教学型RISCV', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('CR4', '', '教学型RISCV', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('CR5', '', '教学型RISCV', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('CR6', '', '教学型RISCV', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('CR7', '', '教学型RISCV', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('CR8', '', '教学型RISCV', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('CR9', '', '教学型RISCV', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('CR10', '', '教学型RISCV', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('CA1', '', '教学型ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('CA2', '', '教学型ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('CA3', '', '教学型ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('CA4', '', '教学型ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('CA5', '', '教学型ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('CA6', '', '教学型ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('CA7', '', '教学型ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('CA8', '', '教学型ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('CA9', '', '教学型ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('CA10', '', '教学型ARM', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('3559A 5G-1', '盒在', '矽灵通RISCV', '展架', '2023-2-2', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('3559A 5G-2', '盒在', '矽灵通RISCV', '', '', '');
|
|
INSERT INTO "public"."fz_device_info" VALUES ('3559A 5G-100', NULL, NULL, NULL, NULL, NULL);
|
|
|
|
-- ----------------------------
|
|
-- Primary Key structure for table fz_device_info
|
|
-- ----------------------------
|
|
ALTER TABLE "public"."fz_device_info" ADD CONSTRAINT "fz_device_info_pkey" PRIMARY KEY ("fz_device_no");
|