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