eventshcema.sql

CREATE TABLE events_ID_temp(
  seq_events INT,
  GAME_ID TEXT,
  YEAR_ID NUM,
  AWAY_TEAM_ID TEXT,
  INN_CT INT,
  BAT_HOME_ID INT,
  OUTS_CT INT,
  BALLS_CT INT,
  STRIKES_CT INT,
  PITCH_SEQ_TX TEXT,
  AWAY_SCORE_CT INT,
  HOME_SCORE_CT INT,
  BAT_ID TEXT,
  BAT_HAND_CD TEXT,
  RESP_BAT_ID TEXT,
  RESP_BAT_HAND_CD TEXT,
  PIT_ID TEXT,
  PIT_HAND_CD TEXT,
  RES_PIT_ID TEXT,
  RES_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 INT,
  BAT_LINEUP_ID INT,
  EVENT_CD INT,
  BAT_EVENT_FL TEXT,
  AB_FL TEXT,
  H_CD INT,
  SH_FL TEXT,
  SF_FL TEXT,
  EVENT_OUTS_CT INT,
  DP_FL TEXT,
  TP_FL TEXT,
  RBI_CT INT,
  WP_FL TEXT,
  PB_FL TEXT,
  FLD_CD INT,
  BATTEDBALL_CD TEXT,
  BUNT_FL TEXT,
  FOUL_FL TEXT,
  BATTEDBALL_LOC_TX TEXT,
  ERR_CT INT,
  ERR1_FLD_CD INT,
  ERR1_CD TEXT,
  ERR2_FLD_CD INT,
  ERR2_CD TEXT,
  ERR3_FLD_CD INT,
  ERR3_CD TEXT,
  BAT_DEST_ID INT,
  RUN1_DEST_ID INT,
  RUN2_DEST_ID INT,
  RUN3_DEST_ID INT,
  BAT_PLAY_TX TEXT,
  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 INT,
  PO1_FLD_CD INT,
  PO2_FLD_CD INT,
  PO3_FLD_CD INT,
  ASS1_FLD_CD INT,
  ASS2_FLD_CD INT,
  ASS3_FLD_CD INT,
  ASS4_FLD_CD INT,
  ASS5_FLD_CD INT,
  EVENT_ID INT,
  HOME_TEAM_ID TEXT,
  BAT_TEAM_ID TEXT,
  FLD_TEAM_ID TEXT,
  BAT_LAST_ID INT,
  INN_NEW_FL TEXT,
  INN_END_FL TEXT,
  START_BAT_SCORE_CT INT,
  START_FLD_SCORE_CT INT,
  INN_RUNS_CT INT,
  GAME_PA_CT INT,
  INN_PA_CT INT,
  PA_NEW_FL TEXT,
  PA_TRUNC_FL TEXT,
  START_BASES_CD INT,
  END_BASES_CD INT,
  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 INT,
  RUN1_LINEUP_ID INT,
  RUN1_ORIGIN_EVENT_ID INT,
  RUN2_FLD_CD INT,
  RUN2_LINEUP_ID INT,
  RUN2_ORIGIN_EVENT_ID INT,
  RUN3_FLD_CD INT,
  RUN3_LINEUP_ID INT,
  RUN3_ORIGIN_EVENT_ID INT,
  RUN1_RESP_CATCH_ID TEXT,
  RUN2_RESP_CATCH_ID TEXT,
  RUN3_RESP_CATCH_ID TEXT,
  PA_BALL_CT INT,
  PA_CALLED_BALL_CT INT,
  PA_INTENT_BALL_CT INT,
  PA_PITCHOUT_BALL_CT INT,
  PA_HIT_BALL_CT INT,
  PA_OTHER_BALL_CT INT,
  PA_STRIKE_CT INT,
  PA_CALLED_STRIKE_CT INT,
  PA_SWINGMISS_STRIKE_CT INT,
  PA_FOUL_STRIKE_CT INT,
  PA_BIP_STRIKE_CT INT,
  PA_OTHER_STRIKE_CT INT,
  EVENT_RUNS_CT INT,
  FLD_ID TEXT,
  BASE2_FORCE_FL TEXT,
  BASE3_FORCE_FL TEXT,
  BASE4_FORCE_FL TEXT,
  BAT_SAFE_ERR_FL TEXT,
  BAT_FATE_ID INT,
  RUN1_FATE_ID INT,
  RUN2_FATE_ID INT,
  RUN3_FATE_ID INT,
  FATE_RUNS_CT INT,
  ASS6_FLD_CD INT,
  ASS7_FLD_CD INT,
  ASS8_FLD_CD INT,
  ASS9_FLD_CD INT,
  ASS10_FLD_CD INT,
  UNKNOWN_OUT_EXC_FL TEXT,
  UNCERTAIN_PLAY_EXC_FL TEXT,
  HomeTeam TEXT,
  Date INT,
  GameNumber INT,
  PlayNumber INT
);
CREATE INDEX events_id_gameid_idx_temp ON events_ID_temp (`GAME_ID`);
CREATE INDEX events_id_HomeTeamDateGameNumberPlayNumber_idx_temp ON events_ID_temp (HomeTeam, Date, GameNumber, PlayNumber);