newsFeed

Tables (5)

comment

  • comment_id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → post.post_id — NOT NULL — 게시글 고유 식별자
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL — 유저 고유 식별자
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

follow

  • follow_id — BIGINT — Primary key — NOT NULL
  • follower_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • following_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

like

  • like_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL — 유저 고유 식별자
  • post_id — BIGINT — Foreign key → post.post_id — NOT NULL — 게시글 고유 식별자
  • created_at — TIMESTAMP — NOT NULL

post

  • post_id — BIGINT — Primary key — NOT NULL — 게시글 고유 식별자
  • user_id — BIGINT — NOT NULL — 유저고유식별자
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • image — VARCHAR(500)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL — 유저 고유 식별자
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • username — VARCHAR(100) — NOT NULL
  • profile_image — VARCHAR(500)
  • bio — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL