User`s guide

9030971 E17 Data Structure of SQL Tables
C-9
SPECTRUM Data Types
Models
Models
Description: List of all models
Columns: lh The landscape handle, a 4-byte integer
mh The model handle, a 4-byte integer
mth The model type handle, a 4-byte integer
mname The model name, a user-defined varying
character string, defaults to 31 bytes, nulls
allowed
macadr The MAC address of the model, a 17-byte
string, nulls allowed
ipadr The IP address of the model, a 15-byte
string, nulls allowed
Indexed by: lh + mh
mth
Table C-7. Format for Models
Landscape
Handle (lh)
Model
Handle
(mh)
Model
Type
Handle
(mth)
Model Name
(mname)
MAC address
(macadr)
IP Address
(ipadr)
4194304 10485762 65600 World
4194304 10496744 65608 Demo Room
4194304 104885763 65681 Universe
4194304 10488764 66238 LostFound
4194304 00400001 66239 goalie 1.2.34.5.67.89 123.456.789.000
… … … … … …
4-byte integer 4-byte
integer
4-byte
integer
user-deÞned
var char
17-byte
string
15-byte
string
ÑÑÑ INDEX1ÑÑÑ INDEX2