커플정산서비스
테이블 (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