Tabellenbeschreibung:
Speichert die Liste der Mitglieder (Teilnehmer) des WebSphere Commerce-Systems.
Spaltenbeschreibung:
Spaltenname | Spaltentyp | Spaltenbeschreibung |
MEMBER_ID |
BIGINT
NOT NULL |
ID für das Mitglied, ein eindeutiger Primärschlüssel für diese Tabelle. |
STATE |
INTEGER
NULL |
Der Genehmigungsstatus der Registrierung, wie folgt: 0 - Genehmigung anstehend. 1 - Genehmigt. 2 - Zurückgewiesen. Null - Genehmigung nicht anwendbar. |
TYPE |
CHARACTER (3)
NOT NULL |
Der Mitgliedstyp, wie folgt: O = Organisationsentität. U = Benutzer. G = Mitgliedsgruppe. |
Indexe:
Indexname | Indexierte(r) Spaltenname(n) | Indextyp |
I274145 | MEMBER_ID, TYPE | Nicht eindeutiger Index |
SQL020206020658000 | MEMBER_ID | Primärschlüssel |
Integritätsbedingungen:
Name der Integritätsbedingung | Spaltenname(n) | Namen von Fremdtabellen | Name(n) von Fremdspalte(n) | Typ der Integritätsbedingung |
Referenziert durch:
Name der Integritätsbedingung | Referenzierter Spaltenname | Namen von Fremdtabellen | Name(n) von Fremdspalte(n) | Typ der Integritätsbedingung |
F_100 | MEMBER_ID | AUTOBID | OWNER_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_114 | MEMBER_ID | BID | OWNER_ID | Cascade |
F_115 | MEMBER_ID | BID | ADMIN_ID | Cascade |
F_117 | MEMBER_ID | BIDLOG | OWNER_ID | Cascade |
F_118 | MEMBER_ID | BIDLOG | ADMIN_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_348 | MEMBER_ID | FORUM | OWNER_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_554 | MEMBER_ID | ORGENTITY | 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 |
![]() |