account-book

2주차 과제 - 페이히어

테이블 (4)

account_book (가계부)

  • id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → users.id — NOT NULL
  • book_name — string(100)
  • stardard_target — decimal
  • created_at — datetime
  • modified_at — datetime

account_book_detail (가계부 상세내용)

  • id — bigint — 기본 키 — NOT NULL
  • category_id — bigint — 외래 키 → acount_category.id — NOT NULL
  • account_book_id — bigint — 외래 키 → account_book.id — NOT NULL
  • account_date — string(10)
  • price — decimal
  • description — text
  • account_type — string
  • created_at — datetime
  • modified_at — datetime

acount_category (가계부 카테고리)

  • id — bigint — 기본 키 — NOT NULL
  • category_name — string(50)
  • description — text
  • created_at — datetime
  • modified_at — datetime

users (사용자)

  • id — bigint — 기본 키 — NOT NULL
  • hashed_passward — text
  • email_address — string(200)
  • nick_name — string(20)
  • created_at — datetime
  • modified_at — datetime