SchemaSpy Analysis of mkt.concept - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Sun Nov 02 21:30 CET 2014
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

mkt.concept contains 374 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
animalname animaltypeid int4 10  √  null
animalname id serial 10  √  nextval('concept.animal_id_seq'::regclass)
animalname name varchar 50  √  null
animaltype id serial 10  √  nextval('concept.animaltype_id_seq'::regclass)
animaltype name_eng varchar 50  √  null
animaltype name_hun varchar 50  √  null
contacttype id serial 10  √  nextval('concept.contacttype_id_seq'::regclass)
contacttype name_eng varchar 20  √  null
contacttype name_hun varchar 20  √  null
context description_eng varchar 255  √  null
context description_hun varchar 255  √  null
context id serial 10  √  nextval('concept.context_id_seq'::regclass)
context name_eng varchar 50  √  null
context name_hun varchar 50  √  null
corporatenametype id serial 10  √  nextval('concept.corporatenametype_id_seq'::regclass)
corporatenametype name_eng varchar 50  √  null
corporatenametype name_hun varchar 50  √  null
corporatenametype rank int4 10  √  null
corporatetype id serial 10  √  nextval('concept.corporatetype_id_seq'::regclass)
corporatetype name_eng varchar 50  √  null
corporatetype name_hun varchar 50  √  null
datefrequency id serial 10  √  nextval('concept.datefrequency_id_seq'::regclass)
datefrequency name_eng varchar 30  √  null
datefrequency name_hun varchar 30  √  null
documenttype id serial 10  √  nextval('concept.documenttype_id_seq'::regclass)
documenttype name_eng varchar 50  √  null
documenttype name_hun varchar 50  √  null
eventtype id serial 10  √  nextval('concept.eventtype_id_seq'::regclass)
eventtype name_eng varchar 50  √  null
eventtype name_hun varchar 50  √  null
filmeventtype id serial 10  √  nextval('concept.filmeventtype_id_seq'::regclass)
filmeventtype name_eng varchar 150  √  null
filmeventtype name_hun varchar 150  √  null
filmfestivalnametype id serial 10  √  nextval('concept.filmfestivalnametype_id_seq'::regclass)
filmfestivalnametype name_eng varchar 50  √  null
filmfestivalnametype name_hun varchar 50  √  null
filmproduction_phase id serial 10  √  nextval('concept.filmproduction_phase_id_seq'::regclass)
filmproduction_phase name_eng varchar 50  √  null
filmproduction_phase name_hun varchar 50  √  null
filmtype id serial 10  √  nextval('concept.filmtype_id_seq'::regclass)
filmtype name_eng varchar 50  √  null
filmtype name_hun varchar 50  √  null
formataccordingtotime id serial 10  √  nextval('concept.formataccordingtotime_id_seq'::regclass)
formataccordingtotime name_eng varchar 50  √  null
formataccordingtotime name_hun varchar 50  √  null
formatcolortechnics id serial 10  √  nextval('concept.formatcolortechnics_id_seq'::regclass)
formatcolortechnics name_eng varchar 50  √  null
formatcolortechnics name_hun varchar 50  √  null
formatdocumentcompleteness id serial 10  √  nextval('concept.formatdocumentcompleteness_id_seq'::regclass)
formatdocumentcompleteness name_eng varchar 50  √  null
formatdocumentcompleteness name_hun varchar 50  √  null
formatdocumentcopyquality id serial 10  √  nextval('concept.formatdocumentcopyquality_id_seq'::regclass)
formatdocumentcopyquality name_eng varchar 50  √  null
formatdocumentcopyquality name_hun varchar 50  √  null
formatdocumentquality id serial 10  √  nextval('concept.formatdocumentquality_id_seq'::regclass)
formatdocumentquality name_eng varchar 50  √  null
formatdocumentquality name_hun varchar 50  √  null
formatextentpagenumbermeasureunit id serial 10  √  nextval('concept.formatextentpagenumbermeasureunit_id_seq'::regclass)
formatextentpagenumbermeasureunit name_eng varchar 50  √  null
formatextentpagenumbermeasureunit name_hun varchar 50  √  null
formatextentsizemeasureunit id serial 10  √  nextval('concept.formatextentsizemeasureunit_id_seq'::regclass)
formatextentsizemeasureunit name_eng varchar 20  √  null
formatextentsizemeasureunit name_hun varchar 20  √  null
formatfilmcolor id serial 10  √  nextval('concept.formatfilmcolor_id_seq'::regclass)
formatfilmcolor name_eng varchar 50  √  null
formatfilmcolor name_hun varchar 50  √  null
formatfilmfault description_eng text 2147483647  √  null
formatfilmfault desctiption_hun text 2147483647  √  null
formatfilmfault id serial 10  √  nextval('concept.formatfilmfault_id_seq'::regclass)
formatfilmfault name_eng varchar 50  √  null
formatfilmfault name_hun varchar 50  √  null
formatfilmformat id serial 10  √  nextval('concept.formatfilmformat_id_seq'::regclass)
formatfilmformat name_eng varchar 50  √  null
formatfilmformat name_hun varchar 50  √  null
formatfilmscreenformat id serial 10  √  nextval('concept.formatfilmscreenformat_id_seq'::regclass)
formatfilmscreenformat name_eng varchar 50  √  null
formatfilmscreenformat name_hun varchar 50  √  null
formatfilmsound id serial 10  √  nextval('concept.formatfilmsound_id_seq'::regclass)
formatfilmsound name_eng varchar 50  √  null
formatfilmsound name_hun varchar 50  √  null
formatimagecolor id serial 10  √  nextval('concept.formatimagecolor_id_seq'::regclass)
formatimagecolor name_eng varchar 50  √  null
formatimagecolor name_hun varchar 50  √  null
formatimagepaperquality id serial 10  √  nextval('concept.formatimagepaperquality_id_seq'::regclass)
formatimagepaperquality name_eng varchar 50  √  null
formatimagepaperquality name_hun varchar 50  √  null
formatimagepart id serial 10  √  nextval('concept.formatimagepart_id_seq'::regclass)
formatimagepart name_eng varchar 50  √  null
formatimagepart name_hun varchar 50  √  null
formatimageratio id serial 10  √  nextval('concept.formatimageratio_id_seq'::regclass)
formatimageratio name_eng varchar 50  √  null
formatimageratio name_hun varchar 50  √  null
formatpageorientation id serial 10  √  nextval('concept.formatpageorientation_id_seq'::regclass)
formatpageorientation name_eng varchar 50  √  null
formatpageorientation name_hun varchar 50  √  null
formatsounddigitalversion id serial 10  √  nextval('concept.formatsounddigitalversion_id_seq'::regclass)
formatsounddigitalversion name_eng varchar 50  √  null
formatsounddigitalversion name_hun varchar 50  √  null
formatsoundtechnics id serial 10  √  nextval('concept.formatsoundtechnics_id_seq'::regclass)
formatsoundtechnics name_eng varchar 50  √  null
formatsoundtechnics name_hun varchar 50  √  null
formatsynchronsound id serial 10  √  nextval('concept.formatsynchronsound_id_seq'::regclass)
formatsynchronsound name_eng varchar 50  √  null
formatsynchronsound name_hun varchar 50  √  null
gender id serial 10  √  nextval('concept.gender_id_seq'::regclass)
gender name_eng varchar 50  √  null
gender name_hun varchar 50  √  null
genrearticle definition_eng text 2147483647  √  null
genrearticle definition_hun text 2147483647  √  null
genrearticle genretypeid int4 10  √  null
genrearticle id serial 10  √  nextval('concept.genrearticle_id_seq'::regclass)
genrearticle name_eng varchar 35  √  null
genrearticle name_hun varchar 35  √  null
genrebook definition_eng text 2147483647  √  null
genrebook definition_hun text 2147483647  √  null
genrebook genretypeid int4 10  √  null
genrebook id serial 10  √  nextval('concept.genrebook_id_seq'::regclass)
genrebook name_eng varchar 35  √  null
genrebook name_hun varchar 35  √  null
genrefilm definition_eng text 2147483647  √  null
genrefilm definition_hun text 2147483647  √  null
genrefilm genretypeid int4 10  √  null
genrefilm id serial 10  √  nextval('concept.genrefilm_id_seq'::regclass)
genrefilm name_eng varchar 35  √  null
genrefilm name_hun varchar 35  √  null
genreimage definition_eng text 2147483647  √  null
genreimage definition_hun text 2147483647  √  null
genreimage genretypeid int4 10  √  null
genreimage id serial 10  √  nextval('concept.genreimage_id_seq'::regclass)
genreimage name_eng varchar 35  √  null
genreimage name_hun varchar 35  √  null
genreperiodics definition_eng text 2147483647  √  null
genreperiodics definition_hun text 2147483647  √  null
genreperiodics genretypeid int4 10  √  null
genreperiodics id serial 10  √  nextval('concept.genreperiodics_id_seq'::regclass)
genreperiodics name_eng varchar 35  √  null
genreperiodics name_hun varchar 35  √  null
genresound definition_eng text 2147483647  √  null
genresound definition_hun text 2147483647  √  null
genresound genretypeid int4 10  √  null
genresound id serial 10  √  nextval('concept.genresound_id_seq'::regclass)
genresound name_eng varchar 35  √  null
genresound name_hun varchar 35  √  null
geographicaladdresstype id serial 10  √  nextval('concept.geographicaladdresstype_id_seq'::regclass)
geographicaladdresstype name_eng varchar 2147483647  √  null
geographicaladdresstype name_hun varchar 50  √  null
geographicalareatype id serial 10  √  nextval('concept.geographicalareatype_id_seq'::regclass)
geographicalareatype name_eng varchar 50  √  null
geographicalareatype name_hun varchar 50  √  null
imagetype id serial 10  √  nextval('concept.imagetype_id_seq'::regclass)
imagetype name_eng varchar 50  √  null
imagetype name_hun varchar 50  √  null
jurytype id serial 10  √  nextval('concept.jurytype_id_seq'::regclass)
jurytype name_eng varchar 50  √  null
jurytype name_hun varchar 50  √  null
keyword clanid int4 10  √  null
keyword degree int4 10  √  null
keyword description_eng text 2147483647  √  null
keyword description_hun text 2147483647  √  null
keyword fatherid int4 10  √  null
keyword id serial 10  √  nextval('concept.keyword_id_seq'::regclass)
keyword name_eng varchar 50  √  null
keyword name_hun varchar 50  √  null
keyword oldid int4 10  √  null
keyword rank int4 10  √  null
keyword rootorleaf bool 1  √  false
keyword tablename varchar 50  √  null
language code varchar 50  √  null
language id serial 10  √  nextval('concept.language_id_seq'::regclass)
language name_eng varchar 255  √  null
language name_hun varchar 50  √  null
languageusagetype id serial 10  √  nextval('concept.languageusagetype_id_seq'::regclass)
languageusagetype name_eng varchar 50  √  null
languageusagetype name_hun varchar 50  √  null
locationnametype id serial 10  √  nextval('concept.locationnametype_id_seq'::regclass)
locationnametype name_eng varchar 50  √  null
locationnametype name_hun varchar 50  √  null
locationprecision id serial 10  √  nextval('concept.locationprecision_id_seq'::regclass)
locationprecision name_eng varchar 50  √  null
locationprecision name_hun varchar 50  √  null
maintopicarticle definition_eng text 2147483647  √  null
maintopicarticle definition_hun text 2147483647  √  null
maintopicarticle id serial 10  √  nextval('concept.maintopicarticle_id_seq'::regclass)
maintopicarticle maintopictypeid int4 10  √  null
maintopicarticle name_eng varchar 35  √  null
maintopicarticle name_hun varchar 35  √  null
maintopicbook definition_eng text 2147483647  √  null
maintopicbook definition_hun text 2147483647  √  null
maintopicbook id serial 10  √  nextval('concept.maintopicbook_id_seq'::regclass)
maintopicbook maintopictypeid int4 10  √  null
maintopicbook name_eng varchar 35  √  null
maintopicbook name_hun varchar 35  √  null
maintopicfilm definition_eng text 2147483647  √  null
maintopicfilm definition_hun text 2147483647  √  null
maintopicfilm id serial 10  √  nextval('concept.maintopicfilm_id_seq'::regclass)
maintopicfilm maintopictypeid int4 10  √  null
maintopicfilm name_eng varchar 35  √  null
maintopicfilm name_hun varchar 35  √  null
maintopicperiodics definition_eng text 2147483647  √  null
maintopicperiodics definition_hun text 2147483647  √  null
maintopicperiodics id serial 10  √  nextval('concept.maintopicperiodics_id_seq'::regclass)
maintopicperiodics maintopictypeid int4 10  √  null
maintopicperiodics name_eng varchar 35  √  null
maintopicperiodics name_hun varchar 35  √  null
maintopicsound definition_eng text 2147483647  √  null
maintopicsound definition_hun text 2147483647  √  null
maintopicsound id serial 10  √  nextval('concept.maintopicsound_id_seq'::regclass)
maintopicsound maintopictypeid int4 10  √  null
maintopicsound name_eng varchar 35  √  null
maintopicsound name_hun varchar 35  √  null
month id serial 10  √  nextval('concept.month_id_seq'::regclass)
month name_eng varchar 50  √  null
month name_hun varchar 50  √  null
nation id serial 10  √  nextval('concept.nation_id_seq'::regclass)
nation name_eng varchar 50  √  null
nation name_hun varchar 50  √  null
personimportance id serial 10  √  nextval('concept.personimportance_id_seq'::regclass)
personimportance name_eng varchar 50  √  null
personimportance name_hun varchar 50  √  null
personnametype id serial 10  √  nextval('concept.personnametype_id_seq'::regclass)
personnametype name_eng varchar 50  √  null
personnametype name_hun varchar 50  √  null
personnametype rank int4 10  √  null
position id serial 10  √  nextval('concept.position_id_seq'::regclass)
position name_eng varchar 100  √  null
position name_hun varchar 100  √  null
publishingtype id serial 10  √  nextval('concept.publishingtype_id_seq'::regclass)
publishingtype name_eng varchar 50  √  null
publishingtype name_hun varchar 50  √  null
relation code_eng varchar 5  √  null
relation code_hun varchar 5  √  null
relation definition_eng varchar 50  √  null
relation definition_hun varchar 50  √  null
relation id serial 10  √  nextval('concept.relation_id_seq'::regclass)
relation name_eng varchar 25  √  null
relation name_hun varchar 25  √  null
relation rank int4 10  √  null
righttype id serial 10  √  nextval('concept.righttype_id_seq'::regclass)
righttype name_eng varchar 50  √  null
righttype name_hun varchar 50  √  null
role id serial 10  √  nextval('concept.role_id_seq'::regclass)
role name_eng varchar 50  √  null
role name_hun varchar 50  √  null
role profileornot bool 1  √  false
role rank int4 10  √  null
role rolegroupid int4 10  √  null
role superroleid int4 10  √  null
segmenttypefilm id serial 10  √  nextval('concept.segmenttypefilm_id_seq'::regclass)
segmenttypefilm name_eng varchar 50  √  null
segmenttypefilm name_hun varchar 50  √  null
segmenttypefilm rank int4 10  √  null
segmenttypesound id serial 10  √  nextval('concept.segmenttypesound_id_seq'::regclass)
segmenttypesound name_eng varchar 50  √  null
segmenttypesound name_hun varchar 50  √  null
segmenttypesound rank int4 10  √  null
seriestype id serial 10  √  nextval('concept.seriestype_id_seq'::regclass)
seriestype name_eng varchar 50  √  null
seriestype name_hun varchar 50  √  null
soundtype id serial 10  √  nextval('concept.soundtype_id_seq'::regclass)
soundtype name_eng varchar 50  √  null
soundtype name_hun varchar 50  √  null
sourceprecision id serial 10  √  nextval('concept.sourceprecision_id_seq'::regclass)
sourceprecision name_eng varchar 50  √  null
sourceprecision name_hun varchar 50  √  null
stylearticle definition_eng text 2147483647  √  null
stylearticle definition_hun text 2147483647  √  null
stylearticle id serial 10  √  nextval('concept.stylearticle_id_seq'::regclass)
stylearticle name_eng varchar 50  √  null
stylearticle name_hun varchar 50  √  null
stylearticle styletypeid int4 10  √  null
stylebook definition_eng text 2147483647  √  null
stylebook definition_hun text 2147483647  √  null
stylebook id serial 10  √  nextval('concept.stylebook_id_seq'::regclass)
stylebook name_eng varchar 50  √  null
stylebook name_hun varchar 50  √  null
stylebook styletypeid int4 10  √  null
stylefilm definition_eng text 2147483647  √  null
stylefilm definition_hun text 2147483647  √  null
stylefilm id serial 10  √  nextval('concept.stylefilm_id_seq'::regclass)
stylefilm name_eng varchar 50  √  null
stylefilm name_hun varchar 50  √  null
stylefilm styletypeid int4 10  √  null
styleimage definition_eng text 2147483647  √  null
styleimage definition_hun text 2147483647  √  null
styleimage id serial 10  √  nextval('concept.styleimage_id_seq'::regclass)
styleimage name_eng varchar 50  √  null
styleimage name_hun varchar 50  √  null
styleimage styletypeid int4 10  √  null
styleperiodics definition_eng text 2147483647  √  null
styleperiodics definition_hun text 2147483647  √  null
styleperiodics id serial 10  √  nextval('concept.styleperiodics_id_seq'::regclass)
styleperiodics name_eng varchar 50  √  null
styleperiodics name_hun varchar 50  √  null
styleperiodics styletypeid int4 10  √  null
stylesound definition_eng text 2147483647  √  null
stylesound definition_hun text 2147483647  √  null
stylesound id serial 10  √  nextval('concept.stylesound_id_seq'::regclass)
stylesound name_eng varchar 50  √  null
stylesound name_hun varchar 50  √  null
stylesound styletypeid int4 10  √  null
subject BELSO text 2147483647  √  null
subject comment_hun text 2147483647  √  null
subject description_eng text 2147483647  √  null
subject description_hun text 2147483647  √  null
subject ETOMAGYARAZAT text 2147483647  √  null
subject id serial 10  √  nextval('concept.subject_id_seq'::regclass)
subject isdescriptorornot bool 1  √  false
subject KATEGORIA text 2147483647  √  null
subject KIEMELES bool 1  √  false
subject MASR text 2147483647  √  null
subject name_eng varchar 80  √  null
subject name_hun varchar 80  √  null
subject ORIG_TXT int2 5  √  null
subject POTKULCS varchar 80  √  null
subject resource_hun text 2147483647  √  null
subject SZAKCS text 2147483647  √  null
subject TORTENETI text 2147483647  √  null
subject VALTOZAS text 2147483647  √  null
subject_relation_subject degree int4 10  √  null
subject_relation_subject leftsubjectid int4 10  √  null
subject_relation_subject rank int4 10  √  null
subject_relation_subject relationid int4 10  √  null
subject_relation_subject rightsubjectid int4 10  √  null
superrole id serial 10  √  nextval('concept.superrole_id_seq'::regclass)
superrole name_eng varchar 50  √  null
superrole name_hun varchar 50  √  null
textintype id serial 10  √  nextval('concept.textintype_id_seq'::regclass)
textintype name_eng varchar 50  √  null
textintype name_hun varchar 50  √  null
timeprecision id serial 10  √  nextval('concept.timeprecision_id_seq'::regclass)
timeprecision name_eng varchar 20  √  null
timeprecision name_hun varchar 16  √  null
timeprecisionmodifier id serial 10  √  nextval('concept.timeprecisionmodifier_id_seq'::regclass)
timeprecisionmodifier name_eng varchar 20  √  null
timeprecisionmodifier name_hun varchar 16  √  null
timeprecisionperiodtype id serial 10  √  nextval('concept.timeprecisionperiodtype_id_seq'::regclass)
timeprecisionperiodtype name_eng varchar 50  √  null
timeprecisionperiodtype name_hun varchar 50  √  null
titletypebook id serial 10  √  nextval('concept.titletypebook_id_seq'::regclass)
titletypebook name_eng varchar 50  √  null
titletypebook name_hun varchar 50  √  null
titletypebook rank int4 10  √  null
titletypefilm id serial 10  √  nextval('concept.titletype_id_seq'::regclass)
titletypefilm name_eng varchar 50  √  null
titletypefilm name_hun varchar 50  √  null
titletypefilm rank int4 10  √  null
topicplaceindocument id serial 10  √  nextval('concept.topicplaceindocument_id_seq'::regclass)
topicplaceindocument name_eng varchar 50  √  null
topicplaceindocument name_hun varchar 50  √  null
topicplaceindocument rank int4 10  √  null
transcripttype id serial 10  √  nextval('concept.transcripttype_id_seq'::regclass)
transcripttype name_eng varchar 2147483647  √  null
transcripttype name_hun varchar 2147483647  √  null
zproblem_role_can_be_deleted id int4 10  √  null
zproblem_role_can_be_deleted name_eng varchar 50  √  null
zproblem_role_can_be_deleted name_hun varchar 50  √  null
zproblem_role_can_be_deleted profileornot bool 1  √  null
zproblem_role_can_be_deleted rank int4 10  √  null
zproblem_role_can_be_deleted rolegroupid int4 10  √  null
zproblem_role_can_be_deleted superroleid int4 10  √  null
zproblem_role_missing_rank id int4 10  √  null
zproblem_role_missing_rank name_eng varchar 50  √  null
zproblem_role_missing_rank name_hun varchar 50  √  null
zproblem_role_missing_rank profileornot bool 1  √  null
zproblem_role_missing_rank rank int4 10  √  null
zproblem_role_missing_rank rolegroupid int4 10  √  null
zproblem_role_missing_rank superroleid int4 10  √  null
zproblem_role_resolveanddelete id int4 10  √  null
zproblem_role_resolveanddelete name_eng varchar 50  √  null
zproblem_role_resolveanddelete name_hun varchar 50  √  null
zproblem_role_resolveanddelete profileornot bool 1  √  null
zproblem_role_resolveanddelete rank int4 10  √  null
zproblem_role_resolveanddelete rolegroupid int4 10  √  null
zproblem_role_resolveanddelete superroleid int4 10  √  null