Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
ACMT_Idnr int NUMBER(38,0) int int false Primary Key
ACMT_AH_Idnr int NUMBER(38,0) int int false Reference to AH
ACMT_TimeStamp datetime DATE timestamp timestamp true UTC - Time comment added
ACMT_USR_Idnr int NUMBER(38,0) int int true OH Idnr of comment user
ACMT_Content varchar(1024) VARCHAR2 (1024 CHAR) varchar(1024) varchar(1024) true Comment Content Text

Indexes:

Name Fields Primary Unique Clustered Nonclustered
NK_ACMT_AHIdnr ACMT_AH_Idnr, ACMT_TimeStamp false false false false
PK_ACMT ACMT_Idnr, ACMT_AH_Idnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_ACMT_AH ACMT_AH_Idnr AH_Idnr

Return to the Index File