movie-project
Tables (11)
Comment (Untitled5)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → Post.Key — NOT NULL
- Key (Key22) — Foreign key → Post.Key — NOT NULL
- Key (Key3) — Foreign key → Post.Key — NOT NULL
- comment_id (pk)
- post_id (fk)
- user_id (Field3) — User
- content (Field4)
- created_at (Field5)
Follow (Untitled7)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → User.Key — NOT NULL
- follow_id (pk)
- follower_id (fk)
- followed_id (Field3) — Movie
Like (Untitled6)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → User.Key — NOT NULL
- like_id (pk)
- user_id (fk)
- post_id (Field3) — Post
Movie-detail (Untitled2)
- Key — Primary key — NOT NULL
- movie_id (pk)
- title (Field2)
- release_date (Field3)
- director (Field4)
- genre (Field5)
- poster_image (Field)
Movies (Untitled9)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → Movie-detail.Key — NOT NULL
- movie_id (pk)
- title (Field3)
- image (Field4)
Post (Untitled4)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → User.Key — NOT NULL
- Key (Key3) — Foreign key → Movie-detail.Key — NOT NULL
- post_id (pk)
- user_id (fk)
- movie_id (Field3) — Movie
- content (Field4)
- image (Field5)
- updated_at (Field)
- created_at (Field2)
Profile (Untitled8)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → User.Key — NOT NULL
- profile_id (pk)
- user_id (fk)
- profile_content (Field3)
- profile_picture (Field4)
- updated_at (Field)
- created_at (Field2)
User (Untitled)
- Key — Primary key — NOT NULL
- user_id (pk)
- email (Field2)
- password (Field3)
- name (Field4)
- profile_picture (Field5)
- created_at (Field)
location (Untitled3)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → Movie-detail.Key — NOT NULL
- location_id (pk)
- movie_id (FK)
- name (Field3)
- description (Field4)
- location (Field5)
- image (Field6)
post-tag (Untitled11)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → Post.Key — NOT NULL
- Key (Key22) — Foreign key → Post.Key — NOT NULL
- Key (Key3) — Foreign key → Post.Key — NOT NULL
- post_id (fk)
- tag_id (f) — Tag
tag (Untitled10)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → post-tag.Key — NOT NULL
- Key (Key22) — Foreign key → post-tag.Key — NOT NULL
- Key (Key222) — Foreign key → post-tag.Key — NOT NULL
- Key (Key3) — Foreign key → post-tag.Key — NOT NULL
- tag_id (pk)
- location_id (fk)
- created_at (Field3)