Navigation: Catalog: Knack > Schemas > Schema: Objects > Tables

TestExpanded: Knack Tests

Catalog: Knack

Schema: Objects

Primary Keys: record_id

Label: Tests

Can retrieve data and change data using insert, update and delete.

Table Columns

The columns of the table TestExpanded 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	Required	Documentation
AddressWithGeocoding_city	varchar2	☐
AddressWithGeocoding_latitude	decimal	☐
AddressWithGeocoding_longitude	decimal	☐
AddressWithGeocoding_state	varchar2	☐
AddressWithGeocoding_street	varchar2	☐
AddressWithGeocoding_street2	varchar2	☐
AddressWithGeocoding_zip	varchar2	☐
Auto_Increment	decimal	☐	{"type":"auto_increment","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f689643b3e682001590b4ca","name":"Auto Increment","key":"field_21","object_key":"object_4","relationship":null,"format":null,"default":null,"immutable":null}
Currency	decimal	☐	{"type":"currency","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f6896274395f40015a3df57","name":"Currency","key":"field_19","object_key":"object_4","relationship":null,"format":{"input":null,"conn_default":null,"default":null,"sorting":null,"type":null,"options":null,"format":"$","mark_decimal":null,"mark_thousands":null,"precision":null,"rounding":null,"show_commas":null,"pre":null,"post":null,"text_format":null,"label":null,"enable_geocoding":false,"equation_type":null},"default":"","immutable":null}
Date_Time	datetime	☐
Email_email	varchar2	☐
Email_label	varchar2	☐
Equation	decimal	☐
File_data	blob	☐
File_filename	varchar2	☐
File_s3	char	☐
File_size	int32	☐
File_thumb_url	varchar2	☐
File_type	varchar2	☐
File_url	varchar2	☐
Image_data	blob	☐
Image_filename	varchar2	☐
Image_s3	char	☐
Image_size	int32	☐
Image_thumb_url	varchar2	☐
Image_type	varchar2	☐
Image_url	varchar2	☐
IntlAddress_city	varchar2	☐
IntlAddress_state	varchar2	☐
IntlAddress_street	varchar2	☐
IntlAddress_street2	varchar2	☐
IntlAddress_zip	varchar2	☐
IntlAddressLatLng_latitude	decimal	☐
IntlAddressLatLng_longitude	decimal	☐
IntlAddressWithCountry_city	varchar2	☐
IntlAddressWithCountry_country	varchar2	☐
IntlAddressWithCountry_state	varchar2	☐
IntlAddressWithCountry_street	varchar2	☐
IntlAddressWithCountry_street2	varchar2	☐
IntlAddressWithCountry_zip	varchar2	☐
Link_label	varchar2	☐
Link_url	varchar2	☐
Multiple_Choice	varchar2	☐	{"type":"multiple_choice","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f689646b3e682001590b4de","name":"Multiple Choice","key":"field_22","object_key":"object_4","relationship":null,"format":{"input":null,"conn_default":null,"default":"kn-blank","sorting":"alphabetical","type":"single","options":["First Choice","Second Choice","Third Choice"],"format":null,"mark_decimal":null,"mark_thousands":null,"precision":null,"rounding":null,"show_commas":null,"pre":null,"post":null,"text_format":null,"label":null,"enable_geocoding":false,"equation_type":null},"default":null,"immutable":null}
Name_firstname	varchar2	☐
Name_lastname	varchar2	☐
Name_middlename	varchar2	☐
Name_title	varchar2	☐
Number	decimal	☐	{"type":"number","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f6896244395f40015a3df4e","name":"Number","key":"field_18","object_key":"object_4","relationship":null,"format":{"input":null,"conn_default":null,"default":null,"sorting":null,"type":null,"options":null,"format":"none","mark_decimal":"none","mark_thousands":"none","precision":"2","rounding":"none","show_commas":null,"pre":null,"post":null,"text_format":null,"label":null,"enable_geocoding":false,"equation_type":null},"default":"","immutable":null}
Paragraph_Text	varchar2	☐	{"type":"paragraph_text","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f689601b3e682001590b418","name":"Paragraph Text","key":"field_15","object_key":"object_4","relationship":null,"format":null,"default":"","immutable":null}
Phone	varchar2	☐
Rating	decimal	☐	{"type":"rating","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f6896823758ec001589d9cd","name":"Rating","key":"field_35","object_key":"object_4","relationship":null,"format":{"input":null,"conn_default":null,"default":null,"sorting":null,"type":null,"options":null,"format":null,"mark_decimal":null,"mark_thousands":null,"precision":null,"rounding":null,"show_commas":null,"pre":null,"post":null,"text_format":null,"label":null,"enable_geocoding":false,"equation_type":null},"default":null,"immutable":null}
Record_ID_1	varchar2	☐	{"type":"short_text","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"696a8b987297df53c6ed6de3","name":"Record ID","key":"field_97","object_key":null,"relationship":null,"format":null,"default":null,"immutable":true}
record_id	varchar2	☑
Rich_Text	varchar2	☐	{"type":"rich_text","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f689604b3e682001590b425","name":"Rich Text","key":"field_16","object_key":"object_4","relationship":null,"format":null,"default":"","immutable":null}
Signature_base30	varchar2	☐
Signature_svg	varchar2	☐
Test_Name	varchar2	☐	{"type":"short_text","required":true,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f6895f53838c00015ce7fc7","name":"Test Name","key":"field_14","object_key":null,"relationship":null,"format":null,"default":null,"immutable":null}
Text_Formula	varchar2	☐	{"type":"concatenation","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f68961f4395f40015a3df44","name":"Text Formula","key":"field_17","object_key":"object_4","relationship":null,"format":{"input":null,"conn_default":null,"default":null,"sorting":null,"type":null,"options":null,"format":null,"mark_decimal":null,"mark_thousands":null,"precision":null,"rounding":null,"show_commas":null,"pre":null,"post":null,"text_format":null,"label":null,"enable_geocoding":false,"equation_type":"numeric"},"default":null,"immutable":null}
Timer_from_min	datetime	☐
Timer_stop_count	int32	☐
Timer_to_max	datetime	☐
Timer_total_time	int64	☐
USAddress_city	varchar2	☐
USAddress_state	varchar2	☐
USAddress_street	varchar2	☐
USAddress_street2	varchar2	☐
USAddress_zip	varchar2	☐
Yes_No	char	☐	{"type":"boolean","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f6896494395f40015a3dfcf","name":"Yes/No","key":"field_23","object_key":"object_4","relationship":null,"format":{"input":"dropdown","conn_default":null,"default":"false","sorting":null,"type":null,"options":null,"format":"yes_no","mark_decimal":null,"mark_thousands":null,"precision":null,"rounding":null,"show_commas":null,"pre":null,"post":null,"text_format":null,"label":null,"enable_geocoding":false,"equation_type":null},"default":"false","immutable":null}

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

Please enable JavaScript to view this site.

Knack API Data Model

TestExpanded: Knack Tests

Table Columns

Important Safety and Usage Information