coffee&life&balance
Tables (5)
CoffeeLog (커피기록)
- id (아이디) — INT — Primary key — NOT NULL
- dt_id (통계아이디) — INT — Foreign key → DailyTotal.id — NOT NULL
- user_id (유저아이디) — INT — Foreign key → User.id — NOT NULL
- date (날짜) — DATETIME
- shot (샷) — INT
- base (베이스) — CHAR
- extra (추가) — CHAR
DailyTotal (일별통계)
- id (아이디) — INT — Primary key — NOT NULL
- date (날짜) — DATE
- cup (잔 수) — INT
- shot (샷) — INT
- milk (우유) — INT
- syrup (시럽) — INT
- cream (크림) — INT
Mug (머그잔)
- id (아이디) — INT — Primary key — NOT NULL
- price (가격) — INT
- name (이름) — CHAR
- image (이미지) — URL
MyMugs (구매한 머그잔)
- user_id (유저아이디) — INT — Foreign key → User.id — NOT NULL
- mug_id (머그잔아이디) — INT — Foreign key → Mug.id — NOT NULL
User (사용자)
- id (아이디) — INT — Primary key — NOT NULL
- name (유저네임) — CHAR
- goal (목표치) — INT
- point (포인트) — INT
- email (이메일) — CHAR
- password (비밀번호) — CHAR
- status (고양이상태) — INT