# Synthetic inventory schema (generated by scripts/gen_schema.py)

# Product documentation
Product as pro0
---
ProductId PK int IDENTITY
SegmentRef0 int FK 0- Segment.SegmentId
Field0Product varchar(200)
Field1Product string default=4
Field2Product money NULL
Field3Product text
Field4Product money UNIQUE
Field5Product int UNIQUE
Field6Product varchar(200) UNIQUE

ProductCategory
----------
ProductCategoryId PK int IDENTITY
Field0ProductCategory varchar(200)
Field1ProductCategory datetime default=1
Field2ProductCategory text
Field3ProductCategory bool NULL

Sku
----------
SkuId PK int IDENTITY
Field0Sku varchar(200) NULL
Field1Sku uuid INDEX
Field2Sku bool INDEX
"Display Name" string="Unnamed Sku"

Warehouse
rel >- Segment
----------
WarehouseId PK int IDENTITY
Field0Warehouse decimal(10,2) INDEX
Field1Warehouse decimal(10,2)
Field2Warehouse date INDEX
Field3Warehouse datetime default=6
Field4Warehouse text NULL
Field5Warehouse decimal(10,2) NULL
Field6Warehouse datetime
Field7Warehouse uuid default=5
Field8Warehouse string

Bin
----
BinId PK int IDENTITY
Field0Bin datetime default=7
Field1Bin varchar(200)
Field2Bin decimal(10,2) UNIQUE

# StockLevel documentation
"inventory.StockLevel"
-
StockLevelId PK int IDENTITY
SalesRepRef0 int FK 0-0 SalesRep.SalesRepId
Field0StockLevel text NULL
Field1StockLevel money UNIQUE
Field2StockLevel decimal(10,2) UNIQUE
Field3StockLevel string NULL
Field4StockLevel varchar(200) UNIQUE
Field5StockLevel uuid
Field6StockLevel uuid default=7

StockMove
-
StockMoveId PK int IDENTITY
Field0StockMove datetime NULL

Supplier as sup7
----------
SupplierId PK int IDENTITY
Field0Supplier decimal(10,2)
Field1Supplier int INDEX
Field2Supplier date
Field3Supplier string default=7
Field4Supplier text

PurchaseOrder
---
PurchaseOrderId PK int IDENTITY
RegionRef0 int FK -0< "sales.Region".RegionId
ActivityRef1 int FK >0- Activity.ActivityId
Field0PurchaseOrder int UNIQUE
Field1PurchaseOrder decimal(10,2) INDEX
Field2PurchaseOrder varchar(200) default=1
Field3PurchaseOrder bool default=1
Field4PurchaseOrder text default=8
Field5PurchaseOrder text INDEX
Field6PurchaseOrder uuid

PurchaseOrderLine
----------
PurchaseOrderLineId PK int IDENTITY
DealRef0 int FK - Deal.DealId
Field0PurchaseOrderLine bool UNIQUE

# Receipt documentation
Receipt
---
ReceiptId PK int IDENTITY
BinRef0 int FK -< Bin.BinId
ProductRef1 int FK >- pro0.ProductId
Field0Receipt date NULL
Field1Receipt int default=5

ReceiptLine
----
ReceiptLineId PK int IDENTITY
PlanRef0 int FK >-< Plan.PlanId
SupplierRef1 int FK -0 sup7.SupplierId
Field0ReceiptLine uuid NULL
Field1ReceiptLine string
Field2ReceiptLine datetime
Field3ReceiptLine decimal(10,2) UNIQUE
Field4ReceiptLine datetime INDEX
Field5ReceiptLine text UNIQUE
Field6ReceiptLine int UNIQUE
Field7ReceiptLine bool

Batch
----
BatchId PK int IDENTITY
LeadRef0 int FK 0- Lead.LeadId
Field0Batch money
Field1Batch uuid UNIQUE
Field2Batch varchar(200)
Field3Batch uuid default=5
Field4Batch datetime
Field5Batch money INDEX

