Create Table OnTime in TiDB

create_table_ontime.sql

CREATE TABLE `ontime` (
  `Year` year(4) NOT NULL DEFAULT '0',
  `Quarter` tinyint(4) NOT NULL DEFAULT '0',
  `Month` tinyint(4) NOT NULL DEFAULT '0',
  `DayofMonth` tinyint(4) NOT NULL DEFAULT '0',
  `DayOfWeek` tinyint(4) NOT NULL DEFAULT '0',
  `FlightDate` date DEFAULT NULL,
  `UniqueCarrier` char(7) NOT NULL DEFAULT '',
  `AirlineID` int(11) NOT NULL DEFAULT '0',
  `Carrier` char(2) NOT NULL DEFAULT '',
  `TailNum` varchar(50) NOT NULL DEFAULT '',
  `FlightNum` varchar(10) NOT NULL DEFAULT '',
  `OriginAirportID` int(11) NOT NULL DEFAULT '0',
  `OriginAirportSeqID` int(11) NOT NULL DEFAULT '0',
  `OriginCityMarketID` int(11) NOT NULL DEFAULT '0',
  `Origin` char(5) NOT NULL DEFAULT '',
  `OriginCityName` varchar(100) NOT NULL DEFAULT '',
  `OriginState` char(2) NOT NULL DEFAULT '',
  `OriginStateFips` varchar(10) NOT NULL DEFAULT '',
  `OriginStateName` varchar(100) NOT NULL DEFAULT '',
  `OriginWac` int(11) NOT NULL DEFAULT '0',
  `DestAirportID` int(11) NOT NULL DEFAULT '0',
  `DestAirportSeqID` int(11) NOT NULL DEFAULT '0',
  `DestCityMarketID` int(11) NOT NULL DEFAULT '0',
  `Dest` char(5) NOT NULL DEFAULT '',
  `DestCityName` varchar(100) NOT NULL DEFAULT '',
  `DestState` char(2) NOT NULL DEFAULT '',
  `DestStateFips` varchar(10) NOT NULL DEFAULT '',
  `DestStateName` varchar(100) NOT NULL DEFAULT '',
  `DestWac` int(11) NOT NULL DEFAULT '0',
  `CRSDepTime` int(11) NOT NULL DEFAULT '0',
  `DepTime` int(11) NOT NULL DEFAULT '0',
  `DepDelay` int(11) NOT NULL DEFAULT '0',
  `DepDelayMinutes` int(11) NOT NULL DEFAULT '0',
  `DepDel15` int(11) NOT NULL DEFAULT '0',
  `DepartureDelayGroups` varchar(20) NOT NULL DEFAULT '',
  `DepTimeBlk` varchar(20) NOT NULL DEFAULT '',
  `TaxiOut` int(11) NOT NULL DEFAULT '0',
  `WheelsOff` int(11) NOT NULL DEFAULT '0',
  `WheelsOn` int(11) NOT NULL DEFAULT '0',
  `TaxiIn` int(11) NOT NULL DEFAULT '0',
  `CRSArrTime` int(11) NOT NULL DEFAULT '0',
  `ArrTime` int(11) NOT NULL DEFAULT '0',
  `ArrDelay` int(11) NOT NULL DEFAULT '0',
  `ArrDelayMinutes` int(11) NOT NULL DEFAULT '0',
  `ArrDel15` int(11) NOT NULL DEFAULT '0',
  `ArrivalDelayGroups` int(11) NOT NULL DEFAULT '0',
  `ArrTimeBlk` varchar(20) NOT NULL DEFAULT '',
  `Cancelled` tinyint(4) NOT NULL DEFAULT '0',
  `CancellationCode` char(1) NOT NULL DEFAULT '',
  `Diverted` tinyint(4) NOT NULL DEFAULT '0',
  `CRSElapsedTime` int(11) NOT NULL DEFAULT '0',
  `ActualElapsedTime` int(11) NOT NULL DEFAULT '0',
  `AirTime` int(11) NOT NULL DEFAULT '0',
  `Flights` int(11) NOT NULL DEFAULT '0',
  `Distance` int(11) NOT NULL DEFAULT '0',
  `DistanceGroup` tinyint(4) NOT NULL DEFAULT '0',
  `CarrierDelay` int(11) NOT NULL DEFAULT '0',
  `WeatherDelay` int(11) NOT NULL DEFAULT '0',
  `NASDelay` int(11) NOT NULL DEFAULT '0',
  `SecurityDelay` int(11) NOT NULL DEFAULT '0',
  `LateAircraftDelay` int(11) NOT NULL DEFAULT '0',
  `FirstDepTime` varchar(10) NOT NULL DEFAULT '',
  `TotalAddGTime` varchar(10) NOT NULL DEFAULT '',
  `LongestAddGTime` varchar(10) NOT NULL DEFAULT '',
  `DivAirportLandings` varchar(10) NOT NULL DEFAULT '',
  `DivReachedDest` varchar(10) NOT NULL DEFAULT '',
  `DivActualElapsedTime` varchar(10) NOT NULL DEFAULT '',
  `DivArrDelay` varchar(10) NOT NULL DEFAULT '',
  `DivDistance` varchar(10) NOT NULL DEFAULT '',
  `Div1Airport` varchar(10) NOT NULL DEFAULT '',
  `Div1AirportID` int(11) NOT NULL DEFAULT '0',
  `Div1AirportSeqID` int(11) NOT NULL DEFAULT '0',
  `Div1WheelsOn` varchar(10) NOT NULL DEFAULT '',
  `Div1TotalGTime` varchar(10) NOT NULL DEFAULT '',
  `Div1LongestGTime` varchar(10) NOT NULL DEFAULT '',
  `Div1WheelsOff` varchar(10) NOT NULL DEFAULT '',
  `Div1TailNum` varchar(10) NOT NULL DEFAULT '',
  `Div2Airport` varchar(10) NOT NULL DEFAULT '',
  `Div2AirportID` int(11) NOT NULL DEFAULT '0',
  `Div2AirportSeqID` int(11) NOT NULL DEFAULT '0',
  `Div2WheelsOn` varchar(10) NOT NULL DEFAULT '',
  `Div2TotalGTime` varchar(10) NOT NULL DEFAULT '',
  `Div2LongestGTime` varchar(10) NOT NULL DEFAULT '',
  `Div2WheelsOff` varchar(10) NOT NULL DEFAULT '',
  `Div2TailNum` varchar(10) NOT NULL DEFAULT '',
  `Div3Airport` varchar(10) NOT NULL DEFAULT '',
  `Div3AirportID` int(11) NOT NULL DEFAULT '0',
  `Div3AirportSeqID` int(11) NOT NULL DEFAULT '0',
  `Div3WheelsOn` varchar(10) NOT NULL DEFAULT '',
  `Div3TotalGTime` varchar(10) NOT NULL DEFAULT '',
  `Div3LongestGTime` varchar(10) NOT NULL DEFAULT '',
  `Div3WheelsOff` varchar(10) NOT NULL DEFAULT '',
  `Div3TailNum` varchar(10) NOT NULL DEFAULT '',
  `Div4Airport` varchar(10) NOT NULL DEFAULT '',
  `Div4AirportID` int(11) NOT NULL DEFAULT '0',
  `Div4AirportSeqID` int(11) NOT NULL DEFAULT '0',
  `Div4WheelsOn` varchar(10) NOT NULL DEFAULT '',
  `Div4TotalGTime` varchar(10) NOT NULL DEFAULT '',
  `Div4LongestGTime` varchar(10) NOT NULL DEFAULT '',
  `Div4WheelsOff` varchar(10) NOT NULL DEFAULT '',
  `Div4TailNum` varchar(10) NOT NULL DEFAULT '',
  `Div5Airport` varchar(10) NOT NULL DEFAULT '',
  `Div5AirportID` int(11) NOT NULL DEFAULT '0',
  `Div5AirportSeqID` int(11) NOT NULL DEFAULT '0',
  `Div5WheelsOn` varchar(10) NOT NULL DEFAULT '',
  `Div5TotalGTime` varchar(10) NOT NULL DEFAULT '',
  `Div5LongestGTime` varchar(10) NOT NULL DEFAULT '',
  `Div5WheelsOff` varchar(10) NOT NULL DEFAULT '',
  `Div5TailNum` varchar(10) DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin