graph.table

来自「gxsnmp SNMP MANAGER 的实现」· TABLE 代码 · 共 54 行

#
#  The GRAPH table is used to store graphical information about items that
#  appear in maps.
#
#  _rowid       is a positive integer, unique within the GRAPH table, that
#		is used to identify a specific row in the table.
#
#  created      is the date and time that the row entry was created
#
#  modified     is the date and time that the row entry was last modified
#
#  map		is the rowid of the MAP table entry that this GRAPH entry 
#		applies to.
#
#  type		is the type of this entry.  Current types are 
#               GXSNMP_MAP_HOST, GXSNMP_MAP_NETWORK, and GXSNMP_MAP_WIRE.
#
#  host         For GXSNMP_MAP_HOST and GXSNMP_MAP_WIRE entries, contains
#               the rowid of the associated host entry.
# 
#  network      for GXSNMP_MAP_NETWORK and GXSNMP_MAP_WIRE entries, contains
#               the rowid of the associated network entry.
# 
#  details      is a method-specific description of all information
#               needed to display the item, such as X and Y locations,  
#               pixmap names, etc.  The field is in gtkrc format.
#
#  x and y      are temporary columns, because the code to read and write 
#		the display field isn't written yet.
#
#  pixmap	is the pixmap filename to be used when displaying this
#		object.
#
#  tags         is the application specific tags for this object.
#
create table graph (
   _rowid        int not null,
   created      char(20), 
   modified     char(20),
   map		int,
   type 	smallint,
   host         int,
   network	int,
   details	char(255),
   x		double precision,
   y		double precision,
   pixmap	char(255),
   tags         char(255),
   primary key  (_rowid),
   foreign key  (map)     references map,
   foreign key  (host)    references host,
   foreign key  (network) references network 
);