2024.04. ex4
Tables (7)
Untitled (Customer)
- Key (CuID) — int(100) — Primary key — NOT NULL
- Field (name) — Char(20)
- Field (address) — char(40)
- Field (Phone) — Char(11)
Untitled (DVD RENT)
- Key (DVD Code) — Char(20) — Primary key — NOT NULL
- Field (Date of purchase) — date
- Field (rentData) — date
- Field (ReturnData) — date
- Field
- Key (CuID) — int(100) — Foreign key → Untitled.Key — NOT NULL
- Key (Item ID) — Char(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (Movie)
- Key (Movie ID) — int(12) — Primary key — NOT NULL
- Field (Title) — char(30)
- Field (Year made) — int(4)
- Field (Month made) — int(2)
- Field (Description) — text
- Field (Award) — text
Untitled (Person)
- Key (PersonID) — int(10) — Primary key — NOT NULL
- Field (Biographic) — text
- Key (Name) — Char(20) — NOT NULL
- Field (awad) — text
Untitled (Casting)
- Key (cast Code) — char(20) — Primary key — NOT NULL
- Key (Movie ID) — int(12) — Foreign key → Untitled.Key — NOT NULL
- Key (PersonID) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (Role ID) — int(5) — Foreign key → Untitled.Key — NOT NULL
- Field (Description) — text
- Key (name) — Char(20) — NOT NULL
Untitled (DVD ITEM)
- Key (Item ID) — Char(20) — Primary key — NOT NULL
- Field (buyingDate) — date
- Field (Price) — int(10)
- Field (StatustLevel) — char(1)
- Key (Movie ID) — int(12) — Foreign key → Untitled.Key — NOT NULL
Untitled (Role)
- Key (Role ID) — int(5) — Primary key — NOT NULL
- Field (Role Title) — char(30)
- Field (Description) — text