ㅇㅇ

Tables (6)

alias

  • alias_id — INT — Primary key — NOT NULL
  • entity_id — INT — Foreign key → entity.entity_id — NOT NULL
  • alias_name — VARCHAR(200)
  • alias_type — VARCHAR(50)

article

  • article_id — INT — Primary key — NOT NULL
  • news_id — VARCHAR(100)
  • title — VARCHAR(500)
  • content — TEXT
  • published_at — DATETIME
  • provider — VARCHAR(100)
  • byline — VARCHAR(100)
  • url — VARCHAR(1000)

article_chunk

  • chunk_id — INT — Primary key — NOT NULL
  • article_id — INT — Foreign key → article.article_id — NOT NULL
  • chunk_order — INT
  • chunk_text — TEXT

entity

  • entity_id — INT — Primary key — NOT NULL
  • canonical_name — VARCHAR(200)
  • entity_type — VARCHAR(50)

extraction_result

  • extraction_id — INT — Primary key — NOT NULL
  • article_id — INT — Foreign key → article.article_id — NOT NULL
  • chunk_id — INT — Foreign key → article_chunk.chunk_id — NOT NULL
  • entity_id — INT — Foreign key → entity.entity_id — NOT NULL
  • extracted_name — VARCHAR(200)
  • extracted_type — VARCHAR(50)

relation_extraction

  • relation_id — INT — Primary key — NOT NULL
  • article_id — INT — Foreign key → article.article_id — NOT NULL
  • chunk_id — INT — Foreign key → article_chunk.chunk_id — NOT NULL
  • source_entity_id — INT — Foreign key → entity.entity_id — NOT NULL
  • target_entity_id — INT — Foreign key → entity.entity_id — NOT NULL
  • relation_type — VARCHAR(100)