instagram
Tables (9)
Comment (Untitled3)
- id (Key) — int — Primary key — NOT NULL
- user_id (id3) — int — Foreign key → User.id — NOT NULL
- post_id (id) — int — Foreign key → Post.id — NOT NULL
- content (Field3) — varchar — NOT NULL
- parent_id (Key2) — int — Foreign key → Comment.id
- created_at (Field4) — timestamp — NOT NULL
- updated_at (Field5) — timestamp — NOT NULL
- deleted_at (Field6) — timestamp
Comment_Like (CopyOfUntitled2)
- user_id (id2) — int — Foreign key → User.id — NOT NULL
- comment_id (Key) — int — Foreign key → Comment.id — NOT NULL
Following (Untitled4)
- id (Key) — int — Primary key — NOT NULL
- user_id (id3) — int — Foreign key → User.id — NOT NULL
- following (id) — int — Foreign key → User.id — NOT NULL
Hashtag (Untitled5)
- id (Key) — int — Primary key — NOT NULL
- tag (Field) — varchar — NOT NULL
- created_at (Field2) — timestamp — NOT NULL
- deleted_at (Field3) — timestamp
Image (Untitled)
- id (Key) — int — Primary key
- post_id (id) — int — Foreign key → Post.id — NOT NULL
- uri (Field2) — varchar — NOT NULL
- created_at (Field3) — timestamp — NOT NULL
- updated_at (Field4) — timestamp — NOT NULL
- deleted_at (Field5) — timestamp
Post
- id — int — Primary key — NOT NULL
- user_id (id2) — int — Foreign key → User.id — NOT NULL
- content — varcher
- status (Field3) — varcher — NOT NULL
- created_at (Field4) — timestamp — NOT NULL
- updated_at (Field) — timestamp — NOT NULL
- deleted_at (Field2) — timestamp
Post_Hashtag (Untitled6)
- hashtag_id (Key3) — int — Foreign key → Hashtag.id — NOT NULL
- post_id (id2) — int — Foreign key → Post.id — NOT NULL
Post_Like (Untitled2)
- user_id (id) — int — Foreign key → User.id — NOT NULL
- post_id (id2) — int — Foreign key → Post.id — NOT NULL
User
- id — int — Primary key — NOT NULL
- email — varchar — NOT NULL
- nickname — varchar — NOT NULL
- password — varchar — NOT NULL
- phone_num — varchar
- profile_uri (Field) — varchar
- status — varchar — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at (update_at) — timestamp — NOT NULL
- deleted_at — timestamp