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