acronfinal

Tables (4)

drone_coordinate (드론 좌표)

  • drone_coor_id (Key) — int — Primary key — NOT NULL
  • created_at (등록시간) — timestamp
  • latitude (위도) — double
  • longitude (경도) — double
  • disturbance (교란여부) — boolean
  • drone_id (인덱스) — int — Foreign key → drone_info.drone_id — NOT NULL
  • img_id (id) — int — Foreign key → image.img_id — NOT NULL

drone_info (드론 정보)

  • drone_id (인덱스) — int — Primary key — NOT NULL
  • name (이름) — varchar

image (이미지원본)

  • img_id (id) — int — Primary key — NOT NULL
  • filename (이미지 파일명) — varchar
  • faiss_id (FAISS 벡터 인덱스 ID) — int
  • object_path (MinIO 저장 경로) — varchar
  • latitude (위도) — double
  • longitude (경도) — double
  • geom (geometry) — geometry
  • created_at (등록 시간) — timestamp

target_coordinate (타겟 좌표)

  • target_coor_id (인덱스) — int — Primary key — NOT NULL
  • target_name (타겟이름) — varchar
  • latitude (위도) — double
  • longitude (경도) — double
  • created_at (등록시간) — timestamp
  • Field
  • drone_coor_id (Key) — int — Foreign key → drone_coordinate.drone_coor_id — NOT NULL