EF CORE 设计一个仓储系统的数据库,包括 物料,仓库,仓位,订单,销售单,采购单,出库单,入库单,借调,盘点等数据表
时间: 2024-06-12 21:06:39 浏览: 163
仓库管理系统的数据库设计
5星 · 资源好评率100%
以下是一个可能的EF CORE仓储系统数据库设计:
物料表(Materials)
- 物料ID(MaterialID)
- 物料名称(Name)
- 物料描述(Description)
- 物料规格(Specification)
- 单位(Unit)
- 库存上限(UpperLimit)
- 库存下限(LowerLimit)
仓库表(Warehouses)
- 仓库ID(WarehouseID)
- 仓库名称(Name)
- 仓库地址(Address)
- 仓库管理员(Manager)
仓位表(Locations)
- 仓位ID(LocationID)
- 仓库ID(WarehouseID)
- 仓位名称(Name)
- 仓位描述(Description)
- 仓位容量(Capacity)
- 当前库存(CurrentStock)
订单表(Orders)
- 订单ID(OrderID)
- 订单类型(OrderType)
- 订单状态(OrderStatus)
- 下单时间(OrderTime)
- 订单总金额(OrderAmount)
销售单表(SalesOrders)
- 销售单ID(SalesOrderID)
- 客户ID(CustomerID)
- 销售员(Salesman)
- 销售时间(SalesTime)
- 销售总金额(SalesAmount)
采购单表(PurchaseOrders)
- 采购单ID(PurchaseOrderID)
- 供应商ID(SupplierID)
- 采购员(Purchaser)
- 采购时间(PurchaseTime)
- 采购总金额(PurchaseAmount)
出库单表(DeliveryOrders)
- 出库单ID(DeliveryOrderID)
- 订单ID(OrderID)
- 客户ID(CustomerID)
- 出库时间(DeliveryTime)
- 出库总数量(DeliveryQuantity)
入库单表(ReceiptOrders)
- 入库单ID(ReceiptOrderID)
- 订单ID(OrderID)
- 供应商ID(SupplierID)
- 入库时间(ReceiptTime)
- 入库总数量(ReceiptQuantity)
借调表(Borrowings)
- 借调ID(BorrowingID)
- 借调人(Borrower)
- 借调时间(BorrowingTime)
- 归还时间(ReturnTime)
- 借调物料ID(MaterialID)
- 借调数量(BorrowingQuantity)
盘点表(InventoryCheck)
- 盘点ID(CheckID)
- 盘点人(Checker)
- 盘点时间(CheckTime)
- 盘点仓库ID(WarehouseID)
- 盘点仓位ID(LocationID)
- 盘点物料ID(MaterialID)
- 盘点数量(CheckQuantity)
阅读全文