work4
Tables (8)
Role (Untitled)
- Key (roleID) — int(3) — Primary key — NOT NULL
- Field (roletitle) — char(10)
- Field (description) — text
Untitled (movie)
- Key (movieID) — int(10) — Primary key — NOT NULL
- Field (title) — char(30)
- Field (PubYear) — int(4)
- Field (PubMonth) — int(2)
- Field — longtext
- Field2 (award) — longtext
Untitled (DVDITEM)
- Key (itemID) — nt(100) — Primary key — NOT NULL
- Field (buydate) — date
- Field2 (price) — int(10)
- Field (statulevel)
- Key (movieID) — int(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (moviegenre)
- Key (movieID) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (grnreID) — int(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (Genre)
- Key (grnreID) — int(5) — Primary key — NOT NULL
- Field (name) — int(10)
- Field (descrption) — longtext
Untitled (casting)
- Key (movieID) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (roleID) — int(3) — Foreign key → Role.Key — NOT NULL
- Key (personIDKey) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Field (descrption) — text
Untitled (CIIENT)
- Key (clientID) — int(100) — Primary key — NOT NULL
- Field (name) — char(30)
- Field
Untitled (Person)
- Key (personIDKey) — int(10) — Primary key — NOT NULL
- Field (fname) — char(30)
- Field (minit) — char(1)
- Field (Iname) — char(30)
- Field (descrption) — longtext
- Field (award) — text