People
Create, update, delete, and query Highrise People. This table is dynamic.
テーブル固有の情報
Select
Datetime カラムでは、'>'、および'>=' の演算子だけがサポートされています。
SELECT * FROM People WHERE UpdatedAt > '2016-04-18'
Insert
Person を追加するには、First Name、Last Name、およびJob Title が必須です。
INSERT INTO People (FirstName, LastName, Title) VALUES ('FirstName', 'LastName', 'CEO')
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | Integer | False |
The Id column for the table People. | |
FirstName | String | False |
The FirstName column for the table People. | |
LastName | String | False |
The LastName column for the table People. | |
Title | String | False |
The Title column for the table People. | |
Background | String | False |
The Background column for the table People. | |
EmailAddressAggregate | String | False |
The EmailAddressAggregate column for the table People. | |
PhoneNumberAggregate | String | False |
The PhoneNumberAggregate column for the table People. | |
AddressAggregate | String | False |
The AddressAggregate column for the table People. | |
InstantMessengerAggregate | String | False |
The InstantMessengerAggregate column for the table People. | |
TwitterAccountAggregate | String | False |
The TwitterAccountAggregate column for the table People. | |
WebAddressAggregate | String | False |
The WebAddressAggregate column for the table People. | |
CompanyID | Integer | False |
The CompanyID column for the table People. | |
CompanyName | String | False |
The CompanyName column for the table People. | |
LinkedInURL | String | False |
The LinkedInURL column for the table People. | |
AvatarURL | String | False |
The AvatarURL column for the table People. | |
VisibleTo | String | False |
The VisibleTo column for the table People. | |
OwnerId | Integer | False |
The OwnerId column for the table People. | |
GroupId | String | False |
The GroupId column for the table People. | |
AuthorId | String | True |
The AuthorId column for the table People. | |
CreatedAt | Datetime | True |
The CreatedAt column for the table People. | |
UpdatedAt | Datetime | True |
The UpdatedAt column for the table People. | |
PartyCustomField1 | String | False |
A CustomField of type party. | |
PartyCustomField2 | String | False |
A CustomField of type party. |