features
Data license: Not yet licensed — internal review only · Data source: Ahmed ElBatanony, Innopolis University
- form
- user-action = 'The system lets …'; automation = 'The system automatically …'.
- found_by
- Which blind run's wording was kept (the other run may also have found it), or verifier/adjudicator for added capabilities.
- verification
- confirmed by the verifier; corrected (reworded); or added (missed by both runs).
- pipeline_id
- Link to the full pipeline record of this statement.
- source_sha256
- sha256 of the archived plain text the excerpt was checked against.
- audited
- 1 if the row is in the 150-row blind audit sample.
- audit_correct
- Blind auditor's overall verdict (1 = acceptable as is).
63 rows where app_id = "F2-015" and verification = "confirmed" sorted by feature_id
This data as json, CSV (advanced)
Suggested facets: source_url, source_file, source_sha256, found_by_runs, audited
form 2
- user-action 54
- automation 9
verification 1
- confirmed · 63 ✖
audit_correct 1
- 1.0 3
app_id 1
- Pipedrive · 63 ✖
| feature_id ▼ | app_id | statement | form | excerpt | source_url | source_file | source_sha256 | found_by | found_by_runs | verification | pipeline_id | audited | audit_correct | audit_note |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| F2-015-S001 | Pipedrive F2-015 | The system automatically pulls deal history and previous conversations into a pre-call brief when a call is upcoming. | automation | Nova automatically pulls deal history and previous conversations into a pre-call brief. | https://www.pipedrive.com/en/features | 01.txt | 9e7e20262890ac37e1dab90c69676f092f16e8086ba8428c23ec779d35c39b07 | extract-a | both | confirmed | The system automatically pulls deal history and previous conversations into a pre-call brief when a call is upcoming. F2-015-A001 | 0.0 | ||
| F2-015-S004 | Pipedrive F2-015 | The system lets a user customize pipelines. | user-action | Customize pipelines, tailor business processes to customer needs and keep your team on the right track | https://www.pipedrive.com/en/features | 01.txt | 9e7e20262890ac37e1dab90c69676f092f16e8086ba8428c23ec779d35c39b07 | extract-a | both | confirmed | The system lets a user customize pipelines. F2-015-A004 | 0.0 | ||
| F2-015-S005 | Pipedrive F2-015 | The system lets a user generate sales reports by typing what is needed or choosing a prompt. | user-action | Generate sales reports instantly by typing what you need or choose from 15+ available prompts | https://www.pipedrive.com/en/features | 01.txt | 9e7e20262890ac37e1dab90c69676f092f16e8086ba8428c23ec779d35c39b07 | extract-a | both | confirmed | The system lets a user generate sales reports by typing what is needed or choosing a prompt. F2-015-A006 | 0.0 | ||
| F2-015-S007 | Pipedrive F2-015 | The system lets a user receive personalized deal recommendations from an AI assistant. | user-action | Focus on the right deals thanks to personalized recommendations from your AI-powered assistant | https://www.pipedrive.com/en/features | 01.txt | 9e7e20262890ac37e1dab90c69676f092f16e8086ba8428c23ec779d35c39b07 | extract-a | both | confirmed | The system lets a user receive personalized deal recommendations from an AI assistant. F2-015-A008 | 0.0 | ||
| F2-015-S008 | Pipedrive F2-015 | The system lets a user create emails with templates and a drag-and-drop builder. | user-action | Create stunning emails with templates and a simple drag-and-drop builder | https://www.pipedrive.com/en/features | 01.txt | 9e7e20262890ac37e1dab90c69676f092f16e8086ba8428c23ec779d35c39b07 | extract-a | both | confirmed | The system lets a user create emails with templates and a drag-and-drop builder. F2-015-A009 | 1.0 | 1.0 | |
| F2-015-S009 | Pipedrive F2-015 | The system lets a user segment an email audience. | user-action | Segment your audience and reach each customer with the right message | https://www.pipedrive.com/en/features | 01.txt | 9e7e20262890ac37e1dab90c69676f092f16e8086ba8428c23ec779d35c39b07 | extract-a | both | confirmed | The system lets a user segment an email audience. F2-015-A010 | 0.0 | ||
| F2-015-S012 | Pipedrive F2-015 | The system lets an admin define which team members can see what data and access which features. | user-action | Define which members of your team can see what data and access which Pipedrive features | https://www.pipedrive.com/en/features | 01.txt | 9e7e20262890ac37e1dab90c69676f092f16e8086ba8428c23ec779d35c39b07 | extract-a | both | confirmed | The system lets an admin define which team members can see what data and access which features. F2-015-A013 | 0.0 | ||
| F2-015-S013 | Pipedrive F2-015 | The system lets a user take notes on a mobile device during a call or a meeting. | user-action | Take notes while on the go, during a call or a meeting | https://www.pipedrive.com/en/features | 01.txt | 9e7e20262890ac37e1dab90c69676f092f16e8086ba8428c23ec779d35c39b07 | extract-a | both | confirmed | The system lets a user take notes on a mobile device during a call or a meeting. F2-015-A014 | 0.0 | ||
| F2-015-S014 | Pipedrive F2-015 | The system automatically tracks calls made from the mobile app when they are placed. | automation | Make calls directly from the app and automatically track them in Pipedrive | https://www.pipedrive.com/en/features | 01.txt | 9e7e20262890ac37e1dab90c69676f092f16e8086ba8428c23ec779d35c39b07 | extract-a | both | confirmed | The system automatically tracks calls made from the mobile app when they are placed. F2-015-A015 | 0.0 | ||
| F2-015-S015 | Pipedrive F2-015 | The system lets a user schedule sales activities while offline. | user-action | Schedule sales activities wherever you are, even when offline | https://www.pipedrive.com/en/features | 01.txt | 9e7e20262890ac37e1dab90c69676f092f16e8086ba8428c23ec779d35c39b07 | extract-a | both | confirmed | The system lets a user schedule sales activities while offline. F2-015-A016 | 0.0 | ||
| F2-015-S016 | Pipedrive F2-015 | The system lets a user add a picture taken with a phone to a deal or contact. | user-action | Snap a picture with your phone and add it to a deal or contact | https://www.pipedrive.com/en/features | 01.txt | 9e7e20262890ac37e1dab90c69676f092f16e8086ba8428c23ec779d35c39b07 | extract-a | both | confirmed | The system lets a user add a picture taken with a phone to a deal or contact. F2-015-A017 | 0.0 | ||
| F2-015-S017 | Pipedrive F2-015 | The system lets a user see which clients are nearby. | user-action | Use the “Nearby” feature to see which clients are close and schedule customer interactions | https://www.pipedrive.com/en/features | 01.txt | 9e7e20262890ac37e1dab90c69676f092f16e8086ba8428c23ec779d35c39b07 | extract-a | both | confirmed | The system lets a user see which clients are nearby. F2-015-A018 | 0.0 | ||
| F2-015-S019 | Pipedrive F2-015 | The system lets a user create, manage and send pricing proposals and contracts to prospects and track engagement within them. | user-action | Create, manage and send pricing proposals and contracts to prospects, then track engagement within these documents | https://www.pipedrive.com/en/features | 01.txt | 9e7e20262890ac37e1dab90c69676f092f16e8086ba8428c23ec779d35c39b07 | extract-a | both | confirmed | The system lets a user create, manage and send pricing proposals and contracts to prospects and track engagement within them. F2-015-A020 | 0.0 | ||
| F2-015-S020 | Pipedrive F2-015 | The system lets a user place incoming and outgoing calls with leads and customers and record, track and analyze them. | user-action | Place incoming and outgoing calls with leads and customers, then record, track and analyze them | https://www.pipedrive.com/en/features | 01.txt | 9e7e20262890ac37e1dab90c69676f092f16e8086ba8428c23ec779d35c39b07 | extract-a | both | confirmed | The system lets a user place incoming and outgoing calls with leads and customers and record, track and analyze them. F2-015-A021 | 0.0 | ||
| F2-015-S021 | Pipedrive F2-015 | The system lets a user back up and export business data. | user-action | Back up and export your business and sales management data and merge or remove duplicates in your Pipedrive account | https://www.pipedrive.com/en/features | 01.txt | 9e7e20262890ac37e1dab90c69676f092f16e8086ba8428c23ec779d35c39b07 | extract-a | both | confirmed | The system lets a user back up and export business data. F2-015-A022 | 0.0 | ||
| F2-015-S022 | Pipedrive F2-015 | The system lets a user create shareable, trackable documents from templates. | user-action | Create shareable, trackable documents and templates with Smart Docs to strike while the deal is hot | https://www.pipedrive.com/en/features | 01.txt | 9e7e20262890ac37e1dab90c69676f092f16e8086ba8428c23ec779d35c39b07 | extract-a | both | confirmed | The system lets a user create shareable, trackable documents from templates. F2-015-A023 | 0.0 | ||
| F2-015-S023 | Pipedrive F2-015 | The system lets a user create and send customizable email campaigns. | user-action | Create and send customizable email campaigns with pro templates, built to get more clicks | https://www.pipedrive.com/en/features | 01.txt | 9e7e20262890ac37e1dab90c69676f092f16e8086ba8428c23ec779d35c39b07 | extract-a | a | confirmed | The system lets a user create and send customizable email campaigns. F2-015-A024 | 0.0 | ||
| F2-015-S024 | Pipedrive F2-015 | The system lets a user sync emails with contacts and deals. | user-action | Sync emails with contacts and deals to stay on top of every customer interaction | https://www.pipedrive.com/en/features/email-integration | 04.txt | 31e1bac6f210326bc0280d4ee45bd848c9a58527e6f629364932be3957be80b9 | extract-a | both | confirmed | The system lets a user sync emails with contacts and deals. F2-015-A025 | 0.0 | ||
| F2-015-S025 | Pipedrive F2-015 | The system lets a user create and send emails using customizable templates. | user-action | Create and send emails in Pipedrive using customizable templates | https://www.pipedrive.com/en/features/email-integration | 04.txt | 31e1bac6f210326bc0280d4ee45bd848c9a58527e6f629364932be3957be80b9 | extract-a | both | confirmed | The system lets a user create and send emails using customizable templates. F2-015-A026 | 0.0 | ||
| F2-015-S026 | Pipedrive F2-015 | The system lets a user track email opens and clicks. | user-action | Track opens and clicks in real time to understand email performance | https://www.pipedrive.com/en/features/email-integration | 04.txt | 31e1bac6f210326bc0280d4ee45bd848c9a58527e6f629364932be3957be80b9 | extract-a | both | confirmed | The system lets a user track email opens and clicks. F2-015-A027 | 0.0 | ||
| F2-015-S027 | Pipedrive F2-015 | The system lets a user copy email threads into the inbox by Smart Bcc and automatically link them to deals. | user-action | Copy email threads into your Pipedrive inbox and automatically link to deals. | https://www.pipedrive.com/en/features/email-integration | 04.txt | 31e1bac6f210326bc0280d4ee45bd848c9a58527e6f629364932be3957be80b9 | extract-a | both | confirmed | The system lets a user copy email threads into the inbox by Smart Bcc and automatically link them to deals. F2-015-A028 | 0.0 | ||
| F2-015-S028 | Pipedrive F2-015 | The system lets a user view the full communication history of past emails. | user-action | Get context before every reply with all past emails visible in one dashboard. | https://www.pipedrive.com/en/features/email-integration | 04.txt | 31e1bac6f210326bc0280d4ee45bd848c9a58527e6f629364932be3957be80b9 | extract-a | both | confirmed | The system lets a user view the full communication history of past emails. F2-015-A029 | 0.0 | ||
| F2-015-S029 | Pipedrive F2-015 | The system lets a user schedule emails in advance. | user-action | you can schedule emails in advance and automate follow-ups based on specific actions | https://www.pipedrive.com/en/features/email-integration | 04.txt | 31e1bac6f210326bc0280d4ee45bd848c9a58527e6f629364932be3957be80b9 | extract-a | both | confirmed | The system lets a user schedule emails in advance. F2-015-A030 | 0.0 | ||
| F2-015-S031 | Pipedrive F2-015 | The system lets a user connect a personal or team email account. | user-action | Set up a personal or team account based on how your sales team manages email. | https://www.pipedrive.com/en/features/email-integration | 04.txt | 31e1bac6f210326bc0280d4ee45bd848c9a58527e6f629364932be3957be80b9 | extract-a | a | confirmed | The system lets a user connect a personal or team email account. F2-015-A032 | 0.0 | ||
| F2-015-S032 | Pipedrive F2-015 | The system lets a user create custom dashboards of key sales performance data. | user-action | you can create custom dashboards that highlight key sales performance data. | https://www.pipedrive.com/en/features/sales-reporting | 05.txt | d33e530a724e99ad1171032586f6683a0c89d10e4ea024f22ea669e31126ba6e | extract-a | a | confirmed | The system lets a user create custom dashboards of key sales performance data. F2-015-A034 | 0.0 | ||
| F2-015-S033 | Pipedrive F2-015 | The system lets a user monitor revenue, conversion rates and deal size. | user-action | Monitor revenue, conversion rates and deal size in one place. | https://www.pipedrive.com/en/features/sales-reporting | 05.txt | d33e530a724e99ad1171032586f6683a0c89d10e4ea024f22ea669e31126ba6e | extract-a | both | confirmed | The system lets a user monitor revenue, conversion rates and deal size. F2-015-A035 | 0.0 | ||
| F2-015-S034 | Pipedrive F2-015 | The system lets a user track calls, emails and response times against targets. | user-action | Track calls, emails and response times against targets. | https://www.pipedrive.com/en/features/sales-reporting | 05.txt | d33e530a724e99ad1171032586f6683a0c89d10e4ea024f22ea669e31126ba6e | extract-a | both | confirmed | The system lets a user track calls, emails and response times against targets. F2-015-A036 | 0.0 | ||
| F2-015-S035 | Pipedrive F2-015 | The system lets a manager compare team performance and track shared goals. | user-action | Compare team performance and track shared goals. | https://www.pipedrive.com/en/features/sales-reporting | 05.txt | d33e530a724e99ad1171032586f6683a0c89d10e4ea024f22ea669e31126ba6e | extract-a | both | confirmed | The system lets a manager compare team performance and track shared goals. F2-015-A037 | 0.0 | ||
| F2-015-S036 | Pipedrive F2-015 | The system lets a manager view real-time dashboards for each sales rep. | user-action | View real-time dashboards for each sales rep. | https://www.pipedrive.com/en/features/sales-reporting | 05.txt | d33e530a724e99ad1171032586f6683a0c89d10e4ea024f22ea669e31126ba6e | extract-a | both | confirmed | The system lets a manager view real-time dashboards for each sales rep. F2-015-A038 | 0.0 | ||
| F2-015-S037 | Pipedrive F2-015 | The system lets a user forecast sales revenue by tracking deals from first contact to close. | user-action | Track deals from first contact to close and predict future revenue. | https://www.pipedrive.com/en/features/sales-reporting | 05.txt | d33e530a724e99ad1171032586f6683a0c89d10e4ea024f22ea669e31126ba6e | extract-a | both | confirmed | The system lets a user forecast sales revenue by tracking deals from first contact to close. F2-015-A039 | 0.0 | ||
| F2-015-S038 | Pipedrive F2-015 | The system lets a user build custom reports. | user-action | Build tailored reports and access data in a cloud-based CRM. | https://www.pipedrive.com/en/features/sales-reporting | 05.txt | d33e530a724e99ad1171032586f6683a0c89d10e4ea024f22ea669e31126ba6e | extract-a | both | confirmed | The system lets a user build custom reports. F2-015-A040 | 0.0 | ||
| F2-015-S039 | Pipedrive F2-015 | The system lets a user track when prospects open, view or sign documents. | user-action | See when prospects open, view or sign documents to better understand deal momentum. | https://www.pipedrive.com/en/features/sales-reporting | 05.txt | d33e530a724e99ad1171032586f6683a0c89d10e4ea024f22ea669e31126ba6e | extract-a | both | confirmed | The system lets a user track when prospects open, view or sign documents. F2-015-A041 | 1.0 | 1.0 | |
| F2-015-S040 | Pipedrive F2-015 | The system lets a user link proposals and contracts to deals. | user-action | Keep proposals and contracts connected to your pipeline for a clearer view of performance. | https://www.pipedrive.com/en/features/sales-reporting | 05.txt | d33e530a724e99ad1171032586f6683a0c89d10e4ea024f22ea669e31126ba6e | extract-a | both | confirmed | The system lets a user link proposals and contracts to deals. F2-015-A042 | 0.0 | ||
| F2-015-S041 | Pipedrive F2-015 | The system automatically triggers document actions when a deal reaches a stage. | automation | Trigger document actions based on deal stages to reduce manual work and improve consistency. | https://www.pipedrive.com/en/features/sales-reporting | 05.txt | d33e530a724e99ad1171032586f6683a0c89d10e4ea024f22ea669e31126ba6e | extract-a | both | confirmed | The system automatically triggers document actions when a deal reaches a stage. F2-015-A043 | 0.0 | ||
| F2-015-S042 | Pipedrive F2-015 | The system lets a manager create team-wide and individual goals. | user-action | Create team-wide and individual goals for your sales department. | https://www.pipedrive.com/en/features/sales-reporting | 05.txt | d33e530a724e99ad1171032586f6683a0c89d10e4ea024f22ea669e31126ba6e | extract-a | both | confirmed | The system lets a manager create team-wide and individual goals. F2-015-A044 | 0.0 | ||
| F2-015-S044 | Pipedrive F2-015 | The system automatically creates a deal when a qualified lead is added. | automation | auto-creating a deal when a qualified lead is added or activities whenever a deal moves along the pipeline | https://www.pipedrive.com/en/features/workflow-automation | 06.txt | 2ddcbc42de362ee9bf96b050feac1e6592f1b7e9d8b6e847ad2c52c43b19c9f1 | extract-a | both | confirmed | The system automatically creates a deal when a qualified lead is added. F2-015-A046 | 0.0 | ||
| F2-015-S045 | Pipedrive F2-015 | The system lets a user transfer deal ownership between reps. | user-action | Pipedrive lets you transfer deal ownership between different reps | https://www.pipedrive.com/en/features/workflow-automation | 06.txt | 2ddcbc42de362ee9bf96b050feac1e6592f1b7e9d8b6e847ad2c52c43b19c9f1 | extract-a | both | confirmed | The system lets a user transfer deal ownership between reps. F2-015-A047 | 0.0 | ||
| F2-015-S046 | Pipedrive F2-015 | The system lets a user schedule campaigns for customer interactions. | user-action | allowing you to schedule campaigns to fuel customer interactions | https://www.pipedrive.com/en/features/workflow-automation | 06.txt | 2ddcbc42de362ee9bf96b050feac1e6592f1b7e9d8b6e847ad2c52c43b19c9f1 | extract-a | both | confirmed | The system lets a user schedule campaigns for customer interactions. F2-015-A048 | 0.0 | ||
| F2-015-S047 | Pipedrive F2-015 | The system lets a user start from pre-made workflow automation templates. | user-action | Our set of pre-made workflow automation templates have you covered! | https://www.pipedrive.com/en/features/workflow-automation | 06.txt | 2ddcbc42de362ee9bf96b050feac1e6592f1b7e9d8b6e847ad2c52c43b19c9f1 | extract-a | both | confirmed | The system lets a user start from pre-made workflow automation templates. F2-015-A049 | 0.0 | ||
| F2-015-S049 | Pipedrive F2-015 | The system automatically sends a personalized email when a deal is created or reaches a certain stage. | automation | you can automatically send a personalized email whenever a deal is created or reaches a certain stage. | https://www.pipedrive.com/en/features/workflow-automation | 06.txt | 2ddcbc42de362ee9bf96b050feac1e6592f1b7e9d8b6e847ad2c52c43b19c9f1 | extract-a | both | confirmed | The system automatically sends a personalized email when a deal is created or reaches a certain stage. F2-015-A051 | 0.0 | ||
| F2-015-S050 | Pipedrive F2-015 | The system lets a user delay automation actions to a chosen time or date. | user-action | you can set up actions to be performed automatically and at your preferred time or date. | https://www.pipedrive.com/en/features/workflow-automation | 06.txt | 2ddcbc42de362ee9bf96b050feac1e6592f1b7e9d8b6e847ad2c52c43b19c9f1 | extract-a | both | confirmed | The system lets a user delay automation actions to a chosen time or date. F2-015-A052 | 0.0 | ||
| F2-015-S051 | Pipedrive F2-015 | The system automatically sends Slack notifications when a deal, contact or activity is created, updated or deleted. | automation | you can easily send out real-time, custom Slack notifications. | https://www.pipedrive.com/en/features/workflow-automation | 06.txt | 2ddcbc42de362ee9bf96b050feac1e6592f1b7e9d8b6e847ad2c52c43b19c9f1 | extract-a | both | confirmed | The system automatically sends Slack notifications when a deal, contact or activity is created, updated or deleted. F2-015-A053 | 0.0 | ||
| F2-015-S052 | Pipedrive F2-015 | The system lets a user send notifications to a team chat tool. | user-action | You can do the same with Microsoft Teams. | https://www.pipedrive.com/en/features/workflow-automation | 06.txt | 2ddcbc42de362ee9bf96b050feac1e6592f1b7e9d8b6e847ad2c52c43b19c9f1 | extract-a | both | confirmed | The system lets a user send notifications to a team chat tool. F2-015-A054 | 0.0 | ||
| F2-015-S053 | Pipedrive F2-015 | The system automatically updates tasks in an external task management tool when a deal status changes. | automation | Pipedrive can automatically update Asana tasks when a deal’s status changes | https://www.pipedrive.com/en/features/workflow-automation | 06.txt | 2ddcbc42de362ee9bf96b050feac1e6592f1b7e9d8b6e847ad2c52c43b19c9f1 | extract-a | both | confirmed | The system automatically updates tasks in an external task management tool when a deal status changes. F2-015-A055 | 0.0 | ||
| F2-015-S054 | Pipedrive F2-015 | The system automatically syncs tasks in an external task management tool with deals. | automation | syncing tasks in Trello with deals in Pipedrive, so a change in one tool is reflected in the other. | https://www.pipedrive.com/en/features/workflow-automation | 06.txt | 2ddcbc42de362ee9bf96b050feac1e6592f1b7e9d8b6e847ad2c52c43b19c9f1 | extract-a | both | confirmed | The system automatically syncs tasks in an external task management tool with deals. F2-015-A056 | 0.0 | ||
| F2-015-S055 | Pipedrive F2-015 | The system lets an admin configure automated workflows with a trigger, conditions and an action. | user-action | You need to click on the dedicated app section, configure a trigger, add a condition or multiple conditions and select an action. | https://www.pipedrive.com/en/features/workflow-automation | 06.txt | 2ddcbc42de362ee9bf96b050feac1e6592f1b7e9d8b6e847ad2c52c43b19c9f1 | extract-a | both | confirmed | The system lets an admin configure automated workflows with a trigger, conditions and an action. F2-015-A057 | 0.0 | ||
| F2-015-S056 | Pipedrive F2-015 | The system lets a user capture and manage sales leads in a leads inbox. | user-action | Capture and manage your sales leads with a leads inbox and add-ons. | https://support.pipedrive.com/en | 08.txt | bea1221210312435359dd093f1d9546cfc5403111e91eb6436d8576b53fdecae | extract-a | a | confirmed | The system lets a user capture and manage sales leads in a leads inbox. F2-015-A058 | 1.0 | 1.0 | |
| F2-015-S057 | Pipedrive F2-015 | The system automatically transcribes calls when a user holds a call. | automation | It records and transcribes your calls so you don’t have to. | https://www.pipedrive.com/en/features | 01.txt | 9e7e20262890ac37e1dab90c69676f092f16e8086ba8428c23ec779d35c39b07 | extract-b | b | confirmed | The system automatically transcribes calls when a user holds a call. F2-015-B003 | 0.0 | ||
| F2-015-S058 | Pipedrive F2-015 | The system lets a user review and approve drafted CRM updates in one click. | user-action | drafts CRM updates you can review and approve in one click | https://www.pipedrive.com/en/features | 01.txt | 9e7e20262890ac37e1dab90c69676f092f16e8086ba8428c23ec779d35c39b07 | extract-b | b | confirmed | The system lets a user review and approve drafted CRM updates in one click. F2-015-B005 | 0.0 | ||
| F2-015-S059 | Pipedrive F2-015 | The system lets a salesperson summarize lengthy email threads. | user-action | Streamline sales outreach by turning prompts into emails and summarize lengthy threads quickly | https://www.pipedrive.com/en/features | 01.txt | 9e7e20262890ac37e1dab90c69676f092f16e8086ba8428c23ec779d35c39b07 | extract-b | b | confirmed | The system lets a salesperson summarize lengthy email threads. F2-015-B009 | 0.0 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [features] ([feature_id] TEXT PRIMARY KEY, [app_id] TEXT, [statement] TEXT, [form] TEXT, [excerpt] TEXT, [source_url] TEXT, [source_file] TEXT, [source_sha256] TEXT, [found_by] TEXT, [found_by_runs] TEXT, [verification] TEXT, [pipeline_id] TEXT, [audited] REAL, [audit_correct] REAL, [audit_note] TEXT, FOREIGN KEY ([app_id]) REFERENCES apps(app_id), FOREIGN KEY ([pipeline_id]) REFERENCES candidates(candidate_id)); CREATE INDEX [idx_features_app_id] ON [features]([app_id]); CREATE INDEX [idx_features_verification] ON [features]([verification]); CREATE INDEX [idx_features_form] ON [features]([form]); CREATE INDEX [idx_features_found_by] ON [features]([found_by]);