account_db

테이블 (4)

Untitled (t_ban_account_info)

  • userid — bigint — 외래 키 → 전체계정정보.userid — NOT NULL
  • Field (banType) — smallint
  • Field (createTime) — datetime
  • Field (expireTime) — datetime

Untitled (t_whitelist)

  • userid — bigint — 외래 키 → 전체계정정보.userid — NOT NULL
  • Field (description) — varchar(255)
  • Field (isDeleted) — boolean
  • Field (createTime) — datetime
  • Field (updateTime) — datetime
  • Field (createdBy) — varchar(20)
  • Field (updatedBy) — varchar(20)

샤드정보 (t_account_shard_info)

  • Key2 (serverKey) — varchar(200) — 기본 키 — NOT NULL
  • userid — bigint — 외래 키 → 전체계정정보.userid — NOT NULL
  • dbShardKey — smallint
  • Field (createTime) — datetime

전체계정정보 (t_account_info)

  • userid — bigint — 기본 키 — NOT NULL
  • publisher_id (accountName) — varchar(80)
  • 생성시간 (createTime) — datetime
  • 마지막로그인시간 (lastLoginTime) — datetime