ETS Report

Tables (12)

AnchorReport (Untitled)

  • anchorReportId (앵커 레포트 아이디) — UUID — Primary key — NOT NULL
  • legId (Key) — UUID — Foreign key → Leg.legId — NOT NULL
  • AnchorType (앵커 타입) — ENUM — NOT NULL — DROP, NOON, HEAVE
  • anchorTimeLTC (LTC 기준 NoonAtSeaReport 제출 시간) — LocalDateTime — NOT NULL
  • anchorTimeUTC (UTC 기준 NoonAtSeaReport 제출 시간) — LocalDateTime — NOT NULL
  • anchorLatDegree (anchor 시점의 위도(도)) — String — NOT NULL
  • anchorLatMinute (anchor 시점의 위도(분)) — String — NOT NULL
  • anchorLatDirection (anchor 시점의 위도(초)) — ENUM — NOT NULL — E, W, S, N
  • anchorLonDegree (anchor 시점의 경도(도)) — String — NOT NULL
  • anchorLonMinute (anchor 시점의 경도(분)) — String — NOT NULL
  • anchorLonDirection (anchor 시점의 경도(초)) — ENUM — NOT NULL — E, W, S, N
  • obsDistance (관찰 거리) — Double — NOT NULL
  • engineDistance (엔진 성능기반으로 계산된 선박 항해거리) — Double — NOT NULL
  • steamingHour (항해한 시간) — Double — NOT NULL
  • hfoConsumption (Heavy Fuel Oil Consumption) — Double
  • lfoConsumption (Light Fuel Oil Consumption) — Double
  • mdoConsumption (Marine Diesel Oil Consumption) — Double
  • mgoConsumption (Marine Gas Oil Consumption) — Double
  • lngConsumption (Liquefied Natural Gas Consumption) — Double
  • methanolConsumption (Methanol Consumption) — Double
  • ethanolConsumption (Ethanol Consumption) — Double
  • lpgPropaneConsumption (Lpg Propane Consumption) — Double
  • lpgButaneConsumption (Lpg Butane Consumption) — Double

ArrivalReport (ㅇ)

  • arrivalReportId (고유키) — UUID — Primary key — NOT NULL
  • hfoConsumption (Heavy Fuel Oil Consumption) — Double
  • lfoConsumption (Light Fuel Oil Consumption) — Double
  • mdoConsumption (Marine Diesel Oil Consumption) — Double
  • mgoConsumption (Marine Gas Oil Consumption) — Double
  • lngConsumption (Liquefied Natural Gas Consumption) — Double
  • methanolConsumption — Double
  • ethanolConsumption (Field7) — Double
  • lpgPropaneConsumption (Field8) — Double
  • lpgButaneConsumption (Field9) — Double

BunkeringReport (CopyOfCopyOfUntitled3)

  • bunkeringReportId (고유키) — UUID — Primary key — NOT NULL
  • hfoConsumption (Heavy Fuel Oil Consumption) — Double
  • lfoConsumption (Light Fuel Oil Consumption) — Double
  • mdoConsumption (Marine Diesel Oil Consumption) — Double
  • mgoConsumption (Marine Gas Oil Consumption) — Double
  • lngConsumption (Liquefied Natural Gas Consumption) — Double
  • methanolConsumption — Double
  • ethanolConsumption (Field7) — Double
  • lpgPropaneConsumption (Field8) — Double
  • lpgButaneConsumption (Field9) — Double

DepartureReport (CopyOfCopyOfUntitled4)

  • departureReportId (고유키) — UUID — Primary key — NOT NULL
  • hfoConsumption (Heavy Fuel Oil Consumption) — Double
  • lfoConsumption (Light Fuel Oil Consumption) — Double
  • mdoConsumption (Marine Diesel Oil Consumption) — Double
  • mgoConsumption (Marine Gas Oil Consumption) — Double
  • lngConsumption (Liquefied Natural Gas Consumption) — Double
  • methanolConsumption — Double
  • ethanolConsumption (Field7) — Double
  • lpgPropaneConsumption (Field8) — Double
  • lpgButaneConsumption (Field9) — Double

Fuels (Untitled4)

    Leg (Untitled8)

    • legId (고유키) — UUID — Primary key — NOT NULL
    • nextPortEtaLTC (LTC 기준 다음 항구 도착예정 시간) — LocalDateTime
    • nextPortEtaUTC (UTC 기준 다음 항구 도착예정 시간) — LocalDateTime
    • nextPort (다음 항구) — String
    • isNextEuPort (다음 항구가 EU 항구인지 여부) — boolean
    • distanceTogo (Field5) — Double
    • etaSpeed (Field6) — Double
    • remainCargoQuantity (Field7) — Integer
    • robHfo (Heavy Fuel Oil Rest Of Bunkering) — Double
    • robLfo (Light Fuel Oil Rest Of Bunkering) — Double
    • robMdo (Marine Diesel Oil Rest Of Bunkering) — Double
    • robMgo (Marine Gas Oil Rest Of Bunkering) — Double
    • robLng (Liquefied Natural Gas Rest Of Bunkering) — Double
    • robMethanol (Methanol Rest Of Bunkering) — Double
    • robEthanol (Ethanol Rest Of Bunkering) — Double
    • robLpgPropane (Lpg Propane Rest Of Bunkering) — Double
    • robLpgButane (Lpg Butane Rest Of Bunkering) — Double
    • latestReportType (Field17)

    NoonInPortReport (CopyOfCopyOfUntitled5)

    • noonInPortReportId (고유키) — UUID — Primary key — NOT NULL
    • hfoConsumption (Heavy Fuel Oil Consumption) — Double
    • lfoConsumption (Light Fuel Oil Consumption) — Double
    • mdoConsumption (Marine Diesel Oil Consumption) — Double
    • mgoConsumption (Marine Gas Oil Consumption) — Double
    • lngConsumption (Liquefied Natural Gas Consumption) — Double
    • methanolConsumption — Double
    • ethanolConsumption (Field7) — Double
    • lpgPropaneConsumption (Field8) — Double
    • lpgButaneConsumption (Field9) — Double

    NoontAtSeaReport (CopyOfCopyOfUntitled2)

    • noonAtSeaReportId (고유키) — UUID — Primary key — NOT NULL
    • hfoConsumption (Heavy Fuel Oil Consumption) — Double
    • lfoConsumption (Light Fuel Oil Consumption) — Double
    • mdoConsumption (Marine Diesel Oil Consumption) — Double
    • mgoConsumption (Marine Gas Oil Consumption) — Double
    • lngConsumption (Liquefied Natural Gas Consumption) — Double
    • methanolConsumption — Double
    • ethanolConsumption (Field7) — Double
    • lpgPropaneConsumption (Field8) — Double
    • lpgButaneConsumption (Field9) — Double

    OtherFuels (Untitled5)

      Others (Untitled2)

        VesselSetting (Untitled3)

        • Key — Primary key — NOT NULL
        • Field
        • Field2
        • Field3
        • Field4
        • Field5
        • Field6
        • Field7
        • Field8
        • Field9
        • Field10
        • Field11
        • Field12
        • Field13
        • Field14
        • Field15
        • Field16
        • Field17
        • Field18
        • Field19
        • Field20
        • Field21
        • Field22
        • Field23
        • Field24
        • Field25
        • Field26
        • Field27
        • Field28
        • Field29

        base (CopyOfUntitled)

        • anchorReportId (고유키) — UUID — Primary key — NOT NULL
        • hfoConsumption (Heavy Fuel Oil Consumption) — Double
        • lfoConsumption (Light Fuel Oil Consumption) — Double
        • mdoConsumption (Marine Diesel Oil Consumption) — Double
        • mgoConsumption (Marine Gas Oil Consumption) — Double
        • lngConsumption (Liquefied Natural Gas Consumption) — Double
        • methanolConsumption — Double
        • ethanolConsumption (Field7) — Double
        • lpgPropaneConsumption (Field8) — Double
        • lpgButaneConsumption (Field9) — Double