test1

Tables (14)

batter_lineup

  • id — VARCHAR(30) — Primary key — NOT NULL
  • match_info_id — VARCHAR(30) — Foreign key → schedule.id — NOT NULL
  • position_id — tinyint — Foreign key → position.id — NOT NULL
  • player_id — bigint(11) — Foreign key → player.player_id — NOT NULL
  • team_id — bigint(11) — Foreign key → player.team_id — NOT NULL
  • order — VARCHAR(10)
  • player_name — VARCHAR(20) — NOT NULL

batter_record

  • id — VARCHAR(30) — Primary key — NOT NULL
  • player_id — bigint(11) — Foreign key → player.player_id — NOT NULL
  • team_id — bigint(11) — Foreign key → team.team_id — NOT NULL
  • position — VARCHAR(10)
  • gs — INT
  • b_order — INT
  • pa — INT
  • ab — INT
  • hits — INT
  • doubles — INT
  • triples — INT
  • homeruns — INT
  • bb — INT
  • ibb — INT
  • hbp — INT
  • so — INT
  • sb — INT
  • cs — INT
  • runs — INT
  • rbi — INT
  • dp — INT
  • sc — INT
  • sf — INT

board

  • board_id — BIGINT — Primary key — NOT NULL
  • user_id (user_id2) — BIGINT — Foreign key → users.user_id — NOT NULL
  • type — VARCHAR(30)
  • team — VARCHAR(30)
  • title — VARCHAR(300)
  • content — VARCHAR(3000)
  • created_at — TIMESTAMP
  • modified_at — TIMESTAMP
  • hits — BIGINT

comment

  • comment_id — BIGINT — Primary key — NOT NULL
  • user_id (user_id2) — BIGINT — Foreign key → users.user_id — NOT NULL
  • board_id (board_id2) — BIGINT — Foreign key → board.board_id — NOT NULL
  • content — VARCHAR(1000)
  • created_at — TIMESTAMP
  • modified_at — TIMESTAMP
  • parent_id — BIGINT

likes

  • user_id (user_id2) — BIGINT — Foreign key → users.user_id — NOT NULL
  • comment_id — BIGINT — Foreign key → comment.comment_id — NOT NULL
  • content_type — VARCHAR(10)

pitcher_lineup

  • id — VARCHAR(30) — Primary key — NOT NULL
  • match_info_id — VARCHAR(30) — Foreign key → schedule.id — NOT NULL
  • player_id — bigint(11) — Foreign key → player.player_id — NOT NULL
  • team_id — bigint(11) — Foreign key → player.team_id — NOT NULL
  • position_id — tinyint — Foreign key → position.id — NOT NULL
  • order — VARCHAR(10)
  • player_name — VARCHAR(20) — NOT NULL

pitcher_record

  • id — VARCHAR(30) — Primary key — NOT NULL
  • player_id — bigint(11) — Foreign key → player.player_id — NOT NULL
  • team_id — bigint(11) — Foreign key → team.team_id — NOT NULL
  • p_order — INT
  • starter — INT
  • decision — VARCHAR(10)
  • innings — DOUBLE
  • runs — INT
  • earned_run — INT
  • tbf — INT
  • ab — INT
  • hits — INT
  • doubles — INT
  • triples — INT
  • homeruns — INT
  • bb — INT
  • ibb — INT
  • hbp — INT
  • so — INT
  • np — INT

player

  • player_id — bigint(11) — Primary key — NOT NULL
  • team_id — bigint(11) — Foreign key → team.team_id — NOT NULL
  • name — VARCHAR(20)
  • birth — DATE
  • position — VARCHAR(10)
  • hand — VARCHAR(10)
  • uniform_number — TINYINT
  • photo_path — VARCHAR(200)

position

  • id — tinyint — Primary key — NOT NULL
  • name — varchar(10)

schedule

  • id — VARCHAR(30) — Primary key — NOT NULL
  • match_date — TIMESTAMP
  • away_team_id — bigint(11)
  • home_team_id — bigint(11)
  • stadium — VARCHAR(30)
  • broadcast — VARCHAR(100)
  • status — VARCHAR(20)

score_board

  • id — VARCHAR(30) — Primary key — NOT NULL
  • away_score — VARCHAR(100)
  • away_runs — SMALLINT
  • away_stats — varchar(50)
  • home_score — VARCHAR(100)
  • home_runs — SMALLINT
  • home_stats — varchar(50)

team

  • team_id — bigint(11) — Primary key — NOT NULL
  • name — VARCHAR(20)
  • location — VARCHAR(10)
  • stadium — VARCHAR(30)
  • foundation_year — YEAR
  • emblem_path — VARCHAR(200)
  • team_color — VARCHAR(20)

team_ranking

  • id — varchar(10) — Primary key — NOT NULL
  • team_id — bigint(11) — Foreign key → team.team_id — NOT NULL
  • season — year — NOT NULL
  • rank — tinyint
  • game — smallint
  • win — smallint
  • lose — smallint
  • draw — smallint

users

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(30)
  • password — VARCHAR(100)
  • nickname — VARCHAR(30)
  • auth_id — BIGINT
  • role — VARCHAR(20)