PendingPurchaseOrders


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
companyId uuid 2147483647 √ null
Companies.id PendingPurchaseOrders_companyId_fkey N
productId uuid 2147483647 null
Products.id PendingPurchaseOrders_productId_fkey R
creditPurchaseOrderId uuid 2147483647 √ null
CreditPurchaseOrders.id PendingPurchaseOrders_creditPurchaseOrderId_fkey R
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
creditProductPurchaseOrderId uuid 2147483647 null
CreditProductPurchaseOrders.id PendingPurchaseOrders_creditProductPurchaseOrderId_fkey R

Indexes

Constraint Name Type Sort Column(s)
PendingPurchaseOrders_pkey Primary key Asc id
PendingPurchaseOrders_companyId_productId_idx Performance Asc/Asc companyId + productId

Relationships

Close relationships within degrees of separation