묘캣몬고

테이블 (9)

campus_zones

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • type — VARCHAR(30) — NOT NULL
  • latitude — DECIMAL(10, 7) — NOT NULL
  • longitude — DECIMAL(10, 7) — NOT NULL
  • radius_meters — INT — NOT NULL
  • model_type — VARCHAR(50)
  • description — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

cat_identification_candidates

  • id — BIGINT — 기본 키 — NOT NULL
  • photo_id — BIGINT — 외래 키 — NOT NULL
  • cat_id — BIGINT — 외래 키 — NOT NULL
  • image_similarity_score — DECIMAL(5, 4) — NOT NULL
  • location_score — DECIMAL(5, 4)
  • final_score — DECIMAL(5, 4) — NOT NULL
  • rank_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

cat_photos

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • cat_id — BIGINT — 외래 키 → cats.id — NOT NULL
  • image_url — TEXT — NOT NULL
  • latitude — DECIMAL(10, 7) — NOT NULL
  • longitude — DECIMAL(10, 7) — NOT NULL
  • taken_at — DATETIME — NOT NULL
  • uploaded_at — DATETIME — NOT NULL
  • is_cat — BOOLEAN — NOT NULL
  • cat_detection_confidence — DECIMAL(5, 4)
  • cat_identification_confidence — DECIMAL(5, 4)
  • created_at — DATETIME — NOT NULL

cat_placements

  • id — BIGINT — 기본 키 — NOT NULL
  • cat_id — BIGINT — 외래 키 → cats.id — NOT NULL
  • source_sighting_id — BIGINT — 외래 키 → cat_sightings.id
  • latitude — DECIMAL(10, 7) — NOT NULL
  • longitude — DECIMAL(10, 7) — NOT NULL
  • selected_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

cat_sightings

  • id — BIGINT — 기본 키 — NOT NULL
  • cat_id — BIGINT — 외래 키 → cats.id — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • photo_id — BIGINT — 외래 키 → cat_photos.id — NOT NULL
  • latitude — DECIMAL(10, 7) — NOT NULL
  • longitude — DECIMAL(10, 7) — NOT NULL
  • seen_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL

cats

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(50)
  • description — TEXT
  • representative_photo_id — BIGINT — 외래 키 → cat_photos.id
  • representative_photo_url — TEXT
  • first_seen_at — DATETIME
  • last_seen_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

refresh_tokens

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 — NOT NULL
  • token_hash — VARCHAR(255) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • revoked_at — DATETIME
  • created_at — DATETIME — NOT NULL

user_cat_collections

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • cat_id — BIGINT — 외래 키 → cats.id — NOT NULL
  • first_discovered_at — DATETIME — NOT NULL
  • last_seen_at — DATETIME
  • discovery_photo_id — BIGINT — 외래 키 → cat_photos.id
  • created_at — DATETIME — NOT NULL

users

  • id — BIGINT — 기본 키 — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • profile_image_url — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL