Table:User Table:Object Table:Group
---------- ------------ -----------
object_id <==> object_id <==> object_id
email object_type name
firstname parent_ID description
surname created
last_modified
####
Table:Death Table:Wedding
----------- -------------
object_id object_id
firstname firstname_1
surname surname_1
short_obit firstname_2
obituary surname_2
flowers message_from_couple
charities details
date_of_death date_of_wedding
####
Table:Announcement Table:Death Table:Wedding
------------------ ----------- -------------
object_id object_id object_id
firstname short_obit firstname_2
surname obituary surname_2
flowers message_from_couple
charitites details
date_of_death date_of_wedding
####
Table:Announcement
------------------
object_id
notice_type
firstname_1
surname_2
firstname_2
surname_2
summary
details
date_1
field_1
field_2
field_3
####
Table:Object Table:Properties Table:Object_Properties
------------ ---------------- -----------------------
object_id property_id object_id
object_type property_name (eg flowers) property_id
... property_type (eg text) value
... (or)
text_value
blob_value
date_value
boolean_value
etc