Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
CREATE TABLE `s_retrosheet_events` (
`GAME_ID` TEXT,
`AWAY_TEAM_ID` TEXT,
`INN_CT` BIGINT DEFAULT NULL,
`BAT_HOME_ID` BIGINT DEFAULT NULL,
`OUTS_CT` BIGINT DEFAULT NULL,
`BALLS_CT` BIGINT DEFAULT NULL,
`STRIKES_CT` BIGINT DEFAULT NULL,
`PITCH_SEQ_TX` TEXT,
`AWAY_SCORE_CT` BIGINT DEFAULT NULL,
`HOME_SCORE_CT` BIGINT DEFAULT NULL,
`BAT_ID` TEXT,
`BAT_HAND_CD` TEXT,
`RESP_BAT_ID` TEXT,
`RESP_BAT_HAND_CD` TEXT,
`PIT_ID` TEXT,
`PIT_HAND_CD` TEXT,
`RESP_PIT_ID` TEXT,
`RESP_PIT_HAND_CD` TEXT,
`POS2_FLD_ID` TEXT,
`POS3_FLD_ID` TEXT,
`POS4_FLD_ID` TEXT,
`POS5_FLD_ID` TEXT,
`POS6_FLD_ID` TEXT,
`POS7_FLD_ID` TEXT,
`POS8_FLD_ID` TEXT,
`POS9_FLD_ID` TEXT,
`BASE1_RUN_ID` TEXT,
`BASE2_RUN_ID` TEXT,
`BASE3_RUN_ID` TEXT,
`EVENT_TX` TEXT,
`LEADOFF_FL` TEXT,
`PH_FL` TEXT,
`BAT_FLD_CD` BIGINT DEFAULT NULL,
`BAT_LINEUP_ID` BIGINT DEFAULT NULL,
`EVENT_CD` BIGINT DEFAULT NULL,
`BAT_EVENT_FL` TEXT,
`AB_FL` TEXT,
`H_CD` BIGINT DEFAULT NULL,
`SH_FL` TEXT,
`SF_FL` TEXT,
`EVENT_OUTS_CT` BIGINT DEFAULT NULL,
`DP_FL` TEXT,
`TP_FL` TEXT,
`RBI_CT` BIGINT DEFAULT NULL,
`WP_FL` TEXT,
`PB_FL` TEXT,
`FLD_CD` BIGINT DEFAULT NULL,
`BATTEDBALL_CD` TEXT,
`BUNT_FL` TEXT,
`FOUL_FL` TEXT,
`BATTEDBALL_LOC_TX` TEXT,
`ERR_CT` BIGINT DEFAULT NULL,
`ERR1_FLD_CD` BIGINT DEFAULT NULL,
`ERR1_CD` TEXT,
`ERR2_FLD_CD` BIGINT DEFAULT NULL,
`ERR2_CD` TEXT,
`ERR3_FLD_CD` BIGINT DEFAULT NULL,
`ERR3_CD` TEXT,
`BAT_DEST_ID` BIGINT DEFAULT NULL,
`RUN1_DEST_ID` BIGINT DEFAULT NULL,
`RUN2_DEST_ID` BIGINT DEFAULT NULL,
`RUN3_DEST_ID` BIGINT DEFAULT NULL,
`BAT_PLAY_TX` DOUBLE DEFAULT NULL,
`RUN1_PLAY_TX` TEXT,
`RUN2_PLAY_TX` TEXT,
`RUN3_PLAY_TX` TEXT,
`RUN1_SB_FL` TEXT,
`RUN2_SB_FL` TEXT,
`RUN3_SB_FL` TEXT,
`RUN1_CS_FL` TEXT,
`RUN2_CS_FL` TEXT,
`RUN3_CS_FL` TEXT,
`RUN1_PK_FL` TEXT,
`RUN2_PK_FL` TEXT,
`RUN3_PK_FL` TEXT,
`RUN1_RESP_PIT_ID` TEXT,
`RUN2_RESP_PIT_ID` TEXT,
`RUN3_RESP_PIT_ID` TEXT,
`GAME_NEW_FL` TEXT,
`GAME_END_FL` TEXT,
`PR_RUN1_FL` TEXT,
`PR_RUN2_FL` TEXT,
`PR_RUN3_FL` TEXT,
`REMOVED_FOR_PR_RUN1_ID` TEXT,
`REMOVED_FOR_PR_RUN2_ID` TEXT,
`REMOVED_FOR_PR_RUN3_ID` TEXT,
`REMOVED_FOR_PH_BAT_ID` TEXT,
`REMOVED_FOR_PH_BAT_FLD_CD` BIGINT DEFAULT NULL,
`PO1_FLD_CD` BIGINT DEFAULT NULL,
`PO2_FLD_CD` BIGINT DEFAULT NULL,
`PO3_FLD_CD` BIGINT DEFAULT NULL,
`ASS1_FLD_CD` BIGINT DEFAULT NULL,
`ASS2_FLD_CD` BIGINT DEFAULT NULL,
`ASS3_FLD_CD` BIGINT DEFAULT NULL,
`ASS4_FLD_CD` BIGINT DEFAULT NULL,
`ASS5_FLD_CD` BIGINT DEFAULT NULL,
`EVENT_ID` BIGINT DEFAULT NULL,
`HOME_TEAM_ID` TEXT,
`BAT_TEAM_ID` TEXT,
`FLD_TEAM_ID` TEXT,
`BAT_LAST_ID` BIGINT DEFAULT NULL,
`INN_NEW_FL` TEXT,
`INN_END_FL` TEXT,
`START_BAT_SCORE_CT` BIGINT DEFAULT NULL,
`START_FLD_SCORE_CT` BIGINT DEFAULT NULL,
`INN_RUNS_CT` BIGINT DEFAULT NULL,
`GAME_PA_CT` BIGINT DEFAULT NULL,
`INN_PA_CT` BIGINT DEFAULT NULL,
`PA_NEW_FL` TEXT,
`PA_TRUNC_FL` TEXT,
`START_BASES_CD` BIGINT DEFAULT NULL,
`END_BASES_CD` BIGINT DEFAULT NULL,
`BAT_START_FL` TEXT,
`RESP_BAT_START_FL` TEXT,
`BAT_ON_DECK_ID` TEXT,
`BAT_IN_HOLD_ID` TEXT,
`PIT_START_FL` TEXT,
`RESP_PIT_START_FL` TEXT,
`RUN1_FLD_CD` BIGINT DEFAULT NULL,
`RUN1_LINEUP_CD` BIGINT DEFAULT NULL,
`RUN1_ORIGIN_EVENT_ID` BIGINT DEFAULT NULL,
`RUN2_FLD_CD` BIGINT DEFAULT NULL,
`RUN2_LINEUP_CD` BIGINT DEFAULT NULL,
`RUN2_ORIGIN_EVENT_ID` BIGINT DEFAULT NULL,
`RUN3_FLD_CD` BIGINT DEFAULT NULL,
`RUN3_LINEUP_CD` BIGINT DEFAULT NULL,
`RUN3_ORIGIN_EVENT_ID` BIGINT DEFAULT NULL,
`RUN1_RESP_CAT_ID` TEXT,
`RUN2_RESP_CAT_ID` TEXT,
`RUN3_RESP_CAT_ID` TEXT,
`PA_BALL_CT` BIGINT DEFAULT NULL,
`PA_CALLED_BALL_CT` BIGINT DEFAULT NULL,
`PA_INTENT_BALL_CT` BIGINT DEFAULT NULL,
`PA_PITCHOUT_BALL_CT` BIGINT DEFAULT NULL,
`PA_HITBATTER_BALL_CT` BIGINT DEFAULT NULL,
`PA_OTHER_BALL_CT` BIGINT DEFAULT NULL,
`PA_STRIKE_CT` BIGINT DEFAULT NULL,
`PA_CALLED_STRIKE_CT` BIGINT DEFAULT NULL,
`PA_SWINGMISS_STRIKE_CT` BIGINT DEFAULT NULL,
`PA_FOUL_STRIKE_CT` BIGINT DEFAULT NULL,
`PA_INPLAY_STRIKE_CT` BIGINT DEFAULT NULL,
`PA_OTHER_STRIKE_CT` BIGINT DEFAULT NULL,
`EVENT_RUNS_CT` BIGINT DEFAULT NULL,
`FLD_ID` TEXT,
`BASE2_FORCE_FL` TEXT,
`BASE3_FORCE_FL` TEXT,
`BASE4_FORCE_FL` TEXT,
`BAT_SAFE_ERR_FL` TEXT,
`BAT_FATE_ID` BIGINT DEFAULT NULL,
`RUN1_FATE_ID` BIGINT DEFAULT NULL,
`RUN2_FATE_ID` BIGINT DEFAULT NULL,
`RUN3_FATE_ID` BIGINT DEFAULT NULL,
`FATE_RUNS_CT` BIGINT DEFAULT NULL,
`ASS6_FLD_CD` BIGINT DEFAULT NULL,
`ASS7_FLD_CD` BIGINT DEFAULT NULL,
`ASS8_FLD_CD` BIGINT DEFAULT NULL,
`ASS9_FLD_CD` BIGINT DEFAULT NULL,
`ASS10_FLD_CD` BIGINT DEFAULT NULL
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.