SerialNumber
---
SerialNumberId PK int IDENTITY
ActivityRef0 int FK 0-0 Activity.ActivityId
LedgerEntryRef1 int FK -0< LedgerEntry.LedgerEntryId
Field0SerialNumber string
Field1SerialNumber datetime INDEX

Unit as uni14
rel >- Warehouse
----------
UnitId PK int IDENTITY
Field0Unit bool
Field1Unit bool INDEX
Field2Unit datetime
Field3Unit money default=5
Field4Unit varchar(200) NULL
Field5Unit date
Field6Unit varchar(200) NULL
Field7Unit bool INDEX

# UnitConversion documentation
UnitConversion
-
UnitConversionId PK int IDENTITY
PriceListRef0 int FK >0- PriceList.PriceListId
StockMoveRef1 int FK - StockMove.StockMoveId
Field0UnitConversion bool INDEX
Field1UnitConversion string NULL
Field2UnitConversion text INDEX
Field3UnitConversion bool NULL
Field4UnitConversion string
Field5UnitConversion varchar(200) default=7
Field6UnitConversion money
Field7UnitConversion datetime

Bom
----------
BomId PK int IDENTITY
Field0Bom uuid
Field1Bom varchar(200) INDEX
Field2Bom varchar(200)
Field3Bom bool
Field4Bom string default=8

BomLine
----
BomLineId PK int IDENTITY
PriceListItemRef0 int FK -< PriceListItem.PriceListItemId
Field0BomLine bool NULL
Field1BomLine string NULL
Field2BomLine decimal(10,2)

"inventory.WorkOrder"
----
WorkOrderId PK int IDENTITY
ChargebackRef0 int FK >- Chargeback.ChargebackId
TaxCodeRef1 int FK >-< tax7.TaxCodeId
Field0WorkOrder text default=2
Field1WorkOrder string UNIQUE
Field2WorkOrder money default=7
Field3WorkOrder money default=6
Field4WorkOrder string UNIQUE
Field5WorkOrder string INDEX
Field6WorkOrder text NULL
Field7WorkOrder text NULL

Routing
---
RoutingId PK int IDENTITY
AuditLogRef0 int FK -0 AuditLog.AuditLogId
Field0Routing string NULL
"Display Name" string="Unnamed Routing"

# Operation documentation
Operation
----
OperationId PK int IDENTITY
Field0Operation bool UNIQUE
Field1Operation text
Field2Operation datetime

Machine as mac21
----
MachineId PK int IDENTITY
Field0Machine date
Field1Machine text default=2
Field2Machine date NULL
Field3Machine date UNIQUE
Field4Machine date

Shift
-
ShiftId PK int IDENTITY
Field0Shift decimal(10,2) INDEX
Field1Shift date INDEX
Field2Shift text
Field3Shift datetime NULL
Field4Shift money INDEX

QualityCheck
-
QualityCheckId PK int IDENTITY
TerritoryRef0 int FK 0- ter7.TerritoryId
PriceListItemRef1 int FK 0-0 PriceListItem.PriceListItemId
Field0QualityCheck money INDEX
Field1QualityCheck decimal(10,2) default=5
Field2QualityCheck varchar(200)
Field3QualityCheck bool INDEX
Field4QualityCheck varchar(200) default=5
Field5QualityCheck text UNIQUE
Field6QualityCheck decimal(10,2)
Field7QualityCheck datetime NULL

Defect
---
DefectId PK int IDENTITY
Field0Defect datetime default=6

# Carrier documentation
Carrier
rel >- BankTransaction
---
CarrierId PK int IDENTITY
Field0Carrier date NULL
Field1Carrier varchar(200) default=7
Field2Carrier uuid UNIQUE
Field3Carrier uuid
Field4Carrier money INDEX
Field5Carrier decimal(10,2) default=3

Route
----
RouteId PK int IDENTITY
Field0Route datetime default=7

Stop
----------
StopId PK int IDENTITY
LoanRef0 int FK -0< loa28.LoanId
Field0Stop string NULL

