services

Module: dev

Background services and scheduled jobs.

Name	Type	Nullable	Default Value	Notes
PKID	integer			Service ID
creator	integer			Creator user ID (defaults to authenticated user on creation)
creationdate	bigint		date_part('epoch', now())	Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodified	bigint		date_part('epoch', now())	Last modification date and time as a Unix timestamp (auto-reset on modification)
application applications.ID	integer			Application ID (`null`=STANDALONE)
activity	smallint		0	Activity (`0`=ACTIVE, `1`=DEACTIVATED, `2`=DELETED)
name	text			Name
identifier	character varying(200)			Unique service identifier
type	smallint			Service type (`0`=TIMING, `1`=REMOTECALL, `2`=AFTER_CREATION, `3`=BEFORE_MODIFICATION, `4`=AFTER_MODIFICATION, `5`=AFTER_CREATION_MODIFICATION, `6`=BEFORE_DELETION, `7`=AFTER_DELETION)
entity	text		''	Canonical entity; only for AFTER_CREATION, BEFORE_MODIFICATION, AFTER_MODIFICATION, AFTER_CREATION_MODIFICATION, BEFORE_DELETION or AFTER_DELETION
schedule	integer		0	Schedule as a minute of each day; only for TIMING
interval	smallint		1	Interval in minutes; only for TIMING
mimetype	text		'text/x-zymba'	MIME type (RFC 2045)
binfile binfiles.ID	integer
url	text		''
accesskey	bytea

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_services_application					gin	application
fk_services_binfile					btree	binfile
pk_services					btree	ID
s_services_identifier					gin	identifier
s_services_name					gin	name
u_services_identifier					btree	identifier

Name	Type
c_services_type	check
dc_services_activity	check
dc_services_entity	check
dc_services_identifier	check
dc_services_interval	check
dc_services_mimetype	check
dc_services_name	check
dc_services_schedule	check
dc_services_type	check
dc_services_url	check
fk_services_application	foreign_key
fk_services_binfile	foreign_key
pk_services	primary_key
u_services_identifier	unique

Loading...