model

Tables (4)

comment (movies_comment)

  • PK (id) — INT — Primary key — NOT NULL
  • FK (movie_id) — INT — Primary key — NOT NULL
  • FK (user_id) — INT — Primary key — NOT NULL
  • (comment) — VARCHAR(150)
  • (score) — INT

genre (movies_genre)

  • Key (id) — INT — Primary key — NOT NULL
  • (name) — VARCHAR(150)

movie (movies_movie)

  • PK (id) — INT — Primary key — NOT NULL
  • FK (genre_id) — INT — Foreign key → movie_genre_id.FK — NOT NULL
  • (title) — VARCHAR(150)
  • (poster_url) — VARCHAR(150)
  • (summery) — VARCHAR(150)
  • (audience) — INT
  • (director) — VARCHAR(150)
  • (start_data) — VARCHAR(150)
  • (teaser) — VARCHAR(150)

movie_genre_id (movies_movie_genre_id)

  • PK (id) — INT — Primary key — NOT NULL
  • FK (genre_id) — INT — Primary key — NOT NULL
  • Key (id2) — INT — Foreign key → genre.Key — NOT NULL