Sepfolio

Tables (4)

comments

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.id — NOT NULL
  • post_id — INT — Foreign key → posts.id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP

likes

  • user_id — INT — Foreign key → users.id — NOT NULL
  • post_id — INT — Foreign key → posts.id — NOT NULL

posts

  • id — INT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • body — TEXT — NOT NULL
  • user_id — INT — Foreign key → users.id — NOT NULL
  • post_image — VARCHAR(255)
  • view_count — INT
  • like_count — INT
  • comment_count — INT
  • created_at — TIMESTAMP

users

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • profile_image — VARCHAR(255)
  • created_at — TIMESTAMP