Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
OTI_OH_Idnr int NUMBER(38,0) int int false ID of the cockpit.
OTI_Lnr smallint NUMBER(38,0) smallint smallint false Sequenced number of the elements within the cockpit.
OTI_Caption varchar (30) VARCHAR2 (30 CHAR) varchar(30) varchar (30) true The caption of the element.
OTI_Left int NUMBER(38,0) int int true x-coordinate of the element.
OTI_Top int NUMBER(38,0) int int true y-coordinate of the element.
OTI_Width int NUMBER(38,0) int int true Width of the element.
OTI_Height int NUMBER(38,0) int int true Height of the element.
OTI_Style int NUMBER(38,0) int int true Graphical representatoin of the element. 0 = pie chart, 1 = bar chart, 2 = switch, 3 = traffic lights
OTI_Min int NUMBER(38,0) int int true minimum value.
OTI_Max1 int NUMBER(38,0) int int true maximum value for first limit.
OTI_Max2 int NUMBER(38,0) int int true maximum value for second limit.
OTI_Max3 int NUMBER(38,0) int int true maximum value for third limit.
OTI_ValueType int NUMBER(38,0) int int true Type of the value.
OTI_SrcType varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Type of the source.
OTI_SrcName1 varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of the source (VARA).
OTI_SrcName2 varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Key of the source (VARA).
OTI_Rest varchar (255) VARCHAR2 (255 CHAR) varchar(255) varchar (255) true Additional attributes.
OTI_Container int NUMBER(38,0) int int true The container (line number) this object is located in.

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