lol
Tables (6)
alias
- alias_id — INT — Primary key — NOT NULL
- entity_id — INT — Foreign key → entity.entity_id
- alias_name — VARCHAR(255)
- alias_type — VARCHAR(255)
article
- article_id — INT — Primary key — NOT NULL
- news_id — VARCHAR(255)
- title — VARCHAR(255)
- content — TEXT
- published_at — DATETIME
- provider — VARCHAR(255)
- byline — VARCHAR(255)
- url — VARCHAR(255)
article_chunk
- chunk_id — INT — Primary key — NOT NULL
- article_id — INT — Foreign key → article.article_id
- chunk_order — INT
- chunk_text — TEXT
entity
- entity_id — INT — Primary key — NOT NULL
- canonical_name — VARCHAR(255)
- entity_type — VARCHAR(255)
extraction_result
- extraction_id — INT — Primary key — NOT NULL
- article_id — INT — Foreign key → article.article_id
- chunk_id — INT — Foreign key → article_chunk.chunk_id
- entity_id — INT — Foreign key → entity.entity_id
- extracted_name — VARCHAR(255)
- extracted_type — VARCHAR(255)
relation_extraction
- relation_id — INT — Primary key — NOT NULL
- article_id — INT — Foreign key → article.article_id
- chunk_id — INT — Foreign key → article_chunk.chunk_id
- source_entity_id — INT — Foreign key → entity.entity_id
- target_entity_id — INT — Foreign key → entity.entity_id
- relation_type — VARCHAR(255)