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