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