How are the project tables linked?

[murky024]

So I am trying to write a report on the $ billed vs $ not billed and we keep some of this info in the projects section. I see the project_task_ctm and project_task_audit. How are they related back to the main project table and back to the customer/account table? I don't see any IDs that link either of these in any of the other tables that I would consider related by name.

Is there a copy I can get of the database diagram to help me with this? I am new to writing reports and using SQL so I am taking baby steps in my new company and part of my training is to write some reports for SugarOS with JasperReports

Thank you for any help you can provide.

Edit:Mistyped what I was looking for.

[murky024]

Well I got the relationship. project_task_cstm to project_task to project to project_relation to accounts...