PointsJournalEntries


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
PointsExpiryDatetimes.pointsJournalEntryId PointsExpiryDatetimes_pointsJournalEntryId_fkey C
PointsJournalEntryDebitCredits.pointsJournalEntryId PointsTopUpJournalEntryDebitCredits_pointsJournalEntryId_fkey R
PointsTopUpJournalEntries.pointsJournalEntryId PointsTopUpJournalEntries_pointsJournalEntryId_fkey R
PointsUsageJournalEntries.pointsJournalEntryId PointsUsageJournalEntries_pointsJournalEntryId_fkey R
userId uuid 2147483647 √ null
Users.id PointsJournalEntries_userId_fkey N

The user whose action caused movement of points.
eventDateTime timestamptz 35,6 null

The date and time of the event that caused movement of points.
createdAt timestamptz 35,6 now()
type "employer_commerce"."enum_EmployerCommerce_PointsJournalEntryType" 2147483647 null

Journal entry for point movement can be of many types. This column store The type of event that caused movement of points.
companyId uuid 2147483647 √ null
Companies.id PointsJournalEntries_companyId_fkey N

The company whose action caused movement of points.
descriptionKey text 2147483647 ''::text

Key to the description of the event that caused movement of points. This key is mapped to translation key in the application code.
notes text 2147483647 √ null

This column will be used to describe the purpose of this job post transaction

Indexes

Constraint Name Type Sort Column(s)
PointsJournalEntries_pkey Primary key Asc id
employer_commerce_PointsJournalEntries_eventDateTime_idx Performance Asc eventDateTime
employer_commerce_PointsJournalEntries_userId_idx Performance Asc userId
PointsJournalEntries_companyId_idx Performance Asc companyId

Relationships

Close relationships within degrees of separation