member
Tables (6)
board_comment
- id — INT — Primary key — NOT NULL
- post_id — INT — Foreign key → board_post.id — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
board_post
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
email_verification_token
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.id
- email — VARCHAR(100) — NOT NULL
- token — VARCHAR(255) — NOT NULL
- code — VARCHAR(10)
- purpose — ENUM('SIGNUP','RESET_PASSWORD','LINK_SOCIAL') — NOT NULL
- created_at — DATETIME — NOT NULL
- expires_at — DATETIME — NOT NULL
- verified_at — DATETIME
oauth_user
- id — INT — Primary key — NOT NULL
- provider — VARCHAR(30) — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- oauth_id — VARCHAR(255) — NOT NULL
refresh_token
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- token — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
- expires_at — DATETIME — NOT NULL
- revoked_at — DATETIME
user
- id — INT — Primary key — NOT NULL
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255)
- phone — VARCHAR(15)
- address — VARCHAR(255)
- user_type — ENUM('adopter','admin') — NOT NULL
- is_email_verified — BOOLEAN — NOT NULL
- status — ENUM('ACTIVE','SUSPENDED','WITHDRAWN') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL