velog-clone
Tables (6)
comments
- comment_id — LONG — Primary key — NOT NULL
- content — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- post_id — LONG — Foreign key → posts.post_id — NOT NULL
- user_id — LONG — Foreign key → users.user_id — NOT NULL
follows
- follow_id — LONG — Primary key — NOT NULL
- follwer_id (user_id) — LONG — Foreign key → profiles.profile_id — NOT NULL
- following_id — LONG — Foreign key → profiles.profile_id — NOT NULL
likes
- like_id — LONG — Primary key — NOT NULL
- user_id — LONG — Foreign key → users.user_id — NOT NULL
- post_id — LONG — Foreign key → posts.post_id — NOT NULL
posts
- post_id — LONG — Primary key — NOT NULL
- title — VARCHAR(255)
- content — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- user_id — LONG — Foreign key → users.user_id — NOT NULL
profiles
- profile_id — LONG — Primary key — NOT NULL
- nickname — VARCHAR(255)
- bio — VARCHAR(255) — NOT NULL
- profile_image_url — VARCHAR(500) — NOT NULL
- user_id — LONG — Foreign key → users.user_id — NOT NULL
users
- user_id — LONG — Primary key — NOT NULL
- email — VARCHAR(255)
- password — VARCHAR(255)
- social_id — VARCHAR(255)