• Access/AccessGroup
  • AdminTeam
  • AdminTeam_Member
  • AdminTeam_Orgs
  • AdminTeam_Owner
  • Consultant
  • DHCPapplication
  • DHCPoption
  • DHCPoption_Application
  • DHCPservice
  • DHCPservice_Options
  • Domain
  • Domain_Owner
  • GlobalDefault
  • Interface
  • InterfaceType
  • Interface_DHCPoptions
  • IPaddress
  • IPaddressSpace
  • IPaddressSpace_DHCPoptions
  • IPaddressSpace_Owner
  • LimitedNames
  • LNA
  • LNAteam/AdminTeam_Orgs
  • Location
  • Log
  • LogIPaddress
  • LogName
  • Mfgr/Make
  • Model
  • ModelType
  • MXrecord
  • Name
  • NameForSearch
  • NameType
  • Network
  • Network_DHCPoptions
  • Network_Location
  • Network_Owner
  • Node
  • NodeGrp*
  • NodeTag
  • NodeType
  • Node_Admin
  • Node_NodeGrp
  • Node_NodeType
  • Node_OS
  • Node_Owner
  • Node_ServiceType/Service
  • Node_User
  • Organization
  • OS
  • Owner
  • ParentNodeGrp
  • Person
  • ResName
  • ResName_Owner
  • ServiceType/Service
  • State
  • Users
  • Users_Access/AccessGroup
  • Users_NodeTemplate
  • Users_Owner
  • deleted_IPaddressSpace
  • temp_ip* 
    •   Access                                       AccessGroup                                                
      (                                            (                                                          
          idAccess        handle                       id              int                                    
          snmLabel        shrtname                     label           varchar(32)                            
          snmLowerLabel   shrtname                     lower(label)                                    
          dsDescription   description                  description     varchar(64)                            
          flgDefault      flag                         default_access  numeric(1)                             
          snmDisplayLabel shrtname                     display_label   varchar(32)                            
      )                                            )                                                          
      AdminTeam                                    AdminTeam                                                  
      (                                            (                                                          
          idAdminTeam  handle                          id              int                                    
          nmName       name                            name            varchar(64)                            
          nmLowerName  name                            lower(name)                                     
          vstrEmail    varstring                       email           varchar(256)                           
          dwrdPhone    dword                           phone           varchar(32)                            
          dwrdCreated  dword                           created_by      int                                    
          dwrdModified dword                           modified_by     int                                    
          dtCreated    datetime                        created         timestamp(3)                           
          dtModified   datetime                        modified        timestamp(3)                           
          dwrdLockUser dword                           locked_by       int                                    
          dtLocked     datetime                        locked          timestamp(3)                           
          cmComment    comment                         comments        varchar(256)                           
      )                                            )                                                          
      AdminTeam_Member                             AdminTeam_Member                                           
      (                                            (                                                          
          idAdminTeam  handle                          adminteam       int                                    
          dwrdPerRegID dword                           person          int                                    
      )                                            )                                                          
      AdminTeam_Owner                              AdminTeam_Owner                                            
      (                                            (                                                          
          idOwner     handle                           adminteam       int                                    
          idAdminTeam handle                           owner           int                                    
      )                                            )                                                          
      Consultant                                   Consultant                                                 
      (                                            (                                                          
          dwrdPerRegID   dword                         person           int                                   
          idOrganization handle                        organization     int                                   
          flgPrimary     flag                          primary          numeric(1)                            
      )                                            )                                                          
      DHCPapplication                              DHCPapplication                                            
      (                                            (                                                          
          wrdLabel      word                           label        varchar(16)                               
          dsDescription description                    description  varchar(64)                               
      )                                            )                                                          
      DHCPoption                                   DHCPoption                                                 
      (                                            (                                                          
          idDHCPoption handle                          id        int                                          
          wrdDataType  word                            datatype  varchar(16)                                  
          nmLabel      name                            label     varchar(64)                                  
          wrdType      word                            type      varchar(16)                                  
      )                                            )                                                          
      DHCPoption_Application                       DHCPoption_Application                                     
      (                                            (                                                          
          idDHCPoption handle                          DHCPoption     int                                     
          wrdLabel     word                            label          varchar(16)                             
      )                                            )                                                          
      DHCPservice                                  DHCPservice                                                
      (                                            (                                                          
          idDHCPservice handle                         id            int                                      
          snmLabel      shrtname                       label         varchar(32)                              
          dwrdModified  dword                          modified_by   int                                      
          dtModified    datetime                       modified      timestamp(3)                             
          dsDescription description                    description   varchar(64)                              
      )                                            )                                                          
      DHCPservice_Options                          DHCPservice_Options                                        
      (                                            (                                                          
          idDHCPservice handle                         DHCPservice     int                                    
          idDHCPoption  handle                         DHCPoption      int                                    
          strValue      varstring                      value           varchar(256)                           
      )                                            )                                                          
      Domain                                       Domain                                                     
      (                                            (                                                          
          idDomain     handle                          id           int                                       
          fqdnDomain   fqdname                         domain       varchar(256)                              
          fqdnLower    fqdname                         lower(domain)                                   
          dwrdCreated  dword                           created_by   int                                       
          dwrdModified dword                           modified_by  int                                       
          dtCreated    datetime                        created      timestamp(3)                              
          dtModified   datetime                        modified     timestamp(3)                              
          flgLimited   flag                            limited      numeric(1)                                
          flgAllowName flag                            allow_name   numeric(1)                                
          dwrdLockUser dword                           locked_by    int                                       
          dtLocked     datetime                        locked       timestamp(3)                              
          cmComment    comment                         comments     varchar(256)                              
      )                                            )                                                          
      Domain_Owner                                 Domain_Owner                                               
      (                                            (                                                          
          idDomain handle                              domain  int                                            
          idOwner  handle                              owner   int                                            
      )                                            )                                                          
      GlobalDefault                                GlobalDefault                                              
      (                                            (                                                          
          idDefault     handle                         id              int                                    
          snmLabel      shrtname                       label           varchar(32)                            
          strValue      varstring                      str_value       varchar(256)                           
          intValue      int                            int_value       int                                    
          idValue       numeric(10,0)                  id_value        int                                    
          dsDescription description                    description     varchar(64)                            
          dsLabel       description                    display_label   varchar(64)                            
      )                                            )                                                          
      Interface                                    Interface                                                  
      (                                            (                                                          
          idInterface       handle                     id          int                                        
          snmInterType      shrtname                   type        varchar(32)                                
          snmLowerInterType shrtname                   lower(type)                                     
          idNode            numeric(10,0)              node        int                                        
          intRank           int                        deprecated                                      
          flgRoaming        flag                       roam        numeric(1)                                 
          flgDHCP           flag                       DHCP        numeric(1)                                 
          strHWaddress      shrtname                   HW_address  varchar(32)                                
      )                                            )                                                          
      InterfaceType                                InterfaceType                                              
      (                                            (                                                          
          snmInterType      shrtname                   type        varchar(32)                                
          dsDescription     description                description varchar(64)                                
          snmLowerInterType shrtname                                                                          
      )                                            )                                                          
      Interface_DHCPoptions                        Interface_DHCPoptions                                      
      (                                            (                                                          
          idInterface  handle                          interface   int                                        
          idDHCPoption handle                          DHCPoption  int                                        
          strValue     varstring                       value       varchar(256)                               
      )                                            )                                                          
      IPaddress                                    IPaddress                                                  
      (                                            (                                                          
                                                       id                int                                  
          ipAddress        ip                          IPaddress         varchar(39)                          
          strIPaddress     varchar(16)                 IPaddress_txt     varchar(39)                          
          idStaticIPnode   handle                      deprecated                                      
          flgActive        flag                        active            numeric(1)                           
                                                       PTRpref           numeric(1)                           
          idIPCNode        handle                      IPCnode           int                                  
          idInterface      handle                      interface         int                                  
          idipAddressSpace handle                      IPaddressSpace    int                                  
          closestNameID    handle                      closest_name      int                                  
          dwrdReserved     dword                       reserved_by       int                                  
          dtModified       datetime                    reserved          timestamp(3)                         
      )                                            )                                                          
      IPaddressSpace                               IPaddressSpace                                             
      (                                            (                                                          
          idipAddressSpace handle                      id             int                                     
          idNetwork        handle                      network        int                                     
          dsComment        description                 comments       varchar(64)                             
                                                       prefix         varchar(43)                             
          strPrefix        varchar(19)                 prefix_txt     varchar(43)                             
          ipAddressSpace   ip                          address        varchar(39)                             
          strAddress       varchar(15)                 address_txt    varchar(39)                             
          ipBroadcast      ip                          broadcast      varchar(39)                             
          strBroadcast     varchar(15)                 broadcast_txt  varchar(39)                             
          ipLowRes         ip                          lowres         varchar(39)                             
          ipHighRes        ip                          highres        varchar(39)                             
          tntPrefixLength  tinyint                     IP.masklen(prefix)                              
          ipNetmask        ip                                                                                 
          strNetmask       varchar(15)                                                                        
      )                                            )                                                          
      IPaddressSpace_DHCPoptions                   IPaddressSpace_DHCPoptions                                 
      (                                            (                                                          
          idipAddressSpace handle                      IPaddressSpace  int                                    
          idDHCPoption     handle                      DHCPoption      int                                    
          strValue         varstring                   value           varchar(256)                           
      )                                            )                                                          
      IPaddressSpace_Owner                         IPaddressSpace_Owner                                       
      (                                            (                                                          
          idipAddressSpace handle                      IPaddressSpace  int                                    
          idOwner          handle                      owner           int                                    
      )                                            )                                                          
      LimitedNames                                 LimitedNames                                               
      (                                            (                                                          
          nmLower name                                 name  varchar(64)                                      
      )                                            )                                                          
      LNA                                          LNA                                                        
      (                                            (                                                          
          idUser         handle                        lna          int                                       
          idOrganization handle                        organization int                                       
          flgOfficial    flag                          official     numeric(1)                                
      )                                            )                                                          
      LNAteam                                      AdminTeam_Orgs                                             
      (                                            (                                                          
          idAdminTeam    handle                        adminteam    int                                       
          idOrganization handle                        organization int                                       
      )                                            )                                                          
      Location                                     Location                                                   
      (                                            (                                                          
          idLocation  handle                           id     int                                             
          nmName      name                             name   varchar(64)                                     
          nmLowerName name                             lower(name)                                     
          wrdSite     word                             site   varchar(16)                                     
          wrdCode     word                             code   varchar(16)                                     
      )                                            )


      Log                                          Log                                                        
      (                                            (                                                          
          idLog        handle                          id                  int                                
          dwrdPerRegId dword                           person              int                                
          wrdAction    word                            action              varchar(16)                        
          snmObject    shrtname                        recordtype          varchar(32)                        
                                                       recordtype_display  varchar(32)                        
          fqdnName     fqdname                         LogName.name                                    
          idObject     handle                          record_id           int                                
          dtDate       datetime                        logdate             timestamp(3)                       
      )                                            )                                                          
      LogIPaddress                                 LogIPaddress                                               
      (                                            (                                                          
          idLog        handle                          log_id         int                                     
          ipAddress    ip                              IPaddress      varchar(39)                             
          strIPAddress varchar(15)                     IPaddress_txt  varchar(39)                             
      )                                            )                                                          
      LogName                                      LogName                                                    
      (                                            (                                                          
          idLog       handle                            log_id    int                                         
          fqdnName     name                             name  varchar(256)                                    
      )                                            )                                                          
      Mfgr                                         Make                                                       
      (                                            (                                                          
          snmMfgr    shrtname                          make  varchar(32)                                      
          snmLowMfgr shrtname                          lower(make)                                     
      )                                            )                                                          
      Model                                        Model                                                      
      (                                            (                                                          
          idModel           handle                     id           int                                       
          snmMfgr           shrtname                   make         varchar(32)                               
          snmModelName      shrtname                   modelname    varchar(32)                               
          snmLowMfgr        shrtname                   lower(make)                                     
          snmLowerModelName shrtname                   lower(modelname)                                
          snmModelType      shrtname                   modeltype    varchar(32)                               
          snmLowerModelType shrtname                   lower(modeltype)                                
          dwrdModified      dword                      modified_by  int                                       
          dtModified        datetime                   modified     timestamp(3)                              
      )                                            )                                                          
      ModelType                                    ModelType                                                  
      (                                            (                                                          
          snmModelType      shrtname                   modeltype    varchar(32)                               
          snmLowerModelType shrtname                   lower(modeltype)                                
          dsDescription     description                description  varchar(64)                               
      )                                            )                                                          
      MXrecord                                     MXrecord                                                   
      (                                            (                                                          
          idMXsent handle                              sent_to     int                                        
          idName   handle                              received_by int                                        
          intPref  int                                 preference  int                                        
      )                                            )                                                          
      Name                                         Name                                                       
      (                                            (                                                          
          idName        handle                         id             int                                     
          nmName        name                           name           varchar(64)                             
          nmLower       name                           lower(name)                                     
          idDomain      handle                         domain         int                                     
                                                       fullname       varchar(256)                            
          fqdnName      fqdname                        fullname_lc    varchar(256)                            
          wrdLabel      word                           label          varchar(16)                             
          wrdDNSLabel   word                           DNSlabel       varchar(16)                             
          ipAddress     ip                             IPaddress      int                                     
          idAliasname   handle                         aliasee        int                                     
          idInterface   handle                         interface      int                                     
          idNode        handle                         node           int                                     
          idNodegrp     handle                         removed                                         
          idNetwork     handle                         network        int                                     
          dwrdReserved  dword                          reserved_by    int                                     
          dtStamp       datetime                       reserved       timestamp(3)                            
          idRelatedNode handle                         related_node   int                                     
      )                                            )                                                          
      NameForSearch                                What is this and why do we need it? 
      (                                                                                                       
          idName       handle                          And if we need it, can we use a 
          nmName       name                            materialized view?              
          nmLower      name                                                                                   
          idDomain     handle                                                                                 
          wrdLabel     word                                                                                   
          wrdDNSLabel  word                                                                                   
          ipAddress    ip                                                                                     
          idAliasname  handle                                                                                 
          idInterface  handle                                                                                 
          idNode       handle                                                                                 
          idNodegrp    handle                                                                                 
          idNetwork    handle                                                                                 
      )                                                                                                       
      NameType                                     NameType                                                   
      (                                            (                                                          
          wrdLabel      word                           label        varchar(16)                               
          wrdDNSLabel   word                           DNSlabel     varchar(16)                               
          dsDescription description                    description  varchar(64)                               
      )                                            )                                                          
      Network                                      Network                                                    
      (                                            (                                                          
          idNetwork     handle                         id              int                                    
          idDHCPservice handle                         DHCPservice     int                                    
          dwrdCreated   dword                          created_by      int                                    
          dwrdModified  dword                          modified_by     int                                    
          dtCreated     datetime                       created         timestamp(3)                           
          dtModified    datetime                       modified        timestamp(3)                           
          dsComment     comment                        comments        varchar(256)                           
          dwrdLockUser  dword                          locked_by       int                                    
          dtLocked      datetime                       locked          timestamp(3)                           
      )                                            )                                                          
      Network_DHCPoptions                          Network_DHCPoptions                                        
      (                                            (                                                          
          idNetwork    numeric(10,0)                   network     int                                        
          idDHCPoption handle                          DHCPoption  int                                        
          strValue     varstring                       value       varchar(256)                               
      )                                            )                                                          
                                                   Network_Location    * This is a new table added     
                                                   (                     for the HostReg project.      
                                                       network  int                                           
                                                       location int                                           
                                                   )                                                          
      Network_Owner                                Network_Owner                                              
      (                                            (                                                          
          idNetwork numeric(10,0)                      network int                                            
          idOwner   handle                             owner   int                                            
      )                                            )                                                          
      Node                                         Node                                                       
      (                                            (                                                          
          idNode           handle                      id              int                                    
          idOrganization   handle                      organization    int                                    
          idLocation       handle                      location        int                                    
          wrdRoom          dword                       room            varchar(32)                            
          snmQuality       shrtname                    state           varchar(32)                            
          idModel          handle                      model           int                                    
          dwrdCreated      dword                       created_by      int                                    
          dwrdModified     dword                       modified_by     int                                    
          dtCreated        datetime                    created         timestamp(3)                           
          dtModified       datetime                    modified        timestamp(3)                           
          dsComment        comment                     comments        varchar(256)                           
          tntPTRpref       tinyint                     moved to IPaddress                              
          dtExpiration     datetime                    expiration      timestamp(3)                           
          idDHCPservice    handle                      DHCPservice     int                                    
          idipAddressSpace handle                      IPaddressSpace  int                                    
          idUserOwner      handle                      deprecated                                      
          dwrdLockUser     dword                       locked_by       int                                    
          dtLocked         datetime                    locked          timestamp(3)                           
      )                                            )                                                          
      *NodeGrp*                                    *NodeGrp* removed                                   
                                                                                                              
                                                       All Node Group tables have been                 
                                                       removed from this version.                      
                                                                                                              
      NodeTag                                      NodeTag                                                    
      (                                            (                                                          
          idNode   handle                              node   int                                             
          sdsLabel shrtdescription                     label  varchar(32)                                     
          dsData   description                         value  varchar(256)                                    
      )                                            )                                                          
      NodeType                                     NodeType                                                   
      (                                            (                                                          
          snmNodeType      shrtname                    type         varchar(32)                               
          dsDescription    description                 description  varchar(64)                               
          snmLowerNodeType shrtname                    accessgroup  int                                       
          idAccess         handle                  )                                                          
      )                                                                                                       
      Node_Admin                                   Node_Admin                                                 
      (                                            (                                                          
          idNodeAdmin     handle                       id        int                                          
          intRank         int                          deprecated                                      
          idNode          handle                       node      int                                          
          idAdminTeam     handle                       adminteam int                                          
          dwrdPerRegId    dword                        person    int                                          
          flgSrvTabAccess flag                         deprecated                                      
      )                                             )                                                         
      Node_NodeType                                Node_NodeType                                              
      (                                            (                                                          
          idNode           handle                      node  int                                              
          snmNodeType      shrtname                    type  varchar(32)                                      
          snmLowerNodeType shrtname                    lower(type)                                     
      )                                             )                                                         
      Node_OS                                      Node_OS                                                    
      (                                            (                                                          
          idNode      handle                           node    int                                            
          snmOS       shrtname                         os      varchar(32)                                    
          snmLowOS    shrtname                         lower(os)                                       
          dwrdVersion dword                            version varchar(32)                                    
      )                                            )                                                          
      Node_Owner                                   Node_Owner                                                 
      (                                            (                                                          
          idNode  handle                               node  int                                              
          idOwner handle                               owner int                                              
      )                                            )                                                          
      Node_ServiceType                             Node_Service                                               
      (                                            (                                                          
          idNode          handle                       node        int                                        
          snmSvcType      shrtname                     service     varchar(32)                                
          snmLowerSvcType shrtname                     lower(service)                                  
      )                                            )                                                          
      Node_User                                    Node_User                                                  
      (                                            (                                                          
          idNode       handle                          node    int                                            
          dwrdPerRegId dword                           person  int                                            
      )                                            )                                                          
      Organization                                 Organization                                               
      (                                            (                                                          
          idOrganization      handle                   id            int                                      
          dwrdOrgRegId        dword                    org_regid     varchar(32)                              
          nmOrganization      name                     organization  varchar(64)                              
          nmLowerOrganization name                     lower(organization)                             
      )                                            )                                                          
      OS                                           OS                                                         
      (                                            (                                                          
          snmOS         shrtname                       os           varchar(32)                               
          snmLowOS      shrtname                       lower(os)                                       
          dsDescription description                    description  varchar(64)                               
          dwrdModified  dword                          modified_by  int                                       
          dtModified    datetime                       modified     timestamp(3)                              
      )                                            )                                                          
      Owner                                        Owner                                                      
      (                                            (                                                          
          idOwner       handle                         id          int                                        
          snmLabel      shrtname                       label       varchar(32)                                
          dsDescription comment                        description varchar(256)                               
          dwrdCreated   dword                          created_by  int                                        
          dwrdModified  dword                          modified_by int                                        
          dtCreated     datetime                       created     timestamp(3)                               
          dtModified    datetime                       modified    timestamp(3)                               
          dwrdLockUser  dword                          locked_by   int                                        
          snmLower      shrtname                       lower(label)                                    
          dtLocked      datetime                       locked      timestamp(3)                               
      )                                            )                                                          
      Person                                       Person                                                     
      (                                            (                                                          
                                                       id              int                                    
          dwrdPerRegId    dword                        person_regid    varchar(32)                            
          nmName          name                         name            varchar(64)                            
          nmLower         name                         lower(name)                                     
          wrdSUNetId      word                         netid           varchar(16)                            
          dwrdEmail       name                         email           varchar(64)                            
          dwrdPhone       dword                        phone           varchar(32)                            
          flgActive       bit                          active          numeric(1)                             
          nmLowerLastName name                         lastname        varchar(64)                            
          dwrdDirectoryId dword                        directoryid     varchar(32)                            
      )                                            )                                                          
      ResName                                      ResName                                                    
      (                                            (                                                          
                                                       id          int                                        
          nmName       name                            name        varchar(64)                                
          idDomain     handle                          domain      int                                        
          dwrdModified dword                           modified_by int                                        
          dtModified   datetime                        modified    timestamp(3)                               
      )                                            )                                                          
      ResName_Owner                                ResName_Owner                                              
      (                                            (                                                          
          nmName  name                                 resname int                                            
          idOwner handle                               owner   int                                            
      )                                            )                                                          
      ServiceType                                  Service                                                    
      (                                            (                                                          
          snmSvcType      shrtname                     service     varchar(32)                                
          dsDescription   description                  description varchar(64)                                
          snmLowerSvcType shrtname                     lower(service)                                  
      )                                             )                                                         
      Quality                                      State                                                      
      (                                            (                                                          
          snmQuality       shrtname                    state        varchar(32)                               
                                                       rank         int                                       
                                                       denyDHCP     numeric(1)                                
                                                       denyDNS      numeric(1)                                
          dsDescription    description                 description  varchar(64)                               
                                                       accessgroup  int                                       
          snmLowerQuality  shrtname                    lower(state)                                    
      )                                            )                                                          
      Users                                        Users                                                      
      (                                            (                                                          
          idUser        handle                         id           int                                       
          dwrdPerRegId  dword                          deprecated/unnecessary. never use this.         
          wrdSUNetId    word                           netid        varchar(16)                               
          idDomain      handle                         domain       int                                       
          idOwner       handle                         owner        int                                       
          strPrefix     varchar(19)                    prefix       varchar(43)                               
          flgActive     flag                           active       numeric(1)                                
          flgAllGroups  flag                           all_groups   numeric(1)                                
          flgAllObjects flag                           all_objects  numeric(1)                                
          cmComment     comment                        comments     varchar(256)                              
          dtLastLogin   datetime                       last_login   timestamp(3)                              
          dwrdCreated   dword                          created_by   int                                       
          dwrdModified  dword                          modified_by  int                                       
          dtCreated     datetime                       created      timestamp(3)                              
          dtModified    datetime                       modified     timestamp(3)                              
          dwrdLockUser  dword                          locked_by    int                                       
          dtLocked      datetime                       locked       timestamp(3)                              
      )                                            )                                                          
      Users_Access                                 Users_AccessGroup                                          
      (                                            (                                                          
          idAccess handle                              userid      int                                        
          idUser   handle                              accessgroup int                                        
      )                                            )                                                          
      Users_NodeTemplate                           Users_NodeTemplate                                         
      (                                            (                                                          
          idNode handle                                userid  int                                            
          idUser handle                                node    int                                            
      )                                            )                                                          
      Users_Owner                                  Users_Owner                                                
      (                                            (                                                          
          idOwner handle                               userid  int                                            
          idUser  handle                               owner   int                                            
      )                                            )                                                          
      deleted_IPaddressSpace                       What is this and why do we need it? 
      (                                                                                                       
          ipAddressSpace ip                                                                                   
          ipBroadcast    ip                                                                                   
          idNetwork      handle                                                                               
          dtDeleted      datetime                                                                             
      )                                                                                                       
      temp_ip*                                     temp_ip* deprecated                                 
                                                                                                              
                                                       All temp_ip tables have been                    
                                                       deprecated and removed.  Use                    
                                                       a better solution.