돈굴이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