invantive documentation
Invantive SupportforenAnmelden / Eintragen

SYSTEMPARTITIONSTATISTICS: Data Dictionary System Partition Statistics

read only

  • Katalog: DataDictionary
  • Schema: Invantive
  • Label: System Partition Statistics

Statistics per partitions for all active data containers.

Es können nur Daten abgerufen werden.

Tabellenspalten

Die Spalten der Tabelle SYSTEMPARTITIONSTATISTICS 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
COMPANY_SERVER_MOVE_DATE_UTC datetime Firma Umzugsdatum Server (UTC) Last server move date of the company.
PROVIDER_DATA_CONTAINER_ALIAS varchar2(4000) Datencontaineralias Data container alias.
PROVIDER_DATA_CONTAINER_ID varchar2(4000) Datenkontainer ID Data container ID.
PROVIDER_DESCRIPTION varchar2(16000) Treiberbeschreibung Provider description.
PROVIDER_INSTANCE_UID guid Treiber Instanz-UID Unique ID of the provider instance.
PROVIDER_NAME varchar2(240) Anbietername Name of the provider.
PROVIDER_SHORT_NAME varchar2(240) Treiber Kurzname Provider short name.
PTN_ALLOW_WRITE char Partition für Schreibzugriffe freigeben Whether the partition allows writes.
PTN_CODE varchar2(240) Partitionscode Unique code of the partition.
PTN_COMPANY_ADDRESS varchar2(4000) Partition Firmenadresse Address of the company of the partition.
PTN_COMPANY_CITY varchar2(4000) Partition Firmenstadt City of the company of the partition.
PTN_COMPANY_COC_NUMBER varchar2(4000) CoC-Nummer der Partition Company Chamber of Commerce number of the company of the partition.
PTN_COMPANY_COUNTRY varchar2(4000) Partition Unternehmen Land Country of the company of the partition.
PTN_COMPANY_EMAIL_ADDRESS varchar2(4000) E-Mail-Adresse der Firma „Partition“ Email address of the company of the partition.
PTN_COMPANY_IBAN_NUMBER varchar2(4000) IBAN-Nummer des Unternehmens IBAN number of the company of the partition.
PTN_COMPANY_NAME varchar2(4000) Name des Unternehmens „Partition“ Name of the company of the partition.
PTN_COMPANY_PHONE varchar2(4000) Telefonnummer der Firma „Partition“ Phone of the company of the partition.
PTN_COMPANY_POSTAL_CODE varchar2(4000) Ort, Firma, Postleitzahl ZIP-code of the company of the partition.
PTN_COMPANY_RSIN_NUMBER varchar2(4000) Unternehmen RSIN-Nummer RSIN number of the company of the partition.
PTN_COMPANY_STATE varchar2(4000) Bundesland der Firma „Partition“ State of the company of the partition.
PTN_COMPANY_TWITTER_ACCOUNT varchar2(4000) Twitter-Konto der Firma Partition Twitter account of the company of the partition.
PTN_COMPANY_VAT_NUMBER varchar2(4000) Umsatzsteuer-Identifikationsnummer der Partition Company VAT number of the company of the partition.
PTN_COMPANY_WAGE_TAX_NUMBER varchar2(4000) Steuernummer der Zweigniederlassung für Lohnsteuer Wage tax number of the company of the partition.
PTN_COMPANY_WEB_SITE varchar2(4000) Website der Firma Partition Web site of the company of the partition.
PTN_CREATED_UTC datetime Partition erstellt When the partition was created (UTC).
PTN_DESCRIPTION varchar2(4000) Beschreibung der Partition Description.
PTN_FIRST_USE_UTC datetime Partition – Erste Verwendung When the partition has been used first in this session (UTC).
PTN_INSTANCE_UID guid Instanz-UID Unique ID of the instance.
PTN_IS_SELECTED char Ausgewählte Partition Whether the partition is currently selected.
PTN_IS_SELECTED_BY_DEFAULT char Partition standardmäßig ausgewählt Whether the partition is selected by default.
PTN_IS_USED char Verwendete Partition Whether the partition has been used in this session.
PTN_LABEL varchar2(4000) Partition-Bezeichnung Label for use in lists.
PTN_MASTER_ROLL_UP varchar2(4000) Partition Master – Roll-up Master roll-up.
PTN_MODIFIED_UTC datetime Partition geändert When the partition was last modified (UTC).
PTN_NAME varchar2(4000) Partitionenamen Name.
PTN_ROLL_UP varchar2(4000) Rollvorhang-Partition Roll-up.
PTN_SELECTED_LAST_MODIFIED_UTC datetime Ausgewählt – Letzte Änderung (UTC) When the partition selection was last modified (UTC).
PTN_SELECTED_LAST_SET_UTC datetime Ausgewählter letzter Satz (UTC) When the partition selection was last set (UTC).
PTN_SELECTED_LAST_UNSET_UTC datetime Ausgewählt – Zuletzt nicht festgelegt (UTC) When the partition selection was last unset (UTC).
PTN_SHORT_NAME varchar2(4000) Kurzbezeichnung der Partition Short name.
STC_CODE varchar2(240) Code Unique code of the partition statistic.
STC_CREATION_DATE_UTC datetime Datum erstellen Date at which the entry was originally created (UTC).
STC_DESCRIPTION varchar2(240) Description Description of the partition statistic.
STC_IS_STANDARD char Ist Standard? Is the statistic a standard statistic?
STC_REDUCED_ACCURACY_VALUE varchar2(240) Reduzierter Genauigkeitswert Reduced accuracy value of the partition statistic.
STC_TYPE varchar2(240) Wert Typ Type of value of the partition statistic.
STC_VALUE varchar2(240) Value Value of the partition statistic.

Tasten

Key Column Bezieht sich auf Kind Description
SYSTEMPARTITIONSTATISTICS_PROVIDER_INSTANCE_UID_SYSTEMDATACONTAINERS_fk PROVIDER_INSTANCE_UID SYSTEMDATACONTAINERS.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: