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)