newsFeed
Tables (5)
comment
- comment_id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Foreign key → post.post_id — NOT NULL — 게시글 고유 식별자
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL — 유저 고유 식별자
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
follow
- follow_id — BIGINT — Primary key — NOT NULL
- follower_id — BIGINT — Foreign key → users.user_id — NOT NULL
- following_id — BIGINT — Foreign key → users.user_id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
like
- like_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL — 유저 고유 식별자
- post_id — BIGINT — Foreign key → post.post_id — NOT NULL — 게시글 고유 식별자
- created_at — TIMESTAMP — NOT NULL
post
- post_id — BIGINT — Primary key — NOT NULL — 게시글 고유 식별자
- user_id — BIGINT — NOT NULL — 유저고유식별자
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- image — VARCHAR(500)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
users
- user_id — BIGINT — Primary key — NOT NULL — 유저 고유 식별자
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- username — VARCHAR(100) — NOT NULL
- profile_image — VARCHAR(500)
- bio — TEXT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL