EM

Tables (7)

AnalysisResult (Untitled2)

  • ResultID (Key) — Primary key — NOT NULL
  • AnalysisStatus (Field)
  • AnalysisStartTime (Field2)
  • AnalysisCompletionTime (Field3)

Camera (카메라정보)

  • CameraID (Key) — Primary key — NOT NULL
  • Location (Field)
  • Settings (Field2)

EMSEquipment (EMS장비)

  • EquipmentID (아이디) — Primary key — NOT NULL
  • VesselID (선박아이디)
  • Cameras (카메라정보)
  • SensorCount (센서수)
  • SensorLocations (센서위치)
  • ControlBoxLocation (컨트롤박스위치)

FishingTrip (조업출항정보)

  • TripID (Key) — Primary key — NOT NULL
  • VesselID (Field)
  • DepartureDate (Field2)
  • ReturnDate (Field3)
  • Field4

VesselInfo (선박정보)

  • VesselID (아이디) — Primary key — NOT NULL
  • VesselName (선박명)
  • RegistrationNumber (외부등록번호)
  • FisheryType (선박 유형)
  • VesselPhoto (선박 사진)
  • OwnerName (선박 소유주)
  • OperatorName (선박 운영자)
  • EmsServiceProviderInfo (EM 서비스 제공자 연락처 정보)

VideoInfo (영상정보)

  • VideoID (비디오아이디) — Primary key — NOT NULL
  • Key — Primary key — NOT NULL
  • OperationType (Field)
  • StartTime (Field2)
  • EndTime (Field3)
  • VideoFileName (Field4)
  • Field5

VideoSet (Untitled)

  • SetID (Key) — Primary key — NOT NULL
  • TripID (Field)
  • SetNumber (Field2)
  • Videos (Field3)