PeopleProfiles: Crisp People Profiles
read only
- Catalogo:
Crisp - Schema:
Views - Label: People Profiles
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella PeopleProfiles. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
active_ |
datetime |
itgen_crp_active_last | filters on the platform, writable | Timestamp at which the user was last active. | |
active_ |
char |
itgen_crp_active_now | filters on the platform, writable | Whether user is considered active right now or not. | |
company_ |
varchar2 |
itgen_crp_company_description | filters on the platform, writable | Company description. | |
company_ |
varchar2 |
itgen_crp_company_domain | filters on the platform, writable | Company domain name. | |
company_ |
varchar2 |
itgen_crp_company_geolocation_city | filters on the platform, writable | City name. | |
company_ |
decimal |
itgen_crp_company_geolocation_coordinates_latitude | filters on the platform, writable | Latitude coordinate. | |
company_ |
decimal |
itgen_crp_company_geolocation_coordinates_longitude | filters on the platform, writable | Longitude coordinate. | |
company_ |
varchar2 |
itgen_crp_company_geolocation_country | filters on the platform, writable | Country code. | |
company_ |
varchar2 |
itgen_crp_company_geolocation_region | filters on the platform, writable | Region code. | |
company_ |
varchar2 |
itgen_crp_company_legal_name | filters on the platform, writable | Company legal name. | |
company_ |
decimal |
itgen_crp_company_metrics_arr | filters on the platform, writable | Annual recurring revenue. | |
company_ |
int32 |
itgen_crp_company_metrics_employees | filters on the platform, writable | Number of employees. | |
company_ |
decimal |
itgen_crp_company_metrics_market_cap | filters on the platform, writable | Market capitalization. | |
company_ |
decimal |
itgen_crp_company_metrics_raised | filters on the platform, writable | Money raised. | |
company_ |
varchar2 |
itgen_crp_company_name | filters on the platform, writable | Company name. | |
company_ |
int32 |
itgen_crp_company_timezone | filters on the platform, writable | Company time zone offset in minutes relative to UTC, negated (-120 stands for UTC+02:00). | |
company_ |
varchar2 |
itgen_crp_company_url | filters on the platform, writable | Company website URL. | |
created_ |
datetime |
itgen_crp_created_at | filters on the platform, writable | Profile creation timestamp. | |
email |
varchar2 |
itgen_crp_email | filters on the platform, writable | Email for people profile. | |
notepad |
varchar2 |
itgen_crp_notepad | filters on the platform, writable | Private notepad on people profile. | |
people_ |
varchar2 |
itgen_crp_people_id | filters on the platform, writable | People identifier. | |
person_ |
varchar2 |
itgen_crp_person_address | filters on the platform, writable | Address for user. | |
person_ |
varchar2 |
itgen_crp_person_avatar | filters on the platform, writable | Avatar for user. | |
person_ |
varchar2 |
itgen_crp_person_description | filters on the platform, writable | Description for user. | |
person_ |
varchar2 |
itgen_crp_person_employment_domain | filters on the platform, writable | Company domain name. | |
person_ |
varchar2 |
itgen_crp_person_employment_name | filters on the platform, writable | Company name. | |
person_ |
varchar2 |
itgen_crp_person_employment_role | filters on the platform, writable | User role in company. | |
person_ |
varchar2 |
itgen_crp_person_employment_seniority | filters on the platform, writable | User seniority in company. | |
person_ |
varchar2 |
itgen_crp_person_employment_title | filters on the platform, writable | User title in company. | |
person_ |
varchar2 |
itgen_crp_person_gender | filters on the platform, writable | Gender for user; one of male and female. | |
person_ |
varchar2 |
itgen_crp_person_geolocation_city | filters on the platform, writable | City name. | |
person_ |
decimal |
itgen_crp_person_geolocation_coordinates_latitude | filters on the platform, writable | Latitude coordinate. | |
person_ |
decimal |
itgen_crp_person_geolocation_coordinates_longitude | filters on the platform, writable | Longitude coordinate. | |
person_ |
varchar2 |
itgen_crp_person_geolocation_country | filters on the platform, writable | Country code. | |
person_ |
varchar2 |
itgen_crp_person_geolocation_region | filters on the platform, writable | Region code. | |
person_ |
varchar2 |
itgen_crp_person_nickname | filters on the platform, writable | Nickname for user (includes first name and last name). | |
person_ |
varchar2 |
itgen_crp_person_phone | filters on the platform, writable | Phone number for user. | |
person_ |
int32 |
itgen_crp_person_timezone | filters on the platform, writable | Time zone offset of user in minutes relative to UTC, negated (-120 stands for UTC+02:00). | |
person_ |
varchar2 |
itgen_crp_person_website | filters on the platform, writable | Website of user. | |
score |
int16 |
itgen_crp_score | filters on the platform, writable | Score associated to this profile, from 1 to 5 (based on ratings from user). | |
updated_ |
datetime |
itgen_crp_updated_at | filters on the platform, writable | Profile update timestamp. |
Esempi di Query
--
-- List the people profiles of the website.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/crisp-data-model/webhelp/crisp-connector-crisp-people-profiles.html
--
select *
from Crisp.Crisp.PeopleProfiles
limit 100
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: