Table structure

Tabellen von MH0.1

---

account

• options (OBJECT)

avatar (keine echte Tabelle)

event

• name (STRING)
• date (DATE)
• data (OBJECT)
• tags (ARRAY)
• options (OBJECT)

file

• name (STRING)
• tags (ARRAY)

group

• name (STRING)
• description (STRING)
• isMinistry (BOOL)
• icon (STRING)
• status (OBJECT)
• tags (ARRAY)

household

• name (STRING)
• letterSalutation (STRING)
• address (STRING)
• type (STRING)
• tags (STRING)

note

• title (STRING)
• content (TEXT)
• created (DATE)
• updated (DATE)
• folderId (STRING)
• ownerId (STRING)

person

• firstName (STRING)
• middleName (STRING)
• lastName (STRING)
• nickName (STRING)
• prefix (STRING)
• suffix (STRING)
• gender (STRING)
• emails (OBJECT)
• dates (OBJECT)
• contacts (OBJECT)
• custom (OBJECT)
• address (OBJECT)
• tags (ARRAY)
• status (ARRAY)
• primaryContact (STRING)
• hasAvatar (BOOL)
• search (STRING)

report

• name (STRING)
• query (OBJECT)
• rule (OBJECT)
• order (OBJECT)
• html (STRING)
• pdfOptions (OBJECT)

settings

• name (STRING)
• value (OBJECT)

Tabellen von MH2

auth_assignment

auth_item

auth_item_child

auth_rule

person

• firstName (STRING)
• middleName (STRING)
• lastName (STRING)
• nickName (STRING)
• prefix (STRING)
• suffix (STRING)
• gender (STRING)
• emails (OBJECT)
• dates (OBJECT)
• contacts (OBJECT)
• custom (OBJECT)
• address (OBJECT)
• tags (ARRAY)
• status (ARRAY)
• primaryContact (STRING)
• hasAvatar (BOOL)
• search (STRING)