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