/*
 Navicat Premium Data Transfer

 Source Server         : 生命线前置数据库47.113.226.116
 Source Server Type    : PostgreSQL
 Source Server Version : 140009
 Source Host           : 47.113.226.116:5333
 Source Catalog        : citylifeline_db
 Source Schema         : public

 Target Server Type    : PostgreSQL
 Target Server Version : 140009
 File Encoding         : 65001

 Date: 27/11/2023 11:32:37
*/


-- ----------------------------
-- Table structure for rq_jc_jcxyz
-- ----------------------------
DROP TABLE IF EXISTS "public"."rq_jc_jcxyz";
CREATE TABLE "public"."rq_jc_jcxyz" (
  "bsm" varchar(32) COLLATE "pg_catalog"."default",
  "sbbsm" varchar(64) COLLATE "pg_catalog"."default",
  "bjyz" numeric(10,3),
  "sblx" varchar(32) COLLATE "pg_catalog"."default",
  "jczb" varchar(32) COLLATE "pg_catalog"."default",
  "bz" varchar(255) COLLATE "pg_catalog"."default",
  "tbsj" timestamp(6)
)
;
COMMENT ON COLUMN "public"."rq_jc_jcxyz"."bsm" IS '标识码';
COMMENT ON COLUMN "public"."rq_jc_jcxyz"."sbbsm" IS '设备标识码';
COMMENT ON COLUMN "public"."rq_jc_jcxyz"."bjyz" IS '报警阈值';
COMMENT ON COLUMN "public"."rq_jc_jcxyz"."sblx" IS '设备类型';
COMMENT ON COLUMN "public"."rq_jc_jcxyz"."jczb" IS '监测指标';
COMMENT ON COLUMN "public"."rq_jc_jcxyz"."bz" IS '备注';
COMMENT ON COLUMN "public"."rq_jc_jcxyz"."tbsj" IS '同步时间';
COMMENT ON TABLE "public"."rq_jc_jcxyz" IS '监测项阈值(暂时使用)';