Name Type MSSql Type Oracle Type DB2 Nullable Description
OTI_OH_Idnr int NUMBER(38,0) int false reference to the object header (OH)
OTI_Lnr smallint NUMBER(38,0) smallint false ascending number of the element
OTI_Caption varchar (30) VARCHAR2 (30 CHAR) varchar(30) true caption
OTI_Left int NUMBER(38,0) int true x position
OTI_Top int NUMBER(38,0) int true y position
OTI_Width int NUMBER(38,0) int true width
OTI_Height int NUMBER(38,0) int true height
OTI_Style int NUMBER(38,0) int true 0=cake, 1=bar,2=OnOff,3=traffic lights
OTI_Min int NUMBER(38,0) int true minimum value
OTI_Max1 int NUMBER(38,0) int true maximum value 1
OTI_Max2 int NUMBER(38,0) int true maximum value 2
OTI_Max3 int NUMBER(38,0) int true maximum value 3
OTI_ValueType int NUMBER(38,0) int true value type
OTI_SrcType varchar (8) VARCHAR2 (8 CHAR) varchar(8) true source type
OTI_SrcName1 varchar (200) VARCHAR2 (200 CHAR) varchar(200) true variable
OTI_SrcName2 varchar (200) VARCHAR2 (200 CHAR) varchar(200) true validity value of the variable
OTI_Rest varchar (255) VARCHAR2 (255 CHAR) varchar(255) true other attributes
OTI_Container int NUMBER(38,0) int true container where this object is in (LNR)

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_OTI OTI_OH_Idnr, OTI_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_OTI_OTA OTI_OH_Idnr OTA_OH_Idnr

Return to the Index File