mlb

Tables (3)

Chat (chat)

  • Chat Id (chat_id) — int — Primary key — NOT NULL
  • Game Id (game_id) — int — Foreign key → Game.Game Id — NOT NULL
  • Home Or Away (team_flag) — varchar(1)
  • Content (content) — varchar2(100)
  • Updated (updated) — varchar2(20)
  • User Name (user_name) — varchar(10)

Game (game)

  • Game Id (game_id) — int — Primary key — NOT NULL
  • home Team (home_team) — varchar(3)
  • Away Team (away_team) — varchar(3)
  • Date (date) — varchar2(20)

User (user)

  • User Id (user_id) — int — Primary key — NOT NULL
  • User Name (user_name) — varchar(10)
  • User Password (user_pwd) — varchar(10)
  • Phone (user_phone) — varchar(15)
  • Email (user_email) — varchar(30)
  • My Team (my_team) — varchar(3)