Table mkt.concept.subject
A kulcsszavak felsorolása (ebbe kell bedolgozni a keyword tábla rekordjait).

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
id serial 10  √  nextval('concept.subject_id_seq'::regclass)
document_about_subject.subjectid articles_about_subjects_sub_fkey R
document_about_subject.subjectid document_about_subject_subj_fkey R
document_about_subject.subjectid film_about_subject_subj_fkey R
document_about_subject.subjectid document_about_subject_subj_fkey R
document_about_subject.subjectid periodics_about_subject_sub_fkey R
document_about_subject.subjectid radio_about_subject_subj_fkey R
document_about_subject.subjectid document_about_subject_subj_fkey R
event_subject.subjectid event_subject_subject_fkey R
name_hun varchar 80  √  null
name_eng varchar 80  √  null
KIEMELES bool 1  √  false
ORIG_TXT int2 5  √  null
isdescriptorornot bool 1  √  false
description_hun text 2147483647  √  null
description_eng text 2147483647  √  null
comment_hun text 2147483647  √  null
resource_hun text 2147483647  √  null
SZAKCS text 2147483647  √  null
KATEGORIA text 2147483647  √  null
TORTENETI text 2147483647  √  null
VALTOZAS text 2147483647  √  null
BELSO text 2147483647  √  null
ETOMAGYARAZAT text 2147483647  √  null
MASR text 2147483647  √  null
POTKULCS varchar 80  √  null

Table contained 10,831 rows at Sun Nov 02 21:30 CET 2014

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc subject_pkey

Close relationships  within of separation: