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