Data Dictionary Data ModelActive data containers.
Catalog: DataDictionary
Schema: Invantive
Alias: dcr
Label: Data Container
This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive SQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API.
View Columns
The columns of the view SYSTEMDATACONTAINERS are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
ALIAS |
string(240) |
Alias |
☐ |
Alias of the data container. |
ID |
string(4000) |
ID |
☐ |
Data container ID. |
IS_DEFAULT_FLAG |
boolean |
Is Default? |
☑ |
Is the default provider? |
IS_SERVICE_PROVIDER_FLAG |
boolean |
Is Service Provider? |
☑ |
Is the provider a service provider? |
PARTITIONS_COUNT |
int32 |
Number of Partitions |
☐ |
Number of partitions. |
PARTITIONS_SELECTED_COUNT |
int32 |
Number of Selected Partitions |
☐ |
Number of selected partitions. |
PROVIDER_DATABASE_POOL_DESCRIPTION |
string(240) |
Provider Database Pool Description |
☐ |
Pool description of the database. |
PROVIDER_DATABASE_PRICING_TIER |
string(240) |
Provider Database Pricing Tier |
☐ |
Pricing tier of the database. |
PROVIDER_DATABASE_SERVICE_TIER |
string(240) |
Provider Database Service Tier |
☐ |
Service tier of the database. |
PROVIDER_DATABASE_VERSION_NUMBER |
string(240) |
Provider Database Version Number |
☐ |
Version number of the database. |
PROVIDER_DATABASE_VERSION |
string(240) |
Provider Database Version |
☐ |
Version text of the database. |
PROVIDER_DESCRIPTION |
string(16000) |
Provider Description |
☐ |
Description of the provider. |
PROVIDER_NAME |
string(240) |
Provider Name |
☑ |
Name of the provider. |
PROVIDER_SHORT_NAME |
string(240) |
Provider Short Name |
☑ |
Short name of the provider. |
SessionTimeUtcOffsetSeconds |
int32 |
UTC Session Time Offset (sec) |
☑ |
UTC session offset (seconds). |
UI_LANGUAGE_CODE |
string(30) |
UI Language Code |
☐ |
User interface language code. |
USER_COMPANY_ID |
string(4000) |
User Company ID |
☐ |
Unique ID of the company of the user. |
USER_COMPANY_NAME |
string(4000) |
User Company Name |
☐ |
Name of the company of the user. |
USER_COMPANY_PHONE |
string(4000) |
User Company Phone |
☐ |
Phone of the company of the user. |
USER_COMPANY_SIRET_NUMBER |
string(240) |
User Company SIRET Number |
☐ |
Siret number of the company of the user. |
USER_COMPANY_VAT_NUMBER |
string(240) |
User Company VAT Number |
☐ |
VAT number of the company of the user. |
USER_COMPANY_WEB_SITE |
string(4000) |
User Company Website |
☐ |
Web site of the company of the user. |
USER_EMAIL_ADDRESS |
string(240) |
User Email Address |
☐ |
User email address. |
USER_FIRST_NAME |
string(240) |
User First Name |
☐ |
User first name. |
USER_GENDER |
string(30) |
User Gender |
☐ |
User gender. |
USER_ID |
string(240) |
User ID |
☐ |
User ID. |
USER_LANGUAGE_CODE |
string(240) |
User Language Code |
☐ |
User language code. |
USER_LANGUAGE |
string(240) |
User Language |
☐ |
User language. |
USER_LAST_LOGON |
datetime |
User Last Logon |
☐ |
User last logon. |
USER_LAST_NAME |
string(240) |
User Last Name |
☐ |
User last name. |
USER_LINKED_IN_ACCOUNT |
string(240) |
User LinkedIn Account |
☐ |
User LinkedIn account URL. |
USER_LOG_ON_CODE |
string(240) |
User Log On Code |
☐ |
User log on code. |
USER_MIDDLE_NAME |
string(240) |
User Middle Name |
☐ |
User middle name. |
USER_MOBILE_NUMBER |
string(240) |
User Mobile Number |
☐ |
User mobile number. |
USER_NAME_AND_COMPANY |
string(240) |
User Name and Company |
☐ |
User name and company name. |
USER_NAME |
string(240) |
User Name |
☐ |
User name. |
USER_NATIONALITY |
string(240) |
User Nationality |
☐ |
User nationality. |
USER_PHONE_NUMBER |
string(240) |
User Phone Number |
☐ |
User phone number. |
USER_PICTURE_BLOB |
byte[] |
User Picture (BLOB) |
☐ |
User picture as BLOB. |
USER_PICTURE_MIME_TYPE |
string(240) |
User Picture MIME Type |
☐ |
User picture MIME type. |
USER_PICTURE_URL |
string(4000) |
User Picture (URL) |
☐ |
User picture URL. |
USER_SKYPE_ACCOUNT |
string(240) |
User Skype Account |
☐ |
User Skype account. |
USER_TITLE |
string(240) |
User Title |
☐ |
User titlet. |
USER_TWITTER_ACCOUNT |
string(240) |
User Twitter Account |
☐ |
User Twitter account. |
USER_WEBSITE_URL |
string(240) |
User Website |
☐ |
User website URL. |
17-05-2021 11:57 Version 20.1.419-BETA+3191
