TownAssembly:ERD

Tables (5)

Comment: Comment (Comment)

  • Comment ID (commentId) — Long — Primary key — NOT NULL
  • Title (title) — VARCHAR
  • Content (content) — VARCHAR
  • Opinion ID (opinionID) — Long — Foreign key → Post: Opinion.Opinion ID — NOT NULL
  • User ID (userId) — Long — Foreign key → User.User ID — NOT NULL

Comment: Complement (Complement)

  • Complement ID (compleId) — Long — Primary key — NOT NULL
  • Title (title) — VARCHAR
  • Content (content) — VARCHAR
  • User ID (userId) — Long — Foreign key → User.User ID — NOT NULL

Post: Campaign (Campaign)

  • Campaign ID (campaignId) — Long — Primary key — NOT NULL
  • Title (title) — VARCHAR
  • Content (content) — VARCHAR
  • Image Thumbnail (imageThumb) — VARCHAR
  • Urls (url) — VARCHAR
  • User ID (userId) — Long — Foreign key → User.User ID — NOT NULL
  • Comment ID (commentId) — Long — Foreign key → Comment: Comment.Comment ID — NOT NULL

Post: Opinion (Opinion)

  • Opinion ID (opinionID) — Long — Primary key — NOT NULL
  • Title (title) — VARCHAR
  • Cotent (content) — VARCHAR
  • ContentType (contetnType) — VARCHAR
  • User ID (userId) — Long — Foreign key → User.User ID — NOT NULL

User

  • User ID (userId) — Long — Primary key — NOT NULL