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