exe4
Tables (7)
DVD (Untitled3)
- ID (Key) — int(10) — Primary key — NOT NULL
- title (Field) — char(50)
- year/m (Field2) — char(50)
- copy no (Field5) — char(50)
- ID (Key2) — int(10) — Foreign key → rents.ID — NOT NULL
- movie (Field3) — char(50)
DVD COPY (Untitled6)
- code (Key) — char(50) — Primary key — NOT NULL
- title (Field) — char(50)
- date/P (Field2) — char(50)
- times/R (Field3) — char(50)
- ID (Key2) — int(10) — Foreign key → DVD.ID — NOT NULL
- ID (Key3) — int(10) — Foreign key → customer.ID — NOT NULL
actor (Untitled4)
- name (Key) — char(20) — Primary key — NOT NULL
- code (Field) — char(20)
- biographic information (Field2) — text
customer (Untitled)
- ID (Key) — int(10) — Primary key — NOT NULL
- name (Field) — char(50)
- add (Field2) — char(50)
- phone no (Field3) — intr(10)
director (Untitled5)
- name (Key) — char(20) — Primary key — NOT NULL
- code (Field) — char(20)
- biographic information (Field2) — text
movie (Untitled7)
- code (Key) — int(50) — Primary key — NOT NULL
- title (Field) — char(50)
- copies (Field2) — char(50)
- actor (Field3) — char(50)
- director (Field4) — char(50)
- ID (Key2) — int(10) — Foreign key → DVD.ID — NOT NULL
- name (Key3) — Foreign key → director.name — NOT NULL
- name (Key4) — Foreign key → actor.name — NOT NULL
rents (Untitled2)
- ID (Key) — int(10) — Primary key — NOT NULL
- name (Field) — char(50)
- date/P (Field2) — char(50)
- times/R (Field3) — char(50)
- ID (Key2) — int(10) — Foreign key → customer.ID — NOT NULL