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. List of fields 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 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".