AT&T CentreVu CMS Administration Bedienerhandbuch Seite 213

  • Herunterladen
  • Zu meinen Handbüchern hinzufügen
  • Drucken
  • Seite
    / 268
  • Inhaltsverzeichnis
  • FEHLERBEHEBUNG
  • LESEZEICHEN
  • Bewertet. / 5. Basierend auf Kundenbewertungen
Seitenansicht 212
Database Tables
CentreVu®
CMS Open Database Connectivity
Database Items 3-155
Database Items 3
Overview 3
The Database Items descriptions apply specifically to items in the
dbitems
table. The table contains definitions for Dictionary standard
and custom database items, constants, and calculations. The index is
ITEM_NAME. Because the data contained in the
dbitems
table are
administrative, and are used to define dictionary entries, the table is not
dependent on ECS releases.
Database Items 3
The following table describes the data items in the CMS Database Items
dictionary table.
Database Item Description
Data
Type
Column
Type
Length
ITEM_TYPE
(index)
The type of data for the row. Valid
values are:
dbase = database item
calc = calculation
constant = constant
cust_def = customer-defined
database item
A char(8) 8 byte
ASCII
text string
ITEM_NAME
(index)
The name of the data item. There
can be many ITEM_NAMEs for a
specific ITEM_TYPE.
A char(20) 20 byte
ASCII
text string
FORMULA The formula for the database
constant or calculation.
A char(70) 70 byte
ASCII
text string
STANDARD This item indicates if the item is a
standard or custom database item.
Values are:
1 = standard, not 1 (null) = custom.
A smallint 2 bytes
DESCR The description of the database
calculation, constant, or
standard/custom database item.
A char(50) 50 byte
ASCII
text string
Seitenansicht 212
1 2 ... 208 209 210 211 212 213 214 215 216 217 218 ... 267 268

Kommentare zu diesen Handbüchern

Keine Kommentare