Glamour

Tables (5)

Copy Of Order (CopyOfOrder)

  • userID — integer — Primary key — NOT NULL
  • CustomerName — varcha(20)
  • orderID (orderID2) — integer — Foreign key → P_Order.orderID — NOT NULL

Dept. (Department)

  • Dept.Name — varcha(20) — Primary key
  • dept_no — integer — Primary key — NOT NULL
  • StudentNo — integer — Foreign key → Student.StudentNo — NOT NULL

P_Order (Order)

  • orderID — integer — Primary key — NOT NULL
  • CustomerName — varcha(20)

Publisher (New publisher)

  • publisher_name — Primary key — NOT NULL
  • Field

Student (Untitled 2)

  • StudentNo — integer — Primary key — NOT NULL
  • Student name — varcha(25)
  • Address — varcha(40)
  • Phone — integer