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