나의 스취

테이블 (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