SNS

Tables (4)

Comment (댓글)

  • commentId (Key) — Primary key — NOT NULL
  • userId (Key2) — Foreign key → User.userId — NOT NULL
  • content (Field6)
  • ref (Field)
  • refOrder (Field2)
  • step (Field3)
  • parentNum (Field4)
  • answerNum (Field5)
  • createdAt (Field8)
  • deletedAt (Field7)

Like (좋아요)

  • likeId (Key3) — Primary key — NOT NULL
  • postId (Key) — Foreign key → Post.postId — NOT NULL
  • userId (Key2) — Foreign key → User.userId — NOT NULL
  • createdAt (Field2)
  • deletedAt (Field3)

Post (게시물)

  • postId (Key) — Primary key — NOT NULL
  • userId (Key2) — Foreign key → User.userId — NOT NULL
  • title (Field)
  • content (Field2)
  • image (Field3)
  • hashtag (Field4)
  • createdAt (Field5)
  • updatedAt (Field6)

User (사용자)

  • userId (Key) — Primary key — NOT NULL
  • email (Field)
  • phone (Field2)
  • image (Field3)
  • introduce (Field4)
  • createdAt (Field5)
  • updatedAt (Field6)