Column Type Size Nulls Auto Default Children Parents Comments
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


name text 2147483647 null


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

Table contained 0 rows


Constraint Name Type Sort Column(s)
pk_applications Primary key Asc ID
s_applications Performance Asc/Asc name + identifier
u_applications_identifier Must be unique Asc identifier
u_applications_secret Must be unique Asc secret