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