testpho: Knack testphos |
Catalog: Knack
Schema: Objects
Primary Keys: record_id
Label: testphos
Can retrieve data and change data using insert, update and delete.
Table Columns
The columns of the table testpho are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
datefield |
datetime |
|
☐ |
|
Record_ID_1 |
varchar2 |
|
☐ |
{"type":"short_text","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"696a8b987297df53c6ed6df3","name":"Record ID","key":"field_105","object_key":null,"relationship":null,"format":null,"default":null,"immutable":true} |
record_id |
varchar2 |
|
☑ |
|
Revenue_FY0_Criteria_#1 |
varchar2 |
|
☐ |
{"type":"short_text","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"6418457016ee4400280d2a0c","name":"Revenue FY0 Criteria #1","key":"field_93","object_key":null,"relationship":null,"format":null,"default":null,"immutable":null} |
text |
varchar2 |
|
☐ |
{"type":"short_text","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5fc8c1038c3dfe001deaceca","name":"text","key":"field_91","object_key":"object_12","relationship":null,"format":null,"default":"","immutable":null} |
Knack API Data Model