Editing Public.node (table)
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone.
Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 2: | Line 2: | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
− | |- | + | |- |
| '''Table | | '''Table | ||
| public.node | | public.node | ||
+ | |- | ||
|} | |} | ||
− | + | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
|- style="background:silver" | |- style="background:silver" | ||
Line 14: | Line 15: | ||
| '''Nullable | | '''Nullable | ||
| '''Default | | '''Default | ||
− | | ''' | + | | '''PK |
− | + | | '''Index | |
− | |- | + | |
+ | |- | ||
| nodeid | | nodeid | ||
− | | | + | | |
| not null | | not null | ||
| | | | ||
+ | | pk_nodeid | ||
+ | | node_id_type_idx | ||
+ | |- | ||
+ | | dpname | ||
| | | | ||
− | |||
− | |||
− | |||
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | node_dpname_idx |
+ | |- | ||
| nodecreatetime | | nodecreatetime | ||
− | | | + | | |
| not null | | not null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| nodeparentid | | nodeparentid | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| nodetype | | nodetype | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | node_id_type_idx |
+ | |- | ||
| nodesysoid | | nodesysoid | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| nodesysname | | nodesysname | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| nodesysdescription | | nodesysdescription | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| nodesyslocation | | nodesyslocation | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| nodesyscontact | | nodesyscontact | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| nodelabel | | nodelabel | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | node_label_idx |
+ | |- | ||
| nodelabelsource | | nodelabelsource | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| nodenetbiosname | | nodenetbiosname | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| nodedomainname | | nodedomainname | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| operatingsystem | | operatingsystem | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| lastcapsdpoll | | lastcapsdpoll | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | |
+ | |- | ||
| foreignsource | | foreignsource | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
− | |- | + | | node_foreign_unique_idx |
+ | |- | ||
| foreignid | | foreignid | ||
− | | | + | | |
| null | | null | ||
| | | | ||
| | | | ||
+ | | node_foreign_unique_idx | ||
|} | |} | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
|- style="background:silver" | |- style="background:silver" | ||
Line 167: | Line 153: | ||
| '''Column | | '''Column | ||
| '''Referenced Column | | '''Referenced Column | ||
− | + | ||
− | |- | + | |- |
| [[public.distpoller_(table)|public.distpoller]] | | [[public.distpoller_(table)|public.distpoller]] | ||
| dpname | | dpname | ||
Line 174: | Line 160: | ||
|} | |} | ||
− | + | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
|- style="background:silver" | |- style="background:silver" | ||
Line 180: | Line 166: | ||
| '''Column | | '''Column | ||
| '''Referencing Column | | '''Referencing Column | ||
− | + | ||
− | |- | + | |- |
| [[public.atinterface_(table)|public.atinterface]] | | [[public.atinterface_(table)|public.atinterface]] | ||
| nodeid | | nodeid | ||
| nodeid | | nodeid | ||
− | |- | + | |- |
| [[public.stpnode_(table)|public.stpnode]] | | [[public.stpnode_(table)|public.stpnode]] | ||
| nodeid | | nodeid | ||
| nodeid | | nodeid | ||
− | |- | + | |- |
| [[public.stpinterface_(table)|public.stpinterface]] | | [[public.stpinterface_(table)|public.stpinterface]] | ||
| nodeid | | nodeid | ||
| nodeid | | nodeid | ||
− | |- | + | |- |
| [[public.iprouteinterface_(table)|public.iprouteinterface]] | | [[public.iprouteinterface_(table)|public.iprouteinterface]] | ||
| nodeid | | nodeid | ||
| nodeid | | nodeid | ||
− | |- | + | |- |
| [[public.datalinkinterface_(table)|public.datalinkinterface]] | | [[public.datalinkinterface_(table)|public.datalinkinterface]] | ||
| nodeid | | nodeid | ||
| nodeid | | nodeid | ||
− | |- | + | |- |
| [[public.datalinkinterface_(table)|public.datalinkinterface]] | | [[public.datalinkinterface_(table)|public.datalinkinterface]] | ||
| nodeid | | nodeid | ||
| nodeparentid | | nodeparentid | ||
− | |- | + | |- |
| [[public.inventory_(table)|public.inventory]] | | [[public.inventory_(table)|public.inventory]] | ||
| nodeid | | nodeid | ||
| nodeid | | nodeid | ||
− | |- | + | |- |
| [[public.vlan_(table)|public.vlan]] | | [[public.vlan_(table)|public.vlan]] | ||
| nodeid | | nodeid | ||
| nodeid | | nodeid | ||
− | |- | + | |- |
| [[public.ipinterface_(table)|public.ipinterface]] | | [[public.ipinterface_(table)|public.ipinterface]] | ||
| nodeid | | nodeid | ||
| nodeid | | nodeid | ||
− | |- | + | |- |
| [[public.snmpinterface_(table)|public.snmpinterface]] | | [[public.snmpinterface_(table)|public.snmpinterface]] | ||
| nodeid | | nodeid | ||
| nodeid | | nodeid | ||
− | |- | + | |- |
| [[public.ifservices_(table)|public.ifservices]] | | [[public.ifservices_(table)|public.ifservices]] | ||
| nodeid | | nodeid | ||
| nodeid | | nodeid | ||
− | |- | + | |- |
| [[public.outages_(table)|public.outages]] | | [[public.outages_(table)|public.outages]] | ||
| nodeid | | nodeid | ||
| nodeid | | nodeid | ||
− | |- | + | |- |
| [[public.assets_(table)|public.assets]] | | [[public.assets_(table)|public.assets]] | ||
| nodeid | | nodeid | ||
| nodeid | | nodeid | ||
− | |- | + | |- |
| [[public.notifications_(table)|public.notifications]] | | [[public.notifications_(table)|public.notifications]] | ||
| nodeid | | nodeid | ||
| nodeid | | nodeid | ||
− | |- | + | |- |
| [[public.pathoutage_(table)|public.pathoutage]] | | [[public.pathoutage_(table)|public.pathoutage]] | ||
| nodeid | | nodeid | ||
| nodeid | | nodeid | ||
− | |- | + | |- |
| [[public.category_node_(table)|public.category_node]] | | [[public.category_node_(table)|public.category_node]] | ||
| nodeid | | nodeid | ||
| nodeid | | nodeid | ||
|} | |} |