applications


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID serial 10 nextval('"applications_ID_seq"'::regclass)
resources.application FK_resources_application C
services.application FK_services_application C
weblets.application FK_weblets_application C
creator int4 10 null
users.ID FK_applications_creator N

The object creator

creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

activity int2 5 0

0: Active, 1: Deactivated

name text 2147483647 null
identifier text 2147483647 null
numcounters.identifier Implied Constraint R
version int4 10 10000
vendor text 2147483647 ''::text
secret varchar 40 ''::character varying
restricted int2 5 0
defaultsettings json 2147483647 null
settings json 2147483647 null
settingsbinfile int4 10 null
usersettingsbinfile int4 10 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PK_applications_ID Primary key Asc ID
UNQ_applications_identifier Must be unique Asc identifier
UNQ_applications_secret Must be unique Asc secret

Relationships