| Name | Type MSSql | Type Oracle | Type DB2 | Type Postgresql | Nullable | Description |
|---|---|---|---|---|---|---|
| UAPI_OH_Idnr | int | NUMBER(38,0) | int | int | false | Unique user object identifier (ID). |
| UAPI_Name | varchar (512) | VARCHAR2 (512 CHAR) | varchar(512) | varchar (512) | false | Name or alias for the API key. |
| UAPI_Expiration | datetime | DATE | timestamp | timestamp | true | Time when key becomes invalid |
| UAPI_Hash | varchar (512) | VARCHAR2 (512 CHAR) | varchar(512) | varchar (512) | false | Unique API key hash for user authentication. |
| UAPI_Client | smallint | NUMBER(38,0) | smallint | smallint | true | Client of the user. |
| Name | Fields | Primary | Unique | Clustered | Nonclustered |
|---|---|---|---|---|---|
| PK_UAPI | UAPI_OH_Idnr, UAPI_Name | true | true | false | false |
| Name | Local References | Foreign References |
|---|---|---|
| FK_UAPI_USR | UAPI_OH_Idnr | USR_OH_Idnr |
Return to the Index File