3조
테이블 (5)
invoice_templates
- template_id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- category — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
invoices
- user_invoice_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- template_id — BIGINT — 외래 키 → invoice_templates.template_id — NOT NULL
- amount — DECIMAL(12,2) — NOT NULL
- due_day — INT — NOT NULL
- is_recurring — TINYINT(1) — NOT NULL
- recur_cycle — VARCHAR(20)
- issue_day — DATE — NOT NULL
- recur_start — DATE — NOT NULL
- recur_end — DATE
- notify_before — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
notifications
- notification_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- payment_id — BIGINT — 외래 키 → payments.payment_id — NOT NULL
- type — VARCHAR(30) — NOT NULL
- message — VARCHAR(500) — NOT NULL
- is_read — TINYINT(1) — NOT NULL
- sent_at — DATETIME — NOT NULL
payments
- payment_id — BIGINT — 기본 키 — NOT NULL
- user_invoice_id — BIGINT — 외래 키 → invoices.user_invoice_id — NOT NULL
- due_date — DATE — NOT NULL
- amount — DECIMAL(12,2) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- paid_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
users
- user_id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- deleted_at — DATETIME