Administrators

admin_attributes

Arbitrary attributes of the Server administrators accounts.

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

admin UUID

attribute

INTEGER NOT NULL

attribute number

sequenceno

INTEGER NOT NULL

attribute sequence number

svalue

TEXT DEFAULT ''

attribute string value

nvalue

NUMERIC(19) DEFAULT '0'

attribute numeric value

Table indexes

Index name

Index type

Fields list

admin_attributes_pkey

table primary key

clustering index

id, attribute, sequenceno

Table references

Field name

Direction

Referenced table field

id

admins.id

admin_flat_objects

Cache of objects available to administrators according to their permissions.

Table fields

Field name

Field type

Description

id_admin

VARCHAR(36) NOT NULL

admin UUID

nright

INTEGER NOT NULL

numeric code for administrative permission

id_object

VARCHAR(36) NOT NULL

administrated object ID

Table indexes

Index name

Index type

Fields list

admin_flat_objects_pkey

table primary key

clustering index

id_admin, nright, id_object

Table references

Field name

Direction

Referenced table field

id_admin

admins.id

admin_group_objects

Objects of permissions for administrator groups.

Table fields

Field name

Field type

Description

id_group

VARCHAR(36) NOT NULL

group UUID

nright

INTEGER NOT NULL

numeric code for administrative permission

id_object

VARCHAR(36) NOT NULL

administrated object ID

Table indexes

Index name

Index type

Fields list

admin_group_objects_pkey

table primary key

clustering index

id_group, nright, id_object

admin_group_parent

Parent groups of administrator groups.

Table fields

Field name

Field type

Description

id_group

VARCHAR(36) NOT NULL

group UUID

id_parent

VARCHAR(36) NOT NULL

parent group UUID

modtime

NUMERIC(17) DEFAULT '0'

last modification timestamp

inherit

INTEGER DEFAULT '1'

specifies whether group inherits parent attributes (1 for true)

Table indexes

Index name

Index type

Fields list

admin_group_parent_0001

simple table index

id_parent

admin_group_parent_pkey

table primary key

id_group

admin_group_rights

Permissions for administrator groups.

Table fields

Field name

Field type

Description

id_group

VARCHAR(36) NOT NULL

group UUID

nright

INTEGER NOT NULL

numeric code for administrative permission

value

INTEGER DEFAULT '0'

value for administrative permission

modtime

NUMERIC(17) DEFAULT '0'

last modification timestamp

Table indexes

Index name

Index type

Fields list

admin_group_rights_pkey

table primary key

id_group, nright

admin_groups

Groups of the Server administrators.

Table fields

Field name

Field type

Description

id_group

VARCHAR(36) NOT NULL

group UUID

name

TEXT DEFAULT ''

human-readable name

descr

TEXT DEFAULT ''

human-readable description

modtime

NUMERIC(17) DEFAULT '0'

last modification timestamp

Table indexes

Index name

Index type

Fields list

admin_groups_pkey

table primary key

id_group

admin_msg_lst

Content of messages sent by administrator to stations.

Table fields

Field name

Field type

Description

mid

VARCHAR(36) NOT NULL

message UUID

msg_body

TEXT DEFAULT ''

message body

msg_options

INTEGER DEFAULT '0'

message options, see db-admin-msg-options .ds/.h

logo_url

TEXT DEFAULT ''

URL to open when clicking a user logo

logo_text

TEXT DEFAULT ''

text to display next to a user logo

logo_file

CLOB DEFAULT ''

path to a user logo file

link_url

TEXT DEFAULT ''

URL of a user link

link_text

TEXT DEFAULT ''

text to display as a name of a user link

created

NUMERIC(17) NOT NULL

message creation time

Table indexes

Index name

Index type

Fields list

admin_msg_lst_pkey

table primary key

mid

admin_msg_templates

Templates of messages sent by administrator to stations.

Table fields

Field name

Field type

Description

template_id

VARCHAR(36) NOT NULL

template UUID

msg_body

TEXT DEFAULT ''

message body

msg_options

INTEGER DEFAULT '0'

message options, see db-admin-msg-options .ds/.h

logo_url

TEXT DEFAULT ''

URL to open when clicking a user logo

logo_text

TEXT DEFAULT ''

text to display next to a user logo

logo_file

CLOB DEFAULT ''

path to a user logo file

link_url

TEXT DEFAULT ''

URL of a user link

link_text

TEXT DEFAULT ''

text to display as a name of a user link

admin

VARCHAR(36) NOT NULL

UUID of the administrator who created the message template

name

VARCHAR(100) DEFAULT ''

template name

Table indexes

Index name

Index type

Fields list

admin_msg_templates_0001

simple table index

clustering index

admin

admin_msg_templates_pkey

table primary key

template_id

Table references

Field name

Direction

Referenced table field

admin

admins.id

admin_objects

Objects of permissions for administrators.

Table fields

Field name

Field type

Description

id_admin

VARCHAR(36) NOT NULL

administrator UUID

nright

INTEGER NOT NULL

numeric code for administrative permission

id_object

VARCHAR(36) NOT NULL

administrated objects ID

Table indexes

Index name

Index type

Fields list

admin_objects_pkey

table primary key

clustering index

id_admin, nright, id_object

Table references

Field name

Direction

Referenced table field

id_admin

admins.id

admin_rights

Permissions for administrators.

Table fields

Field name

Field type

Description

id_admin

VARCHAR(36) NOT NULL

administrator UUID

nright

INTEGER NOT NULL

numeric code for administrative permission

value

INTEGER DEFAULT '0'

value for administrative permission

modtime

NUMERIC(17) DEFAULT '0'

last modification timestamp

Table indexes

Index name

Index type

Fields list

admin_rights_pkey

table primary key

id_admin, nright

Table references

Field name

Direction

Referenced table field

id_admin

admins.id

admin_to_admin_group

Parent groups of administrators.

Table fields

Field name

Field type

Description

id_group

VARCHAR(36) NOT NULL

group UUID

id_admin

VARCHAR(36) NOT NULL

administrator UUID

modtime

NUMERIC(17) DEFAULT '0'

last modification timestamp

inherit

INTEGER DEFAULT '1'

specifies whether administrator inherits parent group attributes (1 for true)

Table indexes

Index name

Index type

Fields list

admin_to_admin_group_pkey

table primary key

id_admin

Table references

Field name

Direction

Referenced table field

id_admin

admins.id

admins

Data of the Server administrators accounts.

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

administrator UUID

login

VARCHAR(100) NOT NULL

login name

password

TEXT DEFAULT ''

password, plain or encrypted

fname

TEXT DEFAULT ''

first name

mname

TEXT DEFAULT ''

middle name

lname

TEXT DEFAULT ''

last name

descr

TEXT DEFAULT ''

description/notes/etc.

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

externalauth

INTEGER DEFAULT '0'

autocreated using external authentication

langcode

VARCHAR(8) DEFAULT ''

interface language

datecode

VARCHAR(8) DEFAULT ''

date format

email

VARCHAR(256)

email address

timezone

VARCHAR(8) DEFAULT '0'

local time zone

Table indexes

Index name

Index type

Fields list

admins_0001

unique table index

id

admins_pkey

table primary key

login