| 1234567891011121314151617181920212223242526272829303132333435363738394041 |
- /*
- 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 '监测项阈值(暂时使用)';
|
