Instagram_Modeling
Tables (5)
Comment (Untitled5)
- id (Key) — int — Primary key — NOT NULL
- user_id (Key2) — int — Foreign key → User.id — NOT NULL
- post_id (Key3) — int — Foreign key → Post.id — NOT NULL
- text (Field) — varchar
Like (Untitled4)
- user_id (Key) — int — Foreign key → User.id — NOT NULL
- post_id (Key2) — int — Foreign key → Post.id — NOT NULL
Media (Untitled3)
- Key — Primary key — NOT NULL
- content_url (Field2) — varchar
- post_id (Key2) — int — Foreign key → Post.id — NOT NULL
Post (Untitled2)
- id (Key) — int — Primary key — NOT NULL
- text (Field) — varchar
- created_at (Field2) — timestamp
- user_id (Key2) — int — Foreign key → User.id — NOT NULL
User (Untitled)
- id (Key) — int — Primary key — NOT NULL
- email (Field) — varchar
- name (Field2) — varchar
- password (Field3) — password
- created_at (Field4) — timestamp