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)