인증
테이블 (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