Updating docs, autojoin works on '_id' columns too

d4nt · Jul 12, 2019 · Oct 16, 2018 · Oct 16, 2018 · Oct 16, 2018 · Oct 16, 2018
commit 3eacacbd0591a36080b4cb52438f096b09628bcb
diff --git a/docs/autojoin.md b/docs/autojoin.md
@@ -1,8 +1,8 @@
 # Auto-Join
 
-When a table is selected in the query builder, QueryTree checks for other tables that it can automatically join onto and prompts the user to select those related tables, thereby including the columns from the related table in the results that are returned. 
+When a table is selected in the query builder, QueryTree checks for other tables that it can automatically join onto and prompts the user to select those related tables, thereby including the columns from the related table in the results that are returned.
 
-QueryTree can automatically join from "child" tables onto "parent" tables, but not the other way around. For example, if the user selected the "Orders" table, QueryTree could auto-join onto "Users" or "Products". But selecting "Users" will not prompt you to include information from the "Orders" table. 
+QueryTree can automatically join from "child" tables onto "parent" tables, but not the other way around. For example, if the user selected the "Orders" table, QueryTree could auto-join onto "Users" or "Products". But selecting "Users" will not prompt you to include information from the "Orders" table.
 
 This limitation is primarily for usability, not a technical reasons. The level of user that QueryTree is aimed at, generally seem to understand the idea of selecting Orders and then adding in the related User or Product information. However, if QueryTree were to join from Users onto Orders, the QueryTree user would see the User information repeated multiple times, in our experience, this causes confusion.
 
@@ -40,9 +40,9 @@ Foreign keys on to compound (multiple column) keys are not supported.
 
 In addition to looking for foreign keys, QueryTree will look for columns on the selected table, that:
 
- * Are not the primary key
- * Are not already part of a foreign key
- * Match the name of another table, followed by the letters "id". This check is not case sensitive.
+* Are not the primary key
+* Are not already part of a foreign key
+* Match the name of another table, followed by the letters "_id" or "id". This check is not case sensitive.
 
 For example, given the following two tables, QueryTree will prompt to join from "orders" to "users". Despite the fact that there are no foreign keys.
 
@@ -64,7 +64,6 @@ create table orders
 );
 ```
 
-
 ## Caching
 
 QueryTree will interrogate the structure of your database the first time it is queried, and cache the information for an hour. If you change the database structure and want to see the effects immidiately, please restart the QueryTree process to flush the cache.