게시판

테이블 (6)

Comment

  • comment_id — INT UNSIGNED — 기본 키
  • content — TEXT
  • created_at — DATETIME
  • deleted_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • user_id — INT UNSIGNED — 외래 키 → User.user_id
  • post_id — INT UNSIGNED — 외래 키 → Post.post_id — NOT NULL

Image

  • image_id — INT UNSIGNED — 기본 키
  • is_active — BOOLEAN
  • created_at — DATETIME
  • storage_path — VARCHAR(500)
  • thumbnail_path — VARCHAR(500) — NOT NULL
  • post_id — INT UNSIGNED — 외래 키 → Post.post_id — NOT NULL
  • uploaded_by — INT UNSIGNED — 외래 키 → User.user_id
  • user_id — INT UNSIGNED — 외래 키 → User.user_id

Likes

  • post_id — INT UNSIGNED — 외래 키 → Post.post_id
  • user_id — INT UNSIGNED — 외래 키 → User.user_id
  • created_at — DATETIME

Post

  • post_id — INT UNSIGNED — 기본 키 — NOT NULL
  • title — VARCHAR(26)
  • content — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME — NOT NULL
  • view_count — INT UNSIGNED — NOT NULL
  • user_id — INT UNSIGNED — 외래 키 → User.user_id

Refresh Token

  • refresh_token_id — INT UNSIGNED — 기본 키
  • refresh_token (Field2) — VARCHAR(255)
  • expires_at — DATETIME
  • created_at — DATETIME
  • user_id — INT UNSIGNED — 외래 키 → User.user_id

User

  • user_id — INT UNSIGNED — 기본 키
  • email — VARCHAR(255)
  • nickname — VARCHAR(255)
  • password — VARCHAR(255)
  • status — VARCHAR(20)
  • created_at — DATETIME
  • deleted_at — DATETIME