Difference between revisions of "Public.node (table)"
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | public.node |- |} {| border="1" cellpadding="5" cellspacing="0" style="borde...) |
(No difference)
|
Revision as of 14:14, 7 August 2009
wikibot
| Table | public.node |
| Column | Data Type | Nullable | Default | PK | Index |
| nodeid | not null | pk_nodeid | node_id_type_idx | ||
| dpname | null | node_dpname_idx | |||
| nodecreatetime | not null | ||||
| nodeparentid | null | ||||
| nodetype | null | node_id_type_idx | |||
| nodesysoid | null | ||||
| nodesysname | null | ||||
| nodesysdescription | null | ||||
| nodesyslocation | null | ||||
| nodesyscontact | null | ||||
| nodelabel | null | node_label_idx | |||
| nodelabelsource | null | ||||
| nodenetbiosname | null | ||||
| nodedomainname | null | ||||
| operatingsystem | null | ||||
| lastcapsdpoll | null | ||||
| foreignsource | null | node_foreign_unique_idx | |||
| foreignid | null | node_foreign_unique_idx |
| Relation | Column | Referenced Column |
| public.distpoller | dpname | dpname |
| Detail Table | Column | Referencing Column |
| public.atinterface | nodeid | nodeid |
| public.stpnode | nodeid | nodeid |
| public.stpinterface | nodeid | nodeid |
| public.iprouteinterface | nodeid | nodeid |
| public.datalinkinterface | nodeid | nodeid |
| public.datalinkinterface | nodeid | nodeparentid |
| public.inventory | nodeid | nodeid |
| public.vlan | nodeid | nodeid |
| public.ipinterface | nodeid | nodeid |
| public.snmpinterface | nodeid | nodeid |
| public.ifservices | nodeid | nodeid |
| public.outages | nodeid | nodeid |
| public.assets | nodeid | nodeid |
| public.notifications | nodeid | nodeid |
| public.pathoutage | nodeid | nodeid |
| public.category_node | nodeid | nodeid |
