Swan Stream

Tables (7)

Copy Of movie_data (CopyOfUntitled)

  • movie_id (Key) — int — Primary key — NOT NULL
  • movie_title (Field) — char
  • movie_age_restriction (Field2) — int
  • movie_release_date (Field3)
  • movie_time (Field4) — int
  • content_type (Field5) — char

genre (Untitled3)

  • genre_id (Key) — int — Primary key — NOT NULL
  • genre_title (Field) — char — NOT NULL

movie_data (Untitled)

  • movie_id (Key) — int — Primary key — NOT NULL
  • movie_title (Field) — char
  • movie_age_restriction (Field2) — int
  • movie_release_date (Field3)
  • movie_time (Field4) — int
  • content_type (Field5) — char

movie_data_extended (Untitled4)

  • movie_id (Key) — int — Foreign key → movie_data.movie_id — NOT NULL

movie_genre (Untitled2)

  • movie_id (Key2) — int — Foreign key → movie_data.movie_id — NOT NULL
  • genre_id (Key) — int — Foreign key → genre.genre_id — NOT NULL

movie_tag (CopyOfUntitled2)

  • movie_id (Key2) — int — Foreign key → movie_data.movie_id — NOT NULL
  • tag_id (Key) — int — Foreign key → tag.tag_id — NOT NULL

tag (CopyOfUntitled3)

  • tag_id (Key) — int — Primary key — NOT NULL
  • tag_title (Field) — char — NOT NULL