<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<title>Iro · Datenbase</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta charset="utf-8">
<meta name="description" content="">
<meta name="keywords" content="">
<link rel="shortcut icon" type="image/x-icon" href="images/favicon.png">
<link rel="stylesheet" href="css/reset.css" type="text/css" media="screen">
<link rel="stylesheet" href="css/960.css" type="text/css" media="screen">
<link rel="stylesheet" href="css/style.css" type="text/css" media="screen">
<!--[if IE]><link rel="stylesheet" href="css/style-ie.css" type="text/css" media="screen" /><![endif] -->
</head>
<body>
<div id="head-container">
<div id="head">
<h1 id="logo"><a href="index.html" class="logo" title="Netzguerilla"><span>Netzguerilla</span></a></h1>
<ul id="menu">
<li><a href="index.html" class="menu">Iro</a></li><li><a href="current.html" class="menu">API Documentation</a></li><li><a href="database.html" class="menu active">Datenbase Schema</a></li><li><a href="about.html" class="menu">About us</a></li>
</ul>
</div>
</div>
<div id="content-container">
<div id="content" class="container_12">
<div id="main" class="grid_9">
<h2>Datenbase Schema</h2>
<div class="item">
<p>
</p>
<ol>
<li value="1">1. <a href="#schema">Datenbase schema</a></li>
<li value="3">3.
<a href="#tables">Tables</a>
<ol>
<li value="2.1">2.1 <a href="#table-apiuser">Apiuser</a></li><li value="2.2">2.2 <a href="#table-offer">Offer</a></li><li value="2.3">2.3 <a href="#table-job">Job</a></li><li value="2.4">2.4 <a href="#table-userright">Userright</a></li><li value="2.5">2.5 <a href="#table-message">Message</a></li>
</ol>
</li>
</ol>
</div><div class="item" id="schema">
<h3>Schema</h3>
<img src="images/db-schema.svg">
<p>Overview of used tables.</p>
</div><div class="item" id="tables">
<h3>Tables</h3>
<div class="item" id="table-apiuser">
<h4>Apiuser</h4>
<p><p>An user in iro.</p></p>
</div><div class="item" id="table-offer">
<h4>Offer</h4>
<p><p>All possible Offers over a Message can be sended. <strong>provider</strong>, <strong>typ</strong> and <strong>route</strong> are used to get the data form configuration file.</p></p>
</div><div class="item" id="table-job">
<h4>Job</h4>
<p><p>A complete Job.</p>
<blockquote>
<ul class="simple">
<li><strong>status</strong> show the status of the job (<tt class="docutils literal">init</tt>, <tt class="docutils literal">started</tt>, <tt class="docutils literal">sending</tt>, <tt class="docutils literal">sended</tt> or <tt class="docutils literal">error</tt>).</li>
<li><strong>info</strong> is used to make it possible to create different billing groups for user.</li>
</ul>
</blockquote></p>
</div><div class="item" id="table-userright">
<h4>Userright</h4>
<p><p>Allowed offers for one user. Default routes are sorted by <strong>default</strong> value.</p></p>
</div><div class="item" id="table-message">
<h4>Message</h4>
<p><p>A message that has created costs.</p>
<blockquote>
<strong>isBilled</strong> is False since the bill is paid.</blockquote></p>
</div>
</div>
</div>
<div class="clear"></div>
</div>
</div>
<div id="foot-container">
<div id="foot">
<p>© 2010-2011 <a href="impressum.html">Netzguerilla.net</a>.</p>
</div>
</div>
</body>
</html>