Reference > Database > WebSphere Commerce database tables > B
WebSphere Commerce database table: BUADDR
Reserved for IBM internal use.
Column Name Column Type Description BARFNBR INTEGER NOT NULL Reserved for IBM internal use. BABURFNBR INTEGER NOT NULL Reserved for IBM internal use. BACODE VARCHAR(17) NOT NULL Reserved for IBM internal use. BACDTYPE CHAR(2) Reserved for IBM internal use. BATYPE CHAR(2) NOT NULL Reserved for IBM internal use. BANAME VARCHAR(80) Reserved for IBM internal use. BAADDR1 VARCHAR(50) Reserved for IBM internal use. BAADDR2 VARCHAR(30) Reserved for IBM internal use. BAADDR3 VARCHAR(50) Reserved for IBM internal use. BACITY VARCHAR(30) Reserved for IBM internal use. BASTATE VARCHAR(20) Reserved for IBM internal use. BACNTRY VARCHAR(30) Reserved for IBM internal use. BAZIPC VARCHAR(20) Reserved for IBM internal use. BASGRFNBR INTEGER Reserved for IBM internal use. BAFIELD1 VARCHAR(30) Reserved for IBM internal use. BAFIELD2 VARCHAR(30) Reserved for IBM internal use. BAFIELD3 VARCHAR(30) Reserved for IBM internal use. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000048 BACODE+BABURFNBR+BATYPE Unique Index SQL100520030304150 BARFNBR Primary Key I0000484 BABURFNBR Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_130 BABURFNBR BUYORG BURFNBR Cascade _vcc_freeselect_bottom_