# 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} |