Table of Big O Objects, Fields and Field Types

4/26/00 Modified by SY
Parentheses ( ) mean not implemented in first release

Field Types

  1. DNS = DNS Name Field
  2. Name = non-dns name, no spaces
  3. Name+sp = non-dns name, spaces
  4. String
  5. Select = select box
  6. Drop = dropdown
  7. Display = Display only
  8. Integer
  9. Check = Checkbox
  10. Radio = Radio button
  11. People = people input field
  12. Date = Date field
  13. Address = Ip Address Field

Database Datatypes Used

DataType Base Width
ip int 4
flag bit 1
name char 65
word char 16
dword char 32
fqdname char 255
shrtname char 30
comment varchar 240
varstring varchar 255
description varchar 60
shrtdescription varchar 30
     
datetime   2x4
int   4
tinyint   1

  Field Type DataType Node IPC Router Adv Template (NodeGrp) Network Admin Team User Group Domain
Name DNS, people, etc   DNS DNS DNS DNS DNS DNS DNS w/ spaces people w/ spaces DNS
Name DataType DNS, people, etc   name name name name name x name name people shrtname fqdname
Alias DNS name x x x x x x x        
Domain DNS fqdname x x x x x x x        
MX DNS name x x x x x            
MX Preference integer int x x x x x            
Dept- LNA select name x x x x x       x    
Dept- other select name                 x    
Location select name x x x x x            
Room string dword x x x x x            
Expiration Date date datetime x x x x x            
make/model select 2 shrtname x x x x x            
os select shrtname x x x x x            
Groups select shrtname x x x x x x x x x   x
Administrators people dword x x x x x            
Node User people dword x x x x x            
Custom Field Name string shrtdescription x x x x x            
Custom Field Value string description x x x x x            
Hardware Address hardware shrtname x x x x              
(Interface Type)   shrtname x x x x              
Interface Name DNS name       x              
DHCP/Bootp check flag x x x x              
Roaming check flag x x x x              
Interface IP address address ip x x x x              
IPC IP Address address ip   x                  
IPC IP Address Name DNS name   x                  
Active address check flag x x x x              
DHCP options string name/varstring x x x x     x        
Comments string comment x x x x x x x x x x x
Created By display dword x x x x x x x x x x x
Created when display datetime x x x x x x x x x x x
Modified by display dword x x x x x x x x x x x
Modified when display datetime x x x x x x x x x x x
(Node group) DNS name x x x x              
Node Type check shrtname x x x x x            
(Service) ?   x x x x x            
Ptr Preferences   tinyint       x              
Address Space address ip         x   x        
Address Space Comments string description          x   x    x    
Low Reserve integer ip             x        
High Reserve integer ip             x        
DHCP Service drop shrtname             x        
Dynamic DHCP addresses address ip             x        
Dynamic addr names DNS name             x        
Admin team email string varstring               x      
Admin team phone string dword               x      
Team members people dword               x      
Default Group select, drop shrtname                 x    
Default Addr Space select, drop ip                 x    
Official LNA   flag                 x    
Active User check flag                 x    
Default Domain select, drop fqdname                 x    
Object Access select shrtname                 x    
All Objects check flag                 x    
All Groups check flag                 x    
User Email display dword                 x    
User Phone display dword                 x    
(Template) ?                   x    
Last Login display datetime                 x    
Consultant display dword                 x    
(Nodes) ?             x          
Allow Names radio flag                     x
Limited radio flag                     x