항해블로그

테이블 (5)

Copy Of Post_like (Comment_like)

  • Key (comment_like_id) — bigint — 기본 키 — NOT NULL
  • Key (comment_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • member_id — bigint — 외래 키 → Member.member_id — NOT NULL

Member

  • member_id — bigint — 기본 키 — NOT NULL
  • username — varcher — NOT NULL
  • password — varvhar — NOT NULL

Post

  • post_id — bigint — 기본 키 — NOT NULL
  • member_id — bigint — 외래 키 → Member.member_id — NOT NULL
  • Field (title) — varvhar
  • Field (content) — varvhar
  • Field (created_at) — timestamp
  • Field (modified_at) — timestamp

Post_like

  • Key (post_like_id) — bigint — 기본 키 — NOT NULL
  • post_id — bigint — 외래 키 → Post.post_id — NOT NULL
  • member_id — bigint — 외래 키 → Member.member_id — NOT NULL

Untitled (Comment)

  • Key (comment_id) — bigint — 기본 키 — NOT NULL
  • post_id — bigint — 외래 키 → Post.post_id — NOT NULL
  • member_id — bigint — 외래 키 → Member.member_id — NOT NULL
  • Field (author) — varchar
  • Field (content) — varchar