OntologyEditor

Tables (13)

category (카테고리)

  • id — INT — Primary key
  • domain_id — INT — Foreign key → domain.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • desc — TEXT
  • dataset_id — INT — Foreign key → datasets.id — NOT NULL

class_hierarchy (클래스계층구조)

  • super_id — INT — Foreign key → classes.id — NOT NULL
  • sub_id — INT — Foreign key → classes.id — NOT NULL

classes (클래스)

  • id — INT — Primary key
  • category_id — INT — Foreign key → category.id — NOT NULL
  • uri — VARCHAR(255) — NOT NULL
  • label — VARCHAR(100)
  • comment — TEXT — EX
  • type — ENUM('WHITE', 'BLACK')

constraints (적용제약)

  • id — INT — Primary key
  • ontology_id — INT — Foreign key → ontologies.id — NOT NULL
  • category_id — INT — Foreign key → category.id — NOT NULL
  • class_id — INT — Foreign key → classes.id — NOT NULL

data

  • id — INT — Primary key — NOT NULL
  • dataset_id — INT — Foreign key → datasets.id — NOT NULL
  • source — VARCHAR(100)
  • type — VARCHAR(100)

datasets

  • id — INT — Primary key — NOT NULL
  • type — ENUM('CATEGORY', 'ONTOLOGY', 'INDIVIDUAL')

datatype_properties (속성)

  • id — INT — Primary key
  • uri — VARCHAR(255) — NOT NULL
  • label — VARCHAR(100)
  • domain_id — INT — Foreign key → constraints.id
  • range_type — VARCHAR(50)

domain (도메인)

  • id — INT — Primary key
  • name — VARCHAR(100) — NOT NULL
  • desc — TEXT

individual_types (인스턴스 타입)

  • individuals_id — INT — Foreign key → named_individuals.id — NOT NULL
  • constraint_id — INT — Foreign key → constraints.id — NOT NULL

named_individuals (인스턴스)

  • id — INT — Primary key
  • uri — VARCHAR(255) — NOT NULL
  • label — VARCHAR(100)
  • comment — TEXT — EX

object_properties (관계)

  • id — INT — Primary key
  • uri — VARCHAR(255) — NOT NULL
  • label — VARCHAR(100)
  • comment — TEXT — EX
  • domain_id — INT — Foreign key → constraints.id
  • range_id — INT — Foreign key → constraints.id

ontologies (온톨로지)

  • id — INT — Primary key
  • uri — VARCHAR(255) — NOT NULL
  • label — VARCHAR(100)
  • comment — TEXT — EX
  • dataset_id — INT — Foreign key → datasets.id — NOT NULL

property_hierarchy (속성 계층구조)

  • super_prop_id — INT — Foreign key → object_properties.id — NOT NULL
  • sub_prop_id — INT — Foreign key → object_properties.id — NOT NULL
  • prop_type — ENUM('OBJECT', 'DATATYPE') — NOT NULL