인스타그램 클론

테이블 (14)

Untitled (users)

  • Key (user_id) — int — 기본 키 — NOT NULL
  • Field (email) — varchar(100) — NOT NULL
  • Field (password) — varchar(255) — NOT NULL
  • Field (last_active_at) — date — NOT NULL — need to decide which to ref
  • Field (created_at) — date — NOT NULL
  • Field (updated_at) — date — NOT NULL

Untitled (profile)

  • Key (user_id) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (username) — varchar(100) — NOT NULL
  • Field (fullname) — varchar(100) — NOT NULL
  • Field (image_url) — varchar(255)
  • Field (description) — varchar(255)
  • Field (gender) — varchar(1)
  • Field (website_url) — varchar(500)

Untitled (follow)

  • Key (follower_id) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (followee_id) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (post)

  • Key (post_id) — int — 기본 키 — NOT NULL
  • Key (user_id) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (content) — varchar(500)
  • Field (created_at) — date — NOT NULL
  • Field (updated_at) — date — NOT NULL

Untitled (post_like)

  • Key (user_id) — int — 외래 키 → Untitled.Key — NOT NULL — comb key
  • Key (post_id) — int — 외래 키 → Untitled.Key — NOT NULL — comb key

Untitled (comment)

  • Key (comment_id) — int — 기본 키 — NOT NULL
  • Key (post_id) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (user_id) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (parent_id) — int — 외래 키 → Untitled.Key
  • Field (content) — text — NOT NULL
  • Field (depth) — int — NOT NULL — default = 1 (maxLim= 2)
  • Field (created_at) — date — NOT NULL
  • Field (updated_at) — date — NOT NULL

Untitled (comment_like)

  • Key (user_id) — int — 외래 키 → Untitled.Key — NOT NULL — comb key
  • Key (comment_id) — int — 외래 키 → Untitled.Key — NOT NULL — comb key

Untitled (user_chatroom)

  • Key (user_chatroom_id) — int — 기본 키 — NOT NULL
  • Key (user_id) — int — 외래 키 → Untitled.Key — NOT NULL — unique comb w/ chatroom_id
  • Key (chatroom_id) — int — 외래 키 → Untitled.Key — NOT NULL — unique comb w/ user_id

Untitled (chatroom)

  • Key (chatroom_id) — int — 기본 키 — NOT NULL
  • Field (created_at) — date — NOT NULL
  • Field (updated_at) — date — NOT NULL

Untitled (photo)

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (post_id) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (url) — varchar(255) — NOT NULL

Untitled (tag)

  • Key (tag_id) — int — 기본 키 — NOT NULL
  • Key (tag) — varchar(100) — 기본 키 — NOT NULL — unique

Untitled (message)

  • Key (message_id) — int — 기본 키 — NOT NULL
  • Key (user_chatroom_id) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (parent_id) — int — 외래 키 → Untitled.Key
  • Field (content) — text — NOT NULL
  • Field (created_at) — date — NOT NULL
  • Field (updated_at) — date — NOT NULL
  • Field (depth) — int — NOT NULL — default = 1 (maxLim= 2)

Untitled (message_like)

  • Key (message_id) — int — 외래 키 → Untitled.Key — NOT NULL — comb key
  • Key (user_id) — int — 외래 키 → Untitled.Key — NOT NULL — comb key

Untitled (tag_post)

  • Key (post_id) — int — 외래 키 → Untitled.Key — NOT NULL — comb key
  • Key (tag_id) — int — 외래 키 → Untitled.Key — NOT NULL — comb key