http://dbshelp.devio.at/index.php?action=history&feed=atom&title=Public.assets_%28table%29 Public.assets (table) - Revision history 2026-05-30T21:48:43Z Revision history for this page on the wiki MediaWiki 1.30.0 http://dbshelp.devio.at/index.php?title=Public.assets_(table)&diff=2949&oldid=prev Bot at 09:09, 27 August 2011 2011-08-27T09:09:03Z <p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr style="vertical-align: top;" lang="en"> <td colspan="2" style="background-color: white; color:black; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: white; color:black; text-align: center;">Revision as of 09:09, 27 August 2011</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l20" >Line 20:</td> <td colspan="2" class="diff-lineno">Line 20:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>| integer</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>| integer</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>| not null</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>| not null</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>| <del class="diffchange diffchange-inline">nextval('opennmsnxtid'::regclass)</del></div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>| &#160;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>| &#160;</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>| &#160;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|- valign=&quot;top&quot;</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|- valign=&quot;top&quot;</div></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l293" >Line 293:</td> <td colspan="2" class="diff-lineno">Line 293:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>| '''Columns</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>| '''Columns</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|- valign=&quot;top&quot;</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">| assets_an_idx</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">| </ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">| assetnumber</ins></div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|- valign=&quot;top&quot;</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|- valign=&quot;top&quot;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>| assets_nodeid_idx</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>| assets_nodeid_idx</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>| &#160;</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>| &#160;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>| nodeid</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>| nodeid</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">|- valign=&quot;top&quot;</del></div></td><td colspan="2">&#160;</td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">| assets_an_idx</del></div></td><td colspan="2">&#160;</td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">| </del></div></td><td colspan="2">&#160;</td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">| assetnumber</del></div></td><td colspan="2">&#160;</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|}</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|}</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr> <!-- diff cache key dbshelp:diff:version:1.11a:oldid:2831:newid:2949 --> </table> Bot http://dbshelp.devio.at/index.php?title=Public.assets_(table)&diff=2831&oldid=prev Bot at 22:38, 24 June 2010 2010-06-24T22:38:27Z <p></p> <a href="http://dbshelp.devio.at/index.php?title=Public.assets_(table)&amp;diff=2831&amp;oldid=2339">Show changes</a> Bot http://dbshelp.devio.at/index.php?title=Public.assets_(table)&diff=2339&oldid=prev Bot at 07:31, 11 February 2010 2010-02-11T07:31:19Z <p></p> <a href="http://dbshelp.devio.at/index.php?title=Public.assets_(table)&amp;diff=2339&amp;oldid=731">Show changes</a> Bot http://dbshelp.devio.at/index.php?title=Public.assets_(table)&diff=731&oldid=prev Bot at 13:42, 7 August 2009 2009-08-07T13:42:47Z <p></p> <a href="http://dbshelp.devio.at/index.php?title=Public.assets_(table)&amp;diff=731&amp;oldid=645">Show changes</a> Bot http://dbshelp.devio.at/index.php?title=Public.assets_(table)&diff=645&oldid=prev Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | public.assets |- |} {| border="1" cellpadding="5" cellspacing="0" style="bor... 2009-08-07T13:13:52Z <p>New page: == wikibot == {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot; |- | &#039;&#039;&#039;Table | public.assets |- |} {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;bor...</p> <p><b>New page</b></p><div>== wikibot ==<br /> <br /> {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot;<br /> |-<br /> | '''Table<br /> | public.assets<br /> |-<br /> |}<br /> <br /> <br /> {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot;<br /> |- style=&quot;background:silver&quot;<br /> | '''Column<br /> | '''Data Type<br /> | '''Nullable<br /> | '''Default<br /> | '''PK<br /> | '''Index<br /> <br /> |-<br /> | id<br /> | <br /> | not null<br /> | nextval('opennmsnxtid'::regclass)<br /> | pk_assetid<br /> | <br /> |-<br /> | nodeid<br /> | <br /> | null<br /> | <br /> | <br /> | assets_nodeid_idx<br /> |-<br /> | category<br /> | <br /> | not null<br /> | <br /> | <br /> | <br /> |-<br /> | manufacturer<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | vendor<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | modelnumber<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | serialnumber<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | description<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | circuitid<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | assetnumber<br /> | <br /> | null<br /> | <br /> | <br /> | assets_an_idx<br /> |-<br /> | operatingsystem<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | rack<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | slot<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | port<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | region<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | division<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | department<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | address1<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | address2<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | city<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | state<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | zip<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | building<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | floor<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | room<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | vendorphone<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | vendorfax<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | vendorassetnumber<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | userlastmodified<br /> | <br /> | not null<br /> | <br /> | <br /> | <br /> |-<br /> | lastmodifieddate<br /> | <br /> | not null<br /> | <br /> | <br /> | <br /> |-<br /> | dateinstalled<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | lease<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | leaseexpires<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | supportphone<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | maintcontract<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | maintcontractexpires<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | displaycategory<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | notifycategory<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | pollercategory<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | thresholdcategory<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | comment<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | managedobjectinstance<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |-<br /> | managedobjecttype<br /> | <br /> | null<br /> | <br /> | <br /> | <br /> |}<br /> <br /> <br /> <br /> {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot;<br /> |- style=&quot;background:silver&quot;<br /> | '''Relation<br /> | '''Column<br /> | '''Referenced Column<br /> <br /> |-<br /> | [[public.node_(table)|public.node]]<br /> | nodeid<br /> | nodeid<br /> |}</div> Bot