Reference > Database > WebSphere Commerce database tables > O


WebSphere Commerce database table: ORDBTB

Reserved for IBM internal use.

Column Name Column Type Description
ORBRFNBR INTEGER NOT NULL Reserved for IBM internal use.
ORBUNBR VARCHAR(30) Reserved for IBM internal use.
ORBUREQNBR VARCHAR(30) Reserved for IBM internal use.
ORBVERNBR INTEGER Reserved for IBM internal use.
ORBTYPE CHAR(2) Reserved for IBM internal use.
ORBRLNBR VARCHAR(30) Reserved for IBM internal use.
ORBNOTES1 VARCHAR(600) Reserved for IBM internal use.
ORBNOTES2 VARCHAR(600) Reserved for IBM internal use.
ORBSCOND CHAR(2) Reserved for IBM internal use.
ORBRSDATE TIMESTAMP Reserved for IBM internal use.
ORBSSDATE TIMESTAMP Reserved for IBM internal use.
ORBASDATE TIMESTAMP Reserved for IBM internal use.
ORBUPDATE TIMESTAMP Reserved for IBM internal use.
ORBUAMDATE TIMESTAMP Reserved for IBM internal use.
ORBFLAG CHAR(2) NOT NULL Reserved for IBM internal use.
ORBFIELD1 VARCHAR(30) Reserved for IBM internal use.
ORBFIELD2 VARCHAR(30) Reserved for IBM internal use.
ORBFIELD3 VARCHAR(30) Reserved for IBM internal use.
ORDERS_ID BIGINT Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030400040 ORBRFNBR Primary Key
I0000636 ORDERS_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_493 ORDERS_ID ORDERS ORDERS_ID Cascade

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search