velog-clone

Tables (6)

comments

  • comment_id — LONG — Primary key — NOT NULL
  • content — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • post_id — LONG — Foreign key → posts.post_id — NOT NULL
  • user_id — LONG — Foreign key → users.user_id — NOT NULL

follows

  • follow_id — LONG — Primary key — NOT NULL
  • follwer_id (user_id) — LONG — Foreign key → profiles.profile_id — NOT NULL
  • following_id — LONG — Foreign key → profiles.profile_id — NOT NULL

likes

  • like_id — LONG — Primary key — NOT NULL
  • user_id — LONG — Foreign key → users.user_id — NOT NULL
  • post_id — LONG — Foreign key → posts.post_id — NOT NULL

posts

  • post_id — LONG — Primary key — NOT NULL
  • title — VARCHAR(255)
  • content — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • user_id — LONG — Foreign key → users.user_id — NOT NULL

profiles

  • profile_id — LONG — Primary key — NOT NULL
  • nickname — VARCHAR(255)
  • bio — VARCHAR(255) — NOT NULL
  • profile_image_url — VARCHAR(500) — NOT NULL
  • user_id — LONG — Foreign key → users.user_id — NOT NULL

users

  • user_id — LONG — Primary key — NOT NULL
  • email — VARCHAR(255)
  • password — VARCHAR(255)
  • social_id — VARCHAR(255)