...
| Variable Type | Format | Descriptions | Sample |
|---|---|---|---|
Date(YYYY-mm-dd) | [Year, 4 Digits]-[Month, 2 digits]-[Day, 2 digits] STRING | Separator by "-" character with year, month and day Year needed to be 4 digits, month in 2 and day in 2 If month and day less than 10, "0" needed to be add in front | 2020-03-17 |
VarChar(X) | STRING, alphanumeric, general text with UTF-8 characters With maximum X numbers characters. | Beware of special characters like ' single quote (apostrophe) " double quote \ Black slash | abc1 22h-as_sdasd1 |
Num(X) | NUMBERS only, only digits are allow, 0 until 9. With maximum X numbers of digits | Only digits are allow, but minus sign are acceptable. | 12353 |
Double(X.Y) | FLOAT numbers with precision, in this case X can be any number. Y represent number of precision support | Floating or double number use for amount, separator between X and Y | 81921.00 |
Text | Text in UTF-8 Format, no text limit, however in Linux server back-end, we d have a 50,000 characters limit per POST variable | And full text | JHVSADUsa hduasdgauyxg |
Enum(y/n) | Fixed choice of "enum" either either of the option within the bracket | Choice of either character "y" or "n" in this sample, can be (0,1) or (yes,no) or others fixed options | y |
| Anchor | ||||
|---|---|---|---|---|
|
...