# Stages ## Documentation The stages of the sales pipelines. Each request costs 5 tokens of the daily budget of the company. - Catalog: `Pipedrive` - Schema: `Pipelines` - Primary Keys: `id` Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `Stages` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `add_time` | `datetime` | | ☐ | The stage creation time. | | `days_to_rotten` | `int64` | | ☐ | The number of days the deals not updated in this stage would become rotten. | | `deal_probability` | `int64` | | ☐ | The success probability percentage of the deal. | | `id` | `int64` | | ☑ | The ID of the stage. | | `is_deal_rot_enabled` | `char` | | ☐ | Whether deals in this stage can become rotten. | | `is_deleted` | `char` | | ☐ | Whether the stage is marked as deleted or not. | | `name` | `varchar2` | | ☐ | The name of the stage. | | `order_nr` | `int64` | | ☐ | Defines the order of the stage. | | `pipeline_id` | `int64` | | ☐ | The ID of the pipeline to add the stage to. | | `update_time` | `datetime` | | ☐ | The stage update time. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `pipeline_id` | [[Pipelines-Pipelines\|Pipelines.Pipelines]] | `id` | Declared by the connector, not enforced by the platform | ## Referenced By The columns of these tables refer to a row of this table. | Table | Columns | Guarantee | |---|---|---| | [[Deals-ArchivedDeals\|Deals.ArchivedDeals]] | `stage_id` | Declared by the connector, not enforced by the platform | | [[Deals-Deals\|Deals.Deals]] | `stage_id` | Declared by the connector, not enforced by the platform | | [[Settings-RecentChangesBySinceTimestamp\|Settings.RecentChangesBySinceTimestamp]] | `id` | In words only: The changed row of Stages, when item is 'stage'. |