Products


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
CompanyCreditInventoryLogs.productId CompanyCreditInventoryLogs_productId_fkey R
CompanyProductFreeTrialOffers.productId CompanyProductFreeTrialOffers_productId_fkey C
CompanyProductInventories.productId CompanyProductInventories_productId_fkey R
CompanyProductInventoryLogs.productId CompanyProductInventoryLogs_productId_fkey C
CompanyProductSubscriptions.productId CompanyProductSubscriptions_productId_fkey R
CreditProductPackages.productId CreditProductPackages_productId_fkey C
CreditProductPurchaseOrders.productId CreditProductPurchaseOrders_productId_fkey R
CreditProductSubscriptionPackages.productId CreditProductSubscriptionPackages_productId_fkey C
HotJobProductVariantDetails.productId HotJobProductVariantDetails_productId_fkey C
PendingPurchaseOrders.productId PendingPurchaseOrders_productId_fkey R
PremiumPlanProductVariantDetails.productId SubscriptionPlanProductVariantDetails_productId_fkey C
ProductCreditBenefits.productId ProductCreditBenefits_productId_fkey C
ProductUsageJobProductBenefits.productId ProductUsageJobProductBenefits_productId_fkey C
PurchaseOrderProducts.productId PurchaseOrderProducts_productId_fkey R
RecurringCreditTopUp.productId RecurringCreditTopUp_productId_fkey C
type "employer_purchases"."enum_employer_purchases_Products_type" 2147483647 null
defaultName text 2147483647 null
nameTranslationKey text 2147483647 null
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
timePeriod int4 10 √ null
timePeriodUnit "employer_purchases"."enum_employer_purchases_timePeriodUnit" 2147483647 √ null
variant "employer_purchases"."enum_employer_purchases_Products_variant" 2147483647 'VARIANT_A'::employer_purchases."enum_employer_purchases_Products_variant"
timePeriodValidityType "employer_purchases"."enum_employer_purchases_timePeriodValidityType" 2147483647 'MAX_WITH_CURRENT_EXPIRY'::employer_purchases."enum_employer_purchases_timePeriodValidityType"
countryCode varchar 100 'ID'::character varying
Countries.code Products_countryCode_fkey R

Country Code of country that this product is available in. Foreign Key Reference Countries.

Indexes

Constraint Name Type Sort Column(s)
Products_pkey Primary key Asc id
employer_purchases_Products_type_idx Performance Asc type
Products_type_variant_countryCode_key Must be unique Asc/Asc/Asc type + variant + countryCode

Check Constraints

Constraint Name Constraint
timePeriod_and_timePeriodUnit_check (((("timePeriod" IS NOT NULL) AND ("timePeriod" > 0) AND ("timePeriodUnit" IS NOT NULL)) OR (("timePeriod" IS NULL) AND ("timePeriodUnit" IS NULL))))

Relationships

Close relationships within degrees of separation