Field Name | Enter a field name. Examples: Name, Telephone, etc. |
Width | Enter the length of the field. Note: Width must be 1 for fields other than String.
|
Dimension | Caravan has a unique feature that allows the user to create multi dimensional fields. Each field in Caravan can act as an array. Enter 1 if the field has only one value. Enter a number greater than 1 to specify the number of values the field can store. Example: a person can have eight telephone numbers. The dimension specified for the field telephone will be 8.An array of field names can also be created. Arrays allow you to refer to a series of field names by the same name and use a number (an index) to tell them apart. Refer to Multi-Dimensional Array, which follows, for details.
|
Field Type | Enter the data type of the field. Four datatypes are permissible.STRING – This is a string data type. The contents of this field are alphanumeric and can contain all the characters upto ASCII 127. Example: Smith
|
| NUMERIC – This is a numeric data type. Only long integers can be entered. |
| TIME– This is a date-time data type. The contents of this field can be accessed in the same manner as shown in Special Variables – time.
RELATIONAL– This is a relational field. Relation can be set between various tables in the same database. Refer to Relational Database for details.
FILE– This is a file data type. The contents of this field can be text, images, binary files, etc. The contents of the field can be accessed in the same manner as shown in File object.
|
Flags | Select from the following checkboxes. |
| M – Mandatory – This field cannot be empty.
U – Unique – The contents of this field should be unique.
|
| L – Local – The contents of this field should be local.
K – Key field – There can be only one key field in a table.
|
Default Value | When a new record is inserted in the table, the default value specified here is displayed.
|