ㅇㅇ
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)