OfflineSalesTransactions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
CompanyCreditInventoryAddThroughProductPurchaseLogs.offlineSalesTransactionId CompanyCreditInventoryAddThrough_offlineSalesTransactionId_fkey R
CompanyProductInventoryAddThroughSalesTransactionLogs.offlineSalesTransactionId CompanyProductInventoryAddThroug_offlineSalesTransactionId_fkey C
RecurringCreditTopUp.offlineSalesTransactionId RecurringCreditTopUp_offlineSalesTransactionId_fkey C
companyCreditInventoryLogId uuid 2147483647 √ null
CompanyCreditInventoryLogs.id OfflineSalesTransactions_companyCreditInventoryLogId_fkey C
companyId uuid 2147483647 √ null
Companies.id OfflineSalesTransactions_companyId_fkey N
userId uuid 2147483647 √ null
Users.id OfflineSalesTransactions_userId_fkey N
price numeric 0 √ null
currency "employer_purchases"."enum_employer_purchases_supported_currencies" 2147483647 null
CreditPrices.currency Implied Constraint R
invoiceId text 2147483647 √ null
notes text 2147483647 √ null
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
companyJobSlotSubscriptionId uuid 2147483647 √ null
CompanyJobSlotsSubscriptions.id OfflineSalesTransactions_companyJobSlotSubscriptionId_fkey C

Indexes

Constraint Name Type Sort Column(s)
OfflineSalesTransactions_pkey Primary key Asc id

Check Constraints

Constraint Name Constraint
OfflineSalesTransactions_price_check ((((price IS NOT NULL) AND (price > (0)::numeric)) OR (price IS NULL)))

Relationships

Close relationships within degrees of separation