금주어플
테이블 (4)
CALENDAR_TB (달력)
- calendar_id (Key) — 기본 키 — NOT NULL
- created_at (Field) — TIMESTAMP
- title (Field2) — VARCHAR
- contents (Field3) — VARCHAR(300)
- image_url (Field4) — VARCHAR(400)
DRINKS_TB (그 날 마신 술의 양)
- drink_id (Key) — 기본 키 — NOT NULL
- user_id (Field4)
- type (Field) — VARCHAR
- amount (Field2) — INT
- created_at (Field3) — TIMESTAMP
- date_type (Field5) — VARCHAR
MENTIONS_TB (버전 별 멘트)
- mention_id (Key) — 기본 키 — NOT NULL
- version (Field) — TINYINT(1)
- contents (Field2) — VARCHAR
- step (Field3) — INT
USERS_TB (사용자(소셜))
- user_id (Key) — 기본 키 — NOT NULL
- email (Field6) — VARCHAR
- nickname (Field) — VARCHAR(10)
- version (Field2) — VARCHAR
- limit (Field3) — INT(100)
- limit_type (Field4) — VARCHAR
- goal (Field5) — INT
- platform (Field7) — VARCHAR(30)
- platform_id (Field8) — VARCHAR
- profile (Field9) — VARCHAR
- sex (Field10) — VARCHAR