account_stages


Description

A row in this table represents a pipeline stage.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
account_stage_id varchar 2147483647 null
account_survey_triggers.account_stage_id account_survey_triggers_account_stage_id_fkeyN
email_events.account_stage_id emails_events_account_stage_id_fkeyN
interview_panels.account_stage_id interview_panels_account_stage_id_fkeyC
nurture_campaign_events.account_stage_id nurture_campaign_events_account_stage_id_fkeyN
opportunities.account_stage_id opportunities_account_stage_id_fkeyN
opportunity_feedback_events.account_stage_id opportunities_feedback_events_account_stage_id_fkeyN
opportunity_form_events.account_stage_id opportunities_form_events_account_stage_id_fkeyN
opportunity_progress_events.account_stage_id opportunities_progress_events_account_stage_id_fkeyN
opportunity_progress_events.previous_account_stage_id opportunity_progress_events_previous_account_stage_id_fkeyN

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

rank numeric 131089 null

Used to sort the stages in the correct order - goes from low \(earlier stage\) to high \(later stages\)

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 seconds 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
stage_milestone_enum.stage_milestone_id account_stages_stage_milestone_id_fkeyN

ID of the milestone correspondent to current stage.

stage_pipeline_id varchar 2147483647 null
stage_pipeline_enum.stage_pipeline_id account_stages_stage_pipeline_id_fkeyN

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.

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

Relationships