|
servers
The list of neighbor Servers.
Table fields
Field name
|
Field type
|
Description
|
osid
|
VARCHAR(36) NOT NULL
|
this Server ID
|
id
|
VARCHAR(36) NOT NULL
|
neighbor Server UUID (lid in other tables)
|
name
|
VARCHAR(64) NOT NULL
|
attribute name
|
value
|
TEXT DEFAULT ''
|
attribute value
|
updatetime
|
NUMERIC(17) DEFAULT '0'
|
record creation
|
Table indexes
Index name
|
Index type
|
Fields list
|
servers_0001
|
simple table index
clustering index
|
osid, id, name
|
srv_names
Identification data of neighbor Servers.
Table fields
Field name
|
Field type
|
Description
|
osid
|
VARCHAR(36) NOT NULL
|
server ID
|
oname
|
TEXT DEFAULT ''
|
server name
|
updatetime
|
NUMERIC(17) NOT NULL
|
record time
|
Table indexes
Index name
|
Index type
|
Fields list
|
srv_names_0001
|
simple table index
|
updatetime
|
srv_names_pkey
|
table primary key
|
osid
|
srv_unsent
Events that have not been sent to the neighbor Servers.
Table fields
Field name
|
Field type
|
Description
|
osid
|
VARCHAR(36) NOT NULL
|
originator ID
|
lid
|
VARCHAR(36) NOT NULL
|
neighbor Server UUID
|
mid
|
VARCHAR(36) NOT NULL
|
message UUID
|
id
|
VARCHAR(36) DEFAULT ''
|
station ID
|
stationname
|
INTEGER DEFAULT '0'
|
station name
|
event
|
TEXT DEFAULT ''
|
event name
|
data
|
CLOB DEFAULT ''
|
event data
|
lastsent
|
NUMERIC(17) DEFAULT '0'
|
last sent time
|
arrived
|
NUMERIC(17) NOT NULL
|
record creation
|
Table indexes
Index name
|
Index type
|
Fields list
|
srv_unsent_0001
|
simple table index
clustering index
|
lid, osid
|
srv_unsent_0002
|
simple table index
|
lid, mid
|
Table references
Field name
|
Direction
|
Referenced table field
|
osid
|
←
|
srv_recvhistory.mid
|
stationname
|
↔
|
cat_name_stations.id
|
|