CatchEat

Tables (12)

Badge

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • imageUrl — VARCHAR(500)

BasicDex (CollectionSlot)

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • category — VARCHAR(50) — NOT NULL — 9개 카테고리
  • illustrationUrl — VARCHAR(500)

CollectionCard

  • id — BIGINT — Primary key — NOT NULL
  • registrationId — BIGINT — Foreign key → Registration.id — NOT NULL
  • userCollectionId — BIGINT — Foreign key → UserCollection.id — NOT NULL
  • representativePhotoId — BIGINT — Foreign key → Photo.id — NOT NULL
  • memo — VARCHAR(100) — nullable, 최대 100자
  • locationName — VARCHAR(255) — nullable
  • lat — FLOAT — nullable
  • lng — FLOAT — nullable
  • verificationStatus — VARCHAR(20) — NOT NULL — PHOTO / MANUAL_PENDING / APPROVED
  • collectedAt — DATETIME — NOT NULL

FoodCandidate

  • id — BIGINT — Primary key — NOT NULL
  • registrationId — BIGINT — Foreign key → Registration.id — NOT NULL
  • slotId — BIGINT — Foreign key → BasicDex.id — NOT NULL
  • confidence — FLOAT — NOT NULL
  • selected — BOOLEAN — NOT NULL

MemoTemplate

  • id — BIGINT — Primary key — NOT NULL
  • userId — BIGINT — Foreign key → User.id — NOT NULL
  • content — VARCHAR(100) — NOT NULL — 유저당 최대 3개 제한 (앱 레벨)

Photo

  • id — BIGINT — Primary key — NOT NULL
  • registrationId — BIGINT — Foreign key → Registration.id — NOT NULL
  • url — VARCHAR(500) — NOT NULL
  • hash — VARCHAR(255) — NOT NULL — 동일 사진 재사용 차단

Registration

  • id — BIGINT — Primary key — NOT NULL
  • userId — BIGINT — Foreign key → User.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL — PHOTO / MANUAL_PENDING
  • createdAt — DATETIME — NOT NULL

ReviewQueueItem

  • id — BIGINT — Primary key — NOT NULL
  • registrationId — BIGINT — Foreign key → Registration.id — NOT NULL
  • evidencePhotoId — BIGINT — Foreign key → Photo.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL — 대기 / 승인 / 반려

UnidentifiedFoodReport

  • id — BIGINT — Primary key — NOT NULL
  • registrationId — BIGINT — Foreign key → Registration.id — NOT NULL
  • description — VARCHAR(255) — NOT NULL
  • status — VARCHAR(20) — NOT NULL — 대기 / 채택 / 반려

User

  • id — BIGINT — Primary key — NOT NULL
  • provider — VARCHAR(20) — NOT NULL — GOOGLE / KAKAO
  • providerId — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • nicknameUpdatedAt — DATETIME
  • onboardingCompleted — BOOLEAN — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • deletedAt — DATETIME — soft delete (탈퇴 유예)

UserBadge

  • id — BIGINT — Primary key — NOT NULL
  • userId — BIGINT — Foreign key → User.id — NOT NULL
  • badgeId — BIGINT — Foreign key → Badge.id — NOT NULL
  • acquiredAt — DATETIME — NOT NULL

UserCollection

  • id — BIGINT — Primary key — NOT NULL
  • userId — BIGINT — Foreign key → User.id — NOT NULL
  • slotId — BIGINT — Foreign key → BasicDex.id — NOT NULL
  • rank — INT — NOT NULL — 별 1~3
  • firstCollectedAt — DATETIME — NOT NULL