Instagram clone

Tables (6)

Copy Of Untitled (Like)

  • Key (ID) — bigint — Primary key — NOT NULL
  • Key (POST_ID) — bigint — Foreign key → Untitled2.Key — NOT NULL
  • Key (USER_ID) — bigint — Foreign key → Untitled2.Key — NOT NULL

Untitled (File)

  • Key (ID) — bigint — Primary key — NOT NULL
  • Key (POST_ID) — bigint — Foreign key → Untitled2.Key — NOT NULL
  • Field (FILE) — file — NOT NULL

Untitled (Comment)

  • Key (ID) — bigint — Primary key — NOT NULL
  • Key (POST_ID) — bigint — Foreign key → Untitled2.Key — NOT NULL
  • Key (USER_ID) — bigint — Foreign key → Untitled2.Key — NOT NULL
  • Field (CONTENT) — text — NOT NULL
  • Field (CREATED_AT) — datetime — NOT NULL
  • Field (UPDATED_AT) — datetime — NOT NULL

Untitled2 (User)

  • Key (ID) — bigint — Primary key — NOT NULL
  • Field (EMAIL) — varchar — NOT NULL
  • Field2 (PASSWORD) — varchar — NOT NULL

Untitled2 (Profile)

  • Key (USER_ID) — bigint — Foreign key → Untitled2.Key — NOT NULL
  • Field (NAME) — varchar
  • Field (SITE) — text
  • Field (BIO) — text
  • Field (PROFILE_IMAGE) — image

Untitled2 (Post)

  • Key (ID) — bigint — Primary key — NOT NULL
  • Key (USER_ID) — bigint — Foreign key → Untitled2.Key — NOT NULL
  • Field (CONTENT) — text
  • Field (CREATED_AT) — datetime — NOT NULL
  • Field (LIKE_COUNT) — int
  • Field (COMMENT_COUNT) — int