sns
Tables (6)
Untitled (follow)
- userId (user_id) — Long — Foreign key → users.userId — NOT NULL
- userId (following_id) — Long — Foreign key → users.userId — NOT NULL
Untitled (comments)
- Key (comment_id) — Long — Primary key — NOT NULL
- Field (content) — varchar(200)
- postId (post_id) — Long — Foreign key → post.postId — NOT NULL
- userId (user_id) — Long — Foreign key → users.userId — NOT NULL
- Field (likes_count) — Long
- Field2 (created_date) — Date
comment_likes
- comment_likes (comment_like_id) — Long — Primary key — NOT NULL
- Key (comment_id) — Long — Foreign key → Untitled.Key — NOT NULL
- userId (user_id) — Long — Foreign key → users.userId — NOT NULL
post (posts)
- postId (post_id) — Long — Primary key — NOT NULL
- title — varchar(30) — NOT NULL
- content — varchar(500) — NOT NULL
- userId (user_id) — Long — Foreign key → users.userId — NOT NULL
- Field (likes_count) — Long
- Field (created_date) — Date — NOT NULL
post_likes
- post_likes (post_like_id) — Long — Primary key — NOT NULL
- postId (post_id) — Long — Foreign key → post.postId — NOT NULL
- userId (user_id) — Long — Foreign key → users.userId — NOT NULL
users
- userId (user_id) — Long — Primary key — NOT NULL
- password — varchar(30) — NOT NULL
- email — varchar(30) — NOT NULL
- nickname — varchar(15) — NOT NULL
- amdin (role) — varchar(15) — NOT NULL