weblets


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int4 10 √ null

Weblet ID
creator int4 10 √ null
users.ID fk_weblets_creator N

Creator user ID (defaults to authenticated user on creation)
creationdate int8 19 date_part('epoch'::text, now())

Creation date and time as a Unix time stamp (defaults to current date and time on creation)
lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)
application int4 10 √ null
applications.ID fk_weblets_application C

Application ID (null=STANDALONE)
binfile int4 10 √ null
activity int2 5 0

Activity (0=ACTIVE, 1=DEACTIVATED, 2=DELETED)
name text 2147483647 null

Name
identifier varchar 200 null

Unique weblet identifier (Pattern: ^[a-zA-Z\d][\w.-]*$)
view text 2147483647 ''::text

Canonical view
type int2 5 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 int2 5 0

Width in pixels (0=100%)
height int2 5 0

Height in pixels (0=100%)
url text 2147483647 ''::text
svgpath text 2147483647 ''::text

SVG path for icon (square)
color varchar 6 ''::character varying

Color code (CSS-style hexadecimal without #) (Pattern: ^([A-F\d]{3}){0,2}$)
mimetype text 2147483647 'text/x-zymba'::text

MIME type (RFC 2045)
langaliases json 2147483647 √ null

Language-specific aliases; use language code as object key

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_weblets Primary key Asc ID
fk_weblets_application Performance Asc application
s_weblets Performance Asc/Asc name + identifier
u_weblets_identifier Must be unique Asc identifier

Relationships

Close relationships within degrees of separation