Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce database table: PX_PROMOAUTH
This table contains additional authoring information that is managed by the Promotions tool in the Management Center user interface.
Column Name Column Type Description PX_PROMOTION_ID INTEGER NOT NULL Primary key of the table and foreign key to the PX_PROMOTION table. COMMENTS VARCHAR(254) Comments about the promotion. PROMOTIONTYPE VARCHAR(254) NOT NULL Promotion rule type. DAILYSTARTTIME TIMESTAMP Daily start time (as if on 2000/01/01). DAILYENDTIME TIMESTAMP Daily end time (as if on 2000/01/01). WEEKDAY_SUN SMALLINT Flag to indicate that the promotion is available on Sunday. WEEKDAY_MON SMALLINT Flag to indicate that the promotion is available on Monday. WEEKDAY_TUE SMALLINT Flag to indicate that the promotion is available on Tuesday. WEEKDAY_WED SMALLINT Flag to indicate that the promotion is available on Wednesday. WEEKDAY_THU SMALLINT Flag to indicate that the promotion is available on Thursday. WEEKDAY_FRI SMALLINT Flag to indicate that the promotion is available on Friday. WEEKDAY_SAT SMALLINT Flag to indicate that the promotion is available on Saturday. CTLPARAM VARCHAR(32) Additional control information for the user interface. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved IBM internal use. ADMINSTVENAME VARCHAR(254) Administrative name of the promotion.
Indexes Index Name Indexed Column Names Index Type SQL100520030418170 PX_PROMOTION_ID Primary Key I0001219 ADMINSTVENAME Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3544 PX_PROMOTION_ID PX_PROMOTION PX_PROMOTION_ID Cascade _vcc_freeselect_bottom_