clone

Tables (5)

comments

  • comment_id (id) — LONG — Primary key
  • parent_id — LONG
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • post_id (Key) — LONG — Foreign key → posts.post_id — NOT NULL
  • user_id — LONG — Foreign key → users.user_id

post_images

  • image_id — LONG — Primary key
  • image_url — VARCHAR(500) — NOT NULL
  • position — INT — NOT NULL
  • created_at — TIMESTAMP
  • post_id — LONG — Foreign key → posts.post_id — NOT NULL

posts

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

profiles

  • profile_id — LONG — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • profile_pic — VARCHAR(255)
  • bio_short — VARCHAR(255)
  • bio — TEXT
  • user_id — LONG — Foreign key → users.user_id

users

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