묘캣몬고
테이블 (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