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