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