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)