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)