View mkt.person.zcheck_person_without_personname 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
name_redund varchar 50  √  null
genderid int4 10  √  null
datebirth timestamp 29,6  √  null
datebirthtimeprecisionid int4 10  √  null
datedeath timestamp 29,6  √  null
datedeathtimeprecisionid int4 10  √  null
birthlocationnameid int4 10  √  null
deathlocationnameid int4 10  √  null
profession_hun varchar 100  √  null
profession_eng varchar 100  √  null
administrativenote varchar 255  √  null
canbedeleted bool 1  √  null
personimportanceid int4 10  √  null

Analyzed at Sun Nov 02 21:32 CET 2014