MOVIE_RECOMMEND
Tables (12)
Actor (movies_actor)
- id — Primary key — NOT NULL
- name
Director (movies_director)
- id — Primary key — NOT NULL
- name
Genre (movies_genre)
- id — Primary key — NOT NULL
- name
Movie (movies_movie)
- id (Key) — Primary key — NOT NULL
- title (Field)
- rating (Field2)
- poster_url (Field4)
- overview (Field3)
Movie_Actor (movies_movie_actors)
- id — Primary key — NOT NULL
- actor_id — Foreign key → Actor.id — NOT NULL
- movie_id — Foreign key → Movie.id — NOT NULL
Movie_Director (movies_movie_directors)
- id — Primary key — NOT NULL
- director_id — Foreign key → Director.id — NOT NULL
- id (Key) — Foreign key → Movie.id — NOT NULL
Movie_Genre (movies_movie_genres)
- id — Primary key — NOT NULL
- genre_id — Foreign key → Genre.id — NOT NULL
- movie_id — Foreign key → Movie.id — NOT NULL
Movie_Platform (movies_movie_platform)
- id — Primary key — NOT NULL
- movie_id — Foreign key → Movie.id — NOT NULL
- platform_id — Foreign key → Platform.id — NOT NULL
Party (otts_party)
- id — Primary key — NOT NULL
- owner_id — Foreign key → User.username — NOT NULL
- platform_id — Foreign key → Platform.id — NOT NULL
- price
- capacity
- account_id
- account_password
- bank_account
Party_Participant (otts_party_participants)
- id — Primary key — NOT NULL
- user_id — Foreign key → User.username — NOT NULL
- party_id — Foreign key → Party.id — NOT NULL
- id (Key) — Foreign key → Party.platform_id — NOT NULL
Platform (otts_platform)
- id (Key) — Primary key — NOT NULL
- name (Field)
User (accounts_user)
- username — Primary key — NOT NULL
- password
- is_active