Netflix

Tables (17)

Copy Of Untitled (Genre)

  • Key (GenreID) — Primary key — NOT NULL
  • Field (GenreName)

Customer

  • CustomerEmail — Primary key — NOT NULL
  • CustomerPassword
  • CustomerName
  • CustomerAddress
  • CustomerPhone
  • CardNumber
  • CardValid
  • CardPassword
  • MembershipType — Foreign key → Membership.MembershipType — NOT NULL

Membership

  • MembershipType — Primary key — NOT NULL
  • MembershipName
  • MembershipPrice

Untitled (Content)

  • Key (ContentID) — Primary key — NOT NULL
  • Field (ContentTitle)
  • Field2 (ContentDescription)
  • Field3 (ContentCountry)
  • Field4 (ContentReleaseDate)
  • Field5 (ContentRating)
  • Key (CreaterID) — Foreign key → Untitled.Key — NOT NULL
  • Key (ActorID) — Foreign key → Untitled.Key — NOT NULL
  • Key (ContentProviderID) — Foreign key → Untitled.Key — NOT NULL

Untitled (Profile)

  • Key (ProfileID) — Primary key — NOT NULL
  • Field (ProfileName)
  • Field2 (isKids)
  • CustomerEmail — Foreign key → Customer.CustomerEmail — NOT NULL

Untitled (Creater)

  • Key (CreaterID) — Primary key — NOT NULL
  • Field (CreaterName)

Untitled (Actor)

  • Key (ActorID) — Primary key — NOT NULL
  • Field (ActorName)

Untitled (ContentProvider)

  • Key (ContentProviderID) — Primary key — NOT NULL
  • Field (ContentProviderName)
  • Field (ContentProviderPhone)
  • Field2 (ContentProviderEmail)
  • Field3 (ContentProviderAccount)

Untitled (CustomerPay)

  • Key (CustomerPaymentID) — Primary key — NOT NULL
  • CustomerEmail — Foreign key → Customer.CustomerEmail — NOT NULL
  • MembershipType — Foreign key → Membership.MembershipType — NOT NULL
  • Field (PaymentDate)

Untitled (Content-Genre)

  • Key (ContentGenreID) — Primary key — NOT NULL
  • Key (GenreID2) — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Key (ContentID) — Foreign key → Untitled.Key — NOT NULL

Untitled (Serch)

  • Key (SearchID) — Primary key — NOT NULL
  • Key (ProfileID) — Foreign key → Untitled.Key — NOT NULL
  • Key (ContentID) — Foreign key → Untitled.Key — NOT NULL
  • Field (SearchNumber)

Untitled (WishList)

  • Key (WishListID) — Primary key — NOT NULL
  • Key (ProfileID) — Foreign key → Untitled.Key — NOT NULL
  • Key (ContentID) — Foreign key → Untitled.Key — NOT NULL

Untitled (Save)

  • Key (SaveID) — Primary key — NOT NULL
  • Key (ProfileID) — Foreign key → Untitled.Key — NOT NULL
  • Key (ContentID) — Foreign key → Untitled.Key — NOT NULL

Untitled (Watch)

  • Key (WatchID) — Primary key — NOT NULL
  • Key (ProfileID) — Foreign key → Untitled.Key — NOT NULL
  • Key (ContentID) — Foreign key → Untitled.Key — NOT NULL
  • Field (WatchDate)
  • Field (WatchTime)
  • Field (WatchNumber)

Untitled (ContentPay)

  • Key (ContentPaymentID) — Primary key — NOT NULL
  • Key (ContentID) — Foreign key → Untitled.Key — NOT NULL
  • Key (ContentProviderID) — Foreign key → Untitled.Key — NOT NULL
  • Field (WatchNumber)
  • Field (PaymentPrice)

Untitled (Evaluate)

  • Key (EvaluateID) — Primary key — NOT NULL
  • Key (ContentID) — Foreign key → Untitled.Key — NOT NULL
  • Key (ProfileID) — Foreign key → Untitled.Key — NOT NULL
  • Field (RatingNumber)

Untitled (Episode)

  • Key (EpisodeNumber) — Primary key — NOT NULL
  • Field (EpisodeName)
  • Key (ContentID) — Foreign key → Untitled.Key — NOT NULL