MEMBER

Stores the list of members (participants) of the HCL 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)
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The 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