Nguyen Kimgan

Tables (8)

Copy Of Order1 (CopyOfOrder1)

  • uerID — integer — Primary key — NOT NULL
  • CustormerName — varchar(20)
  • orderID — integer — Foreign key → L_Order.orderID — NOT NULL

Department (Untitled)

  • dpmt.No — integer — Primary key — NOT NULL
  • dpmt.Name — varchar(20)
  • Student.No (Studemt.No) — integer — Foreign key → Student.Student.No — NOT NULL

L_Order (P_Order)

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

Student (Untitled2)

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

book (newbook)

  • bookid — varchar(25) — Primary key — NOT NULL
  • bookname price — integer
  • publisher_name — integer
  • publisher_name (publisher_name2) — varchar(25) — Foreign key → publisher.publisher_name — NOT NULL

custormer (Newcustormer)

  • cusid — Primary key — NOT NULL
  • cus_name — varchar(25)
  • address — varchar(25)
  • phone — integer
  • orderid — integer — Foreign key → order.orderid — NOT NULL

order (neworder)

  • orderid — integer — Primary key — NOT NULL
  • order_date — integer
  • sale_price — integer
  • bookid — varchar(25) — Foreign key → book.bookid — NOT NULL

publisher (Newpublisher)

  • publisher_name — varchar(25) — Primary key — NOT NULL
  • contact_name — integer
  • contact_no — integer