applications

Module: dev

ZeyOS applications with settings, versioning, and OAuth configuration.

Name	Type	Nullable	Default Value	Notes
PKID	integer			Application 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)
activity	smallint		0	Activity (`0`=ACTIVE, `1`=DEACTIVATED, `2`=DELETED)
readmebinfile binfiles.ID	integer			Binary file ID; is read-only (not for `PUT` or `PATCH`)
name	text			Name
identifier	character varying(200)			Unique application identifier
vendor	text		''	Vendor (developer or company name)
restricted	smallint		0	Restricted access via permission with same identifier
callbackurls	text[]			Array-encoded allowed callback URLs for APIs
settingscodebinfile binfiles.ID	integer
usersettingscodebinfile binfiles.ID	integer
secret	bytea
defaultsettings	json
settings	json

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_applications_settingscodebinfile					btree	settingscodebinfile
fk_applications_usersettingscodebinfile					btree	usersettingscodebinfile
pk_applications					btree	ID
s_applications_identifier					gin	identifier
s_applications_name					gin	name
u_applications_identifier					btree	identifier
u_applications_secret					btree	secret

Name	Type
dc_applications_activity	check
dc_applications_defaultsettings	check
dc_applications_identifier	check
dc_applications_name	check
dc_applications_secret	check
dc_applications_settings	check
dc_applications_vendor	check
fk_applications_readmebinfile	foreign_key
fk_applications_settingscodebinfile	foreign_key
fk_applications_usersettingscodebinfile	foreign_key
pk_applications	primary_key
u_applications_identifier	unique

Loading...