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