esb

Tables (5)

ESB_FIMASINARR_RCV (ARR)

  • UNITSYSTEMID (Key) — varchar(4) — Primary key — NOT NULL
  • MESSAGEID (Key2) — varchar(32) — Primary key
  • DATEANDTIME (Key3) — varchar(18) — Primary key — NOT NULL
  • MESSAGETYPE (Field) — varchar(1)
  • FIMS_ID (Field2) — varchar(22)
  • FLIGHTCARRIER (Field3) — varchar(3)
  • FLIGHTCARRIERSHORT (Field4) — varchar(3)
  • FLIGHTNUMBER (Field5) — varchar(4)
  • FLIGHTSUFFIX (Field6) — varchar(1)
  • FLIGHTID (Field7) — varchar(8)
  • PUBLICID (Field8) — varchar(8)
  • SCHEDULED (Field9) — char(12)
  • CODESHARESTATUS (Field10) — varchar(2)
  • MASTERIIS_ID (Field11) — varchar(22)
  • ORIGIN (Field12) — varchar(4)
  • FIRSTAIRPORTSTOP (Field13) — varchar(4)
  • SECONDAIRPORTSTOP (Field14) — varchar(4)
  • THIRDAIRPORTSTOP (Field15) — varchar(4)
  • FOURTHAIRPORTSTOP (Field16) — varchar(4)
  • FIFTHAIRPORTSTOP (Field17) — varchar(4)
  • SIXTHAIRPORTSTOP (Field18) — varchar(4)
  • SEVENTHAIRPORTSTOP (Field19) — varchar(4)
  • EIGHTHAIRPORTSTOP (Field20) — varchar(4)
  • NINTHAIRORTSTOP (Field21) — varchar(4)
  • TENTHAIRPORTSTOP (Field22) — varchar(4)
  • DIVERTEDAIRPORT (Field23) — varchar(4)
  • LINKIIS_ID (Field24) — varchar(22)
  • IRREGULAR (Field25) — varchar(1)
  • TYPEOFFLIGHT (Field26) — varchar(1)
  • SERVICETYPE (Field27) — varchar(1)
  • TRANSIT (Field28) — varchar(1)
  • HANDLINGAGENT (Field29) — varchar(3)
  • REMARKCODEGENERAL (Field30) — varchar(3)
  • REMARKCODESTAFF (Field31) — varchar(3)
  • REMARKCODEBAGGAGE (Field32) — varchar(3)
  • REMARKCODELANDSIDE (Field33) — varchar(3)
  • SPECIALFLIGHTIND (Field34) — varchar(1)
  • AIRCRAFTTYPE (Field35) — varchar(3)
  • AIRCRAFTSUBTYPE (Field36) — varchar(3)
  • AIRCRAFTREGNO (Field37) — varchar(12)
  • AIRCRAFTPAXCAPACITY (Field38) — varchar(3)
  • STAND (Field39) — varchar(4)
  • TERMINAL (Field40) — varchar(4)
  • RUNWAY (Field41) — varchar(4)
  • ESTIMATEDTIME (Field42) — char(12)
  • LATESTTIME (Field43) — char(12)
  • LTASOURCE (Field44) — varchar(1)
  • ONBLOCKTIME (Field45) — char(12)
  • ACTUALTIME (Field46) — char(12)
  • CANCELLED (Field47) — varchar(1)
  • CANCELLEDREASONCODE (Field48) — varchar(4)
  • DIVERTED (Field49) — varchar(1)
  • DIVERTEDREASONCODE (Field50) — varchar(4)
  • IRREGCODE1 (Field51) — varchar(2)
  • IRREGCODE2 (Field52) — varchar(2)
  • DELAYTIME1 (Field53) — varchar(4)
  • DELAYTIME2 (Field54) — varchar(4)
  • LANDED (Field55) — varchar(1)
  • CAROUSEL (Field56) — varchar(3)
  • FIRSTBAGTIME (Field57) — char(12)
  • … +8

ESB_FIMSINDEP_RCV (DEP)

  • UNITSYTEMID (Key) — varchar(4) — Primary key — NOT NULL
  • MESSAGEID (Key2) — varchar(32) — Primary key — NOT NULL
  • DATEANDTIME (Key3) — varchar(18) — Primary key — NOT NULL
  • MESSAGETYPE (Field) — varchar(1)
  • FIMS_ID (Field2) — varchar(22)
  • FLIGHTCARRIER (Field3) — varchar(3)
  • FLIGHTCARRIERSHORT (Field4) — varchar(3)
  • FLIGHTNUMBER (Field5) — varchar(4)
  • FLIGHTSUFFIX (Field6) — varchar(1)
  • FLIGHTID (Field7) — varchar(8)
  • PUBLICID (Field8) — varchar(8)
  • SCHEDULED (Field9) — char(12)
  • CODESHARESTATUS (Field10) — varchar(2)
  • MASTERIIS_ID (Field11) — varchar(22)
  • DESTINATION (Field12) — varchar(4)
  • FIRSTAIRPORTSTOP (Field13) — varchar(4)
  • SECONDAIRPORTSTOP (Field14) — varchar(4)
  • THIRDAIRPORTSTOP (Field15) — varchar(4)
  • FOURTHAIRPORTSTOP (Field16) — varchar(40
  • FIFTHAIRPORTSTOP (Field17) — varchar(4)
  • SIXTHAIRPORTSTOP (Field18) — varchar(4)
  • SEVENTHAIRPORTSTOP (Field19) — varchar(4)
  • EIGHTHAIRPORTSTOP (Field20) — varchar(4)
  • NINTHAIRPORTSTOP (Field21) — varchar(4)
  • TENTHAIRPORTSTOP (Field22) — varchar(4)
  • LINKIIS_ID (Field23) — varchar(22)
  • IRREGULAR (Field24) — varchar(1)
  • TYPEOFFLIGHT (Field25) — varchar(1)
  • SERVICETYPE (Field26) — varchar(1)
  • TRANSIT (Field27) — varchar(1)
  • HANDLINGAGENT (Field28) — varchar(3)
  • REMARKCODEGENERAL (Field29) — varchar(3)
  • REMARKCODEPUBLIC (Field30) — varchar(3)
  • REMARKCODESTAFF (Field31) — varchar(3)
  • REMARKCODEAIRSIDE (Field32) — varchar(3)
  • REMARKCODELANDSIDE (Field33) — varchar(3)
  • GATEREMARKKOREAN (Field34) — varchar(256)
  • GATEREMARKENGLISH (Field35) — varchar(256)
  • GATEREMARKCHINESE (Field36) — varchar(256)
  • GATEREMARKJAPANESE (Field37) — varchar(256)
  • SPECIALFLIGHTIND (Field38) — varchar(1)
  • AIRCRAFTTYPE (Field39) — varchar(3)
  • AIRCRAFTSUBTYPE (Field40) — varchar(3)
  • AIRCRAFTREGNO (Field41) — varchar(12)
  • AIRCRAFTPAXCAPACITY (Field42) — varchar(3)
  • STAND (Field43) — varchar(4)
  • TERMINAL (Field44) — varchar(4)
  • RUNWAY (Field45) — varchar(4)
  • ESTIMATEDTIME (Field46) — char(12)
  • LATESTTIME (Field47) — char(12)
  • LTDSOURCE (Field48) — varchar(1)
  • OFFBLOCKTIME (Field49) — char(12)
  • ACTUALTIME (Field50) — char(12)
  • CANCELLED (Field51) — varchar(1)
  • CANCELLEDREASONCODE (Field52) — varchar(4)
  • DIVERTED (Field53) — varchar(1)
  • DIVERTEDREASONCDOE (Field54) — varchar(4)
  • IRREGCODE1 (Field55) — varchar(2)
  • IRREGCODE2 (Field56) — varchar(2)
  • DELAYTIME1 (Field57) — varchar(4)
  • … +19

ESB_FIMSINLOC_RCV (LOC)

  • UNITSYSTEMID (Key) — varchar(4) — Primary key — NOT NULL
  • MESSAGEID (Key2) — varchar(32) — Primary key — NOT NULL
  • DATEANDTIME (Key3) — varchar(18) — Primary key — NOT NULL
  • MESSAGETYPE (Field) — varchar(1)
  • IATACODE (Field2) — varchar(3)
  • ICAOCODE (Field3) — varchar(4)
  • FLIGHTSECTOR (Field4) — varchar(1)
  • KOREANNAME (Field5) — varchar(90)
  • ENGLISHNAME (Field6) — varchar(90)
  • CHINESENAME (Field7) — varchar(90)
  • JAPANESENAME (Field8) — varchar(90)
  • LANGUAGE5NAME (Field9) — varchar(90)
  • LANGUAGE6NAME (Field10) — varchar(90)
  • LANGUAGE7NAME (Field11) — varchar(90)
  • LANGUAGE8NAME (Field12) — varchar(90)
  • RECV_TIME (Field13) — varchar(17)
  • DEAL_STAT (Field14) — char(1)
  • DEAL_DESC (Field15) — varchar(1000)

ESB_WORLDWTHRINFO2_RCV (WWTHR)

  • UNITSYSTEMID (Key) — varchar(4) — Primary key — NOT NULL
  • MESSAGEID (Key2) — varchar(32) — Primary key — NOT NULL
  • DATEANDTIME (Key3) — varchar(18) — Primary key — NOT NULL
  • REGIONSN (Field) — varchar(5)
  • MSGTYPE (Field2) — char(1)
  • WDATE (Field3) — varchar(12)
  • TIMEZONE (Field4) — varchar(20)
  • LOCALTIME (Field5) — char(12)
  • DAYNIGHT (Field6) — char(1)
  • ICONNO (Field7) — varchar(2)
  • TEMP (Field8) — varchar(10)
  • SENSTMP (Field9) — varchar(10)
  • HMDTY (Field10) — varchar(10)
  • PA (Field11) — varchar(10)
  • WD (Field12) — varchar(2)
  • WS (Field13) — varchar(10)
  • CTYCD (Field14) — varchar(3)
  • RSVRD1 (Field15) — varchar(50)
  • RSVRD2 (Field16) — varchar(50)
  • RSVRD3 (Field17) — varchar(50)
  • RSVRD4 (Field18) — varchar(50)
  • RECV_TIME (Field19) — varchar(17)
  • DEAL_STAT (Field20) — char(1)
  • DEAL_DESC (Field21) — varchar(1000)

ESB_WTHRINFO2_RCV (WTHR)

  • UNITSYSTEMID (Key) — varchar(4) — Primary key — NOT NULL
  • MESSAGEID (Key2) — varchar(32) — Primary key — NOT NULL
  • DATEANDTIME (Key3) — varchar(18) — Primary key — NOT NULL
  • YMD (Field) — varchar(8)
  • DAY (Field2) — varchar(10)
  • CTYNM (Field3) — varchar(60)
  • HUMIDITY (Field4) — varchar(5)
  • WIND (Field5) — varchar(5)
  • WEATHER (Field6) — varchar(30)
  • HGHSTTP (Field7) — varchar(5)
  • LOWSTTP (Field8) — varchar(5)
  • RECV_TIME (Field9) — varchar(17)
  • DEAL_STAT (Field10) — char(1)
  • DEAL_DESC (Field11)