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