Final_Project
Tables (19)
Actor
- id (Key) — Primary key — NOT NULL
- name (Field) — char(30)
- gender (Field2) — int
- birthday (Field3) — date
- deathday (Field4) — date
- profile_img (Field5) — image
- biography (Field6) — text
Actor_Movie
- id (Key) — Primary key — NOT NULL
- actor_id (Key2) — Foreign key → Actor.id — NOT NULL
- movie_id (Key3) — Foreign key → Movie.id — NOT NULL
Challenge (Untitled)
- id (Key) — Primary key — NOT NULL
- name (Field5) — Char(100)
- reward (Field2) — int
- created_at (Field3) — date
- expirated_at (Field4) — date
Challenge_Complete
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → User.id — NOT NULL
- chalenge_id (Key3) — Foreign key → Challenge.id — NOT NULL
Challenge_Movie (Untitled3)
- id (Key) — Primary key — NOT NULL
- Movie_id (Key2) — Foreign key → Movie.id — NOT NULL
- Chalenge_id (Key3) — Foreign key → Challenge.id — NOT NULL
Co-Comment
- id (Key) — Primary key — NOT NULL
- comment_id (Key2) — Foreign key → Comment.id — NOT NULL
- user_id (Key3) — Foreign key → User.id — NOT NULL
- content (Field) — text
- created_at (Field2) — date
Comment
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → User.id — NOT NULL
- review_id (Key3) — Foreign key → Review.id — NOT NULL
- comment (Field) — text
- created_at (Field2) — date
Director
- id (Key) — Primary key — NOT NULL
- name (Field) — char(30)
- gender (Field2) — int
- birthday (Field3) — date
- deathday (Field4) — date
- profile_img (Field5) — image
- biography (Field6) — text
Director_Movie
- id (Key) — Primary key — NOT NULL
- director_id (Key2) — Foreign key → Director.id — NOT NULL
- movie_id (Key3) — Foreign key → Movie.id — NOT NULL
Followed_Following
- id (Key) — Primary key — NOT NULL
- follower_id (Key2) — Foreign key → User.id — NOT NULL
- following_id (Key3) — Foreign key → User.id — NOT NULL
Genre
- id (Key) — Primary key — NOT NULL
- name (Field) — char(30)
Genre_Like
- id (Key) — Primary key — NOT NULL
- genre_id (Key2) — Foreign key → Genre.id — NOT NULL
- user_id (Key3) — Foreign key → User.id — NOT NULL
Movie
- id (Key) — Primary key — NOT NULL
- title (Field) — char(100)
- release_date (Field2) — date
- poseter_url (Field3) — url(200)
- overview (Field4) — text
Movie_Genre
- id (Key) — Primary key — NOT NULL
- movie_id (Key2) — Foreign key → Movie.id — NOT NULL
- genre_id (Key3) — Foreign key → Genre.id — NOT NULL
Movie_Like
- id (Key) — Primary key — NOT NULL
- movie_id (Key2) — Foreign key → Movie.id — NOT NULL
- user_id (Key3) — Foreign key → User.id — NOT NULL
Rating
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → User.id — NOT NULL
- movie_id (Key3) — Foreign key → Movie.id — NOT NULL
- score (Field) — int
Review
- id (Key) — Primary key — NOT NULL
- movie_id (Key2) — Foreign key → Movie.id — NOT NULL
- user_id (Key3) — Foreign key → User.id — NOT NULL
- title (Field) — char(30)
- content (Field2) — text
- created_at (Field3) — datefiled
Review_Like
- id (Key) — Primary key — NOT NULL
- review_id (Key2) — Foreign key → Review.id — NOT NULL
- user_id (Key3) — Foreign key → User.id — NOT NULL
User
- id (Key) — Primary key — NOT NULL
- email (Field4) — text
- password (Field3) — int
- name (Field2) — Char
- profile_img (Field5) — img
- level (Field6) — int
- exp (Field7) — int
- bio (Field8) — text