account
테이블 (6)
가계부 (account)
- Account id (account_id) — int — 기본 키 — NOT NULL
- Account name (account_name) — varchar
가계부 내역 (account_detail)
- Account Detail id (account_detail_id) — int — 기본 키 — NOT NULL
- Account id (account_id) — int — 외래 키 → 가계부.Account id — NOT NULL
- Category (category_id) — int — 외래 키 → 카테고리.Category — NOT NULL
- Title (title) — varchar
- Content (content) — varchar
- amount — int
- Writer Nickname (Field) — varchar
구독 (subscription)
- Subscription id (subscripttion_id) — int — 기본 키 — NOT NULL
- Follower Member Id (follower_member_email) — varchar
- Following member id (following_member_email) — varchar
- Account Id (account_id) — int
- Subscript Type (type_cd) — varchar
권한 (account_authority)
- Account authority id (authority_id) — int — 기본 키 — NOT NULL
- Member id (member_id) — int — 외래 키 → 유저.Member id — NOT NULL
- Account id (account_id) — int — 외래 키 → 가계부.Account id — NOT NULL
- Authority type (level_cd) — varchar
유저 (member)
- Member id (member_id) — int — 기본 키 — NOT NULL
- Email (email) — varchar
- Nickname (nickname) — varchar
카테고리 (category)
- Category (category_id) — int — 기본 키 — NOT NULL
- Name (name) — varchar