Sprint

Tables (10)

Bread (빵)

  • breadId (빵 ID) — bigint — Primary key — NOT NULL
  • name (빵 이름) — varchar — NOT NULL
  • image_url (빵 사진) — varchar — NOT NULL
  • required_count (Field) — int — NOT NULL

BreadkingRanking (Untitled3)

  • ranking_id (Key) — bigint — Primary key — NOT NULL
  • week_start (Field) — datetime — NOT NULL
  • rank (Field2) — int — NOT NULL
  • baked_count (Field3) — NOT NULL
  • created_at (Field4) — datetime — NOT NULL
  • userId (유저 ID) — bigint — Foreign key → User.userId — NOT NULL

Category (카테고리)

  • categoryId — bigint — Primary key — NOT NULL
  • userId (유저 ID) — bigint — Foreign key → User.userId — NOT NULL
  • name — varchar — NOT NULL
  • color — enum — NOT NULL
  • is_visible — boolean — NOT NULL
  • order — int — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

DailyBaking (Untitled)

  • daily_baking_count_id (Key) — Primary key — NOT NULL
  • userId (유저 ID) — bigint — Foreign key → User.userId — NOT NULL
  • bake_date (Field) — datetime — NOT NULL
  • bread_count (Field3) — int — NOT NULL
  • updated_at (Field2) — datetime

DailyPostpone (Untitled4)

  • Key — Primary key — NOT NULL
  • postpone_date (Field) — datetime
  • postpone_count (Field2) — int
  • userId (유저 ID) — bigint — Foreign key → User.userId — NOT NULL

MerooniRanking (Untitled2)

  • ranking_id (Key) — bigint — Primary key — NOT NULL
  • week_start (Field) — datetime — NOT NULL
  • postpone_count (Field2) — int — NOT NULL
  • created_at (Field3) — datetime — NOT NULL
  • userId (유저 ID) — bigint — Foreign key → User.userId — NOT NULL

Timer (타이머)

  • timerId (타이머 ID) — bigint — Primary key — NOT NULL
  • selected_time (총 타이머 설정 시간) — int — NOT NULL — 30분, 60분 선택
  • status (상태) — enum — NOT NULL
  • extended_from_id (지속 시간 타이머 id) — bigint — 연장된 타이머의 원래 timer_id (self join)
  • pause_at (정지 시간) — datetime
  • completed_at (Field) — datetime
  • resumed_time (재시작 시간) — datetime
  • created_at (타이머 생성 시간) — datetime — NOT NULL
  • updated_at (마지막 업데이트 시각 (상태 변경, 시간 갱신 등)) — datetime — NOT NULL

Todo (투두)

  • todoId (투두 ID) — bigint — Primary key — NOT NULL
  • categoryId — bigint — Foreign key → Category.categoryId — NOT NULL
  • content (제목) — varchar — NOT NULL
  • start_time (시작시간) — datetime — NOT NULL
  • is_completed (완료여부) — Boolean
  • target_date (날짜) — date — NOT NULL
  • order (카테고리 순서) — int — NOT NULL
  • created_at (Field) — datetime — NOT NULL
  • updated_at (Field2) — datetime — NOT NULL

User (유저)

  • userId (유저 ID) — bigint — Primary key — NOT NULL
  • nickname (닉네임) — varchar — NOT NULL
  • profile_image (프로필 이미지) — varchar — NOT NULL — 프로필 일러스트
  • commitment_message (다짐 메세지) — varchar
  • notification_enabled (알림 허용여부) — Boolean — NOT NULL — 추후 마이페이지
  • week_start (한 주의 시작) — varchar — NOT NULL — 추후 마이페이지
  • created_at (가입 시간) — datetime — NOT NULL
  • total_bread_count (Field) — int — NOT NULL

UserBread (유저가 획득한 빵)

  • Key — Primary key — NOT NULL
  • breadId (빵 ID) — bigint — Foreign key → Bread.breadId — NOT NULL
  • userId (유저 ID) — bigint — Foreign key → User.userId — NOT NULL
  • is_unlocked (빵 획득 수량) — Boolean — NOT NULL
  • created_at (빵 획득 시간) — datetime — NOT NULL