NewsFeed

Tables (3)

Untitled (comment)

  • Key (id) — long — Primary key — NOT NULL
  • id (user_id) — long — Foreign key → user.id — NOT NULL
  • Field (comment_content) — varchar
  • Field2 (created_at) — datetime
  • Field3 (modified_at) — datetime
  • id (post_id) — long — Foreign key → post.id — NOT NULL

post

  • id — long — Primary key — NOT NULL
  • id (user_id) — long — Foreign key → user.id — NOT NULL
  • Field (post_title)
  • content (post_content) — VARCHAR
  • post_image_url — VARCHAR
  • created_at — datetime
  • modified_aft (modified_at) — datetime

user

  • id (유저 번호) — BIGINT — Primary key — NOT NULL
  • name (user_name) — VARCHAR
  • Field2 (registration_number) — INT — NOT NULL — 주민등록번호
  • email (eamil) — VARCHAR
  • password — VARCHAR
  • profile_image_url — VARCHAR
  • Field (nickname) — VARCHAR — NOT NULL
  • Field (phone_number) — INT — NOT NULL