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

     1  CREATE TABLE "public"."sys_invite" (
     2                                     "id" int8 NOT NULL,
     3                                     "user_id" int8 NOT NULL,
     4                                     "value" json,
     5                                     "expire_at" timestamptz,
     6                                     "activate_number" int2,
     7                                     "state" int2 NOT NULL DEFAULT 1,
     8                                     "type" int2 NOT NULL,
     9                                     "created_at" timestamptz,
    10                                     PRIMARY KEY ("id")
    11  )
    12  ;
    13  
    14  COMMENT ON COLUMN "public"."sys_invite"."id" IS 'ID';
    15  
    16  COMMENT ON COLUMN "public"."sys_invite"."user_id" IS '用户ID, 也就是邀约人ID';
    17  
    18  COMMENT ON COLUMN "public"."sys_invite"."value" IS '邀约Json数据';
    19  
    20  COMMENT ON COLUMN "public"."sys_invite"."expire_at" IS '邀约码背后的关联业务数据,';
    21  
    22  COMMENT ON COLUMN "public"."sys_invite"."activate_number" IS '邀约码的激活次数限制';
    23  
    24  COMMENT ON COLUMN "public"."sys_invite"."state" IS '状态： 0失效、1正常';
    25  
    26  COMMENT ON COLUMN "public"."sys_invite"."type" IS '类型： 1注册、2加入团队、4加入角色 (复合类型)';
    27  
    28      COMMENT ON COLUMN "public"."sys_invite"."value" IS '邀约码背后的关联业务Json数据,';
    29  
    30  COMMENT ON COLUMN "public"."sys_invite"."expire_at" IS '邀约码的过期失效';