| ID |
int4 |
10 |
|
√ |
null |
|
resources.application
|
fk_resources_application C
|
|
services.application
|
fk_services_application C
|
|
weblets.application
|
fk_weblets_application C
|
|
|
Application ID |
| creator |
int4 |
10 |
√ |
|
null |
|
|
users.ID
|
fk_applications_creator N
|
|
Creator user ID (defaults to authenticated user on creation) |
| creationdate |
int8 |
19 |
|
|
date_part('epoch'::text, now()) |
|
|
Creation date and time as a Unix time stamp (defaults to current date and time on creation) |
| lastmodified |
int8 |
19 |
|
|
date_part('epoch'::text, now()) |
|
|
Last modification date and time as a Unix time stamp (auto-reset on modification) |
| settingsbinfile |
int4 |
10 |
√ |
|
null |
|
|
|
| usersettingsbinfile |
int4 |
10 |
√ |
|
null |
|
|
|
| activity |
int2 |
5 |
|
|
0 |
|
|
Activity (0=ACTIVE, 1=DEACTIVATED, 2=DELETED) |
| name |
text |
2147483647 |
|
|
null |
|
|
Name |
| identifier |
varchar |
200 |
|
|
null |
|
|
Unique application identifier (Pattern: ^[a-zA-Z\d][\w.-]*$) |
| version |
int4 |
10 |
|
|
10000 |
|
|
Version number (formatted as 1.00-00) |
| vendor |
text |
2147483647 |
|
|
''::text |
|
|
Vendor (developer or company name) |
| secret |
varchar |
40 |
|
|
''::character varying |
|
|
|
| restricted |
int2 |
5 |
|
|
0 |
|
|
|
| defaultsettings |
json |
2147483647 |
√ |
|
null |
|
|
|
| settings |
json |
2147483647 |
√ |
|
null |
|
|
|
