github.com/SupenBysz/gf-admin-community@v0.7.4/database/migrations/000019_v0.0.12.up.sql (about)

     1  
     2  -- ----------------------------
     3  -- Table structure for sys_message
     4  -- ----------------------------
     5  DROP TABLE IF EXISTS "public"."sys_message";
     6  CREATE TABLE "public"."sys_message" (
     7                                          "id" int8 NOT NULL,
     8                                          "title" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
     9                                          "summary" varchar(128) COLLATE "pg_catalog"."default",
    10                                          "content" text COLLATE "pg_catalog"."default" NOT NULL,
    11                                          "type" int2 NOT NULL,
    12                                          "link" text COLLATE "pg_catalog"."default",
    13                                          "to_user_ids" text COLLATE "pg_catalog"."default" NOT NULL,
    14                                          "to_user_type" int2,
    15                                          "from_user_id" int8 NOT NULL,
    16                                          "from_user_type" int4,
    17                                          "send_at" timestamptz(6),
    18                                          "ext_json" json,
    19                                          "read_user_ids" text COLLATE "pg_catalog"."default" NOT NULL,
    20                                          "data_identifier" varchar(255) COLLATE "pg_catalog"."default",
    21                                          "created_at" timestamptz(6),
    22                                          "updated_at" timestamptz(6),
    23                                          "deleted_at" timestamptz(6)
    24  )
    25  ;
    26  ALTER TABLE "public"."sys_message" OWNER TO "mianlajie";
    27  COMMENT ON COLUMN "public"."sys_message"."id" IS 'ID';
    28  COMMENT ON COLUMN "public"."sys_message"."title" IS '标题';
    29  COMMENT ON COLUMN "public"."sys_message"."summary" IS '摘要';
    30  COMMENT ON COLUMN "public"."sys_message"."content" IS '内容';
    31  COMMENT ON COLUMN "public"."sys_message"."type" IS '消息类型';
    32  COMMENT ON COLUMN "public"."sys_message"."link" IS '跳转链接';
    33  COMMENT ON COLUMN "public"."sys_message"."to_user_ids" IS '接收者UserIds，允许有多个接收者';
    34  COMMENT ON COLUMN "public"."sys_message"."to_user_type" IS '接收者类型用户类型，和UserType保持一致';
    35  COMMENT ON COLUMN "public"."sys_message"."from_user_id" IS '发送者ID，为-1代表系统消息';
    36  COMMENT ON COLUMN "public"."sys_message"."from_user_type" IS '发送者类型';
    37  COMMENT ON COLUMN "public"."sys_message"."send_at" IS '发送时间';
    38  COMMENT ON COLUMN "public"."sys_message"."ext_json" IS '拓展数据Json';
    39  COMMENT ON COLUMN "public"."sys_message"."read_user_ids" IS '已读用户UserIds';
    40  COMMENT ON COLUMN "public"."sys_message"."data_identifier" IS '关联的数据标识';
    41  
    42  -- ----------------------------
    43  -- Records of sys_message
    44  -- ----------------------------
    45  BEGIN;
    46  COMMIT;
    47  
    48  -- ----------------------------
    49  -- Primary Key structure for table sys_message
    50  -- ----------------------------
    51  ALTER TABLE "public"."sys_message" ADD CONSTRAINT "sys_message_pkey" PRIMARY KEY ("id");
    52  
    53