ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Back
History
public.ipinterface_(table)
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Table''' | public.ipinterface |} === Columns === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description''' |- valign="top" | id | integer | not null | | |- valign="top" | nodeid | integer | not null | | |- valign="top" | ipaddr | varchar(16) | not null | | |- valign="top" | ifindex | integer | null | | |- valign="top" | iphostname | varchar(256) | null | | |- valign="top" | ismanaged | char(1) | null | | |- valign="top" | ipstatus | integer | null | | |- valign="top" | iplastcapsdpoll | timestamp with time zone | null | | |- valign="top" | issnmpprimary | char(1) | null | | |- valign="top" | snmpinterfaceid | integer | null | | |} === Primary Key === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Primary Key''' | '''Columns''' |- valign="top" | ipinterface_pkey | id |} === Indexes === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Index''' | '''Type''' | '''Columns''' |- valign="top" | ipinterface_ipaddr_idx | | ipaddr |- valign="top" | ipinterface_ipaddr_ismanaged_idx | | ipaddr, ismanaged |- valign="top" | ipinterface_nodeid_idx | | nodeid |- valign="top" | ipinterface_nodeid_ipaddr_ismanaged_idx | | nodeid, ipaddr, ismanaged |- valign="top" | ipinterface_nodeid_ipaddr_notzero_idx | | nodeid, ipaddr |- valign="top" | ipinterface_nodeid_ismanaged_idx | | ipaddr |- valign="top" | ipinterface_snmpinterfaceid_idx | | snmpinterfaceid |} === Foreign Keys === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Relation''' | '''Column''' | '''Referenced Column''' |- valign="top" | [[public.node_(table)|public.node]] | nodeid | nodeid |- valign="top" | [[public.snmpinterface_(table)|public.snmpinterface]] | snmpinterfaceid | id |} === Detail Tables === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Detail Table''' | '''Column''' | '''Referencing Column''' |- valign="top" | [[public.ifservices_(table)|public.ifservices]] | id | ipinterfaceid |} === Triggers === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Trigger''' | '''Type''' | '''Function''' |- valign="top" | setsnmpinterfacekeysoninserttrigger | STATEMENT AFTER | setsnmpinterfacekeysoninsert |- valign="top" | setsnmpinterfacekeysonupdatetrigger | STATEMENT AFTER | setsnmpinterfacekeysonupdate |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.