Update active relations docs

5 files changed, 23 insertions, 6 deletions

diff --git a/demos/quickstart/protected/pages/Database/ActiveRecord.page b/demos/quickstart/protected/pages/Database/ActiveRecord.page
index c3cf663b..967aae89 100644
--- a/demos/quickstart/protected/pages/Database/ActiveRecord.page
+++ b/demos/quickstart/protected/pages/Database/ActiveRecord.page
@@ -49,15 +49,20 @@
         <li>Finder methods to wrap commonly used SQL queries and return Active Record objects.</li>
         <li>Update existing records and insert new records into the database.</li>
     </ul>
+<h2>Database Supported</h2>
 <p id="p1" class="block-content">
 The Active Record implementation utilizes the <a href="?page=Database.DAO">Prado DAO</a> classes for data access.   
-The current Active Record implementation supports 
-<a href="http://www.mysql.com">MySQL</a>, 
-<a href="http://www.postgres.com">Postgres SQL</a> and 
-<a href="http://www.sqlite.org">SQLite</a> databases.
-Support for other databases can be provided when there are sufficient demand.
+The current Active Record implementation supports the following database. 
 </p>
-<h2 id="138048">Defining an Active Record</h2>
+<ul>
+	<li><a href="http://www.mysql.com">MySQL 4.1 or later</a></li>
+	<li><a href="http://www.postgres.com">Postgres SQL 7.3 or later</a></li>
+	<li><a href="http://www.sqlite.org">SQLite 2 and 3</a></li>
+	<li><a href="#">MS SQL 2000 or later</a></li>
+</ul>
+<p>Support for other databases can be provided when there are sufficient demand.</p>
+
+<h1 id="138048">Defining an Active Record</h1>
 <p id="690483" class="block-content">Let us
     consider the following "users" table that contains two columns named "username" and "email", 
     where "username" is also the primary key. 
@@ -412,6 +417,18 @@ catch(Exception $e) // an exception is raised if a query fails
 }
 </com:TTextHighlighter>
 
+<h1 id="ar_relations">Active Record Relationships</h1>
+<p id="690504a" class="block-content">
+The Prado ActiveRecord implementation supports the foreign key mappings for database
+that supports foreign key contraints. For ActiveRecord relationships to function the
+underlying database must support foreign key constraints (e.g. MySQL with InnoDB).
+</p>
+
+<h2>Foreign Key Mapping</h2>
+
+
+<h2>Association Table Mapping</h2>
+
 <h2 id="138054">References</h2>
 <ul id="u3" class="block-content">
     <li>Fowler et. al. <i>Patterns of Enterprise Application Architecture</i>,
diff --git a/demos/quickstart/protected/pages/Database/ar_objects.png b/demos/quickstart/protected/pages/Database/ar_objects.png
new file mode 100644
index 00000000..027d1e96
--- /dev/null
+++ b/demos/quickstart/protected/pages/Database/ar_objects.png
diff --git a/demos/quickstart/protected/pages/Database/ar_objects.vsd b/demos/quickstart/protected/pages/Database/ar_objects.vsd
new file mode 100644
index 00000000..595b7d86
--- /dev/null
+++ b/demos/quickstart/protected/pages/Database/ar_objects.vsd
diff --git a/demos/quickstart/protected/pages/Database/ar_relations.png b/demos/quickstart/protected/pages/Database/ar_relations.png
new file mode 100644
index 00000000..df72823c
--- /dev/null
+++ b/demos/quickstart/protected/pages/Database/ar_relations.png
diff --git a/demos/quickstart/protected/pages/Database/ar_relations.vsd b/demos/quickstart/protected/pages/Database/ar_relations.vsd
new file mode 100644
index 00000000..9b27e7e3
--- /dev/null
+++ b/demos/quickstart/protected/pages/Database/ar_relations.vsd