CompanyProductInventoryUsageAfterPurchaseLogs


Columns

Column Type Size Nulls Auto Default Children Parents Comments
companyProductInventoryLogId uuid 2147483647 null
CompanyProductInventoryLogs.id CompanyProductInventoryUsageA_companyProductInventoryLogId_fkey C
purchaseOrderProductId uuid 2147483647 null
PurchaseOrderProducts.id CompanyProductInventoryUsageAfterPu_purchaseOrderProductId_fkey R

Foreign key to PurchaseOrderProducts table. Represents the Product of a PurchaseOrder which was used. Should also have entry in PurchaseOrderProductAfterPaymentActionLogs table.

Indexes

Constraint Name Type Sort Column(s)
CompanyProductInventoryUsageAfterPurchaseLogs_pkey Primary key Asc companyProductInventoryLogId

Relationships

Close relationships within degrees of separation