CREATE TABLE http_ontime_03 (
    Year SMALLINT UNSIGNED,
    Quarter TINYINT UNSIGNED,
    Month TINYINT UNSIGNED,
    DayofMonth TINYINT UNSIGNED,
    DayOfWeek TINYINT UNSIGNED,
    FlightDate DATE,
    Reporting_Airline VARCHAR,
    DOT_ID_Reporting_Airline INT,
    IATA_CODE_Reporting_Airline VARCHAR,
    Tail_Number VARCHAR,
    Flight_Number_Reporting_Airline VARCHAR,
    OriginAirportID INT,
    OriginAirportSeqID INT,
    OriginCityMarketID INT,
    Origin VARCHAR,
    OriginCityName VARCHAR,
    OriginState VARCHAR,
    OriginStateFips VARCHAR,
    OriginStateName VARCHAR,
    OriginWac INT,
    DestAirportID INT,
    DestAirportSeqID INT,
    DestCityMarketID INT,
    Dest VARCHAR,
    DestCityName VARCHAR,
    DestState VARCHAR,
    DestStateFips VARCHAR,
    DestStateName VARCHAR,
    DestWac INT,
    CRSDepTime INT,
    DepTime INT,
    DepDelay INT,
    DepDelayMinutes INT,
    DepDel15 INT,
    DepartureDelayGroups VARCHAR,
    DepTimeBlk VARCHAR,
    TaxiOut INT,
    WheelsOff INT,
    WheelsOn INT,
    TaxiIn INT,
    CRSArrTime INT,
    ArrTime INT,
    ArrDelay INT,
    ArrDelayMinutes INT,
    ArrDel15 INT,
    ArrivalDelayGroups INT,
    ArrTimeBlk VARCHAR,
    Cancelled TINYINT UNSIGNED,
    CancellationCode VARCHAR,
    Diverted TINYINT UNSIGNED,
    CRSElapsedTime INT,
    ActualElapsedTime INT,
    AirTime INT,
    Flights INT,
    Distance INT,
    DistanceGroup TINYINT UNSIGNED,
    CarrierDelay INT,
    WeatherDelay INT,
    NASDelay INT,
    SecurityDelay INT,
    LateAircraftDelay INT,
    FirstDepTime VARCHAR,
    TotalAddGTime VARCHAR,
    LongestAddGTime VARCHAR,
    DivAirportLandings VARCHAR,
    DivReachedDest VARCHAR,
    DivActualElapsedTime VARCHAR,
    DivArrDelay VARCHAR,
    DivDistance VARCHAR,
    Div1Airport VARCHAR,
    Div1AirportID INT,
    Div1AirportSeqID INT,
    Div1WheelsOn VARCHAR,
    Div1TotalGTime VARCHAR,
    Div1LongestGTime VARCHAR,
    Div1WheelsOff VARCHAR,
    Div1TailNum VARCHAR,
    Div2Airport VARCHAR,
    Div2AirportID INT,
    Div2AirportSeqID INT,
    Div2WheelsOn VARCHAR,
    Div2TotalGTime VARCHAR,
    Div2LongestGTime VARCHAR,
    Div2WheelsOff VARCHAR,
    Div2TailNum VARCHAR,
    Div3Airport VARCHAR,
    Div3AirportID INT,
    Div3AirportSeqID INT,
    Div3WheelsOn VARCHAR,
    Div3TotalGTime VARCHAR,
    Div3LongestGTime VARCHAR,
    Div3WheelsOff VARCHAR,
    Div3TailNum VARCHAR,
    Div4Airport VARCHAR,
    Div4AirportID INT,
    Div4AirportSeqID INT,
    Div4WheelsOn VARCHAR,
    Div4TotalGTime VARCHAR,
    Div4LongestGTime VARCHAR,
    Div4WheelsOff VARCHAR,
    Div4TailNum VARCHAR,
    Div5Airport VARCHAR,
    Div5AirportID INT,
    Div5AirportSeqID INT,
    Div5WheelsOn VARCHAR,
    Div5TotalGTime VARCHAR,
    Div5LongestGTime VARCHAR,
    Div5WheelsOff VARCHAR,
    Div5TailNum VARCHAR
);
