kbl

Tables (15)

assist

  • assist_id — INT — Primary key — NOT NULL
  • assist — INT — NOT NULL

block

  • block_id — INT — Primary key — NOT NULL
  • block — INT — NOT NULL

freethrow

  • freethrow_id — INT — Primary key — NOT NULL
  • freethrow_op — INT — NOT NULL
  • freethrow_dp — INT — NOT NULL
  • freethrow_tp — INT — NOT NULL

game

  • game_id — INT — Primary key — NOT NULL
  • game_name — VARCHAR(255) — NOT NULL
  • game_date — DATE — NOT NULL

game_match

  • match_id — INT — Primary key — NOT NULL
  • winner_id — INT — NOT NULL
  • loser_id — INT — NOT NULL

game_result

  • game_id — INT — Foreign key → game.game_id — NOT NULL
  • team_id — INT — Foreign key → team.team_id — NOT NULL
  • score — INT — NOT NULL

loser

  • loser_id — INT — Primary key — NOT NULL
  • match_id — INT — Foreign key → game_match.match_id — NOT NULL

play_record

  • playrecord_id — INT — Primary key — NOT NULL
  • player_id — INT — Foreign key → player.player_id — NOT NULL
  • steal_id — INT — Foreign key → steal.steal_id — NOT NULL
  • block_id — INT — Foreign key → block.block_id — NOT NULL
  • rebound_id — INT — Foreign key → rebound.rebound_id — NOT NULL
  • assist_id — INT — Foreign key → assist.assist_id — NOT NULL

player

  • player_id — INT — Primary key — NOT NULL
  • player_lname — VARCHAR(255) — NOT NULL
  • player_fname — VARCHAR(255) — NOT NULL
  • team_id — INT — Foreign key → team.team_id — NOT NULL

player_point

  • playpt_id — INT — Primary key — NOT NULL
  • playrecord_id — INT — Foreign key → play_record.playrecord_id — NOT NULL
  • freethrow_id — INT — Foreign key → freethrow.freethrow_id — NOT NULL
  • yathrow_id — INT — Foreign key → yathrow.yathrow_id — NOT NULL

rebound

  • rebound_id — INT — Primary key — NOT NULL
  • rebound_df — INT — NOT NULL
  • rebound_ak — INT — NOT NULL

steal

  • steal_id — INT — Primary key — NOT NULL
  • steal — INT — NOT NULL

team

  • team_id — INT — Primary key — NOT NULL
  • team_name — VARCHAR(255) — NOT NULL
  • team_stadium — VARCHAR(255) — NOT NULL

winner

  • winner_id — INT — Primary key — NOT NULL
  • match_id — INT — Foreign key → game_match.match_id — NOT NULL

yathrow

  • yathrow_id — INT — Primary key — NOT NULL
  • yathrow_dp — INT — NOT NULL
  • yathrow_tp — INT — NOT NULL