WebSphere Commerce database table: BUSPROF

WebSphere Commerce database table: BUSPROF

This table stores business profile information for a user.
Column Descriptions
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 or this his 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
SQL060903235132610 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

Member data model

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 or this his 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.

Index Name	Indexed Column Names	Index Type
SQL060903235132610	USERS_ID	Primary Key
I0000324	REQUISITIONERID	Non-Unique Index
I0000486	ORGUNIT_ID	Non-Unique Index
I0000487	ORG_ID	Non-Unique Index

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