lv2

Tables (13)

Comment (댓글)

  • Long (Key) — Primary key — NOT NULL
  • String (username)
  • String (comment)
  • Key (Postid) — Foreign key → Post.Key — NOT NULL

Comment (댓글;)

  • Comment (comment) — Primary key — NOT NULL
  • Long (id)
  • String (content)

Image (사진-리스트)

  • Key — Primary key — NOT NULL
  • String (image_url)
  • Field2
  • Key (Postid) — Foreign key → Post.Key — NOT NULL

Post (게시글)

  • Key (Postid) — Primary key — NOT NULL
  • String (title)
  • String (content)
  • int (price)
  • boolean (isSold)
  • String (category)
  • String (Location)
  • Long (userid) — Foreign key → User.Long — NOT NULL

Post (게시글;)

  • Post (post) — Primary key — NOT NULL
  • Long (id)
  • String (content)
  • String (title)
  • int (price)
  • String (category)
  • String (location)

Timestamped (Untitled5)

  • Key — Primary key — NOT NULL
  • LocalDatetTime (creaatedAt)
  • LocalDateTime (modifiedAt)

User (회원)

  • Long (userid) — Primary key — NOT NULL
  • String (username)
  • String (password)
  • String (nickname)
  • String (userCategory)

User (유저정보)

  • User (user) — Primary key — NOT NULL
  • Long (id)
  • String (username)
  • String (password)
  • String (nickname)
  • String (userCategory)

UserRoleEnum (Untitled4)

  • UserRoleEnum (role) — Primary key — NOT NULL
  • String (USER)
  • String (ADMIN)

item (Untitled2)

  • Key — Primary key — NOT NULL
  • Long (id)
  • String (title)
  • String (content)
  • int (price)
  • String (username)

post (Untitled)

  • post_Id (Key) — Primary key — NOT NULL
  • title (Field)
  • content (Field2)
  • createaAt (Field3)
  • user_Id (Key2) — Foreign key → user.user_Id — NOT NULL

user

  • user_Id (Key) — Primary key — NOT NULL
  • username (Field)
  • password (Field2)

user (Untitled3)

  • Key — Primary key — NOT NULL
  • Field
  • Field2