E4
Tables (9)
Copy Of Untitled (director_biography)
- Key (mID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (dID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (customer)
- Key (cID) — char(10) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (address) — char(50)
- Field (phone) — char(11)
Untitled (DVD)
- Key (dID) — char(10) — Primary key — NOT NULL
- Field (pDate) — date
- Field (rentedNum) — int(5)
- Key (gno) — char(2) — Foreign key → Untitled.Key — NOT NULL
- Key (mID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (genre)
- Key (gno) — char(2) — Primary key — NOT NULL
- Field (gName) — char(20)
Untitled (movie)
- Key (mID) — char(10) — Primary key — NOT NULL
- Field (title) — char(30)
- Field (madeyear) — char(4)
- Field (quantity) — int(2)
Untitled (actor)
- Key (aID) — char(10) — Primary key — NOT NULL
- Field (aName) — char(30)
Untitled (director)
- Key (dID) — char(10) — Primary key — NOT NULL
- Field (dName) — char(30)
Untitled (rent)
- Field (rDatetime) — datetime
- Key (cID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (dID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (actor_biography)
- Key (mID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (aID) — char(10) — Foreign key → Untitled.Key — NOT NULL