Reference > Database > WebSphere Commerce database tables > C


WebSphere Commerce database table: CONTRACT

Each row of this table represents a Contract. A Contract is part of a Store, and represents terms and conditions that may be associated with OrderItems. Such as prices, minimum quantities, and who can use the Contract.

Column Name Column Type Description
CONTRACT_ID BIGINT NOT NULL Unique identifier for a contract. Foreign key to TRADING_ID in the TRADING database table.
MAJORVERSION INTEGER NOT NULL DEFAULT 1 Major version number of the Contract.
MINORVERSION INTEGER NOT NULL DEFAULT 0 Minor version number of the Contract.
NAME VARCHAR(200) NOT NULL Uniquely identifies a version of a Contract of a particular origin for a particular owner.
MEMBER_ID BIGINT NOT NULL Owner of the Contract.
ORIGIN INTEGER NOT NULL DEFAULT 0 Indicates why the Contract was created:
0 = manual
1 = imported
2 = RFQ
3 = exchange
4 = auction
5 = 2-party negotiation
6 = deployment
STATE INTEGER NOT NULL DEFAULT 0 Indicates the contract state:
0 = draft
1 = pending approval
2 = approved
3 = active
4 = rejected
5 = canceled
6 = closed
7 = suspended
-1 = deployment in progress
-2 = deployment failed
USAGE INTEGER NOT NULL DEFAULT 0 Indicates how the contract will be used:
0 = default
1 = organization buyer
2 = reseller
3 = special bid
4 = referral
5 = supplier
6 = delegation grid
MARKFORDELETE INTEGER NOT NULL DEFAULT 0 Indicates if this Contract has been marked for deletion:
0 = No
1 = Yes and this Contract has been marked for deletion
COMMENTS VARCHAR(4000) A comment associated with the Contract.
TIMECREATED TIMESTAMP The time the Contract was created.
TIMEUPDATED TIMESTAMP The time the Contract was most recently updated.
TIMEAPPROVED TIMESTAMP The time the Contract was approved.
TIMEACTIVATED TIMESTAMP The time the Contract was activated.
TIMEDEPLOYED TIMESTAMP The time the Contract was deployed.
FAMILY_ID BIGINT The contract belongs to this family of contracts with the same name, owner, and origin.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000078 NAME+MEMBER_ID+MAJORVERSION+MINORVERSION+ORIGIN Unique Index
SQL100520030319170 CONTRACT_ID Primary Key
I0000539 MEMBER_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_253 MEMBER_ID MEMBER MEMBER_ID Cascade
F_252 CONTRACT_ID TRADING TRADING_ID Cascade

Referenced By
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_139 CONTRACT_ID BUYSUPMAP CONTRACT_ID Cascade
F_188 CONTRACT_ID CATCNTR CONTRACT_ID Cascade
F_246 CONTRACT_ID CNTRDISPLY CONTRACT_ID Cascade
F_912 CONTRACT_ID CNTRSTORE CONTRACT_ID Cascade
F_925 CRTDBYCNTR_ID STORE CONTRACT_ID Cascade
F_785 CONTRACT_ID STORECNTR CONTRACT_ID Cascade
F_788 CONTRACT_ID STOREDEF CONTRACT_ID Cascade
F_833 CONTRACT_ID TDPSCNCNTR CONTRACT_ID Cascade


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search