Commits

Anonymous committed 1330a40

rework qdb schema to fit django admin conventions

Comments (0)

Files changed (2)

 
 <tbody>
 <tr>
-<td>Accounts</td>
+<td>Account</td>
 <td>id</td>
 <td>int</td>
 <td></td>
 <td></td>
 <td>parent</td>
 <td>int</td>
-<td>Accounts</td>
+<td>Account</td>
+<td></td>
 </tr>
 </tbody>
 <tbody>
 <tr>
-<td>Transactions</td>
+<td>Job</td>
+<td>id</td>
+<td>int</td>
+<td></td>
+<td></td>
+<td></td>
+</tr>
+<tr>
+<td></td>
+<td>name</td>
+<td>text</td>
+<td></td>
+<td></td>
+<td></td>
+</tr>
+</tbody>
+<tbody>
+<tr>
+<td>Transaction</td>
 <td>id</td>
 <td>int</td>
 </tr>
 <td></td>
 <td>acct</td>
 <td>int</td>
-<td>Accounts</td>
+<td>Account</td>
 </tr>
 <tr>
 <td></td>
 
 <tbody>
 <tr>
-<td>Splits</td>
+<td>Split</td>
 <td>id</td>
 <td>int</td>
 <td></td>
 <td></td>
 <td>trx</td>
 <td>int</td>
-<td>Transactions</td>
+<td>Transaction</td>
 <td></td>
 <td></td>
 </tr>
 <td></td>
 <td>acct</td>
 <td>int</td>
-<td>Accounts</td>
+<td>Account</td>
 </tr>
 <tr>
 <td></td>
-<td>cat</td>
+<td>job</td>
 <td>int</td>
-<td>Categories</td>
+<td>Job</td>
 </tr>
 <tr>
 <td></td>
 </tbody>
 <tbody>
 <tr>
-<td>Payees</td>
+<td>Payee</td>
 <td>id</td>
 <td>int</td>
 <td></td>
 <td></td>
 </tr>
 </tbody>
-<tbody>
-<tr>
-<td>Classes</td>
-<td>id</td>
-<td>int</td>
-<td></td>
-<td></td>
-<td></td>
-</tr>
-<tr>
-<td></td>
-<td>name</td>
-<td>text</td>
-<td></td>
-<td></td>
-<td></td>
-</tr>
-</tbody>
 </table>
+
+<p>Per <a
+href="http://www.twistedmatrix.com/documents/current/howto/policy/coding-standard#auto15">twisted
+conventions</a>, <q>Database tables will be named with plural nouns</q>.
+Hmm... seems to conflict with <a href="http://www.djangoproject.com/documentation/0.96/tutorial02/">django admin</a> defaults.
+</p>
+
 </body>
 </html>
 <?xml version="1.0"?>
 <r:RDF xmlns:r="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:h="http://www.w3.org/1999/xhtml" xmlns:s="http://www.w3.org/2000/01/rdf-schema#" xmlns:dt="http://www.w3.org/2001/XMLSchema#" xmlns:owl="http://www.w3.org/2002/07/owl#">
-  <owl:Class r:ID="Accounts">
-    <s:label>Accounts</s:label>
+  <owl:Class r:ID="Account">
+    <s:label>Account</s:label>
     <s:subClassOf>
       <owl:Restriction>
         <owl:onProperty>
             <s:comment/>
           </owl:ObjectProperty>
         </owl:onProperty>
-        <owl:allValuesFrom r:resource="#Accounts"/>
+        <owl:allValuesFrom r:resource="#Account"/>
       </owl:Restriction>
     </s:subClassOf>
   </owl:Class>
