shiplineScheduleSearch

테이블 (11)

Port (Untitled5)

  • Key — 기본 키 — NOT NULL
  • Code (Field)

Scheduler (스케줄 통합관리)

  • id (Key) — 기본 키 — NOT NULL
  • schedulerType (Field6) — enum
  • callback_url (Field7)
  • schedulerStartDate (Field8)
  • schedulerEndDate (Field9)
  • repeatInterval (Field2)
  • nextRunTime (Field3)
  • lastRunTime (Field4)
  • lastRunStatus (Field5) — enum
  • forwarder (Field)

ShinlineCrawlingSegment (크롤링 설정 키와 값들을 연결 매칭)

  • id (Key) — Long — 기본 키 — NOT NULL
  • segment (Field) — enum

ShipSchedule (선박 스케줄 정보)

  • id (Key) — 기본 키 — NOT NULL
  • shipName (Field)
  • departureDate (Field2)
  • arrivalDate (Field3)
  • voyageNumber (Field4)
  • departureTerminal (Field5)
  • arrivalTerminal (Field6)
  • documentDeadline (Field7)
  • containerDeadline (Field8)
  • afrDeadline (Field9)
  • cfsDeadline (Field10)
  • ediDeadline (Field11)
  • vgmDeadline (Field12)
  • ediOfficer (Field13)
  • srOfficer (Field14)
  • motionDeadlineOfficer (Field15)
  • mrn (Field16)
  • terminalVslVoy (Field17)
  • callSign (Field18)
  • bookingStatus (Field19)
  • shiplineScheduleArchive_Id (Key2) — 외래 키 → ShiplineScheduleArchive.id — NOT NULL

ShipScheduleSearchHistory (선박 스케줄 검색 이력)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • scheduleAuto (Field2) — boolean
  • searchedStartDate (Field)
  • searchedEndDate (Field8)
  • departurePortId (Key2) — 외래 키 → Port.Key — NOT NULL
  • arrivalPortId (Key3) — 외래 키 → Port.Key — NOT NULL
  • forwarder (Field9)

ShiplineCrawlingSegmentDetail (설정된키값)

  • id (Key) — 기본 키 — NOT NULL
  • parameter_name (Field2)
  • value (Field3)
  • description (Field)
  • 세그먼트 매칭키 (Key2) — 외래 키 → ShinlineCrawlingSegment.id — NOT NULL

ShiplineCrawlingSetting (크롤링 세팅)

  • 크롤링Info ID (Key) — 기본 키 — NOT NULL
  • 크롤링타입 (Field8) — enum
  • url (Field2)
  • httpMethod (Field3) — enum
  • contentType (Field7) — enum
  • shiplineId (Key2) — 외래 키 → companies.id — NOT NULL
  • header (Key3) — Long — 외래 키 → ShinlineCrawlingSegment.id — NOT NULL
  • body (Key4) — Long — 외래 키 → ShinlineCrawlingSegment.id — NOT NULL
  • response (Key5) — Long — 외래 키 → ShinlineCrawlingSegment.id — NOT NULL
  • parse (Key6) — Long — 외래 키 → ShinlineCrawlingSegment.id — NOT NULL

ShiplineScheduleArchive (선사 스케줄 이력)

  • id (Key) — 기본 키 — NOT NULL
  • shipLineID (Key2) — 외래 키 → companies.id — NOT NULL
  • ShipScheduleSearchHistory_Id (Key3) — bigint — 외래 키 → ShipScheduleSearchHistory.id — NOT NULL
  • searchedStartDate (Field)
  • searchedEndDate (Field2)
  • departurePortId (Key4) — 외래 키 → Port.Key — NOT NULL
  • arrivalPortId (Key5) — 외래 키 → Port.Key — NOT NULL

companies (Untitled4)

  • id (Key) — 기본 키 — NOT NULL
  • Type (Field)

shiplineBookingSetting (선사부킹세팅)

  • id (Key) — 기본 키 — NOT NULL
  • shipline_id (key)
  • booking_id (Field2)
  • scheduler_id (Key2) — 외래 키 → Scheduler.id — NOT NULL

선사스케줄세팅 (Untitled)

  • id (Key) — 기본 키 — NOT NULL
  • scheduleAuto (Field)
  • searchedStartDate (Field2)
  • searchedEndDate (Field3)
  • departurePortId (Field4)
  • arrivalPortId (Field5)
  • scheduler_id (Key2) — 외래 키 → Scheduler.id — NOT NULL
  • shipline_id (Key3) — 외래 키 → companies.id — NOT NULL