Order
Tables (3)
movie (Untitled2)
- serialNumber (Key) — INT — Primary key — NOT NULL
- movieName (Field) — Varchar(20)
- nation (Field2) — Varchar(20)
- pubYear (Field3) — INT
- directer (Field4) — Varchar(20)
- charge (Field5) — INT
- rental (Field6) — Boolean
- orderId (PK2) — Varchar(20) — NOT NULL
- userName (PK) — Varchar(20) — NOT NULL
orderHistory (-)
- orderId (PK) — Varchar(20) — Primary key — NOT NULL
- userNumber (FK) — Varchar(20)
- serialNumber (FK2) — Varchar(20)
- orderDate (-) — DATE
- returnDate (,) — DATE
- overdueDay (') — Varchar(20)
- overdueCharge (Field2) — Varchar(20)
- serialNumber (Key) — INT — Foreign key → movie.serialNumber — NOT NULL
- userNumber (PK2) — Varchar(20) — Foreign key → user.userNumber — NOT NULL
user (Untitled)
- userNumber (PK) — Varchar(20) — Primary key — NOT NULL
- userName (Field) — Varchar(20)
- userGrade (Field2) — Varchar(20)
- phoneNumber (.) — Varchar(20)
- deleteUser (Field3) — Varchar(20)
- serialNumber (Key) — INT — NOT NULL
- orderId (PK2) — Varchar(20) — NOT NULL