WebSphere Commerce database table: MEMBER
Stores the list of members (participants) of the WebSphere Commerce system.
Column Descriptions Column Name Column Type Description MEMBER_ID BIGINT NOT NULL ID for the member, a unique primary key for this table. TYPE CHAR(3) NOT NULL The type of member as follows:
O = OrgEntity
U = User
G = MemberGroupSTATE INTEGER The registration approval status as follows:
0 = pending approval
1 = approved
2 = rejected
Null = the approval is not applicableOPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL060903235214080 MEMBER_ID Primary Key I274130 MEMBER_ID+TYPE Non-Unique Index Related reference
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_7 MEMBER_ID ACACTGRP MEMBER_ID Cascade F_13 OWNER_ID ACCCUSTEXC MEMBER_ID Cascade F_19 OWNER_ID ACCMBRGRP MEMBER_ID Cascade F_24 MEMBER_ID ACCOUNT MEMBER_ID Cascade F_25 MEMBER_ID ACORGPOL MEMBER_ID Cascade F_1005 MEMBER_ID ACPOLGRP MEMBER_ID Cascade F_30 MEMBER_ID ACPOLICY MEMBER_ID Cascade F_37 MEMBER_ID ACRELGRP MEMBER_ID Cascade F_46 MEMBER_ID ACRESGRP MEMBER_ID Cascade F_48 MEMBER_ID ACRESMEMRL MEMBER_ID Cascade F_57 MEMBER_ID ADDRBOOK MEMBER_ID Cascade F_59 MEMBER_ID ADDRESS MEMBER_ID Cascade F_1103 MEMBER_ID ATCHTGT MEMBER_ID Cascade F_68 MEMBER_ID ATTACHMENT MEMBER_ID Cascade F_77 MEMBER_ID AUCPAYINFO MEMBER_ID Cascade F_85 OWNER_ID AUCTION MEMBER_ID Cascade F_86 ADMIN_ID AUCTION MEMBER_ID Cascade F_90 OWNER_ID AUCTIONLOG MEMBER_ID Cascade F_91 ADMIN_ID AUCTIONLOG MEMBER_ID Cascade F_95 OWNER_ID AUCTSTYLE MEMBER_ID Cascade F_96 ADMIN_ID AUCTSTYLE MEMBER_ID Cascade F_100 OWNER_ID AUTOBID MEMBER_ID Cascade F_101 ADMIN_ID AUTOBID MEMBER_ID Cascade F_104 OWNER_ID AUTOBIDLOG MEMBER_ID Cascade F_105 ADMIN_ID AUTOBIDLOG MEMBER_ID Cascade F_108 MEMBER_ID BASEITEM MEMBER_ID Cascade F_114 OWNER_ID BID MEMBER_ID Cascade F_115 ADMIN_ID BID MEMBER_ID Cascade F_117 OWNER_ID BIDLOG MEMBER_ID Cascade F_118 ADMIN_ID BIDLOG MEMBER_ID Cascade F_127 MEMBER_ID BROADCAST MEMBER_ID Cascade F_1227 SERVICEREP_ID CALADJUST MEMBER_ID Cascade F_183 MEMBER_ID CATALOG MEMBER_ID Cascade F_203 MEMBER_ID CATENTRY MEMBER_ID Cascade F_216 MEMBER_ID CATGROUP MEMBER_ID Cascade F_1161 TARGETID CCOMMENT MEMBER_ID Cascade F_1160 CUSTOMERID CCOMMENT MEMBER_ID Cascade F_240 MEMBER_ID CIITEMLIST MEMBER_ID Cascade F_1130 MEMBER_ID CMFTGCMT MEMBER_ID Cascade F_1134 MEMBER_ID CMFTSKMBREL MEMBER_ID Cascade F_1123 MEMBER_ID CMFWKSPC MEMBER_ID Cascade F_247 MEMBER_ID CNTRNAME MEMBER_ID Cascade F_253 MEMBER_ID CONTRACT MEMBER_ID Cascade F_255 OWNER_ID CONTRLRULE MEMBER_ID Cascade F_256 ADMIN_ID CONTRLRULE MEMBER_ID Cascade F_259 MEMBER_ID CPENDORDER MEMBER_ID Cascade F_1143 RUNAS_ID CTXMGMT MEMBER_ID Cascade F_1086 CALLER_ID CTXMGMT MEMBER_ID Cascade F_317 MEMBER_ID FFMCENTER MEMBER_ID Cascade F_984 MEMBER_ID FILEUPLOAD MEMBER_ID Cascade F_348 OWNER_ID FORUM MEMBER_ID Cascade F_380 MEMBER_ID IITEM MEMBER_ID Cascade F_383 MEMBER_ID IITEMLIST MEMBER_ID Cascade F_406 MEMBER_ID ITEMSPC MEMBER_ID Cascade F_440 MEMBER_ID MBRATTRVAL MEMBER_ID Cascade F_443 MBRGRP_ID MBRGRP MEMBER_ID Cascade F_444 OWNER_ID MBRGRP MEMBER_ID Cascade F_446 MEMBER_ID MBRGRPMBR MEMBER_ID Cascade F_450 DESCENDANT_ID MBRREL MEMBER_ID Cascade F_451 ANCESTOR_ID MBRREL MEMBER_ID Cascade F_454 MEMBER_ID MBRROLE MEMBER_ID Cascade F_456 MEMBER_ID MBRVIEWPRF MEMBER_ID Cascade F_458 MEMBER_ID MEMBRAUCT MEMBER_ID Cascade F_3466 MEMBER_ID MERCHANT MEMBER_ID Cascade F_459 MEMBER_ID MESSAGE MEMBER_ID Cascade F_464 MEMBER_ID MSGMEMREL MEMBER_ID Cascade F_504 MEMBER_ID ORDERITEMS MEMBER_ID Cascade F_516 MEMBER_ID ORDERS MEMBER_ID Cascade F_1138 EDITOR_ID ORDERS MEMBER_ID Cascade F_518 MEMBER_ID ORDERTMPL MEMBER_ID Cascade F_1089 MEMBER_ID ORDRELEASE MEMBER_ID Cascade F_555 ORGENTITY_ID ORGENTITY MEMBER_ID Cascade F_561 MEMBER_ID PARTICIPNT MEMBER_ID Cascade F_587 MEMBER_ID PICKBATCH MEMBER_ID Cascade F_622 MEMBER_ID PRODUCTSET MEMBER_ID Cascade F_1230 CUST_ID REPCUSTREL MEMBER_ID Cascade F_1231 REP_ID REPCUSTREL MEMBER_ID Cascade F_675 MEMBER_ID RFQ MEMBER_ID Cascade F_685 MEMBER_ID RFQRSP MEMBER_ID Cascade F_698 MEMBER_ID RMA MEMBER_ID Cascade F_709 MEMBER_ID RMAITEM MEMBER_ID Cascade F_734 OWNER_ID RULECLSREG MEMBER_ID Cascade F_738 MEMBER_ID SCHCONFIG MEMBER_ID Cascade F_757 MEMBER_ID STADDRESS MEMBER_ID Cascade F_790 MEMBER_ID STOREENT MEMBER_ID Cascade F_841 MEMBER_ID TFALGOREG MEMBER_ID Cascade F_858 MEMBER_ID TFTRADENG MEMBER_ID Cascade F_1195 LOCKEDBY_ID TICKLER MEMBER_ID Cascade F_1196 CREATEDBY_ID TICKLER MEMBER_ID Cascade F_1197 RESPONSIBLEMEMBER TICKLER MEMBER_ID Cascade F_1201 CREATEDBY_ID TKLACTHIST MEMBER_ID Cascade F_865 MEMBER_ID TRADEPOSCN MEMBER_ID Cascade F_896 USERS_ID USERS MEMBER_ID Cascade F_1084 MEMBER_ID WMMMAP MEMBER_ID Cascade