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