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