Vehicle as veh28
----
VehicleId PK int IDENTITY
TaxRateRef0 int FK >0- TaxRate.TaxRateId
BomLineRef1 int FK - BomLine.BomLineId
Field0Vehicle bool INDEX
Field1Vehicle int default=9
Field2Vehicle decimal(10,2) default=5
Field3Vehicle datetime INDEX
Field4Vehicle text default=7
Field5Vehicle datetime
Field6Vehicle date NULL

Driver
-
DriverId PK int IDENTITY
TaxCodeRef0 int FK -< tax7.TaxCodeId
Field0Driver text NULL
Field1Driver decimal(10,2) default=9
Field2Driver money
Field3Driver int NULL
Field4Driver bool default=7
Field5Driver uuid default=2

# Pallet documentation
Pallet
---
PalletId PK int IDENTITY
IntercompanyRef0 int FK >- Intercompany.IntercompanyId
Field0Pallet varchar(200) default=6
Field1Pallet datetime UNIQUE
Field2Pallet text default=8
Field3Pallet uuid UNIQUE
Field4Pallet uuid UNIQUE
Field5Pallet bool INDEX

"inventory.Container"
----
ContainerId PK int IDENTITY
PurchaseOrderRef0 int FK >-< PurchaseOrder.PurchaseOrderId
ProductRef1 int FK -0 pro0.ProductId
Field0Container date UNIQUE

Dock
---
DockId PK int IDENTITY
SalesRepRef0 int FK 0- SalesRep.SalesRepId
FeeRef1 int FK 0-0 Fee.FeeId
Field0Dock varchar(200)
Field1Dock date NULL
Field2Dock decimal(10,2) default=0
Field3Dock string
Field4Dock uuid INDEX
Field5Dock varchar(200)
Field6Dock decimal(10,2) default=6
Field7Dock date

Appointment
-
AppointmentId PK int IDENTITY
AccountRef0 int FK -0< Account.AccountId
AccrualRef1 int FK >0- Accrual.AccrualId
Field0Appointment text
Field1Appointment uuid INDEX
Field2Appointment bool INDEX
Field3Appointment text default=5

CycleCount
----
CycleCountId PK int IDENTITY
WorkOrderRef0 int FK - "inventory.WorkOrder".WorkOrderId
ContainerRef1 int FK -< "inventory.Container".ContainerId
Field0CycleCount date NULL
Field1CycleCount decimal(10,2) default=4
Field2CycleCount datetime UNIQUE
Field3CycleCount datetime
Field4CycleCount uuid INDEX

# Adjustment documentation
Adjustment as adj35
----
AdjustmentId PK int IDENTITY
MachineRef0 int FK >- mac21.MachineId
BatchRef1 int FK >-< Batch.BatchId
Field0Adjustment datetime default=1
Field1Adjustment text INDEX
Field2Adjustment bool UNIQUE
Field3Adjustment int
Field4Adjustment string INDEX

Reservation
rel >- Receipt
----
ReservationId PK int IDENTITY
ExpenseRef0 int FK -0 exp21.ExpenseId
PaymentMethodRef1 int FK 0- PaymentMethod.PaymentMethodId
Field0Reservation text default=4
Field1Reservation datetime
Field2Reservation date NULL
Field3Reservation decimal(10,2)
"Display Name" string="Unnamed Reservation"

Kit
---
KitId PK int IDENTITY
CommissionRef0 int FK 0-0 Commission.CommissionId
SalesRepRef1 int FK -0< SalesRep.SalesRepId
Field0Kit money
Field1Kit uuid

KitItem
---
KitItemId PK int IDENTITY
Field0KitItem varchar(200)
Field1KitItem uuid
Field2KitItem decimal(10,2) UNIQUE
Field3KitItem datetime
Field4KitItem date default=3
Field5KitItem int INDEX
Field6KitItem varchar(200) INDEX
Field7KitItem uuid
Field8KitItem datetime

Attribute
----
AttributeId PK int IDENTITY
EntityRef0 int FK >0- Entity.EntityId
BasketRef1 int FK - Basket.BasketId
Field0Attribute datetime
Field1Attribute text INDEX
Field2Attribute varchar(200) INDEX
Field3Attribute datetime
Field4Attribute bool
Field5Attribute uuid
