View mkt.article.check_document_without_textinid 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 int4 10  √  null
listonly bool 1  √  null
title_hun varchar 250  √  null
title_eng varchar 250  √  null
description_hun text 2147483647  √  null
description_eng text 2147483647  √  null
textintypeid int4 10  √  null
textinid int4 10  √  null
formatextentpagenumberfrom int4 10  √  null
formatextentpagenumberto int4 10  √  null
közlés_helye varchar 100  √  null
issueid int4 10  √  null
dateissued timestamp 29,6  √  null
dateissuedtimeprecisionid int4 10  √  null
issuevolumenumber varchar 15  √  null
completeornot_hun bool 1  √  null
completeornot_eng bool 1  √  null
filenameofhungarian varchar 15  √  null
filenameofenglish varchar 15  √  null
aboutconcretefilmornot bool 1  √  null
aboutconcretepersonornot bool 1  √  null
aboutconcretecorporateornot bool 1  √  null
interviewornot bool 1  √  null
filmhistoricalornot bool 1  √  null
filmtechnicalornot bool 1  √  null
shorttext_hun text 2147483647  √  null
shorttext_eng text 2147483647  √  null
corporatehistoricalornot bool 1  √  null
memoirornot bool 1  √  null
technicshistoricalornot bool 1  √  null
presshistoricalornot bool 1  √  null
newsornot bool 1  √  null
adsornot bool 1  √  null
contr int4 10  √  null

Analyzed at Sun Nov 02 21:30 CET 2014