View mkt.film.document_in_person_role_full_with_bg_huneng 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
documentid int4 10  √  null
personnameid int4 10  √  null
personid int4 10  √  null
roleid int4 10  √  null
rank int4 10  √  null
filmtitle_hun text 2147483647  √  null
person_hun text 2147483647  √  null
role_hun varchar 50  √  null
character_hun varchar 255  √  null
filmtitle_eng text 2147483647  √  null
person_eng text 2147483647  √  null
role_eng varchar 50  √  null
character_eng varchar 255  √  null
documentinpersonroleid int4 10  √  null
bg_personnameid int4 10  √  null
bg_roleid int4 10  √  null
bg_personname_hun text 2147483647  √  null
bg_role_hun varchar 50  √  null
bg_personname_eng text 2147483647  √  null
bg_role_eng varchar 50  √  null

Analyzed at Sun Nov 02 21:31 CET 2014