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:

NameTypeDescription
MEMBER_IDBIGINT NOT NULLID for the member, a unique primary key for this table.
TYPECHAR (3) NOT NULLThe type of member as follows: O = OrgEntity U = User G = MemberGroup
STATEINTEGERThe registration approval status as follows: 0 = pending approval 1 = approved 2 = rejected 3 = pending email activation Null = approval is not applicable (approved)
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>MEMBER_IDPrimary Key
I274130MEMBER_ID+TYPENon-Unique Index

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_100MEMBER_IDAUTOBIDOWNER_IDCascade
F_1005MEMBER_IDACPOLGRPMEMBER_IDCascade
F_101MEMBER_IDAUTOBIDADMIN_IDCascade
F_104MEMBER_IDAUTOBIDLOGOWNER_IDCascade
F_105MEMBER_IDAUTOBIDLOGADMIN_IDCascade
F_108MEMBER_IDBASEITEMMEMBER_IDCascade
F_1084MEMBER_IDWMMMAPMEMBER_IDCascade
F_1086MEMBER_IDCTXMGMTCALLER_IDCascade
F_1089MEMBER_IDORDRELEASEMEMBER_IDCascade
F_1103MEMBER_IDATCHTGTMEMBER_IDCascade
F_1123MEMBER_IDCMFWKSPCMEMBER_IDCascade
F_1130MEMBER_IDCMFTGCMTMEMBER_IDCascade
F_1134MEMBER_IDCMFTSKMBRELMEMBER_IDCascade
F_1138MEMBER_IDORDERSEDITOR_IDCascade
F_114MEMBER_IDBIDOWNER_IDCascade
F_1143MEMBER_IDCTXMGMTRUNAS_IDCascade
F_115MEMBER_IDBIDADMIN_IDCascade
F_1160MEMBER_IDCCOMMENTCUSTOMERIDCascade
F_1161MEMBER_IDCCOMMENTTARGETIDCascade
F_117MEMBER_IDBIDLOGOWNER_IDCascade
F_118MEMBER_IDBIDLOGADMIN_IDCascade
F_1195MEMBER_IDTICKLERLOCKEDBY_IDCascade
F_1196MEMBER_IDTICKLERCREATEDBY_IDCascade
F_1197MEMBER_IDTICKLERRESPONSIBLEMEMBERCascade
F_1201MEMBER_IDTKLACTHISTCREATEDBY_IDCascade
F_1227MEMBER_IDCALADJUSTSERVICEREP_IDCascade
F_1230MEMBER_IDREPCUSTRELCUST_IDCascade
F_1231MEMBER_IDREPCUSTRELREP_IDCascade
F_127MEMBER_IDBROADCASTMEMBER_IDCascade
F_13MEMBER_IDACCCUSTEXCOWNER_IDCascade
F_183MEMBER_IDCATALOGMEMBER_IDCascade
F_19MEMBER_IDACCMBRGRPOWNER_IDCascade
F_203MEMBER_IDCATENTRYMEMBER_IDCascade
F_216MEMBER_IDCATGROUPMEMBER_IDCascade
F_24MEMBER_IDACCOUNTMEMBER_IDCascade
F_240MEMBER_IDCIITEMLISTMEMBER_IDCascade
F_247MEMBER_IDCNTRNAMEMEMBER_IDCascade
F_25MEMBER_IDACORGPOLMEMBER_IDCascade
F_253MEMBER_IDCONTRACTMEMBER_IDCascade
F_255MEMBER_IDCONTRLRULEOWNER_IDCascade
F_256MEMBER_IDCONTRLRULEADMIN_IDCascade
F_259MEMBER_IDCPENDORDERMEMBER_IDCascade
F_30MEMBER_IDACPOLICYMEMBER_IDCascade
F_317MEMBER_IDFFMCENTERMEMBER_IDCascade
F_3466MEMBER_IDMERCHANTMEMBER_IDCascade
F_348MEMBER_IDFORUMOWNER_IDCascade
F_3599MEMBER_IDUPLOADFILEMEMBER_IDCascade
F_3601MEMBER_IDPROCESSFILEMEMBER_IDCascade
F_3613MEMBER_IDWALLETMEMBER_IDCascade
F_3651MEMBER_IDSUBSCRIPTIONMEMBER_IDCascade
F_3655MEMBER_IDSUBSCRTEMPLATEMEMBER_IDCascade
F_37MEMBER_IDACRELGRPMEMBER_IDCascade
F_380MEMBER_IDIITEMMEMBER_IDCascade
F_383MEMBER_IDIITEMLISTMEMBER_IDCascade
F_406MEMBER_IDITEMSPCMEMBER_IDCascade
F_440MEMBER_IDMBRATTRVALMEMBER_IDCascade
F_443MEMBER_IDMBRGRPMBRGRP_IDCascade
F_444MEMBER_IDMBRGRPOWNER_IDCascade
F_446MEMBER_IDMBRGRPMBRMEMBER_IDCascade
F_450MEMBER_IDMBRRELDESCENDANT_IDCascade
F_451MEMBER_IDMBRRELANCESTOR_IDCascade
F_454MEMBER_IDMBRROLEMEMBER_IDCascade
F_456MEMBER_IDMBRVIEWPRFMEMBER_IDCascade
F_458MEMBER_IDMEMBRAUCTMEMBER_IDCascade
F_459MEMBER_IDMESSAGEMEMBER_IDCascade
F_46MEMBER_IDACRESGRPMEMBER_IDCascade
F_464MEMBER_IDMSGMEMRELMEMBER_IDCascade
F_48MEMBER_IDACRESMEMRLMEMBER_IDCascade
F_504MEMBER_IDORDERITEMSMEMBER_IDCascade
F_516MEMBER_IDORDERSMEMBER_IDCascade
F_518MEMBER_IDORDERTMPLMEMBER_IDCascade
F_555MEMBER_IDORGENTITYORGENTITY_IDCascade
F_561MEMBER_IDPARTICIPNTMEMBER_IDCascade
F_57MEMBER_IDADDRBOOKMEMBER_IDCascade
F_587MEMBER_IDPICKBATCHMEMBER_IDCascade
F_59MEMBER_IDADDRESSMEMBER_IDCascade
F_622MEMBER_IDPRODUCTSETMEMBER_IDCascade
F_675MEMBER_IDRFQMEMBER_IDCascade
F_68MEMBER_IDATTACHMENTMEMBER_IDCascade
F_685MEMBER_IDRFQRSPMEMBER_IDCascade
F_698MEMBER_IDRMAMEMBER_IDCascade
F_7MEMBER_IDACACTGRPMEMBER_IDCascade
F_709MEMBER_IDRMAITEMMEMBER_IDCascade
F_734MEMBER_IDRULECLSREGOWNER_IDCascade
F_738MEMBER_IDSCHCONFIGMEMBER_IDCascade
F_757MEMBER_IDSTADDRESSMEMBER_IDCascade
F_77MEMBER_IDAUCPAYINFOMEMBER_IDCascade
F_790MEMBER_IDSTOREENTMEMBER_IDCascade
F_841MEMBER_IDTFALGOREGMEMBER_IDCascade
F_85MEMBER_IDAUCTIONOWNER_IDCascade
F_858MEMBER_IDTFTRADENGMEMBER_IDCascade
F_86MEMBER_IDAUCTIONADMIN_IDCascade
F_865MEMBER_IDTRADEPOSCNMEMBER_IDCascade
F_896MEMBER_IDUSERSUSERS_IDCascade
F_90MEMBER_IDAUCTIONLOGOWNER_IDCascade
F_91MEMBER_IDAUCTIONLOGADMIN_IDCascade
F_95MEMBER_IDAUCTSTYLEOWNER_IDCascade
F_96MEMBER_IDAUCTSTYLEADMIN_IDCascade
F_984MEMBER_IDFILEUPLOADMEMBER_IDCascade