BBB

Tables (4)

NEWBOOK

  • BOOKID — INT
  • PUBNAME2 — VARCHAR(100)
  • BOOKNAME — VARCHAR(255)
  • PRICE — DECIMAL(10, 2)

NEWCUSTOMER

  • CUSTID — INT
  • CUSTNAME — VARCHAR(100)
  • ADDRESS — VARCHAR(255)
  • CUSTPHONE — VARCHAR(20)

NEWORDERS

  • ORDERID — INT
  • CUSTID — INT
  • BOOKID — INT
  • SALEPRICE — DECIMAL(10, 2)
  • ORDERDATE — DATE

NEWPUBLISHER

  • PUBNAME — VARCHAR(100)
  • STNAME — VARCHAR(100)
  • OFFICEPHONE — VARCHAR(20)