ERD-04
Tables (7)
Untitled (CUSTOMER)
- Key (customerID) — char(10) — Primary key — NOT NULL
- Field (customerName) — char(10)
- Field (cusromerAdd) — char(20)
Untitled (DVD_COPY)
- Key (DVDcopyId) — int(10) — Primary key — NOT NULL
- Field (DVDbuyDate) — date
- Field (DVDlendDate) — date
- Field (DVDlendCount) — int(5)
- Key (DVDId) — char(8) — Foreign key → Untitled.Key — NOT NULL
- Key (customerID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (DVDlendTime) — time
Untitled (DVD_INFO)
- Key (DVDId) — char(8) — Primary key — NOT NULL
- Field (DVDtitle) — char(30)
- Field (DVDreleaseYear) — int(4)
Untitled (ACTORS)
- Key (actorID) — char(10) — Primary key — NOT NULL
- Field (actorDescription) — text
Untitled (DIRECTOR)
- Key (directorID) — char(10) — Primary key — NOT NULL
- Field (directorDescription) — text
Untitled (ACTOR_DVD)
- Key (DVDId) — char(8) — Foreign key → Untitled.Key — NOT NULL
- Key (actorID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (DIRECTOR_DVD)
- Key (directorID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (DVDId) — char(8) — Foreign key → Untitled.Key — NOT NULL