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