Here is the ERD of Liberum Help Desk. Not the best one but will give you a general idea on how database is maintained. As you can see, naming and links are confusing. The lines should be viewed as links rather than relations. All relations are maintained in code than in database.
If you want a copy let me know and I can email you one.
Thanks,
