couplebudget
Tables (6)
budgets
- id — BIGINT
- couple_id — BIGINT — NOT NULL
- month — VARCHAR(7) — NOT NULL — 예: 2025-10
- target_amount — INT — NOT NULL
- spent_amount — INT
- created_at — DATETIME
- updated_at — DATETIME
categories
- id — BIGINT
- couple_id — BIGINT
- name — VARCHAR(50) — NOT NULL
- color — VARCHAR(20)
- icon — VARCHAR(50)
- created_at — DATETIME
- updated_at — DATETIME
couples
- id — BIGINT
- user1_id — BIGINT — NOT NULL
- user2_id — BIGINT — NOT NULL
- status — ENUM('PENDING','ACCEPTED','REJECTED') — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
notifications
- id — BIGINT
- couple_id — BIGINT — NOT NULL
- sender_id — BIGINT
- message — VARCHAR(255) — NOT NULL
- type — ENUM('INFO','BUDGET','TRANSACTION')
- is_read — BOOLEAN
- created_at — DATETIME
transactions
- id — BIGINT
- couple_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- category_id — BIGINT
- date — DATE — NOT NULL
- time — VARCHAR(5) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- amount — INT — NOT NULL
- method — ENUM('CARD','CASH','TRANSFER') — NOT NULL
- memo — TEXT
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_couple_date
users
- id — BIGINT
- email — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(30) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME