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

mkt.radio contains 39 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
document datecreated date 13  √  null
document datecreatedtimeprecisionid int4 10  √  null
document description_eng varchar 255  √  null
document description_hun varchar 255  √  null
document filename varchar 50  √  null
document formatsounddigitalversionid int4 10  √  null
document id serial 10  √  nextval('radio.document_id_seq'::regclass)
document iscompleteorpart bool 1  √  false
document length varchar 50  √  null
document note_eng varchar 255  √  null
document note_hun varchar 255  √  null
document rootpath varchar 50  √  null
document seriesid int4 10  √  null
document soundtypeid int4 10  √  null
document title_eng varchar 50  √  null
document title_hun varchar 50  √  null
document_about_film documentid int4 10  √  null
document_about_film filmid int4 10  √  null
document_about_film segmentid int4 10  √  null
document_about_subject documentid int4 10  √  null
document_about_subject formatsynchronsoundid int4 10  √  null
document_about_subject framefrom int4 10  √  null
document_about_subject frameto int4 10  √  null
document_about_subject segmentid int4 10  √  null
document_about_subject subjectid int4 10  √  null
document_about_subject topicplaceindocumentid int4 10  √  null
document_by_person_role documentid int4 10  √  null
document_by_person_role personnameid int4 10  √  null
document_by_person_role rank int4 10  √  null
document_by_person_role roleid int4 10  √  null
series dateissued timestamp 29,6  √  null
series dateissuedtimeprecisionid int4 10  √  null
series description_eng varchar 255  √  null
series description_hun varchar 255  √  null
series id serial 10  √  nextval('radio.series_id_seq'::regclass)
series note_eng varchar 255  √  null
series note_hun varchar 255  √  null
series title_eng varchar 50  √  null
series title_hun varchar 50  √  null