test

Tables (13)

ATTRIBUTE_DOMAIN_TABLE

  • AD_ID — NUMBER(19,0) — Primary key — NOT NULL
  • ATTRIBUTE_ID — NUMBER(19,0) — Foreign key → ATTRIBUTE_TABLE.ATTRIBUTE_ID — NOT NULL
  • DOMAIN_ID — NUMBER(19,0) — Foreign key → DOMAIN_TABLE.DOMAIN_ID — NOT NULL

ATTRIBUTE_TABLE

  • ATTRIBUTE_ID — NUMBER(19,0) — Primary key — NOT NULL
  • ATTRIBUTE_NAME — NVARCHAR(200) — NOT NULL
  • CONDITION — VARCHAR(255)

CONDITION_GAZETTEER_TABLE

  • CONDITION_GAZETTEER_ID — NUMBER(19,0) — Primary key — NOT NULL
  • OBJECT_SYNONYM — VARCHAR(255)
  • ORIGINAL_OBJECT — VARCHAR(255)
  • ATTRIBUTE_ID — NUMBER(19,0) — Foreign key → ATTRIBUTE_TABLE.ATTRIBUTE_ID — NOT NULL

DESCRIPTION_IMAGE_TABLE

  • DI_ID — VARCHAR(255) — Primary key — NOT NULL
  • DESCRIPTION_ID — NUMBER(19,0) — Foreign key → DESCRIPTION_TABLE.DESCRIPTION_ID — NOT NULL
  • IMAGE_ID — NUMBER(19,0) — Foreign key → IMAGE_TABLE.IMAGE_ID — NOT NULL

DESCRIPTION_TABLE

  • DESCRIPTION_ID — NUMBER(19,0) — Primary key — NOT NULL
  • DOMAIN_NAME — VARCHAR(255)
  • OBJECT — CLOB
  • SOURCE — VARCHAR(255)

DOMAIN_TABLE

  • DOMAIN_ID — NUMBER(19,0) — Primary key — NOT NULL
  • DOMAIN_NAME — NVARCHAR(200) — NOT NULL

ENTITY_ATTRIBUTE_OBJECT_TABLE

  • EAO_ID — VARCHAR(255) — Primary key — NOT NULL
  • ATTRIBUTE_ID — NUMBER(19,0) — Foreign key → ATTRIBUTE_TABLE.ATTRIBUTE_ID — NOT NULL
  • ENTITY_ID — NUMBER(19,0) — Foreign key → ENTITY_TABLE.ENTITY_ID — NOT NULL
  • OBJECT_ID — NVARCHAR(2000) — Foreign key → OBJECT_TABLE.OBJECT_ID — NOT NULL

ENTITY_DOMAIN_TABLE

  • ED_ID — NUMBER(19,0) — Primary key — NOT NULL
  • DOMAIN_ID — NUMBER(19,0) — Foreign key → DOMAIN_TABLE.DOMAIN_ID — NOT NULL
  • ENTITY_ID — NUMBER(19,0) — Foreign key → ENTITY_TABLE.ENTITY_ID — NOT NULL

ENTITY_TABLE

  • ENTITY_ID — NUMBER(19,0) — Primary key — NOT NULL
  • ENTITY_DESCRIPTION — CLOB
  • ENTITY_NAME — NVARCHAR(400) — NOT NULL
  • ORIGINAL_NAME — VARCHAR(255) — NOT NULL

GAZETTEER_TABLE

  • GAZETTEER_ID — NUMBER(19,0) — Primary key — NOT NULL
  • ENTITY_SYNONYM — VARCHAR(255)
  • ENTITY_ID — NUMBER(19,0) — Foreign key → ENTITY_TABLE.ENTITY_ID — NOT NULL

IMAGE_TABLE

  • IMAGE_ID — NUMBER(19,0) — Primary key — NOT NULL
  • IMAGE_DATA — BLOB

KNOWLEDGE_METADATA_TABLE

  • KM_ID — VARCHAR(255) — Primary key — NOT NULL
  • SOURCE — NVARCHAR(200)
  • DESCRIPTION_ID — NUMBER(19,0) — Foreign key → DESCRIPTION_TABLE.DESCRIPTION_ID — NOT NULL

OBJECT_TABLE

  • OBJECT_ID — NVARCHAR(2000) — Primary key — NOT NULL
  • OBJECT_VALUE — CLOB