계산뭐시깽
테이블 (5)
budgets
- id — BIGINT
- user_id — BIGINT — NOT NULL
- category_id — BIGINT — NOT NULL
- amount — DECIMAL(15,2) — NOT NULL
- year_month — CHAR(7) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
categories
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
- color_code — VARCHAR(20)
- icon — VARCHAR(100)
- is_active — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
fixed_transactions
- id — BIGINT
- user_id — BIGINT — NOT NULL
- category_id — BIGINT — NOT NULL
- amount — DECIMAL(15,2) — NOT NULL
- type — VARCHAR(20) — NOT NULL
- memo — VARCHAR(255)
- day_of_month — INT
- is_active — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
transactions
- id — BIGINT
- user_id — BIGINT — NOT NULL
- category_id — BIGINT — NOT NULL
- fixed_transaction_id — BIGINT
- amount — DECIMAL(15,2) — NOT NULL
- type — VARCHAR(20) — NOT NULL
- memo — VARCHAR(255)
- transaction_date — DATE — NOT NULL
- receipt_url — VARCHAR(500)
- created_at — DATETIME
- updated_at — DATETIME
users
- id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255)
- monthly_budget — DECIMAL(15,2)
- created_at — DATETIME
- updated_at — DATETIME