SYSTEMDATACONTAINERS: Data Dictionary Datacontainer
read only
- Katalog:
DataDictionary - Schema:
Invantive - Label: Datacontainer
Active data containers.
Es können nur Daten abgerufen werden.
Tabellenspalten
Die Spalten der Tabelle SYSTEMDATACONTAINERS sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ALIAS |
varchar2 |
Alias | Alias of the data container. | ||
CONSUMPTION_ |
number |
Verbrauch – Letzte Runde | Number of calls or credits the platform charged for its last answer. | ||
DAILY_ |
number |
Tageslimit | Number of calls allowed per day. | ||
DAILY_ |
number |
Täglich verbleibend | Number of calls left of the current day. | ||
DAILY_ |
datetime |
Tägliches Rücksetzdatum (UTC) | Moment at which the number of calls allowed per day is replenished. | ||
DAILY_ |
number |
Täglicher Gebrauch | Number of calls spent of the current day. | ||
HOURLY_ |
number |
Stundenlimit | Number of calls allowed per hour. | ||
HOURLY_ |
number |
Verbleibende Stunden | Number of calls left of the current hour. | ||
HOURLY_ |
datetime |
Datum für stündliche Zurücksetzung (UTC) | Moment at which the number of calls allowed per hour is replenished. | ||
ID |
varchar2 |
ID | Data container ID. | ||
IS_ |
char |
Ist Standard? | Is the default provider? | ||
IS_ |
char |
Ist Dienstleister? | Is the provider a service provider? | ||
LAST_ |
datetime |
Messung UTC | Moment the platform last stated its rate limit, without which the figures beside it can not be read. | ||
MINUTELY_ |
number |
Minutenbegrenzung | Number of calls allowed per minute. | ||
MINUTELY_ |
number |
Verbleibende Minuten | Number of calls left of the current minute. | ||
MINUTELY_ |
datetime |
Datum und Uhrzeit (UTC) auf die Minute genau zurücksetzen | Moment at which the number of calls allowed per minute is replenished. | ||
PARTITIONS_ |
int32 |
Anzahl der Partitionen | Number of partitions. | ||
PARTITIONS_ |
int32 |
Anzahl der ausgewählten Partitionen | Number of selected partitions. | ||
PROVIDER_ |
varchar2 |
Treiber Datenbankpoolbeschreibung | Pool description of the database. | ||
PROVIDER_ |
varchar2 |
Treiber Datenbankpreisstaffel | Pricing tier of the database. | ||
PROVIDER_ |
varchar2 |
Treiber Datenbankdienstebene | Service tier of the database. | ||
PROVIDER_ |
varchar2 |
Version des Datenbanktreiber | Version text of the database. | ||
PROVIDER_ |
varchar2 |
Treiber Datenbankversionsnummer | Version number of the database. | ||
PROVIDER_ |
varchar2 |
Treiberbeschreibung | Description of the provider. | ||
PROVIDER_ |
guid |
Treiber Instanz-UID | Unique ID of the provider instance. | ||
PROVIDER_ |
varchar2 |
Anbietername | Name of the provider. | ||
PROVIDER_ |
varchar2 |
Treiber Kurzname | Short name of the provider. | ||
SECONDLY_ |
number |
Zweitens: Begrenzung | Number of calls allowed per second. | ||
SECONDLY_ |
number |
Zweitens: Verbleibend | Number of calls left of the current second. | ||
SECONDLY_ |
datetime |
Zweitens: Datum auf UTC zurücksetzen | Moment at which the number of calls allowed per second is replenished. | ||
SESSION_ |
int32 |
UTC-Sitzungszeitversatz (Sek.) | UTC session offset (seconds). | ||
UI_ |
varchar2 |
UI-Sprachcode | User interface language code. | ||
USER_ |
varchar2 |
Cognito-Benutzer-ID | Identifier of the user in the Invantive Cloud user administration. | ||
USER_ |
varchar2 |
Benutzerfirma Addresszeile 1 | Address line 1 of the company of the user. | ||
USER_ |
varchar2 |
Benutzerfirma Addresszeile 2 | Address line 2 of the company of the user. | ||
USER_ |
varchar2 |
Benutzerfirma Addresszeile 3 | Address line 3 of the company of the user. | ||
USER_ |
varchar2 |
Firmen-BIC | BIC of the company of the user. | ||
USER_ |
varchar2 |
Benutzer Unternehmen Stadt | City of the company of the user. | ||
USER_ |
varchar2 |
Benutzerunternehmen CoC-Nummer | CoC number of the company of the user. | ||
USER_ |
varchar2 |
Land des Unternehmens | Country of the company of the user. | ||
USER_ |
varchar2 |
Währungscode des Unternehmens | Currency code of the company of the user. | ||
USER_ |
date |
Benutzerfirma gegründet | Date established of the company of the user. | ||
USER_ |
varchar2 |
Benutzer Unternehmen E-Mail-Adresse | Email address of the company of the user. | ||
USER_ |
int32 |
Benutzerfirma Mitarbeiter | Number of employees of the company of the user. | ||
USER_ |
varchar2 |
GLN-Nummer des Unternehmens | GLN number of the company of the user. | ||
USER_ |
varchar2 |
Firmen-IBAN | IBAN of the company of the user. | ||
USER_ |
varchar2 |
Benutzerfirma-ID | Unique ID of the company of the user. | ||
USER_ |
varchar2 |
Benutzerfirma Rechtsstruktur | Legal structure of the company of the user. | ||
USER_ |
varchar2 |
Benutzer Unternehmenname | Name of the company of the user. | ||
USER_ |
varchar2 |
Benutzerfirma PayPal-Kennung | PayPal identifier of the company of the user. | ||
USER_ |
varchar2 |
Benutzerfirma Telefon | Phone of the company of the user. | ||
USER_ |
varchar2 |
Unternehmen Postleitzahl | ZIP-code of the company of the user. | ||
USER_ |
varchar2 |
RSIN-Nummer des Benutzerunternehmens | RSIN number of the company of the user. | ||
USER_ |
varchar2 |
Benutzerfirma SIRET-Nummer | SIRET number of the company of the user. | ||
USER_ |
varchar2 |
Unternehmen Bundesland | State of the company of the user. | ||
USER_ |
varchar2 |
Benutzerfirma Markennamen | Tradenames of the company of the user. | ||
USER_ |
varchar2 |
Benutzerfirma Umsatzsteuer-Identifikationsnummer | VAT number of the company of the user. | ||
USER_ |
varchar2 |
Unternehmen Lohnsteuernummer | Wage tax number of the company of the user. | ||
USER_ |
varchar2 |
Benutzerfirma Website | Web site of the company of the user. | ||
USER_ |
varchar2 |
Benutzer E-Mail-Adresse | User email address. | ||
USER_ |
varchar2 |
Vorname des Benutzers | User first name. | ||
USER_ |
varchar2 |
Geschlecht des Benutzers | User gender. | ||
USER_ |
varchar2 |
Benutzer-Kennung | User ID. | ||
USER_ |
varchar2 |
Benutzersprache | User language; the same value as the user language code. | ||
USER_ |
varchar2 |
Benutzersprachencode | User language code. | ||
USER_ |
datetime |
Letzte Anmeldung des Benutzers | User last logon. | ||
USER_ |
varchar2 |
Nachname des Benutzers | User last name. | ||
USER_ |
varchar2 |
LinkedIn-Benutzerkonto | User LinkedIn account URL. | ||
USER_ |
varchar2 |
Benutzeranmeldungscode | User log on code. | ||
USER_ |
varchar2 |
Zweiter Vorname des Benutzers | User middle name. | ||
USER_ |
varchar2 |
Handynummer des Benutzers | User mobile number. | ||
USER_ |
varchar2 |
Benutzername | User name. | ||
USER_ |
varchar2 |
Nutzername und Unternehmen | User name and company name. | ||
USER_ |
varchar2 |
Nationalität des Benutzers | User nationality. | ||
USER_ |
varchar2 |
Telefonnummer des Benutzers | User phone number. | ||
USER_ |
blob |
Benutzerbild (BLOB) | User picture as BLOB. | ||
USER_ |
varchar2 |
Benutzerbild MIME-Typ | User picture MIME type. | ||
USER_ |
varchar2 |
Benutzerbild (URL) | User picture URL. | ||
USER_ |
varchar2 |
Skype-Konto des Benutzers | User Skype account. | ||
USER_ |
varchar2 |
Titel des Benutzers | User titlet. | ||
USER_ |
varchar2 |
Twitter-Konto des Nutzers | User Twitter account. | ||
USER_ |
varchar2 |
Webseite des Nutzers | User website URL. |
Tasten
| Key | Column | Bezieht sich auf | Kind | Description |
|---|---|---|---|---|
SYSTEMDATACONTAINERS_ |
PROVIDER_ |
SYSTEMPROVIDERS.NAME |
Key |
Verwiesen von
- 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)
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: