erd-practice
Tables (8)
comments (Untitled4)
- comment_id — UUID — Primary key — NOT NULL
- body — VARCHAR(100)
- post_id — UUID — Foreign key → posts.post_id — NOT NULL
- user_id — UUID — Foreign key → users.user_id — NOT NULL — RRIMARY KEY
followers (Untitled7)
- user_id (누가) — UUID — Foreign key → users.user_id — NOT NULL — RRIMARY KEY
- user_id (누구를) — UUID — Foreign key → users.user_id — NOT NULL — RRIMARY KEY
hashtags (Untitled5)
- tag_id — UUID — Primary key — NOT NULL
- title — VARCHAR(10)
likes (Untitled8)
- post_id — UUID — Foreign key → posts.post_id — NOT NULL
- user_id — UUID — Foreign key → users.user_id — NOT NULL — RRIMARY KEY
photos (Untitled3)
- photo_id — UUID — Primary key — NOT NULL
- image_url — VARCHAR(100)
- post_id — UUID — Foreign key → posts.post_id — NOT NULL
posts (Untitled2)
- post_id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.user_id — NOT NULL — RRIMARY KEY
- content — TEXT
posts_hashtags (Untitled6)
- tag_id — UUID — Foreign key → hashtags.tag_id — NOT NULL
- post_id — UUID — Foreign key → posts.post_id — NOT NULL
users (Untitled)
- user_id — UUID — Primary key — NOT NULL — RRIMARY KEY
- name — VARCHAR(100)
- created_at — TIMESTAMP