库存控制
2016-10-03 11:54:43 34 举报
《数据库设计教程》中“库存控制”示例
作者其他创作
大纲/内容
purchaseOrderNo1:n
ProductCategory
categoryNocategoryDescription
categoryNo1:n
Product
productNoproductNameserialNounitPricequantityOnHandreorderLevelrecorderQuantityrecorderLeadTimecategoryNo
Supplier
supplierNosupplierNamesupplierStreetsupplierCitysupplierStatesupplierZipCodesuppTelNosuppFaxNosuppEmailAddresssuppWebAddresscontactNamecontactTelNocontactFaxNocontactEmailAddresspaymentTerms
Transaction
transactionNotransactionDatetransactionDescriptionunitPriceunitsOrderedunitsReceivedunitsSoldunitsWastageproductNopurchaseOrderNo
Employee
employeeNotitlefirstNamemiddleNamelastNameaddressworkTelExthomeTelNoempEmailAddresssocialSecurityNumberpositionsexsalarydateStarted
PurchaseOrder
purchaseOrderNopurchaseOrderDescriptionorderDatedateRequiredshippedDatefreightChargesupplierNoemployeeNo
supplierNo1:n
productNo1:n
employeeNo1:n
0 条评论
下一页