顾客(顾客号,赊购限额,余额,折扣)
Customers(CustomerID,CreditLimit,Balance,Discount)
收货地址(收货地址号,收货地址,顾客号)
Addresses(AddressID,DetailInformation,CustomerID)
订单(订单号,订货日期,收货地址号,顾客号)
Orders(OrderID,OrderDate,AddressID,CustomerID)
订货细则(订单号,货物号,订货数量,未发货量)
OrderDetails(OrderID,ProductID,Quantity,NotShippedQuantity)
货物(货物号,实际存货量,制造厂商,最低存货量,货物描述)
Products(ProductID,Stock,Manufacturer,ReorderLevel,Description)