Reference > Database > WebSphere Commerce database tables > B

WebSphere Commerce database table: BUYSUPSEC

Reserved for IBM internal use.

Column Name	Column Type	Description
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.

Indexes

Index Name	Indexed Column Names	Index Type
SQL100520030306100	BUYORG_ID+SUPORG_ID	Primary Key
I0000494	SUPORG_ID	Non-Unique Index

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_144	SUPORG_ID	ORGENTITY	ORGENTITY_ID	Cascade
F_145	BUYORG_ID	ORGENTITY	ORGENTITY_ID	Cascade

Related reference

• Member data model

_vcc_freeselect_bottom_

+

Search Tips   |   Advanced Search