Orders


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
OrderItems.orderId OrderItems_orderId_fkey C
PointsUsageJournalEntries.orderId PointsUsageJournalEntries_orderId_fkey R
userCompanyId uuid 2147483647 √ null
UserCompanies.id Orders_userCompanyId_fkey N
createdAt timestamptz 35,6 now()
userId uuid 2147483647 √ null
Users.id Orders_userId_fkey R
companyId uuid 2147483647 √ null
Companies.id Orders_companyId_fkey N

Indexes

Constraint Name Type Sort Column(s)
Orders_pkey Primary key Asc id
employer_commerce_Orders_companyId_idx Performance Asc companyId
employer_commerce_Orders_userCompanyId_idx Performance Asc userCompanyId
employer_commerce_Orders_userId_idx Performance Asc userId

Relationships

Close relationships within degrees of separation