news feed

Tables (7)

comment_likes (Untitled6)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key2) — BIGINT — Foreign key → users.id — NOT NULL
  • comment_id (Key3) — BIGINT — Foreign key → comments.id — NOT NULL

comments (Untitled4)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • content (Field) — VARCHAR(255)
  • created_at (Field2) — DATETIME(6)
  • modified_at (Field3) — DATETIME(6)
  • user_id (Key2) — BIGINT — Foreign key → users.id — NOT NULL
  • post_id (Key3) — BIGINT — Foreign key → posts.id — NOT NULL

deleted_users (Untitled7)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • email (Field) — VARCHAR(255)
  • deleted_at (Field2) — DATETIME(6)

follows (Untitled3)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • follower_id (Key3) — BIGINT — Foreign key → users.id — NOT NULL
  • following_id (Key4) — BIGINT — Foreign key → users.id — NOT NULL

post_likes (Untitled5)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key2) — BIGINT — Foreign key → users.id — NOT NULL
  • post_id (Key3) — BIGINT — Foreign key → posts.id — NOT NULL

posts (Untitled2)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • title (Field) — VARCHAR(30)
  • content (Field2) — VARCHAR(255)
  • created_at (Field3) — DATETIME(6)
  • moidified_at (Field4) — DATETIME(6)
  • user_id (Key2) — BINGINT — Foreign key → users.id — NOT NULL

users (Untitled)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • user_name (Field) — VARCHAR(30)
  • email (Field2) — VARCHAR(255)
  • password (Field3) — VARCHAR(255)