simpleSNS
Tables (7)
Comment (comment)
- Id (id) — Primary key — NOT NULL
- Comment (comment)
- Id (post_id) — Foreign key → Post.Id — NOT NULL
- Id (user_id) — Foreign key → User.Id — NOT NULL
Heart (heart)
- Id (id) — Primary key — NOT NULL
- Id (post_id) — Foreign key → Post.Id — NOT NULL
- Id (user_id) — Foreign key → User.Id — NOT NULL
ImgUrls (img_urls)
- Id (post_id) — Foreign key → Post.Id — NOT NULL
- ImgUrls (img_urls)
Post (post)
- Id (id) — Primary key — NOT NULL
- Content (content)
- Id (user_id) — Foreign key → User.Id — NOT NULL
User (user)
- Id (id) — Primary key — NOT NULL
- Name (name)
- PhoneNumber (phone_num)
- Tag (tag)
- Password (password)
UserRole (user_role)
- Id (user_id) — Foreign key → User.Id — NOT NULL
- UserRole (user_role)