5.6

Tables (4)

Untitled

  • Field
  • Field2
  • Field3

comments

  • id — INT — Primary key — NOT NULL
  • post_id — INT — Foreign key → posts.id — NOT NULL
  • user_id — INT — Foreign key → users.id — NOT NULL
  • comment — TEXT — NOT NULL
  • created_at — TIMESTAMP

posts

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • view_count — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

users

  • id — INT — Primary key — NOT NULL
  • login_id — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100)
  • created_at — TIMESTAMP