BASIC_BOARD_230622

Tables (6)

Untitled (user)

  • Key (id) — int — Primary key — NOT NULL
  • Field (identifier) — varchar(255) — NOT NULL
  • Field (password) — varchar(255) — NOT NULL
  • Field (nickname) — varchar(255) — NOT NULL
  • Field (email) — varchar(255) — NOT NULL
  • Field (created_date) — datetime — NOT NULL
  • Field (update_date) — datetime — NOT NULL
  • Field (email_auth) — tinyint(1) — NOT NULL
  • Field (email_received) — tinyint(1) — NOT NULL

Untitled (auth_email)

  • Key (id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (email) — varchar(255) — NOT NULL
  • Field (token) — varchar(255) — NOT NULL
  • Field (created_date) — datetime — NOT NULL

Untitled (article)

  • Key (id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (type) — varchar(255) — NOT NULL
  • Field (nickname) — varchar(255) — NOT NULL
  • Field (title) — varchar(255) — NOT NULL
  • Field (content) — text — NOT NULL
  • Field (created_date) — datetime — NOT NULL
  • Field (update_date) — datetime — NOT NULL
  • Field (view_count) — int — NOT NULL
  • Field (like_count) — int — NOT NULL

Untitled (like)

  • Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (article_id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (reply)

    Untitled