database

Tables (3)

comments

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

posts

  • post_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR(100)
  • content — TEXT
  • created_at — TIMESTAMP

users

  • user_id — INT — Primary key — NOT NULL
  • email — VARCHAR(100)
  • password — VARCHAR(255)
  • nickname — VARCHAR(50)
  • created_at — DATETIME