|
appctl_bases
Content of trusted applications group of Application Control.
Table fields
Field name
|
Field type
|
Description
|
dbid
|
VARCHAR(36) NOT NULL
|
UUID of trusted applications group
|
dbtype
|
INTEGER NOT NULL
|
type of trusted applications group (files or certificates)
|
blockno
|
INTEGER NOT NULL
|
blocking number
|
block
|
CHARACTER(1024) NOT NULL
|
data block of 768-bytes in base64 encoding
|
Table indexes
Index name
|
Index type
|
Fields list
|
appctl_bases_pkey
|
table primary key
clustering index
|
dbid, dbtype, blockno
|
Table references
Field name
|
Direction
|
Referenced table field
|
dbid
|
→
|
appctl_dir.dbid
|
appctl_dir
Description of trusted applications group of Application Control.
Table fields
Field name
|
Field type
|
Description
|
dbid
|
VARCHAR(36) NOT NULL
|
UUID of trusted applications group
|
srvid
|
VARCHAR(36) NOT NULL
|
master Server ID (it will process)
|
name
|
VARCHAR(256) DEFAULT ''
|
name of trusted applications group
|
descr
|
TEXT DEFAULT ''
|
description of trusted applications group
|
params
|
TEXT NOT NULL
|
generation params of trusted applications group
|
begintime
|
NUMERIC(17) DEFAULT '0'
|
start time of creation
|
endtime
|
NUMERIC(17) DEFAULT '0'
|
end time of creation (0—incomplete)
|
fl_sha256
|
VARCHAR(256) DEFAULT ''
|
SHA-256 of unloaded hashes of files
|
fl_fsize
|
NUMERIC(20) DEFAULT '0'
|
size of unloaded hashes of files
|
cr_sha256
|
VARCHAR(256) DEFAULT ''
|
SHA-256 of unloaded hashes of certificates
|
cr_fsize
|
NUMERIC(20) DEFAULT '0'
|
size of unloaded hashes of certificates
|
error
|
TEXT DEFAULT ''
|
processing error
|
Table indexes
Index name
|
Index type
|
Fields list
|
appctl_dir_0001
|
simple table index
|
srvid
|
appctl_dir_pkey
|
table primary key
|
dbid
|
appctl_download
Application Control downloaded data blocks.
Table fields
Field name
|
Field type
|
Description
|
dbid
|
VARCHAR(36) NOT NULL
|
UUID of trusted applications group
|
stid
|
VARCHAR(36) NOT NULL
|
station ID
|
dbtype
|
INTEGER NOT NULL
|
type of trusted applications group (files or certificates)
|
blockno
|
INTEGER NOT NULL
|
blocking number
|
block
|
CHARACTER(1024) NOT NULL
|
data block of 768-bytes in base64 encoding
|
Table indexes
Index name
|
Index type
|
Fields list
|
appctl_download_0001
|
simple table index
|
stid
|
appctl_download_pkey
|
table primary key
clustering index
|
dbid, stid, dbtype, blockno
|
Table references
Field name
|
Direction
|
Referenced table field
|
dbid
|
→
|
appctl_dir.dbid
|
stid
|
→
|
stations.id
|
appctl_event_cert
Application Control event certificate metadata.
Table fields
Field name
|
Field type
|
Description
|
id
|
INTEGER PRIMARY KEY AUTOINCREMENT
|
certificate ID
|
thumbprint
|
VARCHAR(64) NOT NULL
|
certificate thumbprint (SHA-1)
|
serial
|
TEXT NOT NULL
|
certificate serial number
|
issuer
|
TEXT NOT NULL
|
certificate issuer
|
subject
|
TEXT NOT NULL
|
certificate subject
|
ts
|
NUMERIC(17) NOT NULL
|
certificate timestamp
|
not_before
|
NUMERIC(17) NOT NULL
|
certificate start date
|
not_after
|
NUMERIC(17) NOT NULL
|
certificate end date
|
Table indexes
Index name
|
Index type
|
Fields list
|
appctl_event_cert_0001
|
unique table index
|
thumbprint
|
appctl_event_file
Application Control event file metadata.
Table fields
Field name
|
Field type
|
Description
|
id
|
INTEGER PRIMARY KEY AUTOINCREMENT
|
file ID
|
sha256
|
VARCHAR(64) NOT NULL
|
file SHA-256 hash
|
ver
|
TEXT DEFAULT ''
|
file version
|
descr
|
TEXT DEFAULT ''
|
file description
|
origname
|
TEXT DEFAULT ''
|
file original name
|
prodname
|
TEXT DEFAULT ''
|
file product name
|
prodver
|
TEXT DEFAULT ''
|
file product version
|
company
|
TEXT DEFAULT ''
|
file company name
|
filesize
|
NUMERIC(20) DEFAULT '0'
|
file size
|
cert
|
INTEGER DEFAULT '0'
|
certificate
|
Table indexes
Index name
|
Index type
|
Fields list
|
appctl_event_file_0001
|
unique table index
|
sha256
|
Table references
Field name
|
Direction
|
Referenced table field
|
cert
|
↔
|
appctl_event_cert.id
|
appctl_participant
Generation participant of trusted applications group of Application Control.
Table fields
Field name
|
Field type
|
Description
|
dbid
|
VARCHAR(36) NOT NULL
|
UUID of trusted applications group
|
stid
|
VARCHAR(36) NOT NULL
|
station ID
|
begintime
|
NUMERIC(17) DEFAULT '0'
|
start time of creation
|
endtime
|
NUMERIC(17) DEFAULT '0'
|
end time of creation (0—incomplete)
|
fl_sha256
|
VARCHAR(256) DEFAULT ''
|
expected files DB SHA256
|
fl_fsize
|
NUMERIC(20) DEFAULT '0'
|
expected files DB size
|
fl_csize
|
NUMERIC(20) DEFAULT '0'
|
current files DB size
|
cr_sha256
|
VARCHAR(256) DEFAULT ''
|
expected certificate DB SHA256
|
cr_fsize
|
NUMERIC(20) DEFAULT '0'
|
expected certificate DB size
|
cr_csize
|
NUMERIC(20) DEFAULT '0'
|
current certificate DB size
|
state
|
INTEGER DEFAULT '0'
|
see hash-db-download-status.ds
|
Table indexes
Index name
|
Index type
|
Fields list
|
appctl_participant_0001
|
simple table index
|
stid
|
appctl_participant_pkey
|
table primary key
clustering index
|
dbid, stid
|
Table references
Field name
|
Direction
|
Referenced table field
|
dbid
|
↔
|
appctl_dir.dbid
|
|