Sõnakogude impordi faili "word.json" andmestruktuuride osaline kirjeldus failist "tables-desc.txt"

tables-desc-fragment.txt

================================================================================
word
-----------------------------------columns--------------------------------------
id, bigint, PK 
lang, character 3, (optional) 
morph_code, character varying 100, (optional) -> morph.code
homonym_nr, integer, (optional) 
word_class, character varying 100, (optional) 
display_morph_code, character varying 100, (optional) -> display_morph.code
gender_code, character varying 100, (optional) -> gender.code
aspect_code, character varying 100, (optional) -> aspect.code
----------------------------------referrers-------------------------------------
word_word_type
word_relation
word_guid
word_process_log
paradigm
lexeme
word_lifecycle_log
word_etymology_relation
word_etymology
word_group_member
================================================================================
word_guid
-----------------------------------columns--------------------------------------
id, bigint, PK 
word_id, bigint, (mandatory) -> word.id
guid, character varying 100, (mandatory) 
dataset_code, character varying 10, (mandatory) -> dataset.code
================================================================================
word_word_type
-----------------------------------columns--------------------------------------
id, bigint, PK 
word_id, bigint, (mandatory) -> word.id
word_type_code, character varying 100, (mandatory) -> word_type.code
order_by, bigint, (mandatory - default exists) 
================================================================================
word_etymology
-----------------------------------columns--------------------------------------
id, bigint, PK 
word_id, bigint, (mandatory) -> word.id
etymology_type_code, character varying 100, (optional) -> etymology_type.code
etymology_year, text, (optional) 
comment, text, (optional) 
comment_prese, text, (optional) 
is_questionable, boolean, (mandatory - default exists) 
order_by, bigint, (mandatory - default exists) 
----------------------------------referrers-------------------------------------
word_etymology_relation
word_etymology_source_link
================================================================================
word_etymology_relation
-----------------------------------columns--------------------------------------
id, bigint, PK 
word_etym_id, bigint, (mandatory) -> word_etymology.id
related_word_id, bigint, (mandatory) -> word.id
comment, text, (optional) 
comment_prese, text, (optional) 
is_questionable, boolean, (mandatory - default exists) 
is_compound, boolean, (mandatory - default exists) 
order_by, bigint, (mandatory - default exists) 
================================================================================
word_etymology_source_link
-----------------------------------columns--------------------------------------
id, bigint, PK 
word_etym_id, bigint, (mandatory) -> word_etymology.id
source_id, bigint, (mandatory) -> source.id
type, character varying 100, (mandatory) 
name, text, (optional) 
value, text, (optional) 
order_by, bigint, (mandatory - default exists) 
================================================================================
word_relation
-----------------------------------columns--------------------------------------
id, bigint, PK 
word1_id, bigint, (mandatory) -> word.id
word2_id, bigint, (mandatory) -> word.id
word_rel_type_code, character varying 100, (optional) -> word_rel_type.code
relation_status, character varying 100, (optional) 
order_by, bigint, (mandatory - default exists) 
----------------------------------referrers-------------------------------------
word_relation_param
================================================================================
word_group_member
-----------------------------------columns--------------------------------------
id, bigint, PK 
word_group_id, bigint, (mandatory) -> word_group.id
word_id, bigint, (mandatory) -> word.id
order_by, bigint, (mandatory - default exists) 
================================================================================
word_group
-----------------------------------columns--------------------------------------
id, bigint, PK 
word_rel_type_code, character varying 100, (mandatory) -> word_rel_type.code
----------------------------------referrers-------------------------------------
word_group_member
================================================================================
word_lifecycle_log
-----------------------------------columns--------------------------------------
id, bigint, PK 
word_id, bigint, (mandatory) -> word.id
lifecycle_log_id, bigint, (mandatory) -> lifecycle_log.id
================================================================================
word_process_log
-----------------------------------columns--------------------------------------
id, bigint, PK 
word_id, bigint, (mandatory) -> word.id
process_log_id, bigint, (mandatory) -> process_log.id
================================================================================