MEMBER
Stores the list of members (participants) of the WebSphere Commerce system. A member is either a user, an organizational entity or a member group.
Column Descriptions:
Name 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
3 = pending email activation
Null = approval is not applicable (approved)OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
Indexes:
Name Column Names Type <SYSTEM-GENERATED> MEMBER_ID Primary Key I274130 MEMBER_ID+TYPE Non-Unique Index
Referenced By Child Tables:
Constraint Columns Child Table Child Columns Type F_100 MEMBER_ID AUTOBID OWNER_ID Cascade F_1005 MEMBER_ID ACPOLGRP MEMBER_ID Cascade F_101 MEMBER_ID AUTOBID ADMIN_ID Cascade F_104 MEMBER_ID AUTOBIDLOG OWNER_ID Cascade F_105 MEMBER_ID AUTOBIDLOG ADMIN_ID Cascade F_108 MEMBER_ID BASEITEM MEMBER_ID Cascade F_1084 MEMBER_ID WMMMAP MEMBER_ID Cascade F_1086 MEMBER_ID CTXMGMT CALLER_ID Cascade F_1089 MEMBER_ID ORDRELEASE MEMBER_ID Cascade F_1103 MEMBER_ID ATCHTGT MEMBER_ID Cascade F_1123 MEMBER_ID CMFWKSPC MEMBER_ID Cascade F_1130 MEMBER_ID CMFTGCMT MEMBER_ID Cascade F_1134 MEMBER_ID CMFTSKMBREL MEMBER_ID Cascade F_1138 MEMBER_ID ORDERS EDITOR_ID Cascade F_114 MEMBER_ID BID OWNER_ID Cascade F_1143 MEMBER_ID CTXMGMT RUNAS_ID Cascade F_115 MEMBER_ID BID ADMIN_ID Cascade F_1160 MEMBER_ID CCOMMENT CUSTOMERID Cascade F_1161 MEMBER_ID CCOMMENT TARGETID Cascade F_117 MEMBER_ID BIDLOG OWNER_ID Cascade F_118 MEMBER_ID BIDLOG ADMIN_ID Cascade F_1195 MEMBER_ID TICKLER LOCKEDBY_ID Cascade F_1196 MEMBER_ID TICKLER CREATEDBY_ID Cascade F_1197 MEMBER_ID TICKLER RESPONSIBLEMEMBER Cascade F_1201 MEMBER_ID TKLACTHIST CREATEDBY_ID Cascade F_1227 MEMBER_ID CALADJUST SERVICEREP_ID Cascade F_1230 MEMBER_ID REPCUSTREL CUST_ID Cascade F_1231 MEMBER_ID REPCUSTREL REP_ID Cascade F_127 MEMBER_ID BROADCAST MEMBER_ID Cascade F_13 MEMBER_ID ACCCUSTEXC OWNER_ID Cascade F_183 MEMBER_ID CATALOG MEMBER_ID Cascade F_19 MEMBER_ID ACCMBRGRP OWNER_ID Cascade F_203 MEMBER_ID CATENTRY MEMBER_ID Cascade F_216 MEMBER_ID CATGROUP MEMBER_ID Cascade F_24 MEMBER_ID ACCOUNT MEMBER_ID Cascade F_240 MEMBER_ID CIITEMLIST MEMBER_ID Cascade F_247 MEMBER_ID CNTRNAME MEMBER_ID Cascade F_25 MEMBER_ID ACORGPOL MEMBER_ID Cascade F_253 MEMBER_ID CONTRACT MEMBER_ID Cascade F_255 MEMBER_ID CONTRLRULE OWNER_ID Cascade F_256 MEMBER_ID CONTRLRULE ADMIN_ID Cascade F_259 MEMBER_ID CPENDORDER MEMBER_ID Cascade F_30 MEMBER_ID ACPOLICY MEMBER_ID Cascade F_317 MEMBER_ID FFMCENTER MEMBER_ID Cascade F_3466 MEMBER_ID MERCHANT MEMBER_ID Cascade F_348 MEMBER_ID FORUM OWNER_ID Cascade F_3599 MEMBER_ID UPLOADFILE MEMBER_ID Cascade F_3601 MEMBER_ID PROCESSFILE MEMBER_ID Cascade F_3613 MEMBER_ID WALLET MEMBER_ID Cascade F_3651 MEMBER_ID SUBSCRIPTION MEMBER_ID Cascade F_3655 MEMBER_ID SUBSCRTEMPLATE MEMBER_ID Cascade F_37 MEMBER_ID ACRELGRP 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 MEMBER_ID MBRGRP MBRGRP_ID Cascade F_444 MEMBER_ID MBRGRP OWNER_ID Cascade F_446 MEMBER_ID MBRGRPMBR MEMBER_ID Cascade F_450 MEMBER_ID MBRREL DESCENDANT_ID Cascade F_451 MEMBER_ID MBRREL ANCESTOR_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_459 MEMBER_ID MESSAGE MEMBER_ID Cascade F_46 MEMBER_ID ACRESGRP MEMBER_ID Cascade F_464 MEMBER_ID MSGMEMREL MEMBER_ID Cascade F_48 MEMBER_ID ACRESMEMRL MEMBER_ID Cascade F_504 MEMBER_ID ORDERITEMS MEMBER_ID Cascade F_516 MEMBER_ID ORDERS MEMBER_ID Cascade F_518 MEMBER_ID ORDERTMPL MEMBER_ID Cascade F_555 MEMBER_ID ORGENTITY ORGENTITY_ID Cascade F_561 MEMBER_ID PARTICIPNT MEMBER_ID Cascade F_57 MEMBER_ID ADDRBOOK MEMBER_ID Cascade F_587 MEMBER_ID PICKBATCH MEMBER_ID Cascade F_59 MEMBER_ID ADDRESS MEMBER_ID Cascade F_622 MEMBER_ID PRODUCTSET MEMBER_ID Cascade F_675 MEMBER_ID RFQ MEMBER_ID Cascade F_68 MEMBER_ID ATTACHMENT MEMBER_ID Cascade F_685 MEMBER_ID RFQRSP MEMBER_ID Cascade F_698 MEMBER_ID RMA MEMBER_ID Cascade F_7 MEMBER_ID ACACTGRP MEMBER_ID Cascade F_709 MEMBER_ID RMAITEM MEMBER_ID Cascade F_734 MEMBER_ID RULECLSREG OWNER_ID Cascade F_738 MEMBER_ID SCHCONFIG MEMBER_ID Cascade F_757 MEMBER_ID STADDRESS MEMBER_ID Cascade F_77 MEMBER_ID AUCPAYINFO MEMBER_ID Cascade F_790 MEMBER_ID STOREENT MEMBER_ID Cascade F_841 MEMBER_ID TFALGOREG MEMBER_ID Cascade F_85 MEMBER_ID AUCTION OWNER_ID Cascade F_858 MEMBER_ID TFTRADENG MEMBER_ID Cascade F_86 MEMBER_ID AUCTION ADMIN_ID Cascade F_865 MEMBER_ID TRADEPOSCN MEMBER_ID Cascade F_896 MEMBER_ID USERS USERS_ID Cascade F_90 MEMBER_ID AUCTIONLOG OWNER_ID Cascade F_91 MEMBER_ID AUCTIONLOG ADMIN_ID Cascade F_95 MEMBER_ID AUCTSTYLE OWNER_ID Cascade F_96 MEMBER_ID AUCTSTYLE ADMIN_ID Cascade F_984 MEMBER_ID FILEUPLOAD MEMBER_ID Cascade
Related reference
Access control data model
Calculation code - direct attachment data model
Catalog data model
Catalog entry data model
Catalog group data model
Contract data model
Fulfillment data model
Interest item data model
Scheduler data model
Member data model
Messaging data model
Offers data model
Order data model
Order management - RMA data model
Order management - RMAitem data model
Order item data model
Order item - allocated data model
Order item - backordered data model
Order release data model
Procurement data model
Product set data model
Request for Quote (RFQ) data model
Authentication data model
Store data model