Reference > Database > WebSphere Commerce database tables > O
WebSphere Commerce database table: ORCOMMENT
The table stores the comments for an order entered by a customer service representative.
Column Name Column Type Description ORCOMMENT_ID BIGINT NOT NULL Generated unique key. ORDERS_ID BIGINT NOT NULL The Order. LASTUPDATE TIMESTAMP The time this comment is created. COMMENTS VARCHAR(3000) The content of the comment. OPTCOUNTER SMALLINT Reserved for IBM internal use. ORDCHGRSN_ID INTEGER Reference to the order change reason code table. SERVICEREP_ID BIGINT The user ID of the service representative that created this order change comment. BUSCHN_ID INTEGER Indicate the channel the order was changed. ORDERVERSION SMALLINT The order version FIELD1 INTEGER Customizable field. FIELD2 VARCHAR(254) Customizable field. FIELD3 TIMESTAMP Customizable field.
Indexes Index Name Indexed Column Names Index Type SQL100520030359310 ORCOMMENT_ID Primary Key I0000632 ORDERS_ID Non-Unique Index I0001264 ORDCHGRSN_ID Non-Unique Index I0001265 SERVICEREP_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type R_3463 BUSCHN_ID BUSCHN BUSCHN_ID Cascade R_3456 ORDCHGRSN_ID ORDCHGRSN ORDCHGRSN_ID Cascade F_483 ORDERS_ID ORDERS ORDERS_ID Cascade R_3462 SERVICEREP_ID USERS USERS_ID Cascade
Related reference
_vcc_freeselect_bottom_