Needing help understanding the database structure

Topics: Troubleshooting
Nov 30, 2012 at 9:08 AM
Edited Nov 30, 2012 at 9:09 AM

Hello,

SysCache seems to have broken my taxonmy tables, I am getting exceptions when trying to modify taxonomies or a query using taxonomy field as filter.

As I have already dozens of contents created using taxonomies, I will try to repair the database where seems that a record is missing.

New to Orchard, I am not used to NHibernate but fluent on SLQ Server.

Before diving into the code, I would appreciate some indications on the place where I could find the information used by NHibernate to create tables and links between these tables.

 

From a first look, I see that NHibernate does not generate external keys to link tables ? 

Is there any naming convention in the column names which could also help in relating tables ?

 

Thanks for help.

CS

Coordinator
Nov 30, 2012 at 4:20 PM

That information, including instructions to create foreign keys, can be found in Migrations.cs files.

Nov 30, 2012 at 5:11 PM

Finally I found a small bug in Taxonomies' TermPart.cs and reported it.