Data structure

Person

Container of all personal datas including 5 additional fields for customization.

Column	Description
id	Primary key
salutation
name
birthname
firstname
middlename
nickname
nickfirstname	Calculated field. Nickname, if empty firstname.
address
zip
city
state
country
hh_person_id	Household leader (Foreign key to person). Used for addresslist.
hh_salutation_override	For household leaders: Overwrite of salutation.
hh_name_override	For household leaders: Overwrite of name.
birthday
deceased
telephone
mobile
email
url
user_id	This user can manage the data online.
image
custom1	Custom field. Set label in configuration.
custom2	Custom field. Set label in configuration.
custom3	Custom field. Set label in configuration.
custom4	Custom field. Set label in configuration.
custom5	Custom field. Set label in configuration.
description	Textfield for descriptions.
createdby	Create user name
createddate	Create date/time
modifiedby	Modify user name
modifieddate	Modify date/time

Membership

Container of all membership datas including most fields of the related person object.

Column	Description
id	Primary key
published
person_id	related person (Foreign key to person).
type	Membership type. Customizable see preferences.
begin	Begin date of this membership.
end	End date of this membership.
beginyear	Calculated field. Year of begin.
endyear	Calculated field. Year of end
beginendyear	Calculated field. beginyear - endyear
createdby	Create user name
createddate	Create date/time
modifiedby	Modify user name
modifieddate	Modify date/time
salutation	See object "person".
name	See object "person".
birthname	See object "person".
firstname	See object "person".
middlename	See object "person".
nickname	See object "person".
nickfirstname	See object "person".
address	See object "person".
city	See object "person".
zip	See object "person".
country	See object "person".
state	See object "person".
hh_person_id	See object "person".
hh_salutation_override	See object "person".
hh_name_override	See object "person".
birthday	See object "person".
deceased	See object "person".
telephone	See object "person".
mobile	See object "person".
url	See object "person".
email	See object "person".
image	See object "person".
custom1	See object "person".
custom2	See object "person".
custom3	See object "person".
custom4	See object "person".
custom5	See object "person".

Board

Container of all board datas including most fields of the related person object.

Column	Description
id	Primary key
published	Publish the data to the public.
person_id	related person (Foreign key to person).
job	Membership type. Customizable see preferences.
sortorder	Integer number used for special sorting.
begin	Begin date of this membership.
end	End date of this membership.
beginyear	Calculated field. Year of begin.
endyear	Calculated field. Year of end
beginendyear	Calculated field. beginyear - endyear
createdby	Create user name
createddate	Create date/time
modifiedby	Modify user name
modifieddate	Modify date/time
salutation	See object "person".
name	See object "person".
birthname	See object "person".
firstname	See object "person".
middlename	See object "person".
nickname	See object "person".
nickfirstname	See object "person".
address	See object "person".
city	See object "person".
zip	See object "person".
country	See object "person".
state	See object "person".
hh_person_id	See object "person".
hh_salutation_override	See object "person".
hh_name_override	See object "person".
birthday	See object "person".
deceased	See object "person".
telephone	See object "person".
mobile	See object "person".
url	See object "person".
email	See object "person".
image	See object "person".
custom1	See object "person".
custom2	See object "person".
custom3	See object "person".
custom4	See object "person".
custom5	See object "person".