TEST

Tables (6)

domains

  • domain_id — SERIAL
  • name — TEXT — NOT NULL
  • description — TEXT

relation_types

  • relation_type_id — SERIAL
  • predicate — TEXT — NOT NULL
  • is_directional — BOOLEAN — NOT NULL
  • inverse_relation_type_id — INT — Foreign key → relation_types.relation_type_id

relations

  • relation_id — BIGSERIAL
  • source_term_id — TEXT — Foreign key → terms.term_id — NOT NULL
  • relation_type_id — INT — Foreign key → relation_types.relation_type_id — NOT NULL
  • target_term_id — TEXT — Foreign key → terms.term_id — NOT NULL
  • source_id — BIGINT — Foreign key → sources.source_id
  • confidence — TEXT — NOT NULL
  • evidence — TEXT
  • status — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • CHECK — (source_term_id <> target_term_id)

sources

  • source_id — BIGSERIAL
  • source_type — TEXT — NOT NULL
  • source_ref — TEXT — NOT NULL
  • title — TEXT
  • url — TEXT
  • version — TEXT

term_aliases

  • alias_id — BIGSERIAL
  • term_id — TEXT — Foreign key → terms.term_id — NOT NULL
  • alias_text — TEXT — NOT NULL
  • alias_type — TEXT — NOT NULL
  • is_preferred — BOOLEAN — NOT NULL

terms

  • term_id — TEXT
  • standard_term — TEXT — NOT NULL
  • korean_name — TEXT
  • english_full_name — TEXT
  • domain_id — INT — Foreign key → domains.domain_id
  • description — TEXT
  • external_url — TEXT
  • status — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL