ProductUsageJobProductBenefits


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
productId uuid 2147483647 null
Products.id ProductUsageJobProductBenefits_productId_fkey C
jobProductId uuid 2147483647 null
JobProducts.id ProductUsageJobProductBenefits_jobProductId_fkey C
amount int4 10 null
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
ProductUsageJobProductBenefits_pkey Primary key Asc id
ProductUsageJobProductBenefits_productId_jobProductId_key Must be unique Asc/Asc productId + jobProductId

Check Constraints

Constraint Name Constraint
ProductUsageJobProductBenefits_amount_check ((amount > 0))

Relationships

Close relationships within degrees of separation