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)