submission_keyword_map

4959 rows


Description

simple correlation table, maps keywords from either eclKeywords or iedakeywords table to submissions; compound key (submission_id, keyword_id)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
submission_id int4 10 null

foreign key to submissions table
keyword_id text 2147483647 null
eclkeyword.keyword_id Implied ConstraintR

foreign key to keyword_id in either eclkeyword or iedakeywords

Relationships

Close relationships within degrees of separation