DEVTORY

Tables (6)

Comment (Untitled2)

  • commentid (Key) — Primary key — NOT NULL
  • content (Field)
  • postid (Key2) — UUID — Foreign key → Post.postid — NOT NULL
  • memberid (아이디) — UUID — Foreign key → Member.memberid — NOT NULL

Member (사용자)

  • memberid (아이디) — UUID — Primary key — NOT NULL
  • email (Field)
  • password (Field2)
  • nickname (Field3)

Post (Untitled)

  • postid (Key) — UUID — Primary key — NOT NULL
  • title (Field)
  • like (Field2)
  • memberid (아이디) — UUID — Foreign key → Member.memberid — NOT NULL

PostLike (Untitled3)

  • likeId (Key) — Primary key — NOT NULL
  • postid (Key2) — UUID — Foreign key → Post.postid — NOT NULL
  • memberid (아이디) — UUID — Foreign key → Member.memberid — NOT NULL

PostPage (Untitled4)

  • postPageId (Key) — Primary key — NOT NULL
  • title (Field)
  • content (Field2)
  • imageUrl (Field3)
  • postid (Key2) — UUID — Foreign key → Post.postid — NOT NULL

Tag (Untitled5)

  • tagId (Key) — Primary key — NOT NULL
  • value (Field)
  • memberid (아이디) — UUID — Foreign key → Member.memberid — NOT NULL