everytime

Tables (3)

comment (댓글)

  • id (댓글ID) — pk,ai,nn,uq — Primary key — NOT NULL
  • postID (게시글ID) — pk,ai,nn,uq — Foreign key → post.id — NOT NULL
  • id (유저ID) — pk,ai,nn,uq — Foreign key → user.id — NOT NULL
  • content (내용) — nn
  • regDate (생성일) — nn

post (게시글)

  • id (게시글ID) — pk,ai,nn,uq — Primary key — NOT NULL
  • writerID (유저ID) — pk,ai,nn,uq — Foreign key → user.id — NOT NULL
  • title (제목) — nn
  • content (내용) — nn
  • regDate (생성일) — nn
  • likeCount (좋아요 수) — nn
  • publicStatus (공개여부) — nn

user (유저)

  • id (유저ID) — pk,ai,nn,uq — Primary key — NOT NULL
  • email (이메일) — uq, nn
  • nickname (닉네임) — uq, nn
  • password (비밀번호) — nn
  • school (소속학교) — nn