Reference > Database > WebSphere Commerce database tables > B
WebSphere Commerce database table: BUSPROF
This table stores business profile information for a user. It is populated by the user registration commands. It is intended to be populated for users with profile type (USERS.PROFILETYPE) of "B", signifying that this is business user.
Column Name Column Type Description USERS_ID BIGINT NOT NULL Foreign key to the USERS table for this business user. EMPLOYEEID VARCHAR(20) A method to identify the employee, such as by employee number. ORG_ID BIGINT Identifies the organization to which the business user owning this business profile is associated with. ORGUNIT_ID BIGINT Identifies the organizational unit to which the business user owning this business profile is associated with. If there are multiple organizational units, it is usually the lowest one that is referred to here. EMPLOYEETYPE VARCHAR(128) The employee type, such as regular, part time, special part time, supplemental, and contractor. DEPARTMENTNUM VARCHAR(128) The department number for the business user. ALTERNATEID VARCHAR(20) A special ID assigned by the organization or organizational unit to which this business user belongs. MANAGER VARCHAR(256) The name of the manager or supervisor of this business user. SECRETARY VARCHAR(256) The name of the secretary or administrative assistant of the business user. REQUISITIONERID VARCHAR(128) A unique ID for identifying the requisitioner. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030305170 USERS_ID Primary Key I0000324 REQUISITIONERID Non-Unique Index I0000486 ORGUNIT_ID Non-Unique Index I0000487 ORG_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_132 ORG_ID ORGENTITY ORGENTITY_ID Cascade F_133 ORGUNIT_ID ORGENTITY ORGENTITY_ID Cascade F_134 USERS_ID USERS USERS_ID Cascade
Related reference
_vcc_freeselect_bottom_