devCommunity
Tables (6)
Comment
- id — int — Primary key — NOT NULL
- id (userId) — int — Foreign key → User_Post.id — NOT NULL
- id (postId) — int — Foreign key → User_Post.id — NOT NULL
- content — text
- createdAt — timestamp
Like
- id — int — Primary key — NOT NULL
- id (userId) — int — Foreign key → User_Post.id — NOT NULL
- id (postId) — int — Foreign key → User_Post.id — NOT NULL
Post
- id (postId) — int — Primary key — NOT NULL
- title — text
- content — text
- createdAt — timestamp
- updatedAt — timestamp
User
- userId — int — Primary key — NOT NULL
- email — text
- encryptedPassword — text
- createdAt — timestamp
UserProfile
- userProfileId — int — Primary key — NOT NULL
- userId — int — Foreign key → User.userId — NOT NULL
- nickname — text
- name — text
User_Post
- id — int — Primary key — NOT NULL
- id (userId) — int — Foreign key → User.userId — NOT NULL
- id (postId) — int — Foreign key → Post.id — NOT NULL