KKK-Triple-K

Tables (8)

actor (movies_actor)

  • Key (id) — INT — Primary key — NOT NULL
  • PK (movie_id) — INT — Foreign key → movie.PK — NOT NULL
  • (name) — VARCHAR(100)
  • (character) — VARCHAR(50)
  • (profile_photo) — TEXT

comment (movies_comment)

  • PK (id) — INT — Primary key — NOT NULL
  • FK (movie_id) — INT — Foreign key → movie.PK — NOT NULL
  • FK (user_id) — INT — Foreign key → user.PK — NOT NULL
  • (content) — 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
  • (name) — VARCHAR(150)
  • (poster_url) — VARCHAR(1000)
  • (description) — TEXT
  • (audience_rating) — VARCHAR(100)
  • (audience) — INT
  • (release_date) — VARCHAR(50)

movie_genre_id (movies_movie_genre_id)

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

movie_like_users (movies_movie_like_users)

  • PK (id) — INT — Primary key — NOT NULL
  • FK (movie_id) — INT — Foreign key → movie.PK — NOT NULL
  • FK (user_id) — INT — Foreign key → user.PK — NOT NULL

user (accounts_user)

  • PK (id) — INT — Primary key — NOT NULL
  • (email) — VARCHAR(150)
  • (first_name) — VARCHAR(150)
  • (last_name) — VARCHAR(150)
  • (sex) — CHOICE
  • (age) — INT
  • (password) — VARCHAR(128)

user_followers (accounts_user_followers)

  • PK (id) — INT — Primary key — NOT NULL
  • FK (from_user_id) — INT — Foreign key → user.PK — NOT NULL
  • FK (to_user_id) — INT — Foreign key → user.PK — NOT NULL