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