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