MyFirstProject

Tables (4)

Copy Of Order (Untitled4)

  • userID — integer — Primary key — NOT NULL
  • CustomerName — varchar(20)
  • orderID — integer — Foreign key → Order 1.orderID — NOT NULL

Dept. (Untitled3)

  • dept_no — integer — Primary key — NOT NULL
  • Dept. Name (DeptName) — varchar(25)
  • Student No (StudentNo.) — integer — Foreign key → Student.Student No — NOT NULL

Order 1 (Order)

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

Student (Untitled)

  • Student No (StudentNo.) — integer — Primary key — NOT NULL
  • Student Name (StudentName.) — varchar(25)
  • Address — varchar(40)
  • Phone — integer