Table mkt.article.document_about_subject
A cikkben milyen témákról, kulcsszavakról van szó.

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
documentid int4 10  √  null
document.id articles_about_subjects_art_fkey R
A cikk azonosítója.
subjectid int4 10  √  null
subject.id articles_about_subjects_sub_fkey R
A téma, kulcsszó azonosítója.
topicplaceindocumentid int4 10  √  null
topicplaceindocument.id document_about_subject_topic_fkey R
Az említés típusa.

Table contained 2,135 rows at Sun Nov 02 21:30 CET 2014

Indexes:
Column(s) Type Sort Constraint Name
documentid Performance Asc fki_articles_about_subjects_art_fkey
subjectid Performance Asc fki_articles_about_subjects_sub_fkey
topicplaceindocumentid Performance Asc fki_document_about_subject_topic_fkey

Close relationships  within of separation: