goorm

Tables (3)

COMMENT (댓글)

  • commentId (댓글ID) — Primary key — NOT NULL
  • nickname (닉네임)
  • content (내용)
  • postId (게시글ID) — Foreign key → POST.postId — NOT NULL

POST (게시글)

  • postId (게시글ID) — Primary key — NOT NULL
  • title (제목)
  • date (날짜)
  • content (내용)
  • image (이미지)
  • userId (유저ID) — Foreign key → USER.userId — NOT NULL

USER (유저)

  • userId (유저ID) — Primary key — NOT NULL
  • name (이름) — String
  • nickname (닉네임) — String
  • phone (연락처) — String