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