[Images]
parent_image_id = Images:id

[Person]
office_id = Office:id
company_id = Companies:id
project_id = Projects:id
owner_id = Person:id

[Companies]
logo_id = Images:id
owner_id = Person:id
main_office_id = Office:id
comptype_id = core_enum:id


[Office]
company_id = Companies:id

[Projects]
client_id = Companies:id
agency_id = Companies:id
team_id = Groups:id
open_by = Person:id
owner_id = Person:id

[ProjectDirectory]
person_id = Person:id
project_id = Projects:id


[Groups]
leader = Person:id

[group_members]
group_id = Groups:id
user_id =  Person:id

[group_rights]
group_id = Groups:id

[Events]
person_id = Person:id

[core_event_audit]
event_id = Events:id
old_audit_id = core_event_audit:id

[core_watch]
person_id = Person:id

[core_person_alias]
person_id = Person:id

[core_notify]
person_id = Person:id
event_id = Events:id
watch_id = core_watch:id
trigger_person_id = Person:id
trigger_event_id = Events:id

[core_notify_recur]
person_id = Person:id
last_event_id = Events:id
method_id = core_enum:id



[database__render]
Projects = name
Companies = name
Office =  name
Person = name
Groups = name
Images = filename

 
[ProjectDirectory]
person_id = Person:id
project_id = Projects:id
office_id = Office:id
company_id = Companies:id

[core_email]
owner_id = Person:id