OrderItems


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
JobExtensionOrderItems.orderItemId JobExtensionOrderItems_orderItemId_fkey C
JobPostOrderItems.orderItemId JobPostOrderItems_orderItemId_fkey C
orderId uuid 2147483647 √ null
Orders.id OrderItems_orderId_fkey C
productId uuid 2147483647 √ null
Products.id OrderItems_productId_fkey R
costInPoints numeric 0 null

Indexes

Constraint Name Type Sort Column(s)
OrderItems_pkey Primary key Asc id
employer_commerce_OrderItems_orderId_idx Performance Asc orderId
employer_commerce_OrderItems_productId_idx Performance Asc productId

Check Constraints

Constraint Name Constraint
OrderItems_costInPoints_check (("costInPoints" >= (0)::numeric))

Relationships

Close relationships within degrees of separation