|
ads_computers
Active Directory computers.
Table fields
Field name
|
Field type
|
Description
|
pid
|
VARCHAR(36) NOT NULL
|
parent container GUID
|
sid
|
VARCHAR(255) NOT NULL
|
computer SID
|
Table indexes
Index name
|
Index type
|
Fields list
|
ads_computers_pkey
|
table primary key
|
sid
|
ads_containers
Active Directory containers.
Table fields
Field name
|
Field type
|
Description
|
pid
|
VARCHAR(36) DEFAULT ''
|
parent container ID
|
cid
|
VARCHAR(36) NOT NULL
|
container ID
|
dn
|
TEXT NOT NULL
|
container DN
|
sid
|
VARCHAR(255) DEFAULT ''
|
container SID
|
name
|
TEXT DEFAULT ''
|
object name
|
Table indexes
Index name
|
Index type
|
Fields list
|
ads_containers_0001
|
simple table index
clustering index
|
pid
|
ads_containers_pkey
|
table primary key
|
cid
|
ads_users
Active Directory users.
Table fields
Field name
|
Field type
|
Description
|
sid
|
VARCHAR(255) NOT NULL
|
user SID
|
dn
|
TEXT NOT NULL
|
user DN
|
pid
|
VARCHAR(36) NOT NULL
|
parent container GUID
|
name
|
TEXT DEFAULT ''
|
object name
|
Table indexes
Index name
|
Index type
|
Fields list
|
ads_users_0001
|
simple table index
clustering index
|
pid
|
ads_users_pkey
|
table primary key
|
sid
|
client_address
Addresses of clients who represent organizations.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
organization ID
|
orgref
|
INTEGER NOT NULL
|
reference to use from client_org
|
country
|
CHARACTER(2) NOT NULL
|
country ISO code
|
zip
|
VARCHAR(256) NOT NULL
|
ZIP code
|
city
|
VARCHAR(256) NOT NULL
|
city name
|
street1
|
VARCHAR(256) NOT NULL
|
street, line #1
|
street2
|
VARCHAR(256)
|
street, line #2
|
Table indexes
Index name
|
Index type
|
Fields list
|
client_address_pkey
|
table primary key
clustering index
|
id, orgref
|
client_bankinfo
Bank information about clients who represent organizations.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
organization ID
|
name
|
INTEGER NOT NULL
|
attribute name
|
value
|
VARCHAR(256)
|
attribute value
|
Table indexes
Index name
|
Index type
|
Fields list
|
client_bankinfo_pkey
|
table primary key
clustering index
|
id, name
|
client_org
Credentials of clients who represent organizations.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
organization ID
|
full_name
|
VARCHAR(256)
|
organization full name
|
name
|
VARCHAR(256)
|
organization short name
|
phone
|
VARCHAR(20)
|
phone number
|
email
|
VARCHAR(256)
|
email address
|
url
|
VARCHAR(256)
|
website
|
contract
|
VARCHAR(30)
|
contract number
|
contract_date
|
NUMERIC(17)
|
contract date
|
jaddr
|
INTEGER DEFAULT '0'
|
reference to client_address for client legal address
|
baddr
|
INTEGER DEFAULT '0'
|
reference to client_address for client bank address reference
|
paddr
|
INTEGER DEFAULT '0'
|
reference to client_address for client post address reference
|
laddr
|
INTEGER DEFAULT '0'
|
reference to client_address for client location address reference
|
Table indexes
Index name
|
Index type
|
Fields list
|
client_org_pkey
|
table primary key
|
id
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
groups_list.id
|
deleted_groups
Information on deleted station groups.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
group ID
|
pid
|
VARCHAR(36) DEFAULT ''
|
parent group
|
name
|
TEXT DEFAULT ''
|
group name
|
descr
|
TEXT DEFAULT ''
|
description/notes/etc.
|
type
|
INTEGER DEFAULT '0'
|
type: system/user/etc.
|
platform
|
NUMERIC(12) DEFAULT '0'
|
group platform (for system groups)
|
createtime
|
NUMERIC(17) DEFAULT '0'
|
record creation time
|
modtime
|
NUMERIC(17) DEFAULT '0'
|
record modification time
|
deleted
|
NUMERIC(17) DEFAULT '0'
|
group deletion time
|
Table indexes
Index name
|
Index type
|
Fields list
|
deleted_groups_pkey
|
table primary key
|
id
|
depot_station_accounting
Deleted station accounts accounting information.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
station ID
|
freedays
|
INTEGER NOT NULL
|
grace period in days
|
Table indexes
Index name
|
Index type
|
Fields list
|
depot_station_accounting_pkey
|
table primary key
|
id
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
depot_stations.id
|
depot_station_attributes
Deleted station accounts attributes.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
station ID
|
attribute
|
INTEGER NOT NULL
|
attribute
|
value
|
VARCHAR(4000)
|
attribute value
|
modtime
|
NUMERIC(17)
|
modification time
|
Table indexes
Index name
|
Index type
|
Fields list
|
depot_station_attributes_pkey
|
table primary key
|
id, attribute
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
depot_stations.id
|
depot_station_extra
Deleted station accounts extra information.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
station ID
|
descr
|
TEXT DEFAULT ''
|
description/notes/etc.
|
organization
|
TEXT DEFAULT ''
|
organization
|
department
|
TEXT DEFAULT ''
|
department
|
country
|
CHARACTER(2) DEFAULT ''
|
2-letter country ISO code
|
province
|
TEXT DEFAULT ''
|
state/province/etc.
|
city
|
TEXT DEFAULT ''
|
city
|
street
|
TEXT DEFAULT ''
|
street
|
floor
|
TEXT DEFAULT ''
|
floor
|
room
|
TEXT DEFAULT ''
|
room
|
latitude
|
INTEGER DEFAULT '0'
|
latitude, in seconds, +north -south
|
longitude
|
INTEGER DEFAULT '0'
|
longitude, in seconds, +east -west
|
email
|
TEXT DEFAULT ''
|
administrator email
|
modtime
|
NUMERIC(17) DEFAULT '0'
|
record modification time
|
Table indexes
Index name
|
Index type
|
Fields list
|
depot_station_extra_pkey
|
table primary key
|
id
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
depot_stations.id
|
depot_station_history
Deleted station accounts operation history.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
station ID
|
oper
|
INTEGER DEFAULT '0'
|
operations, see st-history-values .ds/.h
|
rate
|
VARCHAR(36) DEFAULT ''
|
tariff ID
|
date1
|
NUMERIC(17) DEFAULT '0'
|
1st date for the period start (station creation, station expiration) or grace period duration
|
date2
|
NUMERIC(17) DEFAULT '0'
|
2nd date for the period end
|
created
|
NUMERIC(17) NOT NULL
|
record creation time
|
Table indexes
Index name
|
Index type
|
Fields list
|
depot_station_history_0001
|
simple table index
|
id
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
depot_stations.id
|
depot_stations
Deleted station accounts base information.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
station ID
|
gid
|
VARCHAR(36) NOT NULL
|
primary group ID
|
rate
|
VARCHAR(36) NOT NULL
|
station current tariff ID
|
kid
|
VARCHAR(36) DEFAULT ''
|
license key ID
|
osgroup
|
VARCHAR(36) DEFAULT ''
|
operating system group
|
password
|
TEXT DEFAULT ''
|
password as plain text
|
name
|
TEXT DEFAULT ''
|
station name
|
state
|
INTEGER DEFAULT '0'
|
current state, see st-db-state .ds/.h
|
addr
|
TEXT DEFAULT ''
|
current network address
|
lastseenfrom
|
TEXT DEFAULT ''
|
network address of the last connection
|
lastseenat
|
NUMERIC(17) NOT NULL
|
time of the last connection
|
createtime
|
NUMERIC(17) DEFAULT '0'
|
record creation time
|
modtime
|
NUMERIC(17) DEFAULT '0'
|
record modification time
|
lastos
|
NUMERIC(12) DEFAULT '0'
|
last reported operating system
|
server
|
VARCHAR(36) DEFAULT ''
|
login server
|
expires
|
NUMERIC(17) DEFAULT '0'
|
account expiration time
|
blockbeg
|
NUMERIC(17) DEFAULT '0'
|
account blocking start date
|
blockend
|
NUMERIC(17) DEFAULT '0'
|
account blocking end date
|
allowedaddr
|
TEXT DEFAULT ''
|
allowed addresses ACL
|
osclass
|
INTEGER DEFAULT '0'
|
operating system class, see st-db-osclass .h/.ds
|
prototype
|
INTEGER DEFAULT '0'
|
network protocol type, see st-db-proto .ds/.h
|
hasperset
|
INTEGER DEFAULT '0'
|
does the station have personal settings
|
modpersettime
|
NUMERIC(17) DEFAULT '0'
|
the `hasperset` field modification time
|
emplace_id
|
VARCHAR(36) DEFAULT ''
|
emplacing ID, may be non-empty only during emplacing
|
reboot
|
INTEGER DEFAULT '0'
|
reboot state, see st-db-reboot .ds/.h
|
sid
|
VARCHAR(255) DEFAULT ''
|
SID—security identifier of Windows OS user account
|
ldapdn
|
VARCHAR(512) DEFAULT ''
|
LDAP—distinguished name of a station under Windows OS
|
lastos_bldnum
|
INTEGER DEFAULT '0'
|
OS build number, Windows only
|
type
|
INTEGER DEFAULT '0'
|
station type, see st-db-type .ds/.h
|
Table indexes
Index name
|
Index type
|
Fields list
|
depot_stations_0001
|
simple table index
clustering index
|
modtime
|
depot_stations_pkey
|
table primary key
|
id
|
group_accounting
Information on a grace period of station groups (Dr.Web AV-Desk only).
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
group ID
|
freedays
|
INTEGER
|
cost-free period in days
|
Table indexes
Index name
|
Index type
|
Fields list
|
group_accounting_pkey
|
table primary key
|
id
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
groups_list.id
|
group_attributes
Arbitrary attributes of station groups. Is not currently used.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
group ID
|
attribute
|
INTEGER NOT NULL
|
attribute
|
value
|
VARCHAR(4000)
|
attribute value
|
modtime
|
NUMERIC(17)
|
modification time
|
Table indexes
Index name
|
Index type
|
Fields list
|
group_attributes_pkey
|
table primary key
clustering index
|
id, attribute
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
groups_list.id
|
group_children
The list of child groups for station groups.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
group ID
|
child
|
VARCHAR(36) NOT NULL
|
child group ID
|
Table indexes
Index name
|
Index type
|
Fields list
|
group_children_pkey
|
table primary key
|
id, child
|
group_parent
Information on parent groups for station groups.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
group ID
|
pid
|
VARCHAR(36) NOT NULL
|
parent group ID
|
modtime
|
NUMERIC(17) DEFAULT '0'
|
record modification time
|
Table indexes
Index name
|
Index type
|
Fields list
|
group_parent_0001
|
simple table index
|
pid
|
group_parent_pkey
|
table primary key
|
id
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
groups_list.id
|
group_password
Passwords for the access to groups (is used by group installers).
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
group ID
|
password
|
VARCHAR(256) NOT NULL
|
password to access the group (is used by group installers)
|
Table indexes
Index name
|
Index type
|
Fields list
|
group_password_pkey
|
table primary key
|
id
|
group_stations_count
Cache of the number of stations in groups.
Table fields
Field name
|
Field type
|
Description
|
osid
|
VARCHAR(36) NOT NULL
|
server ID
|
flags
|
INTEGER NOT NULL
|
counting flags, see st-db-counting .ds/.h
|
group_id
|
VARCHAR(36) NOT NULL
|
group ID
|
admin_id
|
VARCHAR(36) NOT NULL
|
admin UUID
|
count
|
INTEGER NOT NULL
|
number of stations
|
modtime
|
NUMERIC(17) DEFAULT '0'
|
record modification time
|
Table indexes
Index name
|
Index type
|
Fields list
|
group_stations_count_pkey
|
table primary key
clustering index
|
osid, admin_id, flags, group_id
|
groupping_rules
Information on automatic membership in user groups.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
group ID
|
script
|
TEXT DEFAULT ''
|
script for automatic grouping
|
gr_rule
|
TEXT DEFAULT ''
|
rule for automatic grouping
|
Table indexes
Index name
|
Index type
|
Fields list
|
groupping_rules_pkey
|
table primary key
|
id
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
groups_list.id
|
groups_list
The list of station groups.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
group ID
|
name
|
TEXT DEFAULT ''
|
group name
|
descr
|
TEXT DEFAULT ''
|
description/notes/etc.
|
type
|
INTEGER DEFAULT '0'
|
type: system/user/etc.
|
platform
|
NUMERIC(12) DEFAULT '0'
|
group platform (for system groups)
|
createtime
|
NUMERIC(17) DEFAULT '0'
|
record creation time
|
modtime
|
NUMERIC(17) DEFAULT '0'
|
record modification time
|
hasperset
|
INTEGER DEFAULT '0'
|
does the group have personal settings
|
modpersettime
|
NUMERIC(17) DEFAULT '0'
|
the `hasperset` field modification time
|
Table indexes
Index name
|
Index type
|
Fields list
|
groups_list_pkey
|
table primary key
|
id
|
iface_hidden_groups
Information on displaying of groups in the anti-virus network tree.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
record owner (admin.id)
|
gid
|
VARCHAR(36) NOT NULL
|
group ID
|
flag
|
INTEGER DEFAULT '1'
|
0 = hidden
|
Table indexes
Index name
|
Index type
|
Fields list
|
iface_hidden_groups_pkey
|
table primary key
clustering index
|
id, gid
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
admins.id
|
msad_object
Display names of Active Directory objects.
Table fields
Field name
|
Field type
|
Description
|
sid
|
VARCHAR(255) NOT NULL
|
user/group SID
|
name
|
TEXT DEFAULT ''
|
display name
|
Table indexes
Index name
|
Index type
|
Fields list
|
msad_object_pkey
|
table primary key
|
sid
|
newbies
The list of unapproved stations (newbies).
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
station ID
|
name
|
TEXT DEFAULT ''
|
station name
|
addr
|
TEXT DEFAULT ''
|
station network address
|
connected
|
NUMERIC(17) DEFAULT '0'
|
connection time
|
platform
|
NUMERIC(12) DEFAULT '0'
|
reported operating system
|
server
|
VARCHAR(36) DEFAULT ''
|
server
|
admin
|
VARCHAR(36) DEFAULT ''
|
login name of the administrator who changed the action on the station connect
|
admaddr
|
TEXT DEFAULT ''
|
network address of the administrator who changed the action on the station connect
|
onconnect
|
INTEGER DEFAULT '0'
|
the action on the station connect, see newbie-db-onconnect.ds
|
stationid
|
VARCHAR(36) DEFAULT ''
|
ID of the station after approving (onconnect==approve)
|
gid
|
VARCHAR(36) DEFAULT ''
|
ID of the group to which the station approved (onconnect==approve)
|
rate
|
VARCHAR(36) DEFAULT ''
|
rate of the station after approving (onconnect==approve)
|
state
|
INTEGER DEFAULT '1'
|
see newbie-db-state.ds
|
no_grace
|
INTEGER DEFAULT '0'
|
flag to disable grace period
|
description
|
TEXT DEFAULT ''
|
station description
|
ldapdn
|
TEXT DEFAULT ''
|
station LDAP DN
|
mac
|
VARCHAR(128) DEFAULT ''
|
station MAC
|
sid
|
VARCHAR(256) DEFAULT ''
|
station SID
|
Table indexes
Index name
|
Index type
|
Fields list
|
newbies_pkey
|
table primary key
|
id
|
policy_list
The list of policies for stations configuring.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
policy ID
|
name
|
VARCHAR(255) DEFAULT 'Unnamed'
|
policy name
|
version
|
NUMERIC(17) DEFAULT '0'
|
current version of a policy (0 if there is no current version)
|
Table indexes
Index name
|
Index type
|
Fields list
|
policy_list_pkey
|
table primary key
|
id
|
policy_stations
Assigning policies to stations.
Table fields
Field name
|
Field type
|
Description
|
sid
|
VARCHAR(36) NOT NULL
|
station ID
|
id
|
VARCHAR(36) NOT NULL
|
policy ID
|
assigned
|
NUMERIC(17) DEFAULT '0'
|
assigning time
|
Table indexes
Index name
|
Index type
|
Fields list
|
policy_stations_0001
|
simple table index
|
id
|
policy_stations_pkey
|
table primary key
|
sid
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
policy_list.id
|
sid
|
→
|
stations.id
|
policy_versions
The list of policy versions for stations configuring.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
policy ID
|
version
|
NUMERIC(17) NOT NULL
|
policy version
|
Table indexes
Index name
|
Index type
|
Fields list
|
policy_versions_pkey
|
table primary key
clustering index
|
id, version
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
policy_list.id
|
proxies
Accounts of Proxy servers connected to the Server.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
proxy ID
|
gid
|
VARCHAR(36) NOT NULL
|
primary group ID
|
password
|
TEXT DEFAULT ''
|
password as plain text
|
name
|
TEXT DEFAULT ''
|
station name, if the Proxy server is linked to a station
|
state
|
INTEGER DEFAULT '0'
|
current state, see st-db-state .ds/.h
|
addr
|
TEXT DEFAULT ''
|
current network address
|
lastseenfrom
|
TEXT DEFAULT ''
|
network address of the last connection
|
lastseenat
|
NUMERIC(17) DEFAULT '0'
|
time of the last connection
|
createtime
|
NUMERIC(17) DEFAULT '0'
|
record creation time
|
modtime
|
NUMERIC(17) DEFAULT '0'
|
record modification time
|
server
|
VARCHAR(36) DEFAULT ''
|
login server
|
prototype
|
INTEGER DEFAULT '0'
|
network protocol type, see st-db-proto .ds/.h
|
station
|
VARCHAR(36) DEFAULT ''
|
station ID, if the Proxy server is linked to a station
|
hasperset
|
INTEGER DEFAULT '0'
|
does the Proxy have personal settings
|
modpersettime
|
NUMERIC(17) DEFAULT '0'
|
the `hasperset` field modification time
|
Table indexes
Index name
|
Index type
|
Fields list
|
proxies_0001
|
simple table index
|
station
|
proxies_pkey
|
table primary key
|
id
|
station_accounting
Information in stations grace period (Dr.Web AV-Desk only).
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
station ID
|
freedays
|
INTEGER NOT NULL
|
grace period in days
|
Table indexes
Index name
|
Index type
|
Fields list
|
station_accounting_pkey
|
table primary key
|
id
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
stations.id
|
station_attributes
Arbitrary attributes of station accounts.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
station ID
|
attribute
|
INTEGER NOT NULL
|
attribute
|
value
|
VARCHAR(4000)
|
attribute value
|
modtime
|
NUMERIC(17)
|
modification time
|
Table indexes
Index name
|
Index type
|
Fields list
|
station_attributes_0001
|
simple table index
clustering index
|
attribute
|
station_attributes_pkey
|
table primary key
|
id, attribute
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
stations.id
|
station_extra
Additional information on station accounts.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
station ID
|
descr
|
TEXT DEFAULT ''
|
description/notes/etc.
|
organization
|
TEXT DEFAULT ''
|
organization
|
department
|
TEXT DEFAULT ''
|
department
|
country
|
CHARACTER(2) DEFAULT ''
|
2-letter country ISO code
|
province
|
TEXT DEFAULT ''
|
state/province/etc.
|
city
|
TEXT DEFAULT ''
|
city
|
street
|
TEXT DEFAULT ''
|
street
|
floor
|
TEXT DEFAULT ''
|
floor
|
room
|
TEXT DEFAULT ''
|
room
|
latitude
|
INTEGER DEFAULT '0'
|
latitude, in seconds, +north -south
|
longitude
|
INTEGER DEFAULT '0'
|
longitude, in seconds, +east -west
|
email
|
TEXT DEFAULT ''
|
administrator email
|
modtime
|
NUMERIC(17) DEFAULT '0'
|
record modification time
|
Table indexes
Index name
|
Index type
|
Fields list
|
station_extra_pkey
|
table primary key
|
id
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
stations.id
|
station_groups
Information about the placement of stations in user groups.
Table fields
Field name
|
Field type
|
Description
|
sid
|
VARCHAR(36) NOT NULL
|
station ID
|
gid
|
VARCHAR(36) NOT NULL
|
group ID
|
createtime
|
NUMERIC(17) DEFAULT '0'
|
record creation time
|
autoadded
|
INTEGER DEFAULT '0'
|
does the station is added to the group according to automatic membership rules
|
Table indexes
Index name
|
Index type
|
Fields list
|
station_groups_0001
|
simple table index
|
gid
|
station_groups_0002
|
simple table index
|
sid
|
station_groups_pkey
|
table primary key
clustering index
|
sid, gid
|
Table references
Field name
|
Direction
|
Referenced table field
|
sid
|
→
|
stations.id
|
station_links
Information about the stations interconnects.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
station ID
|
lid
|
VARCHAR(36) NOT NULL
|
linked station ID
|
established
|
NUMERIC(17) NOT NULL
|
link establish time
|
Table indexes
Index name
|
Index type
|
Fields list
|
station_links_pkey
|
table primary key
clustering index
|
id, lid
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
stations.id
|
lid
|
→
|
stations.id
|
stations
Data of stations accounts.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
station ID
|
gid
|
VARCHAR(36) NOT NULL
|
primary group ID
|
rate
|
VARCHAR(36) NOT NULL
|
station current tariff ID
|
kid
|
VARCHAR(36) DEFAULT ''
|
license key ID
|
osgroup
|
VARCHAR(36) DEFAULT ''
|
operating system group
|
password
|
TEXT DEFAULT ''
|
password as plain text
|
name
|
TEXT DEFAULT ''
|
station name
|
state
|
INTEGER DEFAULT '0'
|
current state, see st-db-state .ds/.h
|
addr
|
TEXT DEFAULT ''
|
current network address
|
lastseenfrom
|
TEXT DEFAULT ''
|
network address of the last connection
|
lastseenat
|
NUMERIC(17) NOT NULL
|
time of the last connection
|
createtime
|
NUMERIC(17) DEFAULT '0'
|
record creation time
|
modtime
|
NUMERIC(17) DEFAULT '0'
|
record modification time
|
lastos
|
NUMERIC(12) DEFAULT '0'
|
last reported operating system
|
server
|
VARCHAR(36) DEFAULT ''
|
login server
|
expires
|
NUMERIC(17) DEFAULT '0'
|
account expiration time
|
blockbeg
|
NUMERIC(17) DEFAULT '0'
|
account blocking start date
|
blockend
|
NUMERIC(17) DEFAULT '0'
|
account blocking end date
|
allowedaddr
|
TEXT DEFAULT ''
|
allowed addresses ACL
|
osclass
|
INTEGER DEFAULT '0'
|
operating system class, see st-db-osclass .h/.ds
|
prototype
|
INTEGER DEFAULT '0'
|
network protocol type, see st-db-proto .ds/.h
|
hasperset
|
INTEGER DEFAULT '0'
|
does the station have personal settings
|
modpersettime
|
NUMERIC(17) DEFAULT '0'
|
the `hasperset` field modification time
|
emplace_id
|
VARCHAR(36) DEFAULT ''
|
emplacing ID, may be non-empty only during emplacing
|
reboot
|
INTEGER DEFAULT '0'
|
reboot state, see st-db-reboot .ds/.h
|
sid
|
VARCHAR(255) DEFAULT ''
|
SID—security identifier of Windows OS user account
|
ldapdn
|
VARCHAR(512) DEFAULT ''
|
LDAP—distinguished name of a station under Windows OS
|
lastos_bldnum
|
INTEGER DEFAULT '0'
|
OS build number, Windows only
|
type
|
INTEGER DEFAULT '0'
|
station type, see st-db-type .ds/.h
|
Table indexes
Index name
|
Index type
|
Fields list
|
stations_0001
|
simple table index
clustering index
|
gid
|
stations_0002
|
simple table index
|
lastseenat
|
stations_0003
|
simple table index
|
sid
|
stations_a0001
|
simple table index
|
rate
|
stations_pkey
|
table primary key
|
id
|
stations_left_groups
The list of groups in which the stations were previously included.
Table fields
Field name
|
Field type
|
Description
|
sid
|
VARCHAR(36) NOT NULL
|
station ID
|
gid
|
VARCHAR(36) NOT NULL
|
group ID
|
createtime
|
NUMERIC(17) DEFAULT '0'
|
record creation time
|
Table indexes
Index name
|
Index type
|
Fields list
|
stations_left_groups_0001
|
simple table index
clustering index
|
gid
|
Table references
Field name
|
Direction
|
Referenced table field
|
gid
|
→
|
groups_list.id
|
sid
|
→
|
stations.id
|
|