Stores the list of members (participants) of the WebSphere Commerce system.
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 = MemberGroup |
STATE | INTEGER | The registration approval status as follows: 0 = pending approval 1 = approved 2 = rejected Null = the approval is not applicable |
OPTCOUNTER | SMALLINT | Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL050212031239610 | MEMBER_ID | Primary Key |
I274130 | MEMBER_ID+TYPE | Non-Unique Index |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | 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_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 |