Descripción de la tabla:
Almacena la lista de miembros (participantes) del sistema WebSphere Commerce.
Descripción de las columnas:
Nombre de columna | Tipo de columna | Descripción de columna |
MEMBER_ID |
BIGINT
NOT NULL |
ID del miembro, una clave primaria exclusiva para esta tabla. |
STATE |
INTEGER
NULL |
El estado de aprobación de registro. Es uno de los siguientes: 0 - pendiente de aprobación. 1 - aprobado. 2 - rechazado. Null - la aprobación no se puede aplicar. |
TYPE |
CHARACTER (3)
NOT NULL |
El tipo de miembro. Puede ser uno de los siguientes: O = entidad de organización U = usuario G = grupo de miembros |
Índices:
Nombre de índice | Nombre(s) de columna(s) indexada(s) | Tipo de índice |
I274145 | MEMBER_ID, TYPE | Índice no exclusivo |
SQL020206020658000 | MEMBER_ID | Clave primaria |
Restricciones:
Nombre de restricción | Nombre(s) de columna | Nombre de tabla externa | Nombre(s) de columna(s) externa(s) | Tipo de restricción |
Referenciada por:
Nombre de restricción | Nombre de columna referenciada | Nombre de tabla externa | Nombre(s) de columna(s) externa(s) | Tipo de restricción |
F_100 | MEMBER_ID | AUTOBID | OWNER_ID | Cascada |
F_101 | MEMBER_ID | AUTOBID | ADMIN_ID | Cascada |
F_104 | MEMBER_ID | AUTOBIDLOG | OWNER_ID | Cascada |
F_105 | MEMBER_ID | AUTOBIDLOG | ADMIN_ID | Cascada |
F_108 | MEMBER_ID | BASEITEM | MEMBER_ID | Cascada |
F_114 | MEMBER_ID | BID | OWNER_ID | Cascada |
F_115 | MEMBER_ID | BID | ADMIN_ID | Cascada |
F_117 | MEMBER_ID | BIDLOG | OWNER_ID | Cascada |
F_118 | MEMBER_ID | BIDLOG | ADMIN_ID | Cascada |
F_127 | MEMBER_ID | BROADCAST | MEMBER_ID | Cascada |
F_13 | MEMBER_ID | ACCCUSTEXC | OWNER_ID | Cascada |
F_183 | MEMBER_ID | CATALOG | MEMBER_ID | Cascada |
F_19 | MEMBER_ID | ACCMBRGRP | OWNER_ID | Cascada |
F_203 | MEMBER_ID | CATENTRY | MEMBER_ID | Cascada |
F_216 | MEMBER_ID | CATGROUP | MEMBER_ID | Cascada |
F_24 | MEMBER_ID | ACCOUNT | MEMBER_ID | Cascada |
F_240 | MEMBER_ID | CIITEMLIST | MEMBER_ID | Cascada |
F_247 | MEMBER_ID | CNTRNAME | MEMBER_ID | Cascada |
F_25 | MEMBER_ID | ACORGPOL | MEMBER_ID | Cascada |
F_253 | MEMBER_ID | CONTRACT | MEMBER_ID | Cascada |
F_255 | MEMBER_ID | CONTRLRULE | OWNER_ID | Cascada |
F_256 | MEMBER_ID | CONTRLRULE | ADMIN_ID | Cascada |
F_259 | MEMBER_ID | CPENDORDER | MEMBER_ID | Cascada |
F_30 | MEMBER_ID | ACPOLICY | MEMBER_ID | Cascada |
F_317 | MEMBER_ID | FFMCENTER | MEMBER_ID | Cascada |
F_348 | MEMBER_ID | FORUM | OWNER_ID | Cascada |
F_37 | MEMBER_ID | ACRELGRP | MEMBER_ID | Cascada |
F_380 | MEMBER_ID | IITEM | MEMBER_ID | Cascada |
F_383 | MEMBER_ID | IITEMLIST | MEMBER_ID | Cascada |
F_406 | MEMBER_ID | ITEMSPC | MEMBER_ID | Cascada |
F_440 | MEMBER_ID | MBRATTRVAL | MEMBER_ID | Cascada |
F_443 | MEMBER_ID | MBRGRP | MBRGRP_ID | Cascada |
F_444 | MEMBER_ID | MBRGRP | OWNER_ID | Cascada |
F_446 | MEMBER_ID | MBRGRPMBR | MEMBER_ID | Cascada |
F_450 | MEMBER_ID | MBRREL | DESCENDANT_ID | Cascada |
F_451 | MEMBER_ID | MBRREL | ANCESTOR_ID | Cascada |
F_454 | MEMBER_ID | MBRROLE | MEMBER_ID | Cascada |
F_456 | MEMBER_ID | MBRVIEWPRF | MEMBER_ID | Cascada |
F_458 | MEMBER_ID | MEMBRAUCT | MEMBER_ID | Cascada |
F_459 | MEMBER_ID | MESSAGE | MEMBER_ID | Cascada |
F_46 | MEMBER_ID | ACRESGRP | MEMBER_ID | Cascada |
F_464 | MEMBER_ID | MSGMEMREL | MEMBER_ID | Cascada |
F_48 | MEMBER_ID | ACRESMEMRL | MEMBER_ID | Cascada |
F_504 | MEMBER_ID | ORDERITEMS | MEMBER_ID | Cascada |
F_516 | MEMBER_ID | ORDERS | MEMBER_ID | Cascada |
F_518 | MEMBER_ID | ORDERTMPL | MEMBER_ID | Cascada |
F_554 | MEMBER_ID | ORGENTITY | MEMBER_ID | Cascada |
F_555 | MEMBER_ID | ORGENTITY | ORGENTITY_ID | Cascada |
F_561 | MEMBER_ID | PARTICIPNT | MEMBER_ID | Cascada |
F_57 | MEMBER_ID | ADDRBOOK | MEMBER_ID | Cascada |
F_587 | MEMBER_ID | PICKBATCH | MEMBER_ID | Cascada |
F_59 | MEMBER_ID | ADDRESS | MEMBER_ID | Cascada |
F_622 | MEMBER_ID | PRODUCTSET | MEMBER_ID | Cascada |
F_675 | MEMBER_ID | RFQ | MEMBER_ID | Cascada |
F_68 | MEMBER_ID | ATTACHMENT | MEMBER_ID | Cascada |
F_685 | MEMBER_ID | RFQRSP | MEMBER_ID | Cascada |
F_698 | MEMBER_ID | RMA | MEMBER_ID | Cascada |
F_7 | MEMBER_ID | ACACTGRP | MEMBER_ID | Cascada |
F_709 | MEMBER_ID | RMAITEM | MEMBER_ID | Cascada |
F_734 | MEMBER_ID | RULECLSREG | OWNER_ID | Cascada |
F_738 | MEMBER_ID | SCHCONFIG | MEMBER_ID | Cascada |
F_757 | MEMBER_ID | STADDRESS | MEMBER_ID | Cascada |
F_77 | MEMBER_ID | AUCPAYINFO | MEMBER_ID | Cascada |
F_790 | MEMBER_ID | STOREENT | MEMBER_ID | Cascada |
F_841 | MEMBER_ID | TFALGOREG | MEMBER_ID | Cascada |
F_85 | MEMBER_ID | AUCTION | OWNER_ID | Cascada |
F_858 | MEMBER_ID | TFTRADENG | MEMBER_ID | Cascada |
F_86 | MEMBER_ID | AUCTION | ADMIN_ID | Cascada |
F_865 | MEMBER_ID | TRADEPOSCN | MEMBER_ID | Cascada |
F_896 | MEMBER_ID | USERS | USERS_ID | Cascada |
F_90 | MEMBER_ID | AUCTIONLOG | OWNER_ID | Cascada |
F_91 | MEMBER_ID | AUCTIONLOG | ADMIN_ID | Cascada |
F_95 | MEMBER_ID | AUCTSTYLE | OWNER_ID | Cascada |
F_96 | MEMBER_ID | AUCTSTYLE | ADMIN_ID | Cascada |
![]() |