programs_info/无锡市生命线项目/其他文件/第七批次修改数据库/message_read.sql

/*
 Navicat Premium Data Transfer

 Source Server         : pgsql政务测试2.22.195.139
 Source Server Type    : PostgreSQL
 Source Server Version : 140010
 Source Host           : 2.22.195.139:54321
 Source Catalog        : citylifeline_db
 Source Schema         : public

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

 Date: 01/08/2024 14:05:39
*/


-- ----------------------------
-- Table structure for message_read
-- ----------------------------
DROP TABLE IF EXISTS "public"."message_read";
CREATE TABLE "public"."message_read" (
  "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "source_id" varchar(128) COLLATE "pg_catalog"."default",
  "user_id" varchar(64) COLLATE "pg_catalog"."default",
  "source_type" varchar(4) COLLATE "pg_catalog"."default",
  "deleted" int4,
  "create_time" timestamp(6),
  "update_time" timestamp(6),
  "creater_id" varchar(64) COLLATE "pg_catalog"."default",
  "updater_id" varchar(64) COLLATE "pg_catalog"."default",
  "is_read" int4,
  "remark" varchar(255) COLLATE "pg_catalog"."default",
  "source_id2" varchar(255) COLLATE "pg_catalog"."default",
  "name" varchar(1000) COLLATE "pg_catalog"."default"
)
;
COMMENT ON COLUMN "public"."message_read"."id" IS 'id';
COMMENT ON COLUMN "public"."message_read"."source_id" IS '原表id';
COMMENT ON COLUMN "public"."message_read"."user_id" IS '推送用户id';
COMMENT ON COLUMN "public"."message_read"."source_type" IS '原表映射关系(''1'':warning_info[预警管理表],2:industry_supervision_report行业公告查看,3:work_order_admin工单管理,4用户对应急专家zy_js_yjzj,5应急专家对用户chat_topic)';
COMMENT ON COLUMN "public"."message_read"."deleted" IS '1不删除0已经删除';
COMMENT ON COLUMN "public"."message_read"."create_time" IS '创建时间';
COMMENT ON COLUMN "public"."message_read"."update_time" IS '修改时间';
COMMENT ON COLUMN "public"."message_read"."creater_id" IS '创建人id';
COMMENT ON COLUMN "public"."message_read"."updater_id" IS '修改人id';
COMMENT ON COLUMN "public"."message_read"."is_read" IS '是否已读1已读,0未读';
COMMENT ON COLUMN "public"."message_read"."remark" IS '备注';
COMMENT ON COLUMN "public"."message_read"."source_id2" IS '原表id2';
COMMENT ON COLUMN "public"."message_read"."name" IS '名称';
COMMENT ON TABLE "public"."message_read" IS '生命线首页_消息通知';

-- ----------------------------
-- Primary Key structure for table message_read
-- ----------------------------
ALTER TABLE "public"."message_read" ADD CONSTRAINT "notice_read_pkey" PRIMARY KEY ("id");