MC3-FutureStarz

테이블 (4)

가계부 (account)

  • id (account_id) — Int — 기본 키 — NOT NULL
  • id (user_id) — Int — 외래 키 → 유저.id — NOT NULL
  • date (account_date) — Date
  • type (bill_type) — Int
  • bill — Int
  • category (account_category) — Int
  • content (account_content) — varchar(45)
  • over (over_status) — Bool
  • share (share_status) — Bool

그룹 (group)

  • id (group_id) — Int — 기본 키 — NOT NULL
  • name (group_name) — varchar(40)
  • caption (group_caption) — varchar(180)
  • goal (group_goal) — Int
  • cur (group_cur) — Int
  • max (group_max) — Int
  • lock (lock_status) — Bool
  • pw (group_pw) — Int

댓글 (comment)

  • 댓글 id (comment_id) — Int — 기본 키 — NOT NULL
  • id (user_id) — Int — 외래 키 → 유저.id — NOT NULL
  • comment (user_comment) — String
  • Field

유저 (user)

  • id (user_id) — Int — 기본 키 — NOT NULL
  • id (group_id) — Int — 외래 키 → 그룹.id — NOT NULL
  • nickname (user_nickname) — varchar(30)
  • email (user_email) — String
  • goal (user_goal) — Int
  • profile (user_image) — String