Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | gen_random_uuid() |
|
|
||||||
| jobId | uuid | 2147483647 | null |
|
|
||||||
| boostedAt | timestamptz | 35,6 | null |
|
|
||||||
| boostEndsAt | timestamptz | 35,6 | null |
|
|
||||||
| status | "employer_purchases"."enum_EmployerPurchases_JobBoostRecords_status" | 2147483647 | null |
|
|
||||||
| createdAt | timestamptz | 35,6 | now() |
|
|
||||||
| updatedAt | timestamptz | 35,6 | now() |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| JobBoostRecords_pkey | Primary key | Asc | id |
| JobBoostRecords_jobId_status_idx | Must be unique | Asc/Asc | jobId + status |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| JobBoostRecords_boostedAt_boostEndsAt_check | (("boostedAt" < "boostEndsAt")) |
Relationships
Close relationships within degrees of separation
