17 <body> |
17 <body> |
18 <div id="head-container"> |
18 <div id="head-container"> |
19 <div id="head"> |
19 <div id="head"> |
20 <h1 id="logo"><a href="index.html" class="logo" title="Netzguerilla"><span>Netzguerilla</span></a></h1> |
20 <h1 id="logo"><a href="index.html" class="logo" title="Netzguerilla"><span>Netzguerilla</span></a></h1> |
21 <ul id="menu"> |
21 <ul id="menu"> |
22 <li><a href="index.html" class="menu">Iro</a></li><li><a href="current.html" class="menu">API Documentation</a></li><li><a href="new.html" class="menu">geplante API Documentation</a></li><li><a href="database.html" class="menu active">Datenbank Schema</a></li><li><a href="impressum.html" class="menu">Impressum</a></li> |
22 <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> |
23 </ul> |
23 </ul> |
24 </div> |
24 </div> |
25 </div> |
25 </div> |
26 <div id="content-container"> |
26 <div id="content-container"> |
27 <div id="content" class="container_12"> |
27 <div id="content" class="container_12"> |
28 <div id="main" class="grid_9"> |
28 <div id="main" class="grid_9"> |
29 <h2>Datenbank Schema</h2> |
29 <h2>Datenbase Schema</h2> |
30 <div class="item"> |
30 <div class="item"> |
31 <p> |
31 <p> |
32 </p> |
32 </p> |
33 <ol> |
33 <ol> |
34 <li value="1">1. <a href="#schema">Datenbankschema</a></li> |
34 <li value="1">1. <a href="#schema">Datenbase schema</a></li> |
35 <li value="3">3. |
35 <li value="3">3. |
36 <a href="#tables">Tabellen</a> |
36 <a href="#tables">Tables</a> |
37 <ol> |
37 <ol> |
38 <li value="2.1">2.1 <a href="#table-apiuser">Apiuser</a></li><li value="2.2">2.2 <a href="#table-job">Job</a></li><li value="2.3">2.3 <a href="#table-message">Message</a></li><li value="2.4">2.4 <a href="#table-offer">Offer</a></li><li value="2.5">2.5 <a href="#table-userright">Userright</a></li> |
38 <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> |
39 </ol> |
39 </ol> |
40 </li> |
40 </li> |
41 </ol> |
41 </ol> |
42 </div><div class="item" id="schema"> |
42 </div><div class="item" id="schema"> |
43 <h3>Schema</h3> |
43 <h3>Schema</h3> |
44 <img src="images/db-schema.svg"> |
44 <img src="images/db-schema.svg"> |
45 <p>Dies ist eine Übersicht der benutzen Tabellen die Iro benötigt.</p> |
45 <p>Overview of used tables.</p> |
46 </div><div class="item" id="tables"> |
46 </div><div class="item" id="tables"> |
47 <h3>Tabellen</h3> |
47 <h3>Tables</h3> |
48 <div class="item" id="table-apiuser"> |
48 <div class="item" id="table-apiuser"> |
49 <h4>Apiuser</h4> |
49 <h4>Apiuser</h4> |
50 <p>Die Benutzerdatenbank von Iro.</p> |
50 <p><p>An user in iro.</p></p> |
|
51 </div><div class="item" id="table-offer"> |
|
52 <h4>Offer</h4> |
|
53 <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> |
51 </div><div class="item" id="table-job"> |
54 </div><div class="item" id="table-job"> |
52 <h4>Job</h4> |
55 <h4>Job</h4> |
53 <p>Ein kompletter Auftrag, der an Iro zum verschicken übergeben wird. Status zeigt den generellen Status des Auftrages an (<em>init</em>, <em>started</em>, <em>sending</em>, <em>sended</em> oder <em>error</em>). <em>info</em> wird verwendet um dem Benutzer eine Möglickeit zu geben verschiede Auftragsgruppen zu erstellen.</p> |
56 <p><p>A complete Job.</p> |
|
57 <blockquote> |
|
58 <ul class="simple"> |
|
59 <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> |
|
60 <li><strong>info</strong> is used to make it possible to create different billing groups for user.</li> |
|
61 </ul> |
|
62 </blockquote></p> |
|
63 </div><div class="item" id="table-userright"> |
|
64 <h4>Userright</h4> |
|
65 <p><p>Allowed offers for one user. Default routes are sorted by <strong>default</strong> value.</p></p> |
54 </div><div class="item" id="table-message"> |
66 </div><div class="item" id="table-message"> |
55 <h4>Message</h4> |
67 <h4>Message</h4> |
56 <p>Wenn ein Vorgang von Iro Kosten erzeugt hat wird eine neue Zeile eingefügt. Solange nicht bezahlt wurde ist <em>isBilled=0</em>.</p> |
68 <p><p>A message that has created costs.</p> |
57 </div><div class="item" id="table-offer"> |
69 <blockquote> |
58 <h4>Offer</h4> |
70 <strong>isBilled</strong> is False since the bill is paid.</blockquote></p> |
59 <p>Alle Routen über die SMS, Faxe und Mails verschickt werden könnnen. <em>provider</em>, <em>typ</em> und <em>route</em> werden verwendet, um die entsprechenden Zugangsdaten laden zu können.</p> |
|
60 </div><div class="item" id="table-userright"> |
|
61 <h4>Userright</h4> |
|
62 <p>Über welche Routen darf ein Benutzer Daten verschicken und welches sind die Standardrouten (<em>isDefault=1</em>) für den Benuter.</p> |
|
63 </div> |
71 </div> |
64 </div> |
72 </div> |
65 </div> |
73 </div> |
66 <div class="clear"></div> |
74 <div class="clear"></div> |
67 </div> |
75 </div> |