was_board

Tables (3)

User

  • id — int — Primary key — NOT NULL
  • email — VARCHAR(30) — NOT NULL
  • password — VARCHAR(60) — NOT NULL
  • nickname — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

comment

  • id — INT — Primary key — NOT NULL
  • content — varchar(500) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP
  • user_id — int — Foreign key → User.id — NOT NULL
  • post_id — int — Foreign key → post.id — NOT NULL

post

  • id — int — Primary key — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — VARCHAR(10000)
  • user_id — int — Foreign key → User.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP
  • view_count — int — NOT NULL