커뮤니티 DB

테이블 (8)

comments

  • comment_id — INT — 기본 키 — NOT NULL
  • comment_content — VARCHAR(600) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • comment_status — ENUM('ACTIVE', 'DELETED') — NOT NULL
  • post_id (post_id2) — INT — 외래 키 → posts.post_id — NOT NULL
  • user_id (user_id2) — INT — 외래 키 → users.user_id — NOT NULL

images

  • image_id — INT — 기본 키 — NOT NULL
  • image_url — VARCHAR(2048) — NOT NULL
  • file_size — INT
  • original_filename — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL

post_images

  • image_id (image_id2) — INT — 외래 키 → images.image_id — NOT NULL
  • post_id — INT — 외래 키 → posts.post_id — NOT NULL
  • display_order — TINYINT — NOT NULL

post_likes

  • like_id (lkie_id) — INT — 기본 키 — NOT NULL
  • created_at — TIMESTAMP
  • user_id (user_id2) — INT — 외래 키 → users.user_id — NOT NULL
  • post_id (post_id2) — INT — 외래 키 → posts.post_id — NOT NULL

post_stats

  • post_id (post_id2) — INT — 외래 키 → posts.post_id — NOT NULL
  • like_count — INT — NOT NULL
  • comment_count — INT — NOT NULL
  • view_count — INT — NOT NULL
  • last_updated — TIMESTAMP — NOT NULL

posts

  • post_id — INT — 기본 키 — NOT NULL
  • post_title — VARCHAR(100) — NOT NULL
  • post_content — LONGTEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • post_status — ENUM('ACTIVE', 'DELETED', 'DRAFT') — NOT NULL
  • user_id — INT

user_tokens

  • user_token_id — INT — 기본 키 — NOT NULL
  • token — VARCHAR(512) — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • user_agent — VARCHAR(255)
  • ip_address — VARCHAR(45)
  • user_id (user_id2) — INT — 외래 키 → users.user_id — NOT NULL

users

  • user_id — INT — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(30) — NOT NULL
  • role — ENUM('USER', 'ADMIN') — NOT NULL
  • user_status — ENUM('ACTIVE', 'INACTIVE','DELETED') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • image_id (image_id2) — INT — 외래 키 → images.image_id — NOT NULL