Skip to main content

weblets

NameTypeStorageNullableForeign KeysDefault Value & Notes
PKIDintegerplainWeblet ID
creatorintegerplainusers.IDCreator user ID (defaults to authenticated user on creation)
creationdatebigintplainDefault: date_part('epoch', now())Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodifiedbigintplainDefault: date_part('epoch', now())Last modification date and time as a Unix timestamp (auto-reset on modification)
applicationintegerplainapplications.IDApplication ID (`null`=STANDALONE)
activitysmallintplainDefault: 0Activity (`0`=ACTIVE, `1`=DEACTIVATED, `2`=DELETED)
nametextmainName
identifiercharacter varying(200)mainUnique weblet identifier
viewtextmainDefault: ''Canonical view
typesmallintplainDefault: 0Weblet type (`0`=INTEGRATED, `1`=STANDALONE, `2`=DETACHED, `3`=POPUP_FRAMED, `4`=POPUP_PLAIN, `5`=EMBEDDED_FRAMED, `6`=EMBEDDED_COLLAPSED, `7`=EMBEDDED_PLAIN)
widthsmallintplainDefault: 0Width in pixels (`0`=100%)
heightsmallintplainDefault: 0Height in pixels (`0`=100%)
svgpathtextextendedDefault: ''SVG path for icon (square)
colorcharacter varying(6)extendedDefault: ''Color code (CSS-style hexadecimal without `#`)
mimetypetextmainDefault: 'text/x-zymba'MIME type (RFC 2045)
langaliasesjsonextendedJSON-encoded language-specific aliases (object); use language code as object key
binfileintegerplainbinfiles.IDNo description provided.
urltextmainDefault: ''No description provided.
NameUniqueNulls DistinctPrimaryPartialMethodKeys
fk_weblets_applicationginapplication
fk_weblets_binfilebtreebinfile
pk_webletsbtreeID
s_weblets_identifierginidentifier
s_weblets_nameginname
u_weblets_identifierbtreeidentifier
NameType
dc_weblets_activitycheck
dc_weblets_colorcheck
dc_weblets_heightcheck
dc_weblets_identifiercheck
dc_weblets_langaliasescheck
dc_weblets_mimetypecheck
dc_weblets_namecheck
dc_weblets_typecheck
dc_weblets_urlcheck
dc_weblets_viewcheck
dc_weblets_widthcheck
fk_weblets_applicationforeign_key
fk_weblets_binfileforeign_key
fk_weblets_creatorforeign_key
pk_webletsprimary_key
u_weblets_identifierunique
Loading...