blog

Tables (3)

User (사용자)

  • id — int — Primary key — NOT NULL
  • 이름 (name) — varchar(30)
  • 닉네임 (nick) — varchar(30)
  • 비번 (password) — varchar(30)

bord (게시글)

  • id — int — Primary key — NOT NULL
  • 제목 (title) — varchar(100)
  • 내용 (content) — varchar(200)
  • id (user_id) — int — Foreign key → User.id — NOT NULL
  • Field

comment (댓글)

  • Key (id) — int — Primary key — NOT NULL
  • id (user_id) — int — Foreign key → User.id — NOT NULL
  • id (bord_id) — int — Foreign key → bord.id — NOT NULL
  • 내용 (content) — varchar(200)
  • 날짜 (insertdate) — datetime