# Persons: Simplicate Persons Fetches all persons Can retrieve and modify data using insert, update and delete. - Catalog: `Simplicate` - Schema: `CRM` - Primary Keys: `id` - Label: Persons ## Table Columns The columns of the table `Persons` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `address_country_code` | `string` | Address Country Code | ☐ | | | `address_country_id` | `string` | Address Country ID | ☐ | | | `address_country` | `string` | Address Country | ☐ | | | `address_id` | `string` | Address ID | ☐ | | | `address_line_1` | `string` | Address Line 1 | ☐ | | | `address_line_2` | `string` | Address Line 2 | ☐ | | | `address_locality` | `string` | Address City | ☐ | | | `address_postal_code` | `string` | Address Postal Code | ☐ | | | `address_province` | `string` | Address Province | ☐ | | | `address_type` | `string` | Address Type | ☐ | | | `avatar_color` | `string` | Avatar Colour | ☐ | | | `avatar_initials` | `string` | Avatar Initials | ☐ | | | `avatar_url_large` | `string` | Avatar Large (URL) | ☐ | | | `avatar_url_small` | `string` | Avatar Small (URL) | ☐ | | | `bank_account` | `string` | Bank Account | ☐ | | | `bank_bic` | `string` | Bank BIC | ☐ | | | `created_at` | `string` | Created On | ☐ | | | `custom_salutation` | `string` | | ☐ | | | `date_of_birth` | `string` | Date of Birth | ☐ | | | `email` | `string` | E-mail | ☐ | | | `facebook_url` | `string` | Facebook URL | ☐ | | | `family_name_prefix` | `string` | Family Name Prefix | ☐ | | | `family_name` | `string` | Last Name | ☐ | | | `first_name` | `string` | First Name | ☐ | | | `full_name` | `string` | Full Name | ☐ | | | `gender_id` | `string` | Gender ID | ☐ | | | `gender` | `string` | Gender | ☐ | | | `id` | `string` | ID | ☐ | | | `initials` | `string` | Initials | ☐ | | | `invoice_receiver` | `string` | Invoice Recipient | ☐ | | | `is_active` | `boolean` | | ☐ | | | `is_employee` | `int64` | Is Employee | ☐ | | | `linkedin_url` | `string` | LinkedIn URL | ☐ | | | `mailing_list_email` | `string` | Mailing List Email | ☐ | | | `note` | `string` | Note | ☐ | | | `phone` | `string` | Phone | ☐ | | | `relation_manager_avatar_color` | `string` | | ☐ | | | `relation_manager_avatar_initials` | `string` | | ☐ | | | `relation_manager_avatar_url_large` | `string` | | ☐ | | | `relation_manager_avatar_url_small` | `string` | | ☐ | | | `relation_manager_bank_account` | `string` | | ☐ | | | `relation_manager_civil_status` | `string` | | ☐ | | | `relation_manager_created_at` | `string` | | ☐ | | | `relation_manager_created` | `string` | | ☐ | | | `relation_manager_employment_status` | `string` | | ☐ | | | `relation_manager_function` | `string` | | ☐ | | | `relation_manager_hourly_cost_tariff` | `float` | | ☐ | | | `relation_manager_hourly_sales_tariff` | `float` | | ☐ | | | `relation_manager_id` | `string` | Relationship Manager ID | ☐ | | | `relation_manager_is_user` | `boolean` | | ☐ | | | `relation_manager_marital_status` | `string` | | ☐ | | | `relation_manager_modified` | `string` | | ☐ | | | `relation_manager_name` | `string` | Relationship Manager Name | ☐ | | | `relation_manager_person_address_country_code` | `string` | | ☐ | | | `relation_manager_person_address_country_id` | `string` | | ☐ | | | `relation_manager_person_address_country` | `string` | | ☐ | | | `relation_manager_person_address_id` | `string` | | ☐ | | | `relation_manager_person_address_line_1` | `string` | | ☐ | | | `relation_manager_person_address_line_2` | `string` | | ☐ | | | `relation_manager_person_address_locality` | `string` | | ☐ | | | `relation_manager_person_address_postal_code` | `string` | | ☐ | | | `relation_manager_person_address_province` | `string` | | ☐ | | | `relation_manager_person_address_type` | `string` | | ☐ | | | `relation_manager_person_avatar_color` | `string` | | ☐ | | | `relation_manager_person_avatar_initials` | `string` | | ☐ | | | `relation_manager_person_avatar_url_large` | `string` | | ☐ | | | `relation_manager_person_avatar_url_small` | `string` | | ☐ | | | `relation_manager_person_bank_account` | `string` | | ☐ | | | `relation_manager_person_bank_bic` | `string` | | ☐ | | | `relation_manager_person_created_at` | `string` | | ☐ | | | `relation_manager_person_custom_salutation` | `string` | | ☐ | | | `relation_manager_person_date_of_birth` | `string` | | ☐ | | | `relation_manager_person_email` | `string` | Relationship Manager Email Address | ☐ | | | `relation_manager_person_facebook_url` | `string` | | ☐ | | | `relation_manager_person_family_name_prefix` | `string` | | ☐ | | | `relation_manager_person_family_name` | `string` | | ☐ | | | `relation_manager_person_first_name` | `string` | | ☐ | | | `relation_manager_person_full_name` | `string` | | ☐ | | | `relation_manager_person_gender_id` | `string` | | ☐ | | | `relation_manager_person_gender` | `string` | | ☐ | | | `relation_manager_person_id_2` | `string` | | ☐ | | | `relation_manager_person_id` | `string` | | ☐ | | | `relation_manager_person_initials` | `string` | | ☐ | | | `relation_manager_person_invoice_receiver` | `string` | | ☐ | | | `relation_manager_person_is_active` | `boolean` | | ☐ | | | `relation_manager_person_is_employee` | `int64` | | ☐ | | | `relation_manager_person_linkedin_url` | `string` | | ☐ | | | `relation_manager_person_mailing_list_email` | `string` | | ☐ | | | `relation_manager_person_note` | `string` | | ☐ | | | `relation_manager_person_phone` | `string` | | ☐ | | | `relation_manager_person_relation_manager_avatar_color` | `string` | | ☐ | | | `relation_manager_person_relation_manager_avatar_initials` | `string` | | ☐ | | | `relation_manager_person_relation_manager_avatar_url_large` | `string` | | ☐ | | | `relation_manager_person_relation_manager_avatar_url_small` | `string` | | ☐ | | | `relation_manager_person_relation_manager_bank_account` | `string` | | ☐ | | | `relation_manager_person_relation_manager_civil_status` | `string` | | ☐ | | | `relation_manager_person_relation_manager_created_at` | `string` | | ☐ | | | `relation_manager_person_relation_manager_created` | `string` | | ☐ | | | `relation_manager_person_relation_manager_employment_status` | `string` | | ☐ | | | `relation_manager_person_relation_manager_function` | `string` | | ☐ | | | `relation_manager_person_relation_manager_hourly_cost_tariff` | `float` | | ☐ | | | `relation_manager_person_relation_manager_hourly_sales_tariff` | `float` | | ☐ | | | `relation_manager_person_relation_manager_id` | `string` | | ☐ | | | `relation_manager_person_relation_manager_is_user` | `boolean` | | ☐ | | | `relation_manager_person_relation_manager_marital_status` | `string` | | ☐ | | | `relation_manager_person_relation_manager_modified` | `string` | | ☐ | | | `relation_manager_person_relation_manager_name` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_address_country_code` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_address_country_id` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_address_country` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_address_id` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_address_line_1` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_address_line_2` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_address_locality` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_address_postal_code` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_address_province` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_address_type` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_avatar_color` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_avatar_initials` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_avatar_url_large` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_avatar_url_small` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_bank_account` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_bank_bic` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_created_at` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_custom_salutation` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_date_of_birth` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_email` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_facebook_url` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_family_name_prefix` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_family_name` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_first_name` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_full_name` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_gender_id` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_gender` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_id_2` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_id` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_initials` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_invoice_receiver` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_is_active` | `boolean` | | ☐ | | | `relation_manager_person_relation_manager_person_is_employee` | `int64` | | ☐ | | | `relation_manager_person_relation_manager_person_linkedin_url` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_mailing_list_email` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_note` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_phone` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_relation_manager_bank_account` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_relation_manager_civil_status` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_relation_manager_created_at` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_relation_manager_created` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_relation_manager_employment_status` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_relation_manager_function` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_relation_manager_hourly_cost_tariff` | `float` | | ☐ | | | `relation_manager_person_relation_manager_person_relation_manager_hourly_sales_tariff` | `float` | | ☐ | | | `relation_manager_person_relation_manager_person_relation_manager_id` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_relation_manager_is_user` | `boolean` | | ☐ | | | `relation_manager_person_relation_manager_person_relation_manager_marital_status` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_relation_manager_modified` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_relation_manager_name` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_relation_manager_person_id` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_relation_manager_simplicate_url` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_relation_manager_social_security_number` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_relation_manager_timeline_email_address` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_relation_manager_updated_at` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_relation_manager_work_email` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_relation_manager_work_mobile` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_relation_manager_work_phone` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_relation_number` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_relation_type_color` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_relation_type_id` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_relation_type_label` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_relation_type_type` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_simplicate_url` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_timeline_email_address` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_twitter_url` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_updated_at` | `string` | | ☐ | | | `relation_manager_person_relation_manager_person_use_custom_salutation` | `boolean` | | ☐ | | | `relation_manager_person_relation_manager_person_website_url` | `string` | | ☐ | | | `relation_manager_person_relation_manager_simplicate_url` | `string` | | ☐ | | | `relation_manager_person_relation_manager_social_security_number` | `string` | | ☐ | | | `relation_manager_person_relation_manager_status_id` | `string` | | ☐ | | | `relation_manager_person_relation_manager_status_label` | `string` | | ☐ | | | `relation_manager_person_relation_manager_timeline_email_address` | `string` | | ☐ | | | `relation_manager_person_relation_manager_type_id` | `string` | | ☐ | | | `relation_manager_person_relation_manager_type_label` | `string` | | ☐ | | | `relation_manager_person_relation_manager_updated_at` | `string` | | ☐ | | | `relation_manager_person_relation_manager_work_email` | `string` | | ☐ | | | `relation_manager_person_relation_manager_work_mobile` | `string` | | ☐ | | | `relation_manager_person_relation_manager_work_phone` | `string` | | ☐ | | | `relation_manager_person_relation_number` | `string` | | ☐ | | | `relation_manager_person_relation_type_color` | `string` | | ☐ | | | `relation_manager_person_relation_type_id` | `string` | | ☐ | | | `relation_manager_person_relation_type_label` | `string` | | ☐ | | | `relation_manager_person_relation_type_type` | `string` | | ☐ | | | `relation_manager_person_simplicate_url` | `string` | | ☐ | | | `relation_manager_person_timeline_email_address` | `string` | | ☐ | | | `relation_manager_person_twitter_url` | `string` | | ☐ | | | `relation_manager_person_updated_at` | `string` | | ☐ | | | `relation_manager_person_use_custom_salutation` | `boolean` | | ☐ | | | `relation_manager_person_website_url` | `string` | | ☐ | | | `relation_manager_simplicate_url` | `string` | | ☐ | | | `relation_manager_social_security_number` | `string` | | ☐ | | | `relation_manager_status_id` | `string` | | ☐ | | | `relation_manager_status_label` | `string` | | ☐ | | | `relation_manager_timeline_email_address` | `string` | | ☐ | | | `relation_manager_type_id` | `string` | | ☐ | | | `relation_manager_type_label` | `string` | | ☐ | | | `relation_manager_updated_at` | `string` | | ☐ | | | `relation_manager_work_email` | `string` | | ☐ | | | `relation_manager_work_mobile` | `string` | | ☐ | | | `relation_manager_work_phone` | `string` | | ☐ | | | `relation_number` | `string` | Relation Number: | ☐ | | | `relation_type_color` | `string` | Relation Type Colour | ☐ | | | `relation_type_id` | `string` | Relation Type ID | ☐ | | | `relation_type_label` | `string` | Relation Type Label | ☐ | | | `relation_type_type` | `string` | Relation Type | ☐ | | | `simplicate_url` | `string` | Simplicate URL | ☐ | | | `timeline_email_address` | `string` | Timeline Email Address | ☐ | | | `twitter_url` | `string` | Twitter URL | ☐ | | | `updated_at` | `string` | Updated On | ☐ | | | `use_custom_salutation` | `boolean` | | ☐ | | | `website_url` | `string` | Website URL | ☐ | |