programs_info/无锡市生命线项目/其他文件/第七批次修改数据库/social_public_notice_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 10:12:12
*/


-- ----------------------------
-- Table structure for social_public_notice_read
-- ----------------------------
DROP TABLE IF EXISTS "public"."social_public_notice_read";
CREATE TABLE "public"."social_public_notice_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",
  "create_time" timestamp(6),
  "is_read" int4,
  "remark" varchar(255) COLLATE "pg_catalog"."default"
)
;
COMMENT ON COLUMN "public"."social_public_notice_read"."id" IS 'id';
COMMENT ON COLUMN "public"."social_public_notice_read"."source_id" IS '原表id(social_public_notice)';
COMMENT ON COLUMN "public"."social_public_notice_read"."user_id" IS '用户id';
COMMENT ON COLUMN "public"."social_public_notice_read"."create_time" IS '创建时间';
COMMENT ON COLUMN "public"."social_public_notice_read"."is_read" IS '是否已读1已读,0未读';
COMMENT ON COLUMN "public"."social_public_notice_read"."remark" IS '备注(没有用到)';
COMMENT ON TABLE "public"."social_public_notice_read" IS '通知公告已读未读';

-- ----------------------------
-- Uniques structure for table social_public_notice_read
-- ----------------------------
ALTER TABLE "public"."social_public_notice_read" ADD CONSTRAINT "social_public_notice_read_source_id_user_id_key" UNIQUE ("source_id", "user_id");

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