ex4
Tables (8)
actor (Untitled)
- actorid (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(10)
- birth (Field2) — date
- gender (Field3) — char(5)
- biography (Field4) — text
actor-movie (Untitled3)
- actor-movieid (Key) — char(13) — Primary key — NOT NULL
- actorid (Key2) — char(10) — Foreign key → actor.actorid — NOT NULL
- movieid (Key3) — char(13) — Foreign key → movie.movieid — NOT NULL
customer (Untitled5)
- customerid (Key) — char(13) — Primary key — NOT NULL
- name (Field) — char(10)
- phone (Field2) — char(11)
- address (Field3) — text
- birth (Field4) — date
dirctor (Untitled2)
- directorid (Key) — char(13) — Primary key — NOT NULL
- name (Field) — char(10)
- birth (Field2) — date
- gender (Field3) — char(5)
- biography (Field4) — text
dirctor_movie (Untitled8)
- dirctor_movieid (Key) — char(13) — Primary key — NOT NULL
- directorid (Key2) — char(13) — Foreign key → dirctor.directorid — NOT NULL
- movieid (Key3) — char(13) — Foreign key → movie.movieid — NOT NULL
dvd (Untitled7)
- dvdid (Key) — char(13) — Primary key — NOT NULL
- copynumber (Key3) — integer — Primary key — NOT NULL
- movieid (Key2) — char(13) — Foreign key → movie.movieid — NOT NULL
- purchase (Field) — date
movie (Untitled4)
- movieid (Key) — char(13) — Primary key — NOT NULL
- title (Field2) — char(20)
- release (Field3) — date
- discription (Field) — text
rental (Untitled6)
- rentalid (Key) — char(13) — Primary key — NOT NULL
- customerid (Key2) — char(13) — Foreign key → customer.customerid — NOT NULL
- dvdid (Key3) — char(13) — Foreign key → dvd.dvdid — NOT NULL
- copynumber (Key32) — integer — Foreign key → dvd.copynumber — NOT NULL
- date (Field) — date
- time (Field2) — time