Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| member_id | int8 |
|
|
|
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| run_search_at | timestamp |
|
|
|
| note | text |
|
|
|
| ticket_id | int8 |
|
|
|
| canceled_at | timestamp |
|
|
|
| time_note | text |
|
|
|
| completed_at | timestamp |
|
|
|
| company_id | int8 |
|
|
The owning tenant’s ID. @example 1. |
| helper_search_flow | bool |
|
|
Determines if this match request was created using the new helper search flow or not. Only needed while transitioning from the old recommendations flow to the new. @example true, false |
| day_preference | _varchar |
|
|
The prefered day for the members visit from a match request. @example ‘monday’ |
| time_range_preference | _varchar |
|
|
The prefered time range for the members visit from a match request. @example ‘morning’, ‘afternoon’ |
| repeat_frequency_preference | varchar |
|
|
The prefered repeat frequence for the members visit from a match request. @example ‘weekly’ |
| duration_preference | varchar |
|
|
The prefered duration for the members visit from a match request. @example ‘1’ |
| created_at_in_company_tz | timestamp |
|
|
|
| updated_at_in_company_tz | timestamp |
|
|
|
| run_search_at_in_company_tz | timestamp |
|
|
|
| canceled_at_in_company_tz | timestamp |
|
|
|
| completed_at_in_company_tz | timestamp |
|
|
|
| company_timezone | varchar |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| edge_match_requests_pkey | Primary key | Asc | id |