Column Name

Data Type

Notes

Id

Int

Primary Key

CreatedAt

DateTime

UpdatedAt

DateTime

Primary Key

InventoryId

Int

Foreign Key to join into Storage Inventory table

CustomerId

Int

Foreign Key to join into Organisations table

MovementDate

DateTime

DeliveryId

Int

Foreign Key to join into Deliveries table

Quantity

Decimal