UMC Instagram

테이블 (10)

Untitled (Follower)

  • Key (idx) — bigint — 기본 키 — NOT NULL
  • Field2 (user_idx) — bigint — NOT NULL
  • Field (status) — varchar(10) — NOT NULL
  • Field2 (createdAt) — timestamp — NOT NULL
  • Field (updatedAt) — timestamp — NOT NULL

Untitled (Story)

  • Key (idx) — bigint — 기본 키 — NOT NULL
  • Field (user_idx) — bigint — NOT NULL
  • Field (status) — varchar(10) — NOT NULL
  • Field (createdAt) — timestamp — NOT NULL
  • Field (updatedAt) — timestamp — NOT NULL

Untitled (StoryImage)

  • Key (idx) — bigint — 기본 키 — NOT NULL
  • Field (story_idx) — bigint — NOT NULL
  • Field (image_url) — text — NOT NULL
  • Field (status) — varchar(10) — NOT NULL
  • Field (createdAt) — timestamp — NOT NULL
  • Field (updatedAt) — timestamp — NOT NULL

Untitled2 (Following)

  • Key (idx) — bigint — 기본 키 — NOT NULL
  • Field (user_idx) — bigint — NOT NULL
  • Field (status) — varchar(10) — NOT NULL
  • Field2 (createdAt) — timestamp — NOT NULL
  • Field (updatedAt) — timestamp — NOT NULL

게시글 (Posts)

  • Key (idx) — bigint — 기본 키 — NOT NULL
  • Field2 (user_idx) — bigint — NOT NULL
  • Field (content) — text
  • Field (status) — varchar(10) — NOT NULL
  • Field3 (createdAt) — timestamp — NOT NULL
  • Field4 (updatedAt) — timestamp — NOT NULL

게시글 사진 (PostImage)

  • Key (idx) — bigint — 기본 키 — NOT NULL
  • Field (post_idx) — bigint — NOT NULL
  • Field (image_url) — text — NOT NULL
  • Field2 (status) — varchar(10) — NOT NULL
  • Field (createdAt) — timestamp — NOT NULL
  • Field2 (updatedAt) — timestamp — NOT NULL

댓글 (Reply)

  • Key (idx) — bigint — 기본 키 — NOT NULL
  • Field (user_idx) — bigint — NOT NULL
  • Field2 (post_idx) — bigint — NOT NULL
  • Field (content) — text — NOT NULL
  • Field (status) — varchar(10) — NOT NULL
  • Field2 (createdAt) — timestamp — NOT NULL
  • Field3 (updatedAt) — timestamp — NOT NULL

사용자 (User)

  • Key (idx) — bigint — 기본 키 — NOT NULL
  • Field (email) — varchar(50) — NOT NULL
  • Field2 (nickname) — varchar(50) — NOT NULL
  • Field3 (password) — text — NOT NULL
  • Field4 (status) — varchar(10) — NOT NULL
  • Field5 (createdAt) — timestamp — NOT NULL
  • Field (updatedAt) — timestamp — NOT NULL

좋아요 (Likes)

  • Key (idx) — bigint — 기본 키 — NOT NULL
  • Field (user_idx) — bigint — NOT NULL
  • Field2 (post_idx) — bigint — NOT NULL
  • Field (reply_idx) — bigint — NOT NULL
  • Field (story_idx) — bigint — NOT NULL
  • Field (status) — varchar(10) — NOT NULL
  • Field2 (createdAt) — timestamp — NOT NULL
  • Field3 (updatedAt) — timestamp — NOT NULL

프로필 사진 (ProfileImage)

  • Key (idx) — bigint — 기본 키 — NOT NULL
  • Field (user_idx) — bigint — NOT NULL
  • Field (image_url) — text
  • Field2 (status) — varchar(10) — NOT NULL
  • Field (createdAt) — timestamp — NOT NULL
  • Field2 (updatedAt) — timestamp — NOT NULL