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