| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950 |
- /*
- 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:33:36
- */
- -- ----------------------------
- -- Table structure for sg_jc_jcxyz
- -- ----------------------------
- DROP TABLE IF EXISTS "public"."sg_jc_jcxyz";
- CREATE TABLE "public"."sg_jc_jcxyz" (
- "bsm" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
- "sbbsm" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
- "sblx" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
- "jczb" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
- "bjyz" numeric(13,3) NOT NULL,
- "bz" varchar(255) COLLATE "pg_catalog"."default",
- "yskzjbz" varchar(64) COLLATE "pg_catalog"."default",
- "sjtbzt" varchar(16) COLLATE "pg_catalog"."default" NOT NULL,
- "tbsj" timestamp(6) NOT NULL
- )
- ;
- COMMENT ON COLUMN "public"."sg_jc_jcxyz"."bsm" IS '标识码';
- COMMENT ON COLUMN "public"."sg_jc_jcxyz"."sbbsm" IS '设备标识码';
- COMMENT ON COLUMN "public"."sg_jc_jcxyz"."sblx" IS '设备类型';
- COMMENT ON COLUMN "public"."sg_jc_jcxyz"."jczb" IS '监测指标';
- COMMENT ON COLUMN "public"."sg_jc_jcxyz"."bjyz" IS '报警阈值';
- COMMENT ON COLUMN "public"."sg_jc_jcxyz"."bz" IS '备注';
- COMMENT ON COLUMN "public"."sg_jc_jcxyz"."yskzjbz" IS '原始库主键标志';
- COMMENT ON COLUMN "public"."sg_jc_jcxyz"."sjtbzt" IS '数据同步状态';
- COMMENT ON COLUMN "public"."sg_jc_jcxyz"."tbsj" IS '同步时间';
- COMMENT ON TABLE "public"."sg_jc_jcxyz" IS '监测项阈值属性结构表';
- -- ----------------------------
- -- Primary Key structure for table sg_jc_jcxyz
- -- ----------------------------
- ALTER TABLE "public"."sg_jc_jcxyz" ADD CONSTRAINT "sg_jc_jcxyz_pkey" PRIMARY KEY ("bsm");
|
