Blog

Tables (3)

Users (2)

  • id (계정생성ID) — int — Primary key — NOT NULL
  • username (UserID) — varchar
  • password (PW) — varchar
  • role (사용자 권한) — varchar

blog (1)

  • id (게시판 생성ID) — int — Primary key — NOT NULL
  • id (계정생성ID) — int — Foreign key → Users.id — NOT NULL
  • username (UserID) — varchar
  • password (PW) — varchar
  • title (제목) — varchar
  • contents (내용) — varchar
  • create_at (생성일시) — datetime
  • modified_at (수정일시) — datetime

comment (.)

  • id (댓글 생성ID) — int — Primary key — NOT NULL
  • id (게시판 생성ID) — int — Foreign key → blog.id — NOT NULL
  • username (UserID) — varchar
  • contents (내용) — varchar
  • create_at (생성일시) — datetime
  • modified_at (수정일시) — datetime