ERD

Tables (4)

Like (Untitled2)

  • Id (Key) — long — Primary key — NOT NULL — autoincrease
  • user_id (유저 아이디) — long — Foreign key → User.Id — NOT NULL
  • comment_id (댓글 아이디) — long — Foreign key → comment.Id — NOT NULL

Post (user_post)

  • Id (Key) — long — Primary key — NOT NULL — autoIncrease
  • user_id (key) — long — Foreign key → User.Id — NOT NULL
  • title (제목) — varchar — NOT NULL
  • content (내용) — longText — NOT NULL
  • createdDate (작성일) — date — NOT NULL

User (user_table)

  • Id (key) — long — Primary key — NOT NULL — autoIncrease
  • email (이메일) — varchar — NOT NULL
  • password (비밀번호) — varchar — NOT NULL

comment (Untitled)

  • Id (Key) — long — Primary key — NOT NULL — autoIncreease
  • post_id (게시글 ID) — long — Foreign key → Post.Id — NOT NULL
  • user_email (작성자) — varchar
  • content (내용) — longText — NOT NULL
  • createAt (작성일) — date — NOT NULL
  • like (좋아요) — int