w6-newsfeed

Tables (6)

Untitled (accounts)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (email) — varchar(255) — NOT NULL
  • Field (password) — varchar(80) — NOT NULL
  • Field (name) — varchar(20) — NOT NULL — 한글 기준 최대 6자
  • Field (birthdate) — date
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime — NOT NULL

Untitled (friends)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (from_profile_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (to_profile_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (status) — varchar(20) — NOT NULL — default 'PENDING'
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime — NOT NULL

Untitled (post_likes)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (post_id) — bigint — Foreign key → Untitled2.Key — NOT NULL
  • Key (profile_id) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (profiles)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (account_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (nickname) — varchar(25) — NOT NULL — 한글 기준 최대 8자
  • Field (profile_img_url) — text
  • Field (bio) — varchar(160) — 한글 기준 최대 50자
  • Field (friends_count) — int — NOT NULL — default 0
  • Field (post_count) — int — NOT NULL — default 0
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime — NOT NULL

Untitled2 (posts)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (profile_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (content) — varchar(4500) — NOT NULL — 한글 기준 최대 1500자
  • Field (view_count) — int — NOT NULL — default 0
  • Field (comment_count) — int — NOT NULL — default 0
  • Field (like_count) — int — NOT NULL — default 0
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime — NOT NULL

Untitled3 (comments)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (profile_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (post_id) — bigint — Foreign key → Untitled2.Key — NOT NULL
  • Field (content) — varchar(600) — NOT NULL — 한글 기준 최대 200자
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime — NOT NULL