돈굴이ERD

테이블 (9)

Budget (budget)

  • Budget ID (id) — bigint — 기본 키 — NOT NULL
  • Income (income) — int
  • Goal Amount (goal_amount) — int
  • Goal Period (goal_period) — date
  • Fixed saving (fixed_saving) — int
  • Create at (created_at) — datetime
  • Update at (updated_at) — datetime
  • User ID (user_id) — bigint — 외래 키 → User.User ID — NOT NULL

FixedCost (fixed_cost)

  • FixedCost ID (id) — bigint — 기본 키 — NOT NULL
  • Name (name) — varchar(255)
  • Amount (amount) — int
  • Create at (created_at) — datetime
  • Update at (updated_at) — datetime
  • Budget ID (budget_id) — bigint — 외래 키 → Budget.Budget ID — NOT NULL

MonthlyBudget (monthly_budget)

  • MonthlyBudget ID (id) — bigint — 기본 키 — NOT NULL
  • Month (month) — String
  • MonthlyBudget (monthly_budget) — int
  • DailyBudget (daily_budget) — int
  • Budget ID (budget_id) — bigint — 외래 키 → Budget.Budget ID — NOT NULL
  • User ID (user_id) — bigint — 외래 키 → User.User ID — NOT NULL

Report (report)

  • Report ID (id) — bigint — 기본 키 — NOT NULL
  • Month (month) — varchar(255)
  • Total Spent (total_spent) — int
  • Month Budget (month_budget) — int
  • Budget Usage Rate (budget_usageRate) — decimal(5,2)
  • Pattern Analysis (pattern_analysis) — text
  • Feedback (feedback) — text
  • Create at (create_at) — datetime
  • Update at (update_at) — datetime
  • User ID (user_id) — bigint — 외래 키 → User.User ID — NOT NULL

Report Category Breakdown (report_category_breakdown)

  • Category (category) — varchar(255) — 기본 키 — NOT NULL
  • Report ID (report_id) — bigint — 외래 키 → Report.Report ID — NOT NULL
  • Amount (amount) — double

Report Category Ratio (report_category_ratio)

  • Category (category) — varchar(255) — 기본 키 — NOT NULL
  • Report ID (report_id) — bigint — 외래 키 → Report.Report ID — NOT NULL
  • Ratio (ratio) — decimal(5,2)

Report Weekly Spending Rate (report_weekly_spending_rate)

  • Report ID (id) — bigint — 외래 키 → Report.Report ID — NOT NULL
  • Weekly Rate (weekly_rate) — decimal(5,2)

Transaction (transaction)

  • Transaction ID (id) — bigint — 기본 키 — NOT NULL
  • Save Type (save_type) — tinyint
  • Category (category) — varchar(255)
  • Amount (amount) — int
  • Date (date) — date
  • Description (description) — varchar(255)
  • Created at (created_at) — datetime
  • Update at (updated_at) — datetime
  • User ID (user_id) — bigint — 외래 키 → User.User ID — NOT NULL

User (user)

  • User ID (id) — bigint — 기본 키 — NOT NULL
  • User Name (username) — char(24)
  • Email (email) — varchar(255)
  • Created at (created_at) — datetime
  • Updated at (updated_at) — datetime