| Name | Type MSSql | Type Oracle | Type DB2 | Type Postgresql | Nullable | Description |
|---|---|---|---|---|---|---|
| USRP_OH_Idnr | int | NUMBER(38,0) | int | int | false | Connection to table USR |
| USRP_Lnr | smallint | NUMBER(38,0) | smallint | smallint | false | Part of Primary Key |
| USRP_Content | varbinary(255) | RAW(255) | varchar(255) for bit data | bytea | true | Encrypted password content |
| USRP_PwHash | varchar(max) | CLOB | clob(20480 k) COMPACT | text | true | Password history. |
| USRP_PwIsUtf8 | smallint | NUMBER(38,0) | smallint | smallint | true | Indicates if USRP_PwHash was created from UTF-8 (1) or legacy encoding (0) |
| Name | Fields | Primary | Unique | Clustered | Nonclustered |
|---|---|---|---|---|---|
| PK_USRP | USRP_OH_Idnr, USRP_Lnr | true | true | true | false |
| Name | Local References | Foreign References |
|---|---|---|
| FK_USRP_USR | USRP_OH_Idnr | USR_OH_Idnr |
Return to the Index File