NewsFeed

Tables (4)

Comments (댓글)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • contents (Field) — VARCHAR(200) — NOT NULL
  • created_at (Field2) — DATETIME(6) — NOT NULL
  • modified_at (Field3) — DATETIME(6) — NOT NULL
  • user_id (Key2) — BIGINT — Foreign key → Users.id — NOT NULL
  • post_id (Key3) — BIGINT — Foreign key → Posts.id — NOT NULL

Followers (팔로우 관리)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • following_user_id (Key2) — BIGINT — Foreign key → Users.id — NOT NULL
  • follower_user_id (Key3) — BIGINT — Foreign key → Users.id — NOT NULL

Posts (게시물)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • title (Field) — VARCHAR(50) — NOT NULL
  • contents (Field2) — LONGTEXT — NOT NULL
  • created_at (Field3) — DATETIME(6) — NOT NULL
  • modified_at (Field4) — DATETIME(6) — NOT NULL
  • user_id (Key2) — BIGINT — Foreign key → Users.id — NOT NULL

Users (유저)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • email (Field) — VARCHAR(255) — NOT NULL
  • password (Field2) — VARCHAR(255) — NOT NULL
  • username (Field3) — VARCHAR(50) — NOT NULL
  • address (Field4) — VARCHAR(100) — NOT NULL
  • created_at (Field6) — DATETIME(6) — NOT NULL
  • modified_at (Field7) — DATETIME(6) — NOT NULL
  • deleted_at (Field5) — DATETIME(6)