Newsfeed

Tables (3)

tb_comment (Untitled3)

  • comment (Key) — Primary key — NOT NULL
  • postId (Key2) — long — Foreign key → tb_post.postId — NOT NULL
  • UserName (Key22) — String — Foreign key → tb_post.UserName — NOT NULL
  • UserName (Key3) — String — Foreign key → tb_user.UserName — NOT NULL
  • created_at (Field) — localdate
  • modified_at (Field2) — localdate
  • 내용 (Field3) — String

tb_post (Untitled2)

  • postId (Key) — long — Primary key — NOT NULL
  • UserName (Key2) — String — Foreign key → tb_user.UserName — NOT NULL
  • postTitle (Field) — String
  • postContent (Field2) — String
  • postCategory (Field3) — String
  • jmtName (Field4) — String
  • jmtLocation (Field5) — String
  • jmtMenu (Field6) — String
  • jmtImage (Field7) — Url
  • jmtScore (Field8) — float
  • created_at (Field9) — localdate
  • modified_at (Field10) — localdate

tb_user (Untitled)

  • UserName (Key) — String — Primary key — NOT NULL
  • userId (Field) — long
  • userPassword (Field2) — String
  • profileComment (Field3) — String
  • profileImage (Field4) — Url