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