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:
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 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 |