客户订购登记
2016-10-03 10:20:57 89 举报
登录查看完整内容
《数据库设计教程》中“客户订购登记”示例
作者其他创作
大纲/内容
orderNo=orderNo1:n
Customer
customerNocustomerNamecustomerStreetcustomerCitycustomerStatecustomerZipCodecustomerTelNocustomerFaxNomaritalStatuscreditRating
Employee
employeeNotitlefirstNamemiddleNamelastNameaddressworkTelExthomeTelNoempEmailAddresssocialSecurityNumberpositionsexsalarydateStarted
sMethodNo=sMethodNo1:n
PaymentMethod
pMethodNopaymentMethod
employeeNo=employeeNo1:n
Shipment
shipmentNoquantityshipmentDatecompleteStatusorderNoproductNoemployeeNosMethodNo
ShipmentMethod
sMethodNoshipmentMethod
Invoice
invoiceNodateRalseddatePaidcreditCardNoholdersNameexpiryDateorderNopMethodNo
OrderDetail
orderNoproductNoquantityOrdered
Order
orderNoorderDatebillingStreetbillingCitybillingStatebillingZipCodepromisedDatestatuscustomerNoemployeeNo
pMethodNo=pMethodNo1:n
orderNo = orderNo1:1
productNo=productNo1:n
customerNo=customerNo1:n
Product
productNoProductNameserialNounitPricequantityOnHandreorderLevelrecorderQuantityreorderLeadTime
0 条评论
回复 删除
下一页
