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