Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
---|---|---|---|---|---|---|---|---|---|---|---|
id | int4 | 10 | null |
| Primary key. | ||||||
admin_id | int4 | 10 | √ | null |
| Id of the admin the record belongs to. | |||||
admin_name | varchar | 255 | √ | null | Admin name. | ||||||
company_id | int4 | 10 | √ | null |
| Id of the company the record belongs to. | |||||
created_at | timestamp | 29,6 | √ | null | Date the record was created. | ||||||
event | varchar | 255 | √ | null | Job/talent pool activity event kind - one of (‘offer_added’, ‘offer_removed’, ‘offer_status_changed’). | ||||||
offer_id | int4 | 10 | √ | null |
| Id of the offer the record belongs to. | |||||
offer_kind | varchar | 255 | √ | null | Offer kind - one of (‘job’, ‘talent_pool’). | ||||||
offer_previous_status | varchar | 255 | √ | null | Offer previous status. | ||||||
offer_status | varchar | 255 | √ | null | Job/talent pool status. | ||||||
offer_title | varchar | 255 | √ | null | Job/talent pool title. | ||||||
updated_at | timestamp | 29,6 | √ | null | Date the record was updated. |