04
Tables (6)
Untitled (CUSTOME)
- Key (customerNo) — int(10) — Primary key — NOT NULL
- Field (name) — char(4)
- Field2 (address) — char(10)
- Field (phoneNo) — int(11)
Untitled (DVD)
- Key (dvdNo) — int(7) — Primary key — NOT NULL
- Field (date) — int(4)
- Field (time) — int(3)
- Key (customerNo) — int(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (MOVIE)
- Key (movieNo) — int(10) — Primary key — NOT NULL
- Field (titlle) — char(10)
- Field (create year) — int(4)
- Field (type) — char(9)
- Key (dvdNo) — int(7) — Foreign key → Untitled.Key — NOT NULL
Untitled (DIRETOR)
- Key (idenNo) — int(10) — Primary key — NOT NULL
- Field (name) — char(3)
- Field (phoneNo) — int(11)
Untitled (ACTOR)
- Key (idenNo) — int(10) — Primary key — NOT NULL
- Field (name) — char(3)
- Field (phoneNo) — int(11)
Untitled (?)
- Key (idenNo) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (movieNo) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (idenNo2) — int(10) — Foreign key → Untitled.Key — NOT NULL