ERD 4
Tables (4)
ENROLL (Untitled4)
- identification code (Key) — integer — Primary key — NOT NULL
- rental time (Field) — int(11)
- rental date (Field2) — int(11)
- customer numbe (Key2) — char(13) — Foreign key → customer.customer numbe — NOT NULL
- identification code (Key3) — integer — Foreign key → videocassette.identification code — NOT NULL
customer (Untitled)
- customer numbe (Key) — char(13) — Primary key — NOT NULL
- name (Field) — char(10)
- address (Field2) — char(100)
- phone (Field3) — int(11)
- email (Field4) — char(100)
- video store ID (Key2) — int(11) — Foreign key → video store.video store ID — NOT NULL
video store (Untitled3)
- video store ID (Key) — int(11) — Primary key — NOT NULL
- name (Field) — char(10)
- videocassette (Field2) — char(10)
videocassette (Untitled2)
- identification code (Key) — integer — Primary key — NOT NULL
- date of purchase (Field) — int(11)
- number of times the video was rented (Field2) — int(11)
- title (Field3) — char(10)
- the year made (Field4) — int(11)
- actors (Field5) — char(10)
- directors (Field6) — char(10)
- video store ID (Key2) — int(11) — Foreign key → video store.video store ID — NOT NULL