커플정산서비스

테이블 (8)

avatars

  • id — INT — 기본 키 — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • file_path — VARCHAR(500) — NOT NULL
  • bucket_name — VARCHAR(100) — NOT NULL
  • file_url — VARCHAR(500) — NOT NULL
  • is_active — BOOLEAN — NOT NULL

couple_members

  • id (user_id) — INT — 외래 키 → users.id — NOT NULL
  • id (couple_id) — INT — 외래 키 → couples.id — NOT NULL
  • joined_at — DATETIME — NOT NULL

couples

  • id — INT — 기본 키 — NOT NULL
  • invite_code — VARCHAR(255) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

expense_images

  • id — INT — 기본 키 — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • file_path — VARCHAR(500) — NOT NULL
  • bucket_name — VARCHAR(100) — NOT NULL
  • file_url — VARCHAR(500) — NOT NULL
  • id (expenses_id) — INT — 외래 키 → expenses.id — NOT NULL

expenses

  • id — INT — 기본 키 — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • amount — INT — NOT NULL
  • category — VARCHAR(100)
  • memo — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME
  • spent_at — DATETIME — NOT NULL
  • id (couple_id) — INT — 외래 키 → couples.id — NOT NULL
  • id (payer_id) — INT — 외래 키 → users.id — NOT NULL

settlement_details

  • id — INT — 기본 키 — NOT NULL
  • total_amount — FLOAT
  • id (user_id) — INT — 외래 키 → users.id — NOT NULL
  • id (settlement_id) — INT — 외래 키 → settlements.id — NOT NULL

settlements

  • id — INT — 기본 키
  • month — VARCHAR(7)
  • balance_difference — FLOAT
  • settled_at — DATETIME
  • created_at — DATETIME
  • updated_at — DATETIME
  • id (couple_id) — INT — 외래 키 → couples.id

users

  • id — INT — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • id (avatar_id) — INT — 외래 키 → avatars.id