TRANS

Tables (5)

ACHIVEMENT

  • NAME — varchar(50)
  • RULE — integer — ACHIVE_RULE

BLACKLIST

  • OPPSEID — varchar(50) — Primary key — NOT NULL — OPPOSEID
  • USERID — varchar(50) — Foreign key → USER.USERID — NOT NULL
  • STATUS — boolean — NOT NULL — STATUS

FRIEND

  • FRIENDID — varchar(50) — Primary key — NOT NULL — FRIENDID
  • USERID — varchar(50) — Foreign key → USER.USERID — NOT NULL
  • STATUS — boolean — NOT NULL — STATUS

GAMEHISTORY

  • GAMEID — integer — Primary key — NOT NULL — GAMEID
  • USERID — varchar(50) — Foreign key → USER.USERID — NOT NULL
  • OPPSEID — varchar(50) — NOT NULL — OPPOSEID
  • WIN — boolean — WIN
  • STATUS — boolean — NOT NULL — STATUS

USER

  • USERID — varchar(50) — Primary key — NOT NULL
  • TWOFACTOR — boolean — NOT NULL — TWOFACTOR
  • TWOFACTOR_DATA — varchar(50) — TWOFACTOR_DATA
  • STATUS — integer — NOT NULL — STATUS