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 = MemberGroup |
| STATE | 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 | 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 |