-  <owl:Class r:ID="Transactions">
-    <s:label>Transactions</s:label>
+  <owl:Class r:ID="Job">
+    <s:label>Job</s:label>
+    <s:subClassOf>
+      <owl:Restriction>
+        <owl:onProperty>
+          <owl:DataTypeProperty r:about="#id">
+            <s:range r:resource="http://www.w3.org/2001/XMLSchema#integer"/>
+            <s:comment/>
+          </owl:DataTypeProperty>
+        </owl:onProperty>
+        <owl:cardinality r:datatype="http://www.w3.org/2001/XMLSchema#integer">1</owl:cardinality>
+      </owl:Restriction>
+    </s:subClassOf>
+    <s:subClassOf>
+      <owl:Restriction>
+        <owl:onProperty>
+          <owl:DataTypeProperty r:about="#name">
+            <s:range r:resource="http://www.w3.org/2001/XMLSchema#string"/>
+            <s:comment/>
+          </owl:DataTypeProperty>
+        </owl:onProperty>
+        <owl:cardinality r:datatype="http://www.w3.org/2001/XMLSchema#integer">1</owl:cardinality>
+      </owl:Restriction>
+    </s:subClassOf>
+  </owl:Class>
+  <owl:Class r:ID="Transaction">
+    <s:label>Transaction</s:label>
     <s:subClassOf>
       <owl:Restriction>
         <owl:onProperty>
             <s:comment/>
           </owl:ObjectProperty>
         </owl:onProperty>
-        <owl:allValuesFrom r:resource="#Accounts"/>
+        <owl:allValuesFrom r:resource="#Account"/>
       </owl:Restriction>
     </s:subClassOf>
     <s:subClassOf>
       </owl:Restriction>
     </s:subClassOf>
   </owl:Class>
-  <owl:Class r:ID="Splits">
-    <s:label>Splits</s:label>
+  <owl:Class r:ID="Split">
+    <s:label>Split</s:label>
     <s:subClassOf>
       <owl:Restriction>
         <owl:onProperty>
             <s:comment/>
           </owl:ObjectProperty>
         </owl:onProperty>
-        <owl:allValuesFrom r:resource="#Transactions"/>
+        <owl:allValuesFrom r:resource="#Transaction"/>
       </owl:Restriction>
     </s:subClassOf>
     <s:subClassOf>
             <s:comment/>
           </owl:ObjectProperty>
         </owl:onProperty>
-        <owl:allValuesFrom r:resource="#Accounts"/>
+        <owl:allValuesFrom r:resource="#Account"/>
       </owl:Restriction>
     </s:subClassOf>
     <s:subClassOf>
       <owl:Restriction>
         <owl:onProperty>
-          <owl:ObjectProperty r:about="#cat">
+          <owl:ObjectProperty r:about="#job">
             <s:comment/>
           </owl:ObjectProperty>
         </owl:onProperty>
-        <owl:allValuesFrom r:resource="#Categories"/>
+        <owl:allValuesFrom r:resource="#Job"/>
       </owl:Restriction>
     </s:subClassOf>
     <s:subClassOf>
       </owl:Restriction>
     </s:subClassOf>
   </owl:Class>
-  <owl:Class r:ID="Payees">
-    <s:label>Payees</s:label>
-    <s:subClassOf>
-      <owl:Restriction>
-        <owl:onProperty>
-          <owl:DataTypeProperty r:about="#id">
-            <s:range r:resource="http://www.w3.org/2001/XMLSchema#integer"/>
-            <s:comment/>
-          </owl:DataTypeProperty>
-        </owl:onProperty>
-        <owl:cardinality r:datatype="http://www.w3.org/2001/XMLSchema#integer">1</owl:cardinality>
-      </owl:Restriction>
-    </s:subClassOf>
-    <s:subClassOf>
-      <owl:Restriction>
-        <owl:onProperty>
-          <owl:DataTypeProperty r:about="#name">
-            <s:range r:resource="http://www.w3.org/2001/XMLSchema#string"/>
-            <s:comment/>
-          </owl:DataTypeProperty>
-        </owl:onProperty>
-        <owl:cardinality r:datatype="http://www.w3.org/2001/XMLSchema#integer">1</owl:cardinality>
-      </owl:Restriction>
-    </s:subClassOf>
-  </owl:Class>
-  <owl:Class r:ID="Classes">
-    <s:label>Classes</s:label>
+  <owl:Class r:ID="Payee">
+    <s:label>Payee</s:label>
     <s:subClassOf>
       <owl:Restriction>
         <owl:onProperty>
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.