Deals
Create, update, delete, and query Highrise Deals. This table is dynamic.
テーブル固有の情報
Select
Datetime カラムでは、WHERE 句にて'>'、および'>=' の演算子だけがサポートされています。次のクエリは、指定された日の後に更新されたDeal を取得します。
SELECT * FROM Deals WHERE UpdatedAt > '2012-01-12'
Insert
新しいDeal の作成には、Name、CategoryId、Background、Currency、Price、PriceType、Duration、およびPartyId が必須です。
INSERT INTO Deals (Name, CategoryId, Background, Currency, Price, PriceType, Duration, PartyId) VALUES ('deal with someone', 4195389, 'black', 'usd', 500, 'fixed', 123545, 149760370)
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | Integer | False |
The Id column for the table Deals. | |
Name | String | False |
The Name column for the table Deals. | |
AccountId | Integer | False |
The AccountId column for the table Deals. | |
AuthorId | Integer | False |
The AuthorId column for the table Deals. | |
Background | String | False |
The Background column for the table Deals. | |
CategoryId | Integer | False |
The CategoryId column for the table Deals. | |
Currency | String | False |
The Currency column for the table Deals. | |
Duration | Integer | False |
The Duration column for the table Deals. | |
VisibleTo | String | False |
The VisibleTo column for the table Deals. | |
GroupId | String | False |
The GroupId column for the table Deals. | |
OwnerId | Integer | False |
The OwnerId column for the table Deals. | |
PartyId | Integer | False |
The PartyId column for the table Deals. | |
Price | Long | False |
The Price column for the table Deals. | |
PriceType | String | False |
The PriceType column for the table Deals. | |
ResponsiblePartyId | Integer | False |
The ResponsiblePartyId column for the table Deals. | |
Status | String | False |
The Status column for the table Deals. | |
StatusChangedOn | String | True |
The StatusChangedOn column for the table Deals. | |
CreatedAt | Datetime | True |
The CreatedAt column for the table Deals. | |
UpdatedAt | Datetime | True |
The UpdatedAt column for the table Deals. | |
DealCustomField1 | String | False |
A Custom Field of type deal. | |
DealCustomField2 | String | False |
A Custom Field of type deal. |