weblets

Module: dev

UI weblets for embedding custom views in ZeyOS.

Name	Type	Nullable	Default Value	Notes
PKID	integer			Weblet 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 weblet identifier
view	text		''	Canonical view
type	smallint		0	Weblet type (`0`=INTEGRATED, `1`=STANDALONE, `2`=DETACHED, `3`=POPUP_FRAMED, `4`=POPUP_PLAIN, `5`=EMBEDDED_FRAMED, `6`=EMBEDDED_COLLAPSED, `7`=EMBEDDED_PLAIN)
width	smallint		0	Width in pixels (`0`=100%)
height	smallint		0	Height in pixels (`0`=100%)
svgpath	text		''	SVG path for icon (square)
color	character varying(6)		''	Color code (CSS-style hexadecimal without `#`)
mimetype	text		'text/x-zymba'	MIME type (RFC 2045)
langaliases	json			JSON-encoded language-specific aliases (object); use language code as object key
binfile binfiles.ID	integer
url	text		''

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_weblets_application					gin	application
fk_weblets_binfile					btree	binfile
pk_weblets					btree	ID
s_weblets_identifier					gin	identifier
s_weblets_name					gin	name
u_weblets_identifier					btree	identifier

Name	Type
dc_weblets_activity	check
dc_weblets_color	check
dc_weblets_height	check
dc_weblets_identifier	check
dc_weblets_langaliases	check
dc_weblets_mimetype	check
dc_weblets_name	check
dc_weblets_type	check
dc_weblets_url	check
dc_weblets_view	check
dc_weblets_width	check
fk_weblets_application	foreign_key
fk_weblets_binfile	foreign_key
pk_weblets	primary_key
u_weblets_identifier	unique

Loading...