videoshop
Tables (7)
CASTING (Untitled8)
- movieId (Key) — char(30) — Foreign key → MOVIE.movieId — NOT NULL
- personId (Key3) — char(30) — Foreign key → PERSON.personId — NOT NULL
- roleId (Key2) — char(30) — Foreign key → ROLE.roleId — NOT NULL
CUSTOMER (Untitled)
- customerId (Key) — char(30) — Primary key — NOT NULL
- name (Field) — char(30)
- address (Field2) — char(30)
MOVIE (Untitled4)
- movieId (Key) — char(30) — Primary key — NOT NULL
- title (Field) — char(60)
- year (Field2) — int(4)
PERSON (Untitled7)
- personId (Key) — char(30) — Primary key — NOT NULL
- birthdate (Field4) — int(8)
- sex (Field) — char(6)
- nationality (Field2) — char(30)
- debutyear (Field3) — int(4)
ROLE (Untitled9)
- roleId (Key) — char(30) — Primary key — NOT NULL
Transaction (Untitled3)
- transactionId (Key) — char(30) — Primary key — NOT NULL
- datetime (Field2) — int(12)
- customerId (Key2) — char(30) — Foreign key → CUSTOMER.customerId — NOT NULL
- videoCode (Key3) — char(30) — Foreign key → videocassette.videoCode — NOT NULL
videocassette (Untitled2)
- videoCode (Key) — char(30) — Primary key — NOT NULL
- purchaseDate (Field) — int(8)
- rentTimes (Field2) — int(4)
- movieId (Key2) — char(60) — Foreign key → MOVIE.movieId — NOT NULL