Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
account_stage_id | varchar | 2147483647 | null |
|
|
Primary key. |
||||||||||||||||||||||
account_id | varchar | 2147483647 | √ | null |
|
|
ID of the account the record belongs to. |
|||||||||||||||||||||
stage_key | varchar | 2147483647 | √ | null |
|
|
unique id of the stage associated with the account |
|||||||||||||||||||||
stage_name | varchar | 2147483647 | √ | null |
|
|
This is the name of the pipeline stage represented by this entity |
|||||||||||||||||||||
stuck_time | numeric | 131089 | √ | null |
|
|
Setting that determines after how many milliseconds a candidate dwelling at the current stage can be defined “stuck”. |
|||||||||||||||||||||
milestone | varchar | 2147483647 | √ | null |
|
|
Type of stage, can be “lead”, “applicant”, “screen”, “onsite”, “offer” or “deactivated” for stages that are no longer used. |
|||||||||||||||||||||
pipeline | varchar | 2147483647 | √ | null |
|
|
The stages that potential candidates move through |
|||||||||||||||||||||
created_at | timestamp | 29,6 | √ | null |
|
|
Date the object referred to in this entity was created. |
|||||||||||||||||||||
is_active | bool | 1 | √ | null |
|
|
TRUE if the stage is active, FALSE if the stage in deactivated. |
|||||||||||||||||||||
stage_milestone_id | varchar | 2147483647 | √ | null |
|
|
ID of the milestone correspondent to current stage. |
|||||||||||||||||||||
stage_pipeline_id | varchar | 2147483647 | √ | null |
|
|
ID of the pipeline stage for this entity. |
|||||||||||||||||||||
row_updated_at | timestamp | 29,6 | √ | CURRENT_TIMESTAMP |
|
|
Date this entity was updated in the database. Useful to setup incremental refreshes of the data in your periodic ETL job. |
|||||||||||||||||||||
has_interview | bool | 1 | √ | false |
|
|
True when the stage has been configured to have interview |
|||||||||||||||||||||
rank | numeric | 38,12 | √ | null |
|
|
Used to sort the stages in the correct order - goes from low \(earlier stage\) to high \(later stages\) |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
account_stages_pkey | Primary key | Asc | account_stage_id |
account_stages_account_id_index | Performance | Asc | account_id |