EX4

Tables (6)

Actor (Untitled4)

  • ActorCode (Key) — Primary key — NOT NULL
  • biography (Field) — text
  • Field2

Customer (Untitled)

  • CustomerNumber (Key) — char(40) — Primary key — NOT NULL
  • Name (Field) — char(30)
  • adress (Field2) — char(50)
  • Field3

DVD (Untitled2)

  • DVDCODE (Key) — char(40) — Primary key — NOT NULL
  • Buyday (Field) — date
  • quantity (Field2) — integer
  • Lendingday (Field3) — date
  • time (Field4) — time
  • CustomerNumber (Key2) — char(40) — Foreign key → Customer.CustomerNumber — NOT NULL
  • MovieCode (Key3) — Foreign key → Movie.MovieCode — NOT NULL
  • RentCount (Field5) — integer
  • Field6

Directer (Untitled5)

  • DirecCode (Key) — Primary key — NOT NULL
  • biography (Field) — text
  • Field2

Movie (Untitled3)

  • MovieCode (Key) — char(50) — Primary key — NOT NULL
  • title (Field) — char(100)
  • year (Field2) — char(10)
  • Field3

moviecredit (Untitled6)

  • MovieCode (Key) — char(50) — Foreign key → Movie.MovieCode — NOT NULL
  • ActorCode (Key2) — Foreign key → Actor.ActorCode — NOT NULL
  • DirecCode (Key3) — Foreign key → Directer.DirecCode — NOT NULL