deathnote

Tables (11)

chat_messages

  • id — BIGINT
  • chat_room_id — BIGINT — Foreign key → chat_rooms.id — NOT NULL
  • sender_id — BIGINT — Foreign key → users.id — NULL이면 시스템 메시지
  • type — VARCHAR(10) — NOT NULL — USER, SYSTEM
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

chat_rooms

  • id — BIGINT
  • settlement_id — BIGINT — Foreign key → settlements.id — NOT NULL
  • created_at — DATETIME — NOT NULL

late_charges

  • id — BIGINT
  • transfer_id — BIGINT — Foreign key → transfers.id — NOT NULL
  • amount — INT — NOT NULL
  • charged_at — DATETIME — NOT NULL

menu_item_splits

  • id — BIGINT
  • menu_item_id — BIGINT — Foreign key → menu_items.id — NOT NULL
  • settlement_member_id — BIGINT — Foreign key → settlement_members.id — NOT NULL
  • split_amount — INT — NOT NULL

menu_items

  • id — BIGINT
  • receipt_id — BIGINT — Foreign key → receipts.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • unit_price — INT — NOT NULL
  • quantity — INT — NOT NULL

notifications

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • settlement_id — BIGINT — Foreign key → settlements.id — NOT NULL
  • type — VARCHAR(20) — NOT NULL — REMINDER, LATE_CHARGE, PAID, CONFIRMED
  • message — VARCHAR(500) — NOT NULL
  • is_read — BOOLEAN — NOT NULL
  • sent_at — DATETIME — NOT NULL

receipts

  • id — BIGINT
  • settlement_id — BIGINT — Foreign key → settlements.id — NOT NULL
  • store_name — VARCHAR(100)
  • total_amount — INT — NOT NULL
  • ocr_image_url — VARCHAR(255)
  • created_at — DATETIME — NOT NULL

settlement_members

  • id — BIGINT
  • settlement_id — BIGINT — Foreign key → settlements.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • role — VARCHAR(10) — NOT NULL — HOST, MEMBER
  • net_balance — INT — NOT NULL — 양수: 받을 돈, 음수: 낼 돈
  • joined_at — DATETIME — NOT NULL

settlements

  • id — BIGINT
  • created_by — BIGINT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • status — VARCHAR(20) — NOT NULL — ACTIVE, COMPLETED
  • created_at — DATETIME — NOT NULL

transfers

  • id — BIGINT
  • settlement_id — BIGINT — Foreign key → settlements.id — NOT NULL
  • from_member_id — BIGINT — Foreign key → settlement_members.id — NOT NULL
  • to_member_id — BIGINT — Foreign key → settlement_members.id — NOT NULL
  • amount — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL — PENDING, PAID, CONFIRMED
  • paid_at — DATETIME

users

  • id — BIGINT
  • name — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20)
  • profile_image_url — VARCHAR(255)
  • created_at — DATETIME — NOT NULL