Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | null | Primary key. | |||||||
| company_id | int4 | 10 | √ | null |
| Id of the company the record belongs to. | |||||
| created_at | timestamp | 29,6 | √ | null | Date the record was created. | ||||||
| duration | int4 | 10 | √ | null | Number of seconds the offer had a certain status - (Offer needs to change its status for the value to update, duration of the current status will always be 0). | ||||||
| offer_activity_id | int4 | 10 | √ | null |
| Id of the offer activity the record belongs to. | |||||
| offer_id | int4 | 10 | √ | null |
| Id of the offer the record belongs to. | |||||
| previous_status | varchar | 255 | √ | null | Offer previous status. | ||||||
| status | varchar | 255 | √ | null | Offer new status. | ||||||
| status_changed_at | timestamp | 29,6 | √ | null | Date the offer status changed. | ||||||
| updated_at | timestamp | 29,6 | √ | null | Date the record was updated. |