SYSTEMDATACONTAINERS: Data Dictionary Datacontainer
read only
- Catalog:
DataDictionary - Schema:
Invantive - Label: Datacontainer
Active data containers.
Can only retrieve data.
Table Columns
The columns of the table SYSTEMDATACONTAINERS are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ALIAS |
varchar2 |
Alias | Alias of the data container. | ||
CONSUMPTION_ |
number |
Consumption Last Call | Number of calls or credits the platform charged for its last answer. | ||
DAILY_ |
number |
Daily Limit | Number of calls allowed per day. | ||
DAILY_ |
number |
Daily Remaining | Number of calls left of the current day. | ||
DAILY_ |
datetime |
Daily Reset Date Utc | Moment at which the number of calls allowed per day is replenished. | ||
DAILY_ |
number |
Daily Used | Number of calls spent of the current day. | ||
HOURLY_ |
number |
Hourly Limit | Number of calls allowed per hour. | ||
HOURLY_ |
number |
Hourly Remaining | Number of calls left of the current hour. | ||
HOURLY_ |
datetime |
Hourly Reset Date Utc | Moment at which the number of calls allowed per hour is replenished. | ||
ID |
varchar2 |
ID | Data container ID. | ||
IS_ |
char |
Is Default? | Is the default provider? | ||
IS_ |
char |
Is Service Provider? | Is the provider a service provider? | ||
LAST_ |
datetime |
Measurement Utc | Moment the platform last stated its rate limit, without which the figures beside it can not be read. | ||
MINUTELY_ |
number |
Minutely Limit | Number of calls allowed per minute. | ||
MINUTELY_ |
number |
Minutely Remaining | Number of calls left of the current minute. | ||
MINUTELY_ |
datetime |
Minutely Reset Date Utc | Moment at which the number of calls allowed per minute is replenished. | ||
PARTITIONS_ |
int32 |
Number of Partitions | Number of partitions. | ||
PARTITIONS_ |
int32 |
Number of Selected Partitions | Number of selected partitions. | ||
PROVIDER_ |
varchar2 |
Provider Database Pool Description | Pool description of the database. | ||
PROVIDER_ |
varchar2 |
Provider Database Pricing Tier | Pricing tier of the database. | ||
PROVIDER_ |
varchar2 |
Provider Database Service Tier | Service tier of the database. | ||
PROVIDER_ |
varchar2 |
Provider Database Version | Version text of the database. | ||
PROVIDER_ |
varchar2 |
Provider Database Version Number | Version number of the database. | ||
PROVIDER_ |
varchar2 |
Provider Description | Description of the provider. | ||
PROVIDER_ |
guid |
Provider Instance UID | Unique ID of the provider instance. | ||
PROVIDER_ |
varchar2 |
Provider Name | Name of the provider. | ||
PROVIDER_ |
varchar2 |
Provider Short Name | Short name of the provider. | ||
SECONDLY_ |
number |
Secondly Limit | Number of calls allowed per second. | ||
SECONDLY_ |
number |
Secondly Remaining | Number of calls left of the current second. | ||
SECONDLY_ |
datetime |
Secondly Reset Date Utc | Moment at which the number of calls allowed per second is replenished. | ||
SESSION_ |
int32 |
UTC Session Time Offset (sec) | UTC session offset (seconds). | ||
UI_ |
varchar2 |
UI Language Code | User interface language code. | ||
USER_ |
varchar2 |
Cognito User ID | Identifier of the user in the Invantive Cloud user administration. | ||
USER_ |
varchar2 |
User Company Address Line 1 | Address line 1 of the company of the user. | ||
USER_ |
varchar2 |
User Company Address Line 2 | Address line 2 of the company of the user. | ||
USER_ |
varchar2 |
User Company Address Line 3 | Address line 3 of the company of the user. | ||
USER_ |
varchar2 |
Company BIC | BIC of the company of the user. | ||
USER_ |
varchar2 |
User Company City | City of the company of the user. | ||
USER_ |
varchar2 |
User Company CoC Number | CoC number of the company of the user. | ||
USER_ |
varchar2 |
Company Country | Country of the company of the user. | ||
USER_ |
varchar2 |
Company Currency Code | Currency code of the company of the user. | ||
USER_ |
date |
User Company Established | Date established of the company of the user. | ||
USER_ |
varchar2 |
User Company Email Address | Email address of the company of the user. | ||
USER_ |
int32 |
User Company Employees | Number of employees of the company of the user. | ||
USER_ |
varchar2 |
Company GLN Number | GLN number of the company of the user. | ||
USER_ |
varchar2 |
Company IBAN | IBAN of the company of the user. | ||
USER_ |
varchar2 |
User Company ID | Unique ID of the company of the user. | ||
USER_ |
varchar2 |
User Company Legal Structure | Legal structure of the company of the user. | ||
USER_ |
varchar2 |
User Company Name | Name of the company of the user. | ||
USER_ |
varchar2 |
User Company PayPal Identifier | PayPal identifier of the company of the user. | ||
USER_ |
varchar2 |
User Company Phone | Phone of the company of the user. | ||
USER_ |
varchar2 |
Company ZIP Code | ZIP-code of the company of the user. | ||
USER_ |
varchar2 |
User Company RSIN Number | RSIN number of the company of the user. | ||
USER_ |
varchar2 |
User Company SIRET Number | SIRET number of the company of the user. | ||
USER_ |
varchar2 |
Company State | State of the company of the user. | ||
USER_ |
varchar2 |
User Company Tradenames | Tradenames of the company of the user. | ||
USER_ |
varchar2 |
User Company VAT Number | VAT number of the company of the user. | ||
USER_ |
varchar2 |
Company Wage Tax Number | Wage tax number of the company of the user. | ||
USER_ |
varchar2 |
User Company Website | Web site of the company of the user. | ||
USER_ |
varchar2 |
User Email Address | User email address. | ||
USER_ |
varchar2 |
User First Name | User first name. | ||
USER_ |
varchar2 |
User Gender | User gender. | ||
USER_ |
varchar2 |
User ID | User ID. | ||
USER_ |
varchar2 |
User Language | User language; the same value as the user language code. | ||
USER_ |
varchar2 |
User Language Code | User language code. | ||
USER_ |
datetime |
User Last Logon | User last logon. | ||
USER_ |
varchar2 |
User Last Name | User last name. | ||
USER_ |
varchar2 |
User LinkedIn Account | User LinkedIn account URL. | ||
USER_ |
varchar2 |
User Log On Code | User log on code. | ||
USER_ |
varchar2 |
User Middle Name | User middle name. | ||
USER_ |
varchar2 |
User Mobile Number | User mobile number. | ||
USER_ |
varchar2 |
User Name | User name. | ||
USER_ |
varchar2 |
User Name and Company | User name and company name. | ||
USER_ |
varchar2 |
User Nationality | User nationality. | ||
USER_ |
varchar2 |
User Phone Number | User phone number. | ||
USER_ |
blob |
User Picture (BLOB) | User picture as BLOB. | ||
USER_ |
varchar2 |
User Picture MIME Type | User picture MIME type. | ||
USER_ |
varchar2 |
User Picture (URL) | User picture URL. | ||
USER_ |
varchar2 |
User Skype Account | User Skype account. | ||
USER_ |
varchar2 |
User Title | User titlet. | ||
USER_ |
varchar2 |
User Twitter Account | User Twitter account. | ||
USER_ |
varchar2 |
User Website | User website URL. |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
SYSTEMDATACONTAINERS_ |
PROVIDER_ |
SYSTEMPROVIDERS.NAME |
Key |
Referenced By
- SESSIONIOS
PROVIDER_INSTANCE_UID(Textual) - SESSIONROWSCHANGED
PROVIDER_INSTANCE_UID(Textual) - SYSTEMCATALOGS
PROVIDER_INSTANCE_UID(Key) - SYSTEMDATACONTAINERATTRIBUTES
PROVIDER_INSTANCE_UID(Key) - SYSTEMDATACONTAINERHTTPCACHECONTENTS
PROVIDER_INSTANCE_UID(Key) - SYSTEMDATACONTAINERMESSAGES
PROVIDER_INSTANCE_UID(Key) - SYSTEMDATACONTAINERPROPERTIES
PROVIDER_INSTANCE_UID(Key) - SYSTEMDATACONTAINERRESERVEDWORDS
PROVIDER_INSTANCE_UID(Key) - SYSTEMDATACONTAINERSLOTBASEDRATELIMITERS
PROVIDER_INSTANCE_UID(Key) - SYSTEMDATACONTAINERSLOTBASEDRATELIMITERSLOTS
PROVIDER_INSTANCE_UID(Key) - SYSTEMDOMAINCODES
PROVIDER_INSTANCE_UID(Key) - SYSTEMDOMAINCODEVALUES
PROVIDER_INSTANCE_UID(Key) - SYSTEMFILTERTOTABLEFUNCTIONPARAMETERS
PROVIDER_INSTANCE_UID(Key) - SYSTEMLICENSES
PROVIDER_INSTANCE_UID(Key) - SYSTEMOAUTHFLOWEVENTS
PROVIDER_INSTANCE_UID(Key) - SYSTEMPACKAGEFUNCTIONARGUMENTS
PROVIDER_INSTANCE_UID(Key) - SYSTEMPACKAGEFUNCTIONS
PROVIDER_INSTANCE_UID(Key) - SYSTEMPACKAGES
PROVIDER_INSTANCE_UID(Key) - SYSTEMPARTITIONS
PROVIDER_INSTANCE_UID(Key) - SYSTEMPARTITIONSTATISTICS
PROVIDER_INSTANCE_UID(Key) - SYSTEMPARTITIONTAGS
PROVIDER_INSTANCE_UID(Key) - SYSTEMPROVIDERSACTIVE
PROVIDER_INSTANCE_UID(Key) - SYSTEMSCHEMAS
PROVIDER_INSTANCE_UID(Key) - SYSTEMTABLECOLUMNS
PROVIDER_INSTANCE_UID(Key) - SYSTEMTABLEFOREIGNKEYS
PROVIDER_INSTANCE_UID(Key) - SYSTEMTABLEFUNCTIONPARAMETERS
PROVIDER_INSTANCE_UID(Key) - SYSTEMTABLEKEYS
PROVIDER_INSTANCE_UID(Key) - SYSTEMTABLES
PROVIDER_INSTANCE_UID(Key) - SYSTEMVIEWS
PROVIDER_INSTANCE_UID(Key)
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: