assignment_ERD
Tables (11)
Comment (Untitled4)
- id (Key) — Long — Primary key — NOT NULL
- user_id (Key3) — Long — Foreign key → User.id — NOT NULL
- post_id (Key2) — Long — Foreign key → Post.id — NOT NULL
- message (Field) — String
Follow (Untitled6)
- id (Key) — Long — Primary key — NOT NULL
- follower_id (Key2) — Long — Foreign key → User.id — NOT NULL
- following_id (Key3) — Long — Foreign key → User.id — NOT NULL
Image (Untitled11)
- id (Key) — Long — Primary key — NOT NULL
- post_id (Key2) — Long — Foreign key → Post.id — NOT NULL
- image_url (Field) — String
Post (Untitled2)
- id (Key) — Long — Primary key — NOT NULL
- user_id (Key2) — Long — Foreign key → User.id — NOT NULL
- title (Field) — String
- content (Field2) — String
- like (Field3) — int
- created_at (Field5) — LocalDateTime
- modified_at (Field6) — LocalDateTime
Post_Like (Untitled3)
- id (Key3) — Long — Primary key — NOT NULL
- post_id (Key) — Long — Foreign key → Post.id — NOT NULL
- user_id (Key2) — Long — Foreign key → User.id — NOT NULL
Save (Untitled5)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Long — Foreign key → User.id — NOT NULL
- post_id (Key3) — Long — Foreign key → Post.id — NOT NULL
Story (Untitled8)
- id (Key) — Long — Primary key — NOT NULL
- user_id (Key2) — Long — Foreign key → User.id — NOT NULL
- image (Field) — String
- created_at (Field2) — LocalDateTime
- modified_at (Field3) — LocalDateTime
Story_Comment (Untitled10)
- id (Key) — Long — Primary key — NOT NULL
- message (Field) — String
- user_id (Key2) — Long — Foreign key → User.id — NOT NULL
- story_id (Key3) — Long — Foreign key → Story.id — NOT NULL
Stroy_Like (Untitled9)
- id (Key) — Long — Primary key — NOT NULL
- user_id (Key2) — Long — Foreign key → User.id — NOT NULL
- story_id (Key3) — Long — Foreign key → Story.id — NOT NULL
User (Untitled)
- id (Key) — Long — Primary key — NOT NULL
- name (Field) — String
- age (Field2) — int
- nickName (Field5) — String
- email (Field3) — String
- phoneNumber (Field4) — String
- profile_image (Field6) — String
Video (Untitled12)
- id (Key) — Long — Primary key — NOT NULL
- user_id (Key2) — Long — Foreign key → Post.id — NOT NULL
- video_url (Field) — String