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