금주어플

테이블 (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