instagram
Tables (6)
comment
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → users.id — NOT NULL
- post_id — CHAR(36) — Foreign key → post.id — NOT NULL
- content — VARCHAR(255)
- created_at — TIMESTAMP — NOT NULL
follow
- user_id_from — CHAR(36) — Foreign key → users.id — NOT NULL
- user_id_to — CHAR(36) — Foreign key → users.id — NOT NULL
- is_followed — BOOLEAN — NOT NULL
hashtag
- content — VARCHAR(255) — Primary key — NOT NULL
- post_id — CHAR(36) — Foreign key → post.id — NOT NULL
like
- post_id — CHAR(36) — Foreign key → post.id — NOT NULL
- user_id — CHAR(36) — Foreign key → users.id — NOT NULL
- is_liked — BOOLEAN — NOT NULL
post
- id — CHAR(36) — Primary key
- user_id — CHAR(36) — Foreign key → users.id — NOT NULL
- content — VARCHAR(255)
- image — VARCHAR(255)
users
- id — CHAR(36) — Primary key
- name — VARCHAR(255)
- email — VARCHAR(255)
- password — VARCHAR(255)