| |
|
| |
Extended data types allows you to attach
additional significance to certain data types. For instance, you
can designate a string in your data model as one that represents
a telephone number by specifying that its extended data type is
a phone number. Doing so causes zeroCode to automatically generate
the necessary JavaScript, Java and SQL code for conversion and validation
of the data element.
To designate the extended data type of a data element, you would:
- Click on the leaf node associated
with the data element. You can then see the details of the node
on the right pane.
- Click on Extended datatype. zeroCode
supports extended datatypes for Integer, String, Date and Blob.
A complete summary of the supported extended
data types follows.
|
| |
|
Base type
|
Extended
types
|
Format
|
|
Integer
|
Integer
|
Plain
digit string
e.g.,
10502089
|
|
Decimal
|
Embedded
commas
e.g.,
10,502,089
|
|
Money
|
Embedded
commas, preceded by $ sign; negative values parenthesized;
e.g., $10,502,089
|
|
String
|
Plain
text
|
|
|
US
zip code
|
Either
five-digit or nine-digit, e.g., 91023 or 53706-0288
|
|
US
phone number
|
Optional
area code in parentheses, seven-digit phone number, optional
extension following an x
Examples:
(408) 555-1212
867-5309
(202) 663-2521x876
|
|
US
social security number
|
|
|
International
phone number
|
|
|
Date
|
Date
only
|
mm/dd/yyyy
|
|
Time
only
|
hh:mm:ss
|
|
Date
and time
|
mm/dd/yyyy
hh:mm:ss
|
|
Blob
|
Plain
text
Binary
HTML
Word
document
Image
|
|
|
 |
|
|
