123123

Tables (13)

BETTING_LOGS

  • BET_ID — NUMBER
  • BETTOR_EMAIL — VARCHAR(100)
  • GAME_ID — NUMBER
  • POINTS_BET — NUMBER — NOT NULL
  • POINTS_WON — NUMBER
  • RESULT — VARCHAR(20)
  • CREATED_AT — TIMESTAMP

BLOCKED_USERS

  • BLOCKER_EMAIL — VARCHAR(100)
  • BLOCKED_EMAIL — VARCHAR(100)
  • REASON — VARCHAR(255)
  • BLOCKED_AT — TIMESTAMP

BLUETOOTH_CONNECTION_LOGS

  • LOG_ID — NUMBER
  • DEVICE_ID — NUMBER
  • CONNECTOR_EMAIL — VARCHAR(100)
  • CONNECTED_AT — TIMESTAMP
  • DATA_SENT — VARCHAR(255)
  • DATA_RECEIVED — VARCHAR(255)

BLUETOOTH_DEVICES

  • DEVICE_ID — NUMBER
  • OWNER_EMAIL — VARCHAR(100)
  • DEVICE_NAME — VARCHAR(100)
  • MAC_ADDRESS — VARCHAR(50)
  • LAST_CONNECTED_AT — TIMESTAMP

CHAT_MESSAGE

  • MESSAGE_ID — NUMBER
  • ROOM_ID — NUMBER
  • SENDER_EMAIL — VARCHAR(100)
  • CONTENT — VARCHAR(255)
  • CREATED_AT — TIMESTAMP

CHAT_ROOM

  • ROOM_ID — NUMBER
  • ROOM_NAME — VARCHAR(100)
  • IS_PUBLIC — NUMBER(1)
  • CREATED_AT — TIMESTAMP

GAME_RECORDS

  • GAME_ID — NUMBER
  • EMAIL — VARCHAR(100)
  • SCORE — NUMBER
  • CREATED_AT — TIMESTAMP

MUTE_LIST

  • MUTE_ID — NUMBER
  • MUTE_BY_EMAIL — VARCHAR(100)
  • TARGET_EMAIL — VARCHAR(100)
  • ROOM_ID — NUMBER
  • MUTED_AT — TIMESTAMP

POINT_HISTORY

  • POINT_ID — NUMBER
  • SENDER_EMAIL — VARCHAR(100)
  • RECEIVER_EMAIL — VARCHAR(100)
  • POINTS_CHANGE — NUMBER — NOT NULL
  • REASON — VARCHAR(255)
  • CREATED_AT — TIMESTAMP

REWARD_ITEMS

  • ITEM_ID — NUMBER
  • NAME — VARCHAR(100) — NOT NULL
  • IMAGE_URL — VARCHAR(255)
  • PRICE — NUMBER — NOT NULL
  • DESCRIPTION — VARCHAR(255)
  • REWARD_TYPE — VARCHAR(20)
  • CONDITION_VALUE — NUMBER

USERS

  • EMAIL — VARCHAR(100)
  • PASSWORD — VARCHAR(255) — NOT NULL
  • NICKNAME — VARCHAR(50)
  • NAME — VARCHAR(20)
  • BIRTHDATE — DATE
  • PROFILE_PICTURE_URL — VARCHAR(255)
  • POINTS — NUMBER
  • CHAT_COUNT — NUMBER
  • IS_ACTIVE — NUMBER(1)
  • CREATED_AT — TIMESTAMP

USER_REWARDS

  • ITEM_ID — NUMBER
  • OWNER_EMAIL — VARCHAR(100)
  • SENDER_EMAIL — VARCHAR(100)
  • REDEEMED_AT — TIMESTAMP
  • LAST_REDEEMED_AT — TIMESTAMP

VERIFICATION_TOKENS

  • TOKEN_ID — NUMBER
  • EMAIL — VARCHAR(100)
  • TOKEN — VARCHAR(255)
  • EXPIRES_AT — TIMESTAMP