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)