Connections database table

From TaskDepender

@@ Line 47: / Line 47: @@
 [[Image:Single_source_syntax_diagram.gif]]
-Next, a join must be made between this list and the [[Deliverables database table|deliverables]] in which the <tt>DeliverableId</tt> of the connection corresponds to the <tt>Id</tt> of the deliverable. The select statement must retrieve the column values of the deliverable with the accept ion of the <tt>ConnetionId</tt> and <tt>ContainerId</tt>. These are set respectively to the <tt>Id</tt> and <tt>TaskId</tt> of the connection.
+Next, an inner join<ref name="inner_join">[http://en.wikipedia.org/wiki/Join_%28SQL%29#Inner_join Inner join - Wikipedia]</ref> must be made between this table and the [[Deliverables database table|deliverables table]] in which the join predicate is given by the <tt>DeliverableId</tt> of the connection corresponding to the <tt>Id</tt> of the deliverable. The select statement must retrieve the column values of the deliverable with the acception of the <tt>ConnetionId</tt> and <tt>ContainerId</tt>. These are set to the <tt>Id</tt> of the deliverable and <tt>TaskId</tt> of the connection respectively.
-the SQL statement could just look for all those connections for which no deliverable can be found with the <tt>ConnectionId</tt> equal to the connection.
+The result is a table that can be inserted into the [[Deliverables database table|deliverables table]].

Revision as of 19:57, 22 November 2011