Instagram_answer
Tables (8)
comments (Untitled4)
- comment_id — UUID — Primary key — NOT NULL
- post_id — UUID — Foreign key → posts.post_id — NOT NULL
- body — VARCHAR(100)
followers (Untitled7)
- follwoing_id (following_id) — UUID — Foreign key → users.user_id — NOT NULL
- follower_id — UUID — Foreign key → users.user_id — NOT NULL
hashtags (Untitled5)
- tag_id — UUID — Primary key — NOT NULL
- title — VARCHAR(10)
likes (Untitled8)
- user_id — UUID — Foreign key → users.user_id — NOT NULL
- post_id — UUID — Foreign key → posts.post_id — NOT NULL
photos (Untitled2)
- photo_id — UUID — Primary key — NOT NULL
- post_id — UUID — Foreign key → posts.post_id — NOT NULL
- image_uri — VARCHAR(255)
posts (Untitled3)
- post_id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.user_id — NOT NULL
- content — TEXT
posts_hashtags (Untitled6)
- post_id — UUID — Foreign key → posts.post_id — NOT NULL
- tag_id — UUID — Foreign key → hashtags.tag_id — NOT NULL
users (Untitled)
- user_id — UUID — Primary key — NOT NULL
- name — VARCHAR(100)
- created_at — TIMESTAMP