Data Type: save the data type from the MS Excel to the database, or get the intended data type from the database.
New Data Type
Type name: the type names that users can commonly read, such as date, year or month etc.
Base type: number, string and date
Different "Base type" causes distinguished choices.
(1) Number (N)
Integer length: the length of an integer, such as 5.
Decimal length: the length of the decimal number.
(2) String (S)
Max length: the string maximum length, such as 20.
Infinity length: used for the items that are not count by words easily, such as 'Remarks' or "memo".
(3) Date (D)
Default value: it is required to give useful items the default value, such as: the type number' default value is '0'; string is 'null', and date is the current date.
The name of the current field usually contains the following strings:
As defining a 'number', its inputting value is amount, then when the 'single field' and 'multiple field' are defining, the item name corresponded fields will assign the numerical type automatically.
Description: describing the data type.
See also: Create Data Table and Define Field