es4(2)
Tables (8)
actors (Untitled4)
- videoCode (Key) — Primary key — NOT NULL
- moviesgoldfinger (Field)
- actorsinteralCode (Field2)
- moviesTitle (Key2) — Foreign key → movies.moviesTitle — NOT NULL
biographyinformation (Untitled5)
- videoCode (Key) — Primary key — NOT NULL
- directorsinteralCode (Field)
- actorinteralCode (Field2)
- videoCode (Key2) — Foreign key → actors.videoCode — NOT NULL
customer (Untitled8)
- customerNumber (Key) — Primary key — NOT NULL
- name (Field)
- address (Field2)
directors (Untitled6)
- videoCode (Key) — Primary key — NOT NULL
- moviesgoldfinger (Field)
- directorsinteralCode (Field2)
- videoCode (Key2) — Foreign key → biographyinformation.videoCode — NOT NULL
- moviesTitle (Key3) — Foreign key → movies.moviesTitle — NOT NULL
movies (Untitled3)
- moviesTitle (Key) — Primary key — NOT NULL
- moviesyearmade (Field)
- videoCode (Field2)
rentinformation (Untitled7)
- videoCode (Key) — Primary key — NOT NULL
- customerNumber (Field)
- purchaseDate (Field2)
- rentnumberTime (Field3)
- videoCode (Key2) — Foreign key → video.videoCode — NOT NULL
- customerNumber (Key3) — Foreign key → customer.customerNumber — NOT NULL
video (Untitled2)
- videoCode (Key) — Primary key — NOT NULL
- videostoreCode (Field)
- videocopyCode (Field2)
- customerNumber (Field3)
- name (Field4)
- adress (Field5)
- videostoreCode (Key2) — Foreign key → videostore.videostoreCode — NOT NULL
- moviesTitle (Key3) — Foreign key → movies.moviesTitle — NOT NULL
videostore (Untitled)
- videostoreCode (Key) — Primary key — NOT NULL
- movieTile (Field)