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)