| Name | Type MSSql | Type Oracle | Type DB2 | Nullable | Description |
|---|---|---|---|---|---|
| ACMT_Idnr | int | NUMBER(38,0) | int | false | Primary Key |
| ACMT_AH_Idnr | int | NUMBER(38,0) | int | false | Reference to AH |
| ACMT_TimeStamp | datetime | DATE | timestamp | true | UTC - Time comment added |
| ACMT_USR_Idnr | int | NUMBER(38,0) | int | true | OH Idnr of comment user |
| ACMT_Content | varchar(1024) | VARCHAR2 (1024 CHAR) | varchar(1024) | true | Comment Content Text |
| 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 |
| Name | Local References | Foreign References |
|---|---|---|
| FK_ACMT_AH | ACMT_AH_Idnr | AH_Idnr |
Return to the Index File