Sketch
Sketch Basketball Website ERD
Tables (18)
Banner (banner)
- Banner ID (id) — varchar (40) — Primary key — NOT NULL
- Datetime of Creation (created_at) — datetime — NOT NULL
- Datetime of Update (updated_at) — datetime — NOT NULL
- Banner Source URL (url) — varchar (100)
- Type (type) — enum(`Image`, `Video`) — NOT NULL
- Is Live (is_live) — boolean
- Priority (priority) — int
Board (board)
- Board ID (id) — varchar (40) — Primary key — NOT NULL
- Datetime of Creation (created_at) — datetime — NOT NULL
- Datetime of Update (updated_at) — datetime — NOT NULL
- Name (name) — enum(`NEWS`, `SKETCH_TALK_ADULT`, `SKETCH_TALK_YOUTH`) — NOT NULL
Hashtag (hashtag)
- Hashtag ID (id) — varchar (40) — Primary key — NOT NULL
- Datetime of Creation (created_at) — datetime — NOT NULL
- Datetime of Update (updated_at) — datetime — NOT NULL
- Name (name) — varchar (20)
League (league)
- League ID (id) — varchar (40) — Primary key — NOT NULL
- Datetime of Creation (created_at) — datetime — NOT NULL
- Dateime of Update (updated_at) — datetime — NOT NULL
- Name (name) — varchar (80)
- Abbreviation (abv) — varchar (40)
- League Priority (priority) — int
- Category (Field) — enum (`SKETCH`, `KOREAN`, `YOUTH`, `CORPORATE`, `TRAINING`, `OTHERS`)
Match (match)
- Match ID (id) — varchar (40) — Primary key — NOT NULL
- Season ID (id2) — varchar (40) — Foreign key → Season.Season ID — NOT NULL
- Datetime of Creation (created_at) — datetime — NOT NULL
- Datetime of Update (updated_at) — datetime — NOT NULL
- Match Schedule (scheduled_at) — datetime — NOT NULL
- Location (location) — varchar (100) — NOT NULL
- Match Type (match_type) — enum(`League`, `Playoff`, `Semifinal`, `Final`, `Event`)
- Match Name (match_name) — varchar (30) — NOT NULL
- Forfeited Team (forfeit) — enum(`Null`, `HomeTeamForfeit`, `AwayTeamForfeit`)
- Winner (winner) — boolean
- Home Team Score (home_team_score) — int
- Away Team Score (away_team_score) — int
- Home Team ID (home_team_id) — varchar (40) — Foreign key → Team.Team ID — NOT NULL
- Away Tean ID (away_team_id) — varchar (40) — Foreign key → Team.Team ID — NOT NULL
Match Photo (matchphoto)
- Match Photo ID (id) — varchar (40) — Primary key — NOT NULL
- Match ID (match_id) — varchar (40) — Foreign key → Match.Match ID — NOT NULL
- Team ID (team_id) — varchar (40) — Foreign key → Team.Team ID — NOT NULL
- Season ID (id2) — varchar (40) — Foreign key → Match.Season ID — NOT NULL
- Datetime of Creation (created_at) — datetime — NOT NULL
- Datetime of Update (updated_at) — datetime — NOT NULL
- Photo URL (url) — varchar (100)
- Type (type) — enum(`Match`, `Shooting Chart`) — NOT NULL
Match Stat (matchstat)
- Match Stat ID (id) — varchar (40) — Primary key — NOT NULL
- Season Player ID (seasonplayer_id) — varchar (40) — Foreign key → Season Player.Season Player ID — NOT NULL
- Team ID (team_id) — varchar (40) — Foreign key → Season Player.Team ID — NOT NULL
- Match ID (match_id) — varchar (40) — Foreign key → Match.Match ID — NOT NULL
- Season ID (id2) — varchar (40) — Foreign key → Match.Season ID — NOT NULL
- Datetime of Creation (created_at) — datetime — NOT NULL
- Datetime of Update (updated_at) — datetime — NOT NULL
- Minutes (minutes) — int
- Points (points) — int
- Assists (assists) — int
- Defensive Rebounds (def_rebounds) — int
- Offensive_Rebounds (off_rebounds) — int
- Total Rebounds (rebounds) — int
- Field Goal Attempts (field_goal_try) — int
- Field Goal Made (field_goal_made) — int
- Three Point Attempts (three_point_try) — int
- Three Point Made (three_point_made) — int
- Free Throw Attempts (free_throw_try) — int
- Free Throw Made (free_throw_made) — int
- Steals (steals) — int
- Blocks (blocks) — int
- Fouls (fouls) — int
- Turnovers (turnovers) — int
- Shooting Chart URL (shooting_chart) — varchar (100)
- MVP Photo URL (mvp_photo) — varchar (100)
- Is Starter (is_starter) — boolean
- Is Finished (is_finished) — boolean — NOT NULL
Match Video (matchvideo)
- Match Video ID (id) — varchar (40) — Primary key — NOT NULL
- Match ID (match_id) — varchar (40) — Foreign key → Match.Match ID — NOT NULL
- Season ID (id2) — varchar (40) — Foreign key → Match.Season ID — NOT NULL
- Datetime of Creation (created_at) — datetime — NOT NULL
- Datetime of Update (updated_at) — datetime — NOT NULL
- Youtube Video ID (url) — varchar (100)
Player (player)
- Player ID (id) — varchar (40) — Primary key — NOT NULL
- Datetime of Creation (created_at) — datetime — NOT NULL
- Datetime of Update (updated_at) — datetime — NOT NULL
- Name (name) — varchar (40) — UNIQUE
- Profile Photo URL (profile_photo) — varchar (100)
- Weight (weight) — float
- Height (height) — float
- Birthdate (birthdate) — date
- Quote (quote) — varchar (200)
Player Hashtag (playerhashtag)
- Player Hashtag ID (id) — varchar (40) — Primary key — NOT NULL
- Player ID (player_id) — varchar (40) — Foreign key → Player.Player ID — NOT NULL
- Hashtag ID (hashtag_id) — varchar (40) — Foreign key → Hashtag.Hashtag ID — NOT NULL
- Datetime of Creation (created_at) — datetime — NOT NULL
- Datetime of Update (updated_at) — datetime — NOT NULL
Post (post)
- Post ID (id) — varchar (40) — Primary key — NOT NULL
- Board ID (board_id) — varchar (40) — Foreign key → Board.Board ID — NOT NULL
- User ID (user_id) — varchar (40) — Foreign key → User.User ID — NOT NULL
- League ID (league_id) — varchar (40) — Foreign key → League.League ID — NOT NULL
- Datetime of Creation (created_at) — datetime — NOT NULL
- Datetime of Update (updated_at) — datetime — NOT NULL
- Title (title) — varchar (200) — NOT NULL
- Status (status) — enum (`Prioritized`, `Default`, `Hidden`, `Deleted`)
- Content URL (content_url) — varchar (100) — NOT NULL
- Thumbnail Image URL (thumbnail_url) — varchar (100)
- View Count (view_count) — int
Post Image (postimage)
- Post Image ID (id) — varchar (40) — Primary key — NOT NULL
- Post ID (post_id) — varchar (40) — Foreign key → Post.Post ID — NOT NULL
- Datetime of Creation (created_at) — datetime — NOT NULL
- Datetime of Update (updated_at) — datetime — NOT NULL
- Image URL (url) — varchar (100) — NOT NULL
Season (season)
- Season ID (id) — varchar (40) — Primary key — NOT NULL
- League ID (league_id) — varchar (40) — Foreign key → League.League ID — NOT NULL
- Datetime of Creation (created_at) — datetime — NOT NULL
- Datetime of Update (updated_at) — datetime — NOT NULL
- Name (name) — varchar (40)
- Start Date (start_date) — date
- End Date (end_date) — date
Season Player (seasonplayer)
- Season Player ID (id) — varchar (40) — Primary key — NOT NULL
- Team ID (team_id) — varchar (40) — Foreign key → Team.Team ID — NOT NULL
- Player ID (player_id) — varchar (40) — Foreign key → Player.Player ID — NOT NULL
- Season ID (season_id) — varchar (40) — Foreign key → Season.Season ID — NOT NULL
- Datetime of Creation (created__at) — datetime — NOT NULL
- Datetime of Update (updated_at) — datetime — NOT NULL
- Name (name) — varchar (40)
- Position (position) — varchar (15)
- Jersey Number (back_number) — int
- Is Bestfive (is_bestfive) — boolean
Season Team (seasonteam)
- Season Team ID (id) — varchar (40) — Primary key — NOT NULL
- Season ID (season_id) — varchar (40) — Foreign key → Season.Season ID — NOT NULL
- Team ID (team_id) — varchar (40) — Foreign key → Team.Team ID — NOT NULL
- Captain ID (captain_id) — varchar (40) — Foreign key → Player.Player ID
- Datetime of Creation (created_at) — datetime — NOT NULL
- Datetime of Update (updated_at) — datetime — NOT NULL
- Coach Name (coach_name) — varchar (40)
Team (team)
- Team ID (id) — varchar (40) — Primary key — NOT NULL
- Datetime of Creation (created_at) — datetime — NOT NULL
- Datetime of Update (update_at) — datetime — NOT NULL
- Team Name (name) — varchar (40)
- Team Logo (logo) — varchar (100)
User (user)
- User ID (id) — varchar (40) — Primary key — NOT NULL
- Datetime of Creation (created_at) — datetime — NOT NULL
- Datetime of Update (updated_at) — datetime — NOT NULL
- Username (username) — varchar (40) — NOT NULL
- Password (Hashed) (password) — varchar (80) — NOT NULL
- User Status (status) — enum(`ACTIVE`, `INACTIVE`, `DISABLED`)
- Authorization (auth_level) — enum(`SUPER_ADMIN`, `ADMIN`, `USER`)
- Name (name) — varchar (50) — NOT NULL
- Nickname (nickname) — varchar (30) — NOT NULL
- Email (email) — varchar (50) — NOT NULL
- Player ID (player_id) — varchar (40) — Foreign key → Player.Player ID
User Player Request (userplayerrequest)
- Request ID (id) — varchar (40) — Primary key — NOT NULL
- User ID (user_id) — varchar (40) — Foreign key → User.User ID — NOT NULL
- Player ID (player_id) — varchar (40) — Foreign key → Player.Player ID — NOT NULL
- Datetime of Creation (created_at) — datetime — NOT NULL
- Datetime of Update (update_at) — datetime — NOT NULL