xedm

Tables (14)

asyscontentelement

  • elementid — character(16) — NOT NULL
  • volumeid — character(16) — NOT NULL
  • filekey — character — NOT NULL
  • filesize — numeric(38,0) — NOT NULL
  • createdate — timestamp — NOT NULL
  • lastaccess — timestamp — NOT NULL
  • contenttype — numeric(38,0) — NOT NULL
  • contentclassid — character(16)
  • generaldata — character
  • checkhint — numeric(38,0)
  • writedate — timestamp
  • retention — numeric(38,0)
  • checksum — character

asyselement

  • elementid — character(16) — NOT NULL
  • descr — character — NOT NULL
  • usersclass — character(16) — NOT NULL
  • eclassid — character(16) — NOT NULL
  • expiration — timestamp
  • uuid — character
  • creator — character
  • created — timestamp
  • modifier — character
  • modified — timestamp
  • accessed — timestamp
  • transaction_id — numeric(38,0)
  • deleted — numeric(19,0)
  • status — numeric(19,0)
  • parentaclid — character(16)
  • path — character
  • folderpath — character
  • producer — character
  • parentid — character(16)
  • filesize — numeric(38,0)
  • encryptfilesize — numeric(38,0)
  • deadline — timestamp
  • ruleid — character(16)
  • commentsid — character(16)
  • ratingsid — character(16)
  • lockuserid — character
  • enable — numeric(38,0)
  • groupid — character
  • indexed — numeric(38,0)
  • version — character
  • templateid — numeric(18,0)
  • description — character
  • COLUMN — ADMIN_ID
  • COLUMN — PRIV_OWNER
  • COLUMN — PRIV_GROUP
  • COLUMN — PRIV_OTHER
  • COLUMN — PRIV_ADMIN

asyselementattr

  • elementid — character(16) — NOT NULL
  • attrname — character — NOT NULL
  • attrvalue — character
  • label — character
  • mandatory — character(1)
  • type — numeric(19,0)
  • editor — numeric(19,0)
  • position — numeric(19,0)
  • serializablevalue — bytea
  • doublevalue — numeric(38,3)

com_workflow_item

  • item_idx — numeric(5,0) — NOT NULL
  • item_nm — character
  • chg_id — character
  • chg_dt — timestamp
  • chk_type — character
  • chk_content — character

com_workflow_list

  • item_idx — numeric(5,0)
  • list_idx — numeric(5,0) — NOT NULL
  • workflow_cl — character
  • list_order — numeric(3,0)
  • policy_id — character
  • chg_id — character
  • chg_dt — timestamp

es_adminmenu

  • es_id — numeric(19,0) — NOT NULL
  • es_lastmodified — timestamp — NOT NULL
  • es_deleted — numeric(38,0) — NOT NULL
  • es_title — character
  • es_parentid — numeric(19,0) — NOT NULL
  • es_icon — character
  • es_description — character
  • es_url — character
  • es_order — numeric(38,0)

es_audit

  • es_type — numeric(38,0) — NOT NULL
  • es_targetid — character — NOT NULL
  • es_parentid — character
  • es_hasfile — numeric(38,0) — NOT NULL
  • es_hastable — numeric(38,0) — NOT NULL
  • es_events — character

es_bookmark

  • es_id — numeric(19,0) — NOT NULL
  • es_lastmodified — timestamp — NOT NULL
  • es_deleted — numeric(38,0) — NOT NULL
  • es_userid — character — NOT NULL
  • es_targetid — character — NOT NULL
  • es_type — numeric(10,0) — NOT NULL
  • es_title — character — NOT NULL
  • es_description — character
  • es_position — numeric(10,0) — NOT NULL

es_codes

  • es_id — numeric(19,0) — NOT NULL
  • es_lastmodified — timestamp — NOT NULL
  • es_deleted — numeric(38,0) — NOT NULL
  • es_code — character — NOT NULL
  • es_name — character — NOT NULL
  • es_value — character — NOT NULL
  • es_description — character

es_comments

  • commentid — numeric(19,0) — NOT NULL
  • elementid — character(16) — NOT NULL
  • es_comment — character — NOT NULL — haracter varying(4000) NOT NUL
  • creatorid — character
  • creator_nm — character
  • created — timestamp
  • deleted — numeric(38,0)
  • lastmodified — timestamp
  • version — character

es_dashboard

  • es_id — numeric(19,0) — NOT NULL
  • es_deleted — numeric(38,0) — NOT NULL
  • es_userid — character — NOT NULL
  • es_targetid — character — NOT NULL
  • es_dashname — character — NOT NULL

es_dashboardwidget

  • es_widgettype — character — NOT NULL
  • es_widgetname — character — NOT NULL
  • es_widgeticon — character — NOT NULL
  • es_widgettext — character — NOT NULL
  • es_widgetenabled — numeric(2,0) — NOT NULL
  • es_widgetpath — character
  • admin_widget — numeric(2,0) — NOT NULL

es_delegation

  • es_id — numeric(19,0)
  • es_lastmodified — timestamp
  • es_deleted — numeric(38,0)
  • es_mandatorid — character
  • es_delegatorid — character
  • es_comment — character — haracter varying(1000
  • es_expiredate — timestamp
  • es_allowed — character

es_docstat

  • es_creationdate — character(8) — NOT NULL
  • es_creationuserid — character — NOT NULL
  • es_doctypeid — numeric(19,0)
  • es_path — character — NOT NULL
  • es_count — numeric(19,0) — NOT NULL
  • es_size — numeric(19,0) — NOT NULL