나의 스취
테이블 (6)
comments
- id — BIGSERIAL
- post_id — BIGINT — 외래 키 → posts.id — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- parent_id — BIGINT — 외래 키 → comments.id
- content — TEXT — NOT NULL
- is_deleted — BOOLEAN — NOT NULL — Soft
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
likes
- id — BIGSERIAL
- post_id — BIGINT — 외래 키 → posts.id — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL — 좋아요
- created_at — TIMESTAMP — NOT NULL
post_images
- id — BIGSERIAL
- post_id — BIGINT — 외래 키 → posts.id — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
- order_index — SMALLINT — NOT NULL — 이미지
- created_at — TIMESTAMP — NOT NULL
posts
- id — BIGSERIAL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- content — TEXT — NOT NULL — 게시글
- is_deleted — BOOLEAN — NOT NULL — Soft
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
refresh_tokens
- id — BIGSERIAL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- token — VARCHAR(512) — NOT NULL
- expires_at — TIMESTAMP — NOT NULL — 토큰
- created_at — TIMESTAMP — NOT NULL
users
- id — BIGSERIAL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL — BCrypt
- nickname — VARCHAR(50) — NOT NULL — 닉네임
- profile_image_url — VARCHAR(500) — S3
- bio — VARCHAR(300) — 자기소개
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL