QueenAnneCuriosityShopERD

Tables (7)

CUSTOMER

  • CustomerID (CUSTOMER_PK) — Int — Primary key — NOT NULL
  • LastName — Char(25)
  • FirstName — Char(25)
  • Address — Char(35)
  • City — Char(35)
  • State — Char(2)
  • ZIP — Char(12)
  • Phone — Char(12)
  • EmailAddress — VarChar(100)

EMPLOYEE

  • EmployeeID (EMPLOYEE_PK) — Int — Primary key — NOT NULL
  • LastName — Char(25)
  • FirstName — Char(25)
  • Phone — Char(12)
  • EmailAddress — VarChar(100)

INVENTORY_SYSTEM

  • InventoryID (Key) — Int — Primary key — NOT NULL
  • VendorID (VENDOR_PK) — Int — Foreign key → VENDOR.VendorID — NOT NULL
  • ItemID (ITEM_PK) — Int — Foreign key → ITEM.ItemID — NOT NULL
  • ItemQuantityInStock (Field) — Int
  • ItemQuantityOnOrder (Field2) — Int
  • ItemOrderDueDate (Field3) — Date

ITEM

  • ItemID (ITEM_PK) — Int — Primary key — NOT NULL
  • VendorID (ITEM_VENDOR_PK) — Int — Foreign key → VENDOR.VendorID — NOT NULL
  • ItemDescription — VarChar(100)
  • PurchaseDate — Date
  • ItemCost — Numeric(9,2)
  • ItemPrice — Numeric(9,2)

SALE

  • SaleID (SALE_PK) — Int — Primary key — NOT NULL
  • CustomerID (SALE_CUSTOMER_PK) — Int — Foreign key → CUSTOMER.CustomerID — NOT NULL
  • EmployeeID (SALE_EMPLOYEE_FK) — Int — Foreign key → EMPLOYEE.EmployeeID — NOT NULL
  • SaleDate — Date
  • SubTotal — Numeric(9,2)
  • Tax — Numeric(9,2)
  • Total — Numeric(9,2)

SALE_ITEM

  • SaleItemID (SALE_ITEM_SALE_FK) — Int — Primary key — NOT NULL
  • SaleID (SALE_PK) — Int — Foreign key → SALE.SaleID — NOT NULL
  • ItemID (ITEM_PK) — Int — Foreign key → ITEM.ItemID — NOT NULL
  • ItemPrice — Numeric(9,2)
  • Quantity (Field) — Int
  • ExtendedPrice (Field2) — Numeric(9,2)

VENDOR

  • VendorID (VENDOR_PK) — Int — Primary key — NOT NULL
  • CompnayName (CompanyName) — Char(25)
  • ContactLastName — Char(25)
  • ContactFirstName — Char(25)
  • Address — Char(35)
  • City — Char(35)
  • State — Char(2)
  • ZIP — Char(10)
  • Phone — Char(12)
  • Fax — Char(12)
  • EmailAddress — VarChar(100)