community-server

Tables (4)

Comments (댓글)

  • commentId (댓글고유값) — INT — Primary key — NOT NULL
  • comment (댓글내용) — STRING
  • createdAt (생성시간) — DATE
  • updatedAt (수정시간) — DATE
  • userId (회원고유값) — INT — Foreign key → Users.userId — NOT NULL
  • postId (게시글고유값) — INT — Foreign key → Posts.postId — NOT NULL

Likes (좋아요)

  • likeId (좋아요 고유값) — INT — Primary key — NOT NULL
  • userId (회원고유값) — INT — Foreign key → Users.userId — NOT NULL
  • postId (게시글고유값) — INT — Foreign key → Posts.postId — NOT NULL

Posts (게시글)

  • postId (게시글고유값) — INT — Primary key — NOT NULL
  • title (제목) — STRING
  • content (내용) — STRING
  • fileUrl (파일URL) — STRING
  • filename (파일이름) — STRING
  • createdAt (생성시간) — DATE
  • updatedAt (수정시간) — DATE
  • userId (회원고유값) — INT — Foreign key → Users.userId — NOT NULL

Users (회원)

  • userId (회원고유값) — INT — Primary key — NOT NULL
  • email (아이디) — STRING
  • nickname (별명) — STRING
  • password (암호) — STRING
  • createdAt (생성시간) — DATE
  • updatedAt (수정시간) — DATE