weblets


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID serial 10 nextval('"weblets_ID_seq"'::regclass)
creator int4 10 null
users.ID FK_weblets_creator N

The object creator

creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

application int4 10 null
applications.ID FK_weblets_application C
activity int2 5 0

0: Active, 1: Deactivated

name text 2147483647 null
identifier text 2147483647 null
numcounters.identifier Implied Constraint R
view text 2147483647 ''::text
type int2 5 null

0: Embedded, 1: Attached, 2: Standalone, 3: Detached, 4: Pop up framed, 5: Pop up unframed

width int2 5 0
height int2 5 0
url text 2147483647 ''::text
svgpath text 2147483647 ''::text
color varchar 6 ''::character varying
mimetype text 2147483647 'text/x-zymba'::text
binfile int4 10 null
langaliases json 2147483647 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PK_weblets_ID Primary key Asc ID
UNQ_weblets_identifier Must be unique Asc identifier

Relationships