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)

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_USRP USRP_OH_Idnr, USRP_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_USRP_USR USRP_OH_Idnr USR_OH_Idnr

Return to the Index File