연습

테이블 (7)

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Untitled (tag_post_map)

  • Key (tag_post_map_id) — BIGINT — 기본 키 — NOT NULL
  • Key (post_id) — BIGINT — 외래 키 → Copy Of Copy Of Copy Of Copy Of Untitled.Key — NOT NULL
  • Key (user_id) — BIGINT — 외래 키 → Copy Of Copy Of Copy Of Copy Of Untitled.Key — NOT NULL
  • Key (tag_id) — BIGINT — 외래 키 → Copy Of Copy Of Copy Of Copy Of Copy Of Untitled.Key — NOT NULL

Copy Of Copy Of Copy Of Copy Of Copy Of Untitled (tags)

  • Key (tag_id) — BIGINT — 기본 키 — NOT NULL
  • Field (name) — VARCHAR(20)

Copy Of Copy Of Copy Of Copy Of Untitled (posts)

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

Copy Of Copy Of Copy Of Untitled (comments)

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

Copy Of Copy Of Untitled (users)

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

Copy Of Untitled (likes)

  • Key (likes_id) — BIGINT — 기본 키 — NOT NULL
  • Key (comments_id) — BIGINT — 외래 키 → Copy Of Copy Of Copy Of Untitled.Key — NOT NULL
  • Key (post_id) — BIGINT — 외래 키 → Copy Of Copy Of Copy Of Untitled.Key — NOT NULL
  • Key (user_id) — BIGINT — 외래 키 → Copy Of Copy Of Copy Of Untitled.Key — NOT NULL
  • Field (target_id) — BIGINT
  • Field2 (timestamp) — TIMESTAMP
  • Field (target_type) — INTEGER

Untitled (follower_map)

  • Key (follower_id) — BIGINT — 기본 키 — NOT NULL
  • Key (following_id) — BIGINT — 기본 키 — NOT NULL
  • Key (user_id) — BIGINT — 외래 키 → Copy Of Copy Of Untitled.Key — NOT NULL
  • Field (target_id) — BIGINT