HyperCAS ERD

"His gaze pierces cloud, shadow, earth and flesh..."

Tables (5)

Untitled (ci_history)

  • Key (ci_history_id) — RAW(16) — Primary key — NOT NULL
  • Field (time) — TIMESTAMP — NOT NULL
  • Field (ci_id) — CHAR(36) — NOT NULL
  • Field (ci_type) — VARCHAR(255) — NOT NULL
  • Field3 (before_xml) — XMLTYPE
  • Field4 (after_xml) — XMLTYPE

Untitled (relation)

  • Key (relation_id) — CHAR(36) — Primary key — NOT NULL
  • Field (from_ci_id) — CHAR(36) — NOT NULL
  • Field2 (to_ci_id) — CHAR(36) — NOT NULL

Untitled (relation_history)

  • Key (relation_history_id) — RAW(16) — Primary key — NOT NULL
  • Field (time) — TIMESTAMP — NOT NULL
  • Field (relation_id) — CHAR(36) — NOT NULL
  • Field (from_ci_id) — CHAR(36) — NOT NULL
  • Field2 (to_ci_id) — CHAR(36) — NOT NULL
  • Field (change_type) — VARCHAR(255) — NOT NULL

Untitled (ci_userland_index)

  • Key (ci_userland_index_id) — CHAR(36) — Primary key — NOT NULL
  • Key (ci_id) — CHAR(36) — Foreign key → Untitled.Key — NOT NULL
  • Field (ci_type) — VARCHAR(255) — NOT NULL
  • Field (xpath) — VARCHAR(4096) — NOT NULL
  • Field2 (key) — VARCHAR(255) — NOT NULL
  • Field3 (value) — VARCHAR(255)

Untitled (ci_instance)

  • Key (ci_id) — CHAR(36) — Primary key — NOT NULL
  • Field (ci_type) — VARCHAR(255) — NOT NULL
  • Field2 (xml) — XMLTYPE — NOT NULL