stocussion

테이블 (6)

Copy Of Copy Of Untitled2 (user_post_like)

  • Key (user_post_like_id) — int — 기본 키 — NOT NULL
  • (user_id) — int — 외래 키 → 회원.user_id — NOT NULL
  • Key (post_id) — int — 외래 키 → Untitled.Key — NOT NULL

Copy Of Untitled2 (user_comment_like)

  • Key (user_comment_like_id) — int — 기본 키 — NOT NULL
  • (user_id) — int — 외래 키 → 회원.user_id — NOT NULL
  • Key (comment_id) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (comment)

  • Key (comment_id) — int — 기본 키 — NOT NULL
  • Field (content) — vachar
  • Field (creat_at) — datetime
  • Key (post_id) — int — 외래 키 → Untitled.Key — NOT NULL
  • (user_id) — int — 외래 키 → 회원.user_id — NOT NULL

Untitled (post)

  • Key (post_id) — int — 기본 키 — NOT NULL
  • Field (title) — vachar
  • Field (content) — longtext
  • Field (upload_at) — datetime(6)
  • Field (like_num) — int
  • Field (image_url)
  • (user_id) — int — 외래 키 → 회원.user_id — NOT NULL

Untitled (follow)

  • Key (Follow_id) — 기본 키 — NOT NULL
  • (follower_id) — int — 외래 키 → 회원.user_id — NOT NULL
  • (following_id) — int — 외래 키 → 회원.user_id — NOT NULL

회원 (user)

  • (user_id) — int — 기본 키 — NOT NULL
  • Field (name) — vachar
  • Field2 (email) — vachar
  • Field4 (password) — vachar
  • Field5 (remember_token) — vachar
  • Field (introduction) — vachar
  • Field (profile_image) — vachar