ex 4
Tables (11)
CLIENT
- Key (clientId) — int(10) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (address) — char(20)
- Field
Untitled (ITEM)
- Key (itemId) — int(10) — Primary key — NOT NULL
- Key (movieId) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Field
Untitled (MOVIE)
- Key (movieId) — int(10) — Primary key — NOT NULL
- Field (title) — char(20)
- Field (year) — int(10)
- Field (copy) — int(10)
- Field (time) — char(20)
- Key (actorId) — int(10) — NOT NULL
- Field2 (directorId) — nt(10)
- Field (descriptioj) — LONGTEXT
- Field
Untitled (DIRECTOR)
- Key (directorId) — int(10) — Primary key — NOT NULL
- Field (name) — char(20)
- Field2 (age) — int(10)
- Field
- Field2
Untitled (ACTOR)
- Key (actorId) — int(10) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (age) — int(10)
- Field
Untitled (DATARECORD)
- Key (itemData) — Primary key — NOT NULL
- Key (clientId) — int(10) — Foreign key → CLIENT.Key — NOT NULL
- Key (itemId) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Field (startData) — char(20)
- Field
Untitled (MOVIECREW)
- Key (movieId) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (actorId) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (directorId) — int(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (REVIEW)
- Key (reviewId) — int(10) — Primary key — NOT NULL
- Field
Untitled (GENRE)
- Key — Primary key — NOT NULL
- Field (name) — char(20)
- Field2