WebSphere Commerce database table: BUYSUPSEC

Reserved for IBM internal use.


Column Description(s):
Column NameColumn TypeDescription
BUYORG_ID BIGINT NOT NULL Reserved for IBM internal use.
SUPORG_ID BIGINT NOT NULL Reserved for IBM internal use.
BUYERLOGONID VARCHAR(254) NOT NULL Reserved for IBM internal use.
BUYERLOGONPASSWORD BINARY NOT NULL Reserved for IBM internal use.
SUPLOGONIDTYPE VARCHAR(64) Reserved for IBM internal use.
SUPLOGONID VARCHAR(254) Reserved for IBM internal use.
SUPLOGONPASSWORD BINARY Reserved for IBM internal use.
AUTHLEVEL INTEGER NOT NULL Reserved for IBM internal use.
EXPIRYDATE TIMESTAMP Reserved for IBM internal use.
STATUS INTEGER Reserved for IBM internal use.
FIELD1 VARCHAR(64) Reserved for IBM internal use.
FIELD2 VARCHAR(64) Reserved for IBM internal use.
FIELD3 VARCHAR(64) Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031204640 BUYORG_ID+SUPORG_ID Primary Key
I0000494 SUPORG_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_144 SUPORG_ID ORGENTITY ORGENTITY_ID Cascade
F_145 BUYORG_ID ORGENTITY ORGENTITY_ID Cascade

Feedback