Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
MSG_Idnr int NUMBER(38,0) int int false MLS ID
MSG_MSGT_Type char (1) CHAR (1 CHAR) char(1) char (1) false primary key of the MSGT
MSG_OH_Idnr int NUMBER(38,0) int int true primary key of the object header
MSG_TicketNumber varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true MLS Ticket nummer
MSG_SpeakingId varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true MLS Speaker
MSG_CheckFlag char (1) CHAR (1 CHAR) char(1) char (1) true MLS entry should be check

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_MSG MSG_Idnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_MSG_MSGT MSG_MSGT_Type MSGT_Type
FK_MSG_MSGA MSG_OH_Idnr MSGA_OH_Idnr

Return to the Index File