This table holds the Marketplace seller organization and participating store
relationship, and the detailed status for each store.
Column Descriptions:
Name
|
Type
|
Description
|
ORGENTITY_ID |
BIGINT NOT NULL |
Marketplace seller organization id |
STOREENT_ID |
INTEGER NOT NULL |
Identifier of the participating store |
STATUS |
SMALLINT NOT NULL |
Marketplace operator controlled status for a store |
ISONLINE |
SMALLINT NOT NULL |
Marketplace seller controlled online status for a store |
LASTUPDATE |
TIMESTAMP |
Last updated date and time |
OPTCOUNTER |
SMALLINT NOT NULL |
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
|
P_MPSELLER |
ORGENTITY_ID + STOREENT_ID |
Primary Key |
I_MPSELLER_1 |
ORGENTITY_ID |
Non-Unique Index |
I_MPSELLER_2 |
STOREENT_ID |
Non-Unique Index |
Constrained By Parent Tables:
Constraint
|
Columns
|
Parent Table
|
Parent Columns
|
Type
|
F_MPSELLER_ORGENTITY_ID |
ORGENTITY_ID |
ORGENTITY
|
ORGENTITY_ID |
Cascade |
F_MPSELLER_STOREENT_ID |
STOREENT_ID |
STOREENT
|
STOREENT_ID |
Cascade |