인증

테이블 (4)

accounts

  • id — BIGINT — NOT NULL
  • public_id — VARCHAR(36) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

credentials

  • id — BIGINT — NOT NULL
  • account_id — BIGINT — 외래 키 → accounts.id — NOT NULL
  • login_id — VARCHAR(50) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

email_verifications

  • id — BIGINT — NOT NULL
  • account_id — BIGINT — 외래 키 → accounts.id — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • verification_token — VARCHAR(255) — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

social_accounts

  • id — BIGINT — NOT NULL
  • account_id — BIGINT — 외래 키 → accounts.id — NOT NULL
  • provider — VARCHAR(50) — NOT NULL
  • external_id — VARCHAR(255) — NOT NULL