| id |
integer |
Yes |
Yes |
nextval('udf_fields_id_seq'::regclass) |
|
| page_id |
integer |
Yes |
No |
|
ID from udf_pages.id |
| link_table |
character varying(32) |
Yes |
No |
|
Table UDF is used for |
| sequence |
integer |
Yes |
No |
|
Sequence number starting from 0 |
| field_name |
character varying(32) |
No |
No |
''::character varying |
Name of field |
| widget_type |
character varying(32) |
No |
No |
'BCTextBox'::character varying |
Type of field |
| field_label |
character varying(60) |
No |
No |
''::character varying |
Field label |
| align |
smallint |
No |
No |
0 |
Alignment |
| field_type |
smallint |
No |
No |
0 |
|
| decimals |
smallint |
No |
No |
2 |
Number of decimals |
| thousands_sep |
boolean |
No |
No |
false |
Use thousands separator |
| negative_format |
smallint |
No |
No |
0 |
|
| text_mask |
character varying(64) |
No |
No |
''::character varying |
Masking for text |
| date_format |
smallint |
No |
No |
0 |
Date format |
| mask_text_case |
smallint |
No |
No |
0 |
|
| validate_period |
boolean |
No |
No |
false |
Should period be validated |
| validate_period_mode |
smallint |
No |
No |
0 |
|
| postdate_warning |
boolean |
No |
No |
false |
Warn if post dated |
| backdate_warning |
boolean |
No |
No |
false |
Warn if back dated |
| require_numeric |
boolean |
No |
No |
false |
|
| min_numeric |
bigint |
No |
No |
0 |
Minimum number |
| max_numeric |
bigint |
No |
No |
0 |
Maximum number |
| list_items |
character varying(40)[] |
No |
No |
'{}'::character varying[] |
|
| allow_null_date |
boolean |
No |
No |
false |
Allow empty date |
| default_null_date |
boolean |
No |
No |
false |
Default to empty date |