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