member2

Tables (4)

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

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

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