인스타그램

테이블 (6)

Untitled (posts)

  • Key (post_id) — BIGINT — 기본 키 — NOT NULL
  • Key (user_id) — BIGINT — 외래 키 → user_id.Key — NOT NULL
  • Field (timestamp) — TIMESTAMP
  • Field (content) — VARCHAR(100)

Untitled (follower_map)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • Key (user_id) — BIGINT — 외래 키 → user_id.Key — NOT NULL

Untitled (comment_likes)

  • Key (comment_like_id) — BIGINT — 기본 키 — NOT NULL
  • Key (user_id) — BIGINT — 외래 키 → user_id.Key — NOT NULL
  • Key (comment_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Key (user_id2) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Key (post_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Key (user_id22) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Field (timestamp) — TIMESTAMP
  • Field (target_type) — INTEGER

Untitled (comments)

  • Key (comment_id) — BIGINT — 기본 키 — NOT NULL
  • Key (user_id) — BIGINT — 외래 키 → user_id.Key — NOT NULL
  • Key (post_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Key (user_id2) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Field (content) — VARCHAR(100)
  • Field (timestamp) — TIMESTAMP

Untitled (post_likes)

  • Key (post_like_id) — BIGINT — 기본 키 — NOT NULL
  • Key (post_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Key (user_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Key (user_id2) — BIGINT — 외래 키 → user_id.Key — NOT NULL
  • Field (timestamp) — TIMESTAMP
  • Field (target_type) — INTEGER

user_id (users)

  • Key (user_id) — BIGINT — 기본 키 — NOT NULL
  • Field (email) — VARCHAR(50)
  • Field (password) — VARCHAR(50)
  • Field (name) — VARCHAR(50)