거꾸로 가계부

테이블 (5)

Daily_Consumption (Untitled)

  • date — NOT NULL — 기본 키 — NOT NULL
  • history_id — NOT NULL — 외래 키 → History.history_id — NOT NULL
  • user_id — NOT NULL — 외래 키 → History.user_id — NOT NULL
  • records — NOT NULL

Goal (GOAL)

  • icon_id — NOT NULL — 기본 키 — NOT NULL
  • user_id — NOT NULL — 외래 키 → User.user_id — NOT NULL
  • target amount (target amout) — NOT NULL
  • target period start — NOT NULL
  • target period end — NOT NULL
  • memo (goal_memo) — NOT NULL
  • monthly income — NOT NULL
  • essential spending — NOT NULL

History

  • history_id — NOT NULL — 기본 키 — NOT NULL
  • user_id — NOT NULL — 외래 키 → User.user_id — NOT NULL

Record (RECORD)

  • Key (record_id) — NOT NULL — 기본 키 — NOT NULL
  • date — NOT NULL — 외래 키 → Daily_Consumption.date — NOT NULL
  • history_id — NOT NULL — 외래 키 → Daily_Consumption.history_id — NOT NULL
  • user_id — NOT NULL — 외래 키 → Daily_Consumption.user_id — NOT NULL
  • content — NOT NULL
  • cost — NOT NULL
  • record_memo — NOT NULL

User (USER)

  • user_id — NOT NULL — 기본 키 — NOT NULL