services

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