1

Tables (3)

Untitled3 (member)

  • Key (id) — int auto_increment — Primary key — NOT NULL
  • Field (user_id) — NOT NULL
  • Field2 (user_pw) — NOT NULL
  • Field3 (email) — NOT NULL
  • Field (nickname) — NOT NULL
  • Field (created_at) — NOT NULL
  • Field2 (created_by) — NOT NULL
  • Field3 (modified_at) — NOT NULL
  • Field4 (modified_by) — NOT NULL

article

  • Key (id) — int auto_increment — Primary key — NOT NULL
  • Key (member_id) — Foreign key → Untitled3.Key — NOT NULL
  • Field (title) — NOT NULL
  • Field (content) — NOT NULL
  • Field (created_at) — NOT NULL
  • Field2 (created_by) — NOT NULL
  • Field3 (modified_at) — NOT NULL
  • Field4 (modified_by) — NOT NULL

articleComment (article_comment)

  • Key (id) — int auto_increment — Primary key — NOT NULL
  • Key (member_id) — Foreign key → Untitled3.Key — NOT NULL
  • Key (article_id) — Foreign key → article.Key — NOT NULL
  • Field (content) — NOT NULL
  • Field (created_at) — NOT NULL
  • Field (created_by) — NOT NULL
  • Field2 (modified_at) — NOT NULL
  • Field3 (modified_by) — NOT NULL