VDB, Schema, and Properties

SYSADMIN.VDBResources

このテーブルは、現在のVDB の内容を示しています。

Column Name	Type	Description
`resourcePath`	string	Path to the contents
`contents`	blob	Contents as a blob

SYS.VirtualDatabases

このテーブルは現在接続されている仮想データベースに関する情報を提供します。

Column Name	Type	Description
`Name`	string	Name of the VDB
`Version`	string	Version of the VDB

SYS.Schemas

このテーブルは、システムスキーマ自体（System）を含む、仮想データベース内のすべてのスキーマに関する情報を提供します。

Column Name	Type	Description
`VDBName`	string	VDB name
`Name`	string	Schema name
`IsPhysical`	boolean	`TRUE` if represents a source
`UID`	string	Unique ID
`Description`	string	Description
`PrimaryMetamodelURI`	string	URI for the primary meta-model describing the model used for this schema
`OID`	integer	Unique ID

SYS.Properties

このテーブルは、メタモデル拡張に基づくすべてのオブジェクトのユーザー定義プロパティを提供します。通常、メタモデル拡張が使用されていない場合、このテーブルは空です。

Column Name	Type	Description
`Name`	string	Extension property name
`Value`	string	Extension property value
`UID`	string	Key unique ID
`OID`	integer	Unique ID
`ClobValue`	clob	Clob representation of value, if not `NULL`

SYSADMIN.SystemProperties

VDB ごとに保存され、他のVDB からは利用できません。

Column Name	Type	Description
`ID`	biginteger	System property unique ID
`propType`	string	System property type
`propKey`	string	System property unique key
`properties`	string	Property string
`creationDate`	timestamp	System property creation time
`lastModifiedDate`	timestamp	System property edit date, if applicable
`creator`	string	Creator's username
`modifier`	string	Modifier's username, if applicable

SYSADMIN_VDB.SSHTunnel

SYSADMIN_VDB.SSHTunnelテーブルは、既存のすべてのSSH tunnelsを保持・管理します。

Field name	Field type	Mandatory	Description
`id`	biginteger	`NOT NULL`	Unique identifier
`name`	string(255)	`NOT NULL`	Unique name of an SSH tunnel
`localHost`	string(255)	`NOT NULL`	Host of a client's machine (default: `localhost`)
`localPort`	integer	`NOT NULL`	Port of a client's machine
`remoteHost`	string(255)	`NOT NULL`	Host of a remote machine
`remotePort`	integer	`NOT NULL`	Port of a remote machine
`host`	string(255)	`NOT NULL`	Username and host used for connecting to a remote machine via SSH protocol (format: `username@host`)
`portForwardingType`	string(1)	`NOT NULL`	Type of SSH port forwarding (default: `L`). As the CData Virtuality Server supports only local port forwarding at the moment, the field can have only `L` value
`sshPort`	integer	`NOT NULL`	Port used by the SSH server on a remote machine (default: 22)
`sshProperties`	string	`NULL`	SSH comma-separated properties in CSV-like form: `property1=<value1>,property2=<value2>`. Used to provide a timeout, cypher parameters, key parameters like used algorithms, a possibility to provide classes for custom algorithms, and so on
`password`	string(255)	`NULL`	Password used for simple authentication on the SSH server (encrypted)
`passPhrase`	string(255)	`NULL`	Password phrase used in case of a secured private key and key authentication on the SSH server (encrypted)
`privateKey`	string(4096)	`NULL`	Private key used for key authentication on the SSH server
`proxy`	string(255)	`NULL`	Proxy type
`proxyHost`	string(255)	`Null`	Proxy host
`proxyPort`	integer	`NULL`	Proxy port
`proxyUser`	string(255)	`NULL`	Proxy user name.
`proxyPassword`	string(255)	`NULL`	Proxy user password (encrypted).
`state`	string(128)	`NOT NULL`	State of a particular SSH tunnel (possible values: `SUCCESS` or `FAILED`). A special refresh daemon controls all SSH tunnels by a timeout (60 secs) to re-create an SSH tunnel in case it failed
`failureReason`	string(4096)	`NULL`	Failure reason in case a particular SSH tunnel failed
`creationDate`	timestamp	`NOT NULL`	Date of creation of the SSH tunnel
`lastModifiedDate`	timestamp	`NOT NULL`	Date of latest modification of an SSH tunnel
`creator`	string(255)	`NOT NULL`	Username of the person who created the SSH tunnel
`modifier`	string(255)	`NOT NULL`	Username of the person who modified the SSH tunnel
`keyPairId`	integer	`NULL`	ID of a key-pair in the `SYSADMIN_VDB.SSHCredentials` table

SYSADMIN_VDB.SSHCredentials

このテーブルは CData Virtuality Server が生成し、SSH Tunnel が使用するすべてのキーペアを保持・管理します：

Field name	Field type	Mandatory	Description
`id`	biginteger	`NOT NULL`	Unique identifier
`name`	string	`NULL`	Name of the key pair. Must be unique
`privateKey`	string	`NOT NULL`	Private key
`publicKey`	string	`NOT NULL`	Public key
`createionDate`	timestamp	`NOT NULL`	Date of creation of the key pair
`creator`	string	`NOT NULL`	Username of the person who created the key pair
`lastModifiedDate`	timestamp	`NOT NULL`	Date of the latest modification of the key pair
`modifier`	string	`NOT NULL`	Username of the person who modified the key pair