The default sizes and table space names for tables with the ASN, IWH, WCA, WCAETL, WCAMNG, and WCATMP schemas are shown in the following table:
Table name | Tablespace name | Sum of column sizes (in bytes) | Number of rows | Size (in bytes) | Number of pages (size / 4096) |
Tables in ASN schema | |||||
IBMSNAP_APPLYTRAIL | WCA | 1,078 | 1,000 | 1,078,000 | 263 |
IBMSNAP_CCPPARMS | WCA | 16 | 1,000 | 16,000 | 4 |
IBMSNAP_CRITSEC | WCA | 18 | 1,000 | 1,8000 | 4 |
IBMSNAP_PRUNCNTL | WCA | 176 | 1,000 | 176,000 | 43 |
IBMSNAP_PRUNE_LOCK | WCA | 1 | 1,000 | 1,000 | 0 |
IBMSNAP_REGISTER | WCA | 469 | 1,000 | 46,9000 | 115 |
IBMSNAP_SCHEMA_CHG | WCA | 46 | 1,000 | 46,000 | 11 |
IBMSNAP_SUBS_COLS | WCA | 349 | 1,000 | 349,000 | 85 |
IBMSNAP_SUBS_EVENT | WCA | 38 | 1,000 | 38,000 | 9 |
IBMSNAP_SUBS_MEMBR | WCA | 627 | 1,000 | 627,000 | 153 |
IBMSNAP_SUBS_SET | WCA | 166 | 1,000 | 166,000 | 41 |
IBMSNAP_SUBS_STMTS | WCA | 1,115 | 1,000 | 1,115,000 | 272 |
IBMSNAP_SUBS_TGTS | WCA | 83 | 1,000 | 83,000 | 20 |
IBMSNAP_TRACE | WCA | 272 | 1,000 | 272,000 | 66 |
IBMSNAP_UOW | WCA | 79 | 1,000 | 79,000 | 19 |
IBMSNAP_WARM_START | WCA | 45 | 1,000 | 45,000 | 11 |
Tables in IWH schema |
|||||
ACCOUNT_R | WCA | 280 | 1,000 | 280,000 | 68 |
ADDRESS_R | WCA | 2,350 | 1,000 | 2,350,000 | 574 |
ATTRIBUTE_R | WCA | 834 | 1,000 | 834, 000 | 204 |
BASEITEM_R | WCA | 154 | 1,000 | 154,000 | 38 |
BUYERPO_R | WCA | 71 | 1,000 | 71,000 | 17 |
CAMPAIGN_R | WCA | 427 | 1,000 | 427,000 | 104 |
CATALOGDSC_R | WCA | 552 | 1,000 | 552,000 | 135 |
CATALOG_R | WCA | 302 | 1,000 | 302,000 | 74 |
CATENTDESC_R | WCA | 366 | 1,000 | 366,000 | 89 |
CATENTREL_R | WCA | 56 | 1,000 | 56,000 | 14 |
CATENTRY_R | WCA | 290 | 1,000 | 290,000 | 71 |
CATENTSHIP_R | WCA | 136 | 1,000 | 136,000 | 33 |
CATGPENREL_R | WCA | 56 | 1,000 | 56,000 | 14 |
CATGRPDESC_R | WCA | 552 | 1,000 | 552,000 | 135 |
CATGRPREL_R | WCA | 64 | 1,000 | 64,000 | 16 |
CATTOGRP_R | WCA | 48 | 1,000 | 48,000 | 12 |
CONTRACT_R | WCA | 314 | 1,000 | 314,000 | 77 |
CPGNLOG_R | WCA | 314 | 1,000 | 314,000 | 77 |
CPGNSTAT_R | WCA | 56 | 1,000 | 56,000 | 14 |
CURCONVERT_R | WCA | 80 | 1,000 | 80,000 | 20 |
EMSPOT_R | WCA_TAB8K | 33,342 | 1,000 | 33,342,000 | 8,140 |
FFMCENTDS_R | WCA | 124 | 1,000 | 124,000 | 30 |
FFMCENTER_R | WCA | 298 | 1,000 | 298,000 | 73 |
ICCNCPTLNK_R | WCA | 40 | 1,000 | 40,000 | 10 |
ICCONSTRNT_R | WCA | 67 | 1,000 | 67,000 | 16 |
ICEXPLFEAT_R | WCA | 70 | 1,000 | 70,000 | 17 |
ICFEATPROP_R | WCA | 104 | 1,000 | 104,000 | 25 |
ICKNOWDESC_R | WCA | 1,073 | 1,000 | 1,073,000 | 262 |
ICKNOWLEDG_R | WCA | 156 | 1,000 | 156,000 | 38 |
ICMETAPHOR_R | WCA | 434 | 1,000 | 434,000 | 106 |
ICMETAREG_R | WCA | 136 | 1,000 | 136,000 | 33 |
ICMREGDESC_R | WCA | 140 | 1,000 | 140,000 | 34 |
IITEMLIST_T | WCA | 48 | 1,000 | 48,000 | 12 |
IITEM_R | WCA | 86 | 1,000 | 86,000 | 21 |
INITIATIVE_R | WCA | 118 | 1,000 | 118,000 | 29 |
INTVSCHED_R | WCA | 68 | 1,000 | 68,000 | 17 |
ITEMSPC_R | WCA | 131 | 1,000 | 131,000 | 32 |
LISTPRICE_R | WCA | 63 | 1,000 | 63,000 | 15 |
MBRATTR_R | WCA | 309 | 1,000 | 309,000 | 75 |
MBRATTRVAL_R | WCA_TAB8K | 32,759 | 1,000 | 32,759,000 | 7,998 |
MEMBER_R | WCA | 46 | 1,000 | 46,000 | 11 |
OFFERDESC_R | WCA | 298 | 1,000 | 298,000 | 73 |
OFFERPRICE_R | WCA | 83 | 1,000 | 83,000 | 20 |
OFFER_R | WCA | 122 | 1,000 | 122,000 | 30 |
ORDERITEMS_R | WCA | 244 | 1,000 | 244,000 | 60 |
ORDERS_R | WCA | 229 | 1,000 | 229,000 | 56 |
ORDPAYMTHD_R | WCA | 133 | 1,000 | 133,000 | 32 |
ORDSTAT_R | WCA | 78 | 1,000 | 78,000 | 19 |
ORGENTITY_R | WCA | 3,585 | 1,000 | 3,585,000 | 875 |
PARTICIPNT_R | WCA | 68 | 1,000 | 68,000 | 17 |
PASTATS_R | WCA | 52 | 1,000 | 52,000 | 13 |
PCSTATS_R | WCA | 52 | 1,000 | 52,000 | 13 |
PESTATS_R | WCA | 52 | 1,000 | 52,000 | 13 |
QTYUNITDSC_R | WCA | 305 | 1,000 | 305,000 | 74 |
RFQPROD_R | WCA | 95 | 1,000 | 95,000 | 23 |
RFQ_R | WCA | 340 | 1,000 | 340,000 | 83 |
RFQRSPPRD_R | WCA | 103 | 1,000 | 103,000 | 25 |
RFQRSP_R | WCA | 1,052 | 1,000 | 1,052,000 | 257 |
SASTATS_R | WCA | 56 | 1,000 | 56,000 | 14 |
SHIPMODE_R | WCA | 100 | 1,000 | 100,000 | 24 |
STADDRESS_R | WCA | 420 | 1,000 | 420,000 | 103 |
STOREENTDS_R | WCA | 124 | 1,000 | 124,000 | 30 |
STOREENT_R | WCA | 48 | 1,000 | 48,000 | 12 |
STORELANG_R | WCA | 43 | 1,000 | 43,000 | 10 |
STORE_R | WCA | 55 | 1,000 | 55,000 | 13 |
TRADING_R | WCA | 80 | 1,000 | 80,000 | 20 |
TRDDEPAMT_R | WCA | 86 | 1,000 | 86,000 | 21 |
TRDREFAMT_R | WCA | 70 | 1,000 | 70,000 | 17 |
TRDTYPEDSC_R | WCA_TAB8K | 32,740 | 1,000 | 32,740,000 | 7,993 |
USERDEMO_R | WCA | 449 | 1,000 | 449,000 | 110 |
USERPROF_R | WCA | 421 | 1,000 | 421,000 | 103 |
USERS_R | WCA | 103 | 1,000 | 103,000 | 25 |
USRTRAFFIC_R | WCA_TAB8K | 99,303 | 1,000 | 99,303,000 | 24,244 |
WTAXINFO_R | WCA | 69 | 1,000 | 69,000 | 17 |
Tables in IWHWSA schema |
|||||
BROWSERS | WCA | 301 | 0 | 0 | 1 |
CALENDAR | WCA | 99 | 0 | 0 | 1 |
COOKIESSTATUS | WCA | 101 | 0 | 0 | 1 |
DOMAIN | WCA | 101 | 0 | 0 | 1 |
HIT_FACTS | WCA | 373 | 0 | 0 | 1 |
HITPARMS | WCA | 67 | 0 | 0 | 1 |
IMPORTHISTORY | WCA | 57 | 0 | 0 | 1 |
JAVASCRIPTSTATUS | WCA | 101 | 0 | 0 | 1 |
KEY | WCA | 301 | 0 | 0 | 1 |
NETWORKS | WCA | 117 | 0 | 0 | 1 |
PARMS | WCA | 313 | 0 | 0 | 1 |
PLATFORMS | WCA | 301 | 0 | 0 | 1 |
PROTOCOLS | WCA | 101 | 0 | 0 | 1 |
REFERRER | WCA | 67 | 0 | 0 | 1 |
REFERRERHOST | WCA | 305 | 0 | 0 | 1 |
REFERRERURL | WCA | 301 | 0 | 0 | 1 |
RESOURCES | WCA | 313 | 0 | 0 | 1 |
RESULT | WCA | 293 | 0 | 0 | 1 |
RETURNCODES | WCA | 151 | 0 | 0 | 1 |
SERVERNODES | WCA | 51 | 0 | 0 | 1 |
SERVERS | WCA | 301 | 0 | 0 | 1 |
SESSION_FACTS | WCA | 269 | 0 | 0 | 1 |
SESSIONPARMS | WCA | 63 | 0 | 0 | 1 |
SUBDOMAINS | WCA | 309 | 0 | 0 | 1 |
TIMEOFDAY | WCA | 67 | 0 | 0 | 1 |
USERAGENTS | WCA | 317 | 0 | 0 | 1 |
USERS | WCA | 309 | 0 | 0 | 1 |
VALUE | WCA | 301 | 0 | 0 | 1 |
WEB_NODES | WCA | 297 | 0 | 0 | 1 |
Tables in WCA schema |
|||||
ACCOUNT | WCA _ACCOUNT | 262 | 1,000 | 262,000 | 64 |
ADDRESS | WCA _ADDRESS | 1,947 | 1,000 | 1,947,000 | 475 |
ATTRIBUTE | WCA _ATTRIBUTE | 348 | 1,000 | 348,000 | 85 |
ATTRIBUTE_BIN | WCA _ATTRIBUTE_BIN | 206 | 1,000 | 206,000 | 50 |
BASEITEM | WCA _BASEITEM | 132 | 1,000 | 132,000 | 32 |
CAMP_INIT_MPE_REL | WCA _CAMP_REL | 34 | 1,000 | 34,000 | 8 |
CONTRACT | WCA _CONTRACT | 300 | 1,000 | 300,000 | 73 |
ACCT_STATUS_REF | WCA _DATA | 118 | 1,000 | 118,000 | 29 |
ADDRESS_TYPE_REF | WCA _DATA | 59 | 1,000 | 59,000 | 14 |
AGE_RANGE_REF | WCA _DATA | 106 | 1,000 | 106,000 | 26 |
ALL_STORES_PARAM | WCA _DATA | 11 | 1,000 | 11,000 | 3 |
APPLY_INIT | WCA _DATA | 54 | 1,000 | 54,000 | 13 |
APPLY_MEMBER | WCA _DATA | 70 | 1,000 | 70,000 | 17 |
APPLY_RESULT | WCA _DATA | 62 | 1,000 | 62,000 | 15 |
APV_STATUS_REF | WCA _DATA | 59 | 1,000 | 59,000 | 14 |
BROWSER | WCA _DATA | 272 | 1,000 | 272,000 | 66 |
BUYERPOTYP_REF | WCA _DATA | 91 | 1,000 | 91,000 | 22 |
CAMPAIGN | WCA _DATA | 416 | 1,000 | 416,000 | 102 |
CATALOG | WCA _DATA | 276 | 1,000 | 276,000 | 67 |
CATALOG_REF | WCA _DATA | 534 | 1,000 | 534,000 | 130 |
CATEGORY_REF | WCA _DATA | 534 | 1,000 | 534,000 | 130 |
CONCEPT_HIERARCHY | WCA _DATA | 30 | 1,000 | 30,000 | 7 |
CONCEPT_REF | WCA _DATA | 654 | 1,000 | 654,000 | 160 |
CON_STATUS_REF | WCA _DATA | 214 | 1,000 | 214,000 | 52 |
CONSTRAINTS | WCA _DATA | 57 | 1,000 | 57,000 | 14 |
CUR_CONVERT_HIST | WCA _DATA | 60 | 1,000 | 60,000 | 15 |
CURRENCYCONVERSION | WCA _DATA | 60 | 1,000 | 60,000 | 15 |
DAY_OF_FM_REF | WCA _DATA | 62 | 1,000 | 62,000 | 15 |
DAY_OF_FY_REF | WCA _DATA | 62 | 1,000 | 62,000 | 15 |
DAY_OF_WK_REF | WCA _DATA | 62 | 1,000 | 62,000 | 15 |
DAY_RANGE_REF | WCA _DATA | 308 | 1,000 | 308,000 | 75 |
DR_MEMBER_TYPE_REF | WCA _DATA | 37 | 1,000 | 37,000 | 9 |
EVENT_TYPE_REF | WCA _DATA | 77 | 1,000 | 77,000 | 19 |
FACT_CPGN_STATS | WCA _DATA | 62 | 1,000 | 62,000 | 15 |
FACT_METAPHOR | WCA _DATA | 110 | 1,000 | 110,000 | 27 |
FEATURES | WCA _DATA | 52 | 1,000 | 52,000 | 13 |
FFMCENTER | WCA _DATA | 620 | 1,000 | 620,000 | 151 |
HOUR | WCA _DATA | 34 | 1,000 | 34,000 | 8 |
HOUR_AMPM_REF | WCA _DATA | 64 | 1,000 | 64,000 | 16 |
HOUR_TYPE_REF | WCA _DATA | 404 | 1,000 | 404,000 | 99 |
INCOME_REF | WCA _DATA | 406 | 1,000 | 406,000 | 99 |
INITIATIVE | WCA _DATA | 179 | 1,000 | 179,000 | 44 |
INVNTRY_STAT_REF | WCA _DATA | 90 | 1,000 | 90,000 | 22 |
LANGUAGE_REF | WCA _DATA | 22 | 1,000 | 22,000 | 5 |
LAST_UPDATED_REF | WCA _DATA | 28 | 1,000 | 28,000 | 7 |
MARITAL_STAT_REF | WCA _DATA | 59 | 1,000 | 59,000 | 14 |
MEMBER_TYPE_REF | WCA _DATA | 57 | 1,000 | 57,000 | 14 |
META_FEAT_REL | WCA _DATA | 90 | 1,000 | 90,000 | 22 |
METAPHOR | WCA _DATA | 424 | 1,000 | 424,000 | 104 |
METAPHOR_TYPE_REF | WCA _DATA | 122 | 1,000 | 122,000 | 30 |
MON_OF_FY_REF | WCA _DATA | 62 | 1,000 | 62,000 | 15 |
MPE_TYPE_REF | WCA _DATA | 340 | 1,000 | 340,000 | 83 |
MPF_TYPE_REF | WCA _DATA | 59 | 1,000 | 59,000 | 14 |
ORDER_STATUS_REF | WCA _DATA | 151 | 1,000 | 151,000 | 37 |
ORGANIZATION | WCA _DATA | 2,815 | 1,000 | 2,815,000 | 687 |
ORIGIN_REF | WCA _DATA | 92 | 1,000 | 92,000 | 22 |
PARAMETERS | WCA _DATA | 82 | 1,000 | 82,000 | 20 |
PARTROLE_REF | WCA _DATA | 136 | 1,000 | 136,000 | 33 |
PER_AGGR_REF | WCA _DATA | 62 | 1,000 | 62,000 | 15 |
PER_DESC_REF | WCA _DATA | 202 | 1,000 | 202,000 | 49 |
PRODUCT | WCA _DATA | 367 | 1,000 | 367,000 | 90 |
QTR_OF_FY_REF | WCA _DATA | 62 | 1,000 | 62,000 | 15 |
RANK_RANGE_REF | WCA _DATA | 308 | 1,000 | 308,000 | 75 |
REFERENCE | WCA _DATA | 340 | 1,000 | 340,000 | 83 |
RFQ_ENDRES_REF | WCA _DATA | 59 | 1,000 | 59,000 | 14 |
RFQ_STATUS_REF | WCA _DATA | 59 | 1,000 | 59,000 | 14 |
RSP_STATUS_REF | WCA _DATA | 96 | 1,000 | 96,000 | 23 |
SEG_ATTRIBUTE_REF | WCA _DATA | 368 | 1,000 | 368,000 | 90 |
SEGMENT | WCA _DATA | 360 | 1,000 | 360,000 | 88 |
SEGMENTATION | WCA _DATA | 364 | 1,000 | 364,000 | 89 |
SHIPMODE | WCA _DATA | 82 | 1,000 | 82,000 | 20 |
STORE | WCA _DATA | 66 | 1,000 | 66,000 | 16 |
STORE_REF | WCA _DATA | 486 | 1,000 | 486,000 | 119 |
TRADETYPE_REF | WCA _DATA | 106 | 1,000 | 106,000 | 26 |
TRD_STATUS_REF | WCA _DATA | 92 | 1,000 | 92,000 | 22 |
WK_OF_FM_REF | WCA _DATA | 64 | 1,000 | 64,000 | 16 |
WK_OF_FQ_REF | WCA _DATA | 64 | 1,000 | 64,000 | 16 |
WK_OF_FY_REF | WCA _DATA | 64 | 1,000 | 64,000 | 16 |
FACT_EVENT | WCA _FACT_EVENT | 98,695 | 1,000 | 98,695,000 | 24,095 |
FACT_PA | WCA _FACT_META | 50 | 1,000 | 50,000 | 12 |
FACT_PC | WCA _FACT_META | 58 | 1,000 | 58,000 | 14 |
FACT_PE | WCA _FACT_META | 50 | 1,000 | 50,000 | 12 |
FACT_SA | WCA _FACT_META | 54 | 1,000 | 54,000 | 13 |
FACT_VISITS | WCA _FACT_VISIT | 98,572 | 1,000 | 98,572,000 | 24,065 |
FACT_INTEREST | WCA _FT_INT_ATTR | 128 | 1,000 | 128,000 | 31 |
FACT_INTEREST_LIST | WCA _FT_INT_LIST | 99 | 1,000 | 99,000 | 24 |
ITEMSPC | WCA _ITEMSPC | 113 | 1,000 | 113,000 | 28 |
MEMBER | WCA _MEMBER | 1,694 | 1,000 | 1,694,000 | 414 |
MPE | WCA _MPE | 344 | 1,000 | 344,000 | 84 |
OFFER | WCA _OFFER | 121 | 1,000 | 121,000 | 30 |
OFFER_DESC | WCA _OFFERDESC | 280 | 1,000 | 280,000 | 68 |
OFFER_PRICE | WCA _OFFERPRICE | 45 | 1,000 | 45,000 | 11 |
FACT_ORDERITEMS | WCA _ORDERITEM | 701 | 1,000 | 701,000 | 171 |
FACT_ORDERS | WCA _ORDERS | 612 | 1,000 | 612,000 | 149 |
PARTICIPNT | WCA _PARTICIPNT | 54 | 1,000 | 54,000 | 13 |
PERIOD | WCA _PERIOD | 106 | 1,000 | 106,000 | 26 |
GENDER_REF | WCA _PROD_ATTR | 62 | 1,000 | 62,000 | 15 |
PROD_ATTR_REF | WCA _PROD_ATTR | 788 | 1,000 | 788,000 | 192 |
PRODUCT_ATTRIBUTE | WCA _PROD_ATTR | 30 | 1,000 | 30,000 | 7 |
PRODUCT_REF | WCA _PRODDESC | 348 | 1,000 | 348,000 | 85 |
PRODUCT_HIERARCHY | WCA _PRODHIER | 356 | 1,000 | 356,000 | 87 |
RFM | WCA _RFM | 90 | 1,000 | 90,000 | 22 |
RFM_ATTR_LIST | WCA _RFMATTR | 318 | 1,000 | 318,000 | 78 |
RFM_MEMBER | WCA _RFMMBR | 332 | 1,000 | 332,000 | 81 |
RFM_TRADING | WCA _RFMTRAD | 352 | 1,000 | 352,000 | 86 |
RFQ | WCA _RFQ | 322 | 1,000 | 322,000 | 79 |
RFQ_REQPRD | WCA _RFQREQPRD | 77 | 1,000 | 77,000 | 19 |
RFQ_RSP | WCA _RFQRSP | 1,034 | 1,000 | 1,034,000 | 252 |
RFQ_RSPPRD | WCA _RFQRSPPRD | 85 | 1,000 | 85,000 | 21 |
SUM_MEMBER | WCA _SUMMBR | 67 | 1,000 | 67,000 | 16 |
SUM_TRADING | WCA _SUMTRAD | 67 | 1,000 | 67,000 | 16 |
TRADING | WCA _TRADING | 62 | 1,000 | 62,000 | 15 |
EMSPOT | 340 | 1,000 | 340,000 | 83 | |
MEMBER_ORDERS | 12 | 1,000 | 12,000 | 3 | |
MEMBER_WISHES | 12 | 1,000 | 12,000 | 3 | |
RESULTTYPE_REF | 340 | 1,000 | 340,000 | 83 | |
Tables in WCAETL schema |
|||||
BROWSER1_INFO | WCA | 245 | 1,000 | 245,000 | 60 |
BUYERPO_PAYMTHD | WCA | 35 | 1,000 | 35,000 | 9 |
CAMP_PERIOD | WCA | 26 | 1,000 | 26,000 | 6 |
CURR_CONV | WCA | 18 | 1,000 | 18,000 | 4 |
DMT_MEMBER_T | WCA | 16 | 1,000 | 16,000 | 4 |
FE_CLICKS_T | WCA | 62 | 1,000 | 62,000 | 15 |
FE_FOI_T | WCA | 105 | 1,000 | 105,000 | 26 |
FE_REFURL_T | WCA | 148 | 1,000 | 148,000 | 36 |
FE_UPDS_T | WCA | 101 | 1,000 | 101,000 | 25 |
FM_FOI_T | WCA | 82 | 1,000 | 82,000 | 20 |
FM_UPDATE_T | WCA | 34 | 1,000 | 34,000 | 8 |
FM_UPDS_T | WCA | 66 | 1,000 | 66,000 | 16 |
FO_OITEM_T | WCA | 107 | 1,000 | 107,000 | 26 |
ORD_CREATE_DATE | WCA | 34 | 1,000 | 34,000 | 8 |
ORDER_CURRENCY_REF | WCA | 11 | 1,000 | 11,000 | 3 |
ORDERITEM_OFFER | WCA | 47 | 1,000 | 47,000 | 11 |
ORDERITEMS_TRADING | WCA | 36 | 1,000 | 36,000 | 9 |
REPLICATION_HISTORY | WCA | 66 | 1,000 | 66,000 | 16 |
RPT_MEMBER_T | WCA | 16 | 1,000 | 16,000 | 4 |
TEM_CURRENCYCON | WCA | 60 | 1,000 | 60,000 | 15 |
TMP_SUM | WCA | 24 | 1,000 | 24,000 | 6 |
T_ORDERS_PER_HOUR | WCA | 26 | 1,000 | 26,000 | 6 |
WebSphere Commerce Analyzer _TRACE | WCA | 202 | 1,000 | 202,000 | 49 |
AGE_V | 24 | 1,000 | 24,000 | 6 | |
DMT_PROSPECT_V | 36 | 1,000 | 36,000 | 9 | |
DMT_PURCHASER_V | 36 | 1,000 | 36,000 | 9 | |
FE_ORD_STATUS_V | 36 | 1,000 | 36,000 | 9 | |
FM_ORD_STATUS_V | 36 | 1,000 | 36,000 | 9 | |
GENDER_REF_V | 14 | 1,000 | 14,000 | 3 | |
INCOME_V | 132 | 1,000 | 132,000 | 32 | |
MARITAL_STAT_REF_V | 9 | 1,000 | 9,000 | 2 | |
MEMBER_TYPE_REF_V | 7 | 1,000 | 7,000 | 2 | |
PROSPECT_COUNT_V | 12 | 1,000 | 12,000 | 3 | |
PURCHASER_COUNT_V | 12 | 1,000 | 12,000 | 3 | |
Tables in WCAEXCPT schema |
|||||
ACCOUNTSUM | WCA | 3,2803 | 0 | 0 | 1 |
ADDRESS | WCA | 3,4725 | 0 | 0 | 1 |
BASEITEM | WCA | 3,2910 | 0 | 0 | 1 |
CONTRACTSUM | WCA | 32,839 | 0 | 0 | 1 |
DMT_MEMBER_T | WCA | 32,794 | 0 | 0 | 1 |
FACT_EVENT | WCA | 131,493 | 0 | 0 | 1 |
FACT_INTEREST_LIST | WCA | 32,877 | 0 | 0 | 1 |
FACT_METAPHOR | WCA | 32,888 | 0 | 0 | 1 |
FACT_ORDERS | WCA | 33,390 | 0 | 0 | 1 |
FACT_ORDERITEMS | WCA | 34,116 | 0 | 0 | 1 |
FACT_VISITS | WCA | 131,350 | 0 | 0 | 1 |
FE_CLICKS_T | WCA | 32,840 | 0 | 0 | 1 |
FE_FOI_T | WCA | 32,883 | 0 | 0 | 1 |
FE_REFURL_T | WCA | 32,926 | 0 | 0 | 1 |
FE_UPDS_T | WCA | 32,879 | 0 | 0 | 1 |
FM_FOI_T | WCA | 32,860 | 0 | 0 | 1 |
FM_UPDATE_T | WCA | 32,812 | 0 | 0 | 1 |
FM_UPDS_T | WCA | 32,844 | 0 | 0 | 1 |
FO_OITEM_T | WCA | 32,885 | 0 | 0 | 1 |
INITCHARS | WCA | 32,867 | 0 | 0 | 1 |
MEMBSUMS | WCA | 33,385 | 0 | 0 | 1 |
MEMCTGSUMT | WCA | 32,841 | 0 | 0 | 1 |
MEMCTGYSUM | WCA | 32,841 | 0 | 0 | 1 |
MEMORDSUM | WCA | 33,316 | 0 | 0 | 1 |
MEMPRODSUM | WCA | 33,327 | 0 | 0 | 1 |
PRODUCT_ATTRIBUTE | WCA | 32,808 | 0 | 0 | 1 |
RPT_MEMBER_T | WCA | 32,794 | 0 | 0 | 1 |
TMP_CALC_ITEMS | WCA | 32,846 | 0 | 0 | 1 |
TMP_SUM_ITEMS | WCA | 32,966 | 0 | 0 | 1 |
T_PERIOD_ORDER | WCA | 32,800 | 0 | 0 | 1 |
Tables in WCAMNG schema |
|||||
ACCOUNTSUM | WCA | 77 | 1,000 | 77,000 | 19 |
ACNTAPP01 | WCA | 42 | 1,000 | 42,000 | 10 |
ACNTAPP02 | WCA | 42 | 1,000 | 42,000 | 10 |
APPTABS | WCA | 52 | 1,000 | 52,000 | 13 |
ARFQAPP01 | WCA | 42 | 1,000 | 42,000 | 10 |
ARFQAPP02 | WCA | 42 | 1,000 | 42,000 | 10 |
CNTRAPP01 | WCA | 42 | 1,000 | 42,000 | 10 |
CNTRAPP02 | WCA | 42 | 1,000 | 42,000 | 10 |
CONTRACTSUM | WCA | 61 | 1,000 | 61,000 | 15 |
DATATABS | WCA | 560 | 1,000 | 560,000 | 137 |
INITAPP11 | WCA | 38 | 1,000 | 38,000 | 9 |
INITAPP12 | WCA | 38 | 1,000 | 38,000 | 9 |
INITCHARS | WCA | 89 | 1,000 | 89,000 | 22 |
MEMAPP21 | WCA | 42 | 1,000 | 42,000 | 10 |
MEMAPP22 | WCA | 42 | 1,000 | 42,000 | 10 |
MEMAPP31 | WCA | 42 | 1,000 | 42,000 | 10 |
MEMAPP32 | WCA | 42 | 1,000 | 42,000 | 10 |
MEMAPP41 | WCA | 42 | 1,000 | 42,000 | 10 |
MEMAPP42 | WCA | 42 | 1,000 | 42,000 | 10 |
MEMAPP51 | WCA | 42 | 1,000 | 42,000 | 10 |
MEMAPP52 | WCA | 42 | 1,000 | 42,000 | 10 |
MEMAPP61 | WCA | 42 | 1,000 | 42,000 | 10 |
MEMAPP62 | WCA | 42 | 1,000 | 42,000 | 10 |
MEMAPP91 | WCA | 42 | 1,000 | 42,000 | 10 |
MEMAPP92 | WCA | 42 | 1,000 | 42,000 | 10 |
MEMBSUMS | WCA | 607 | 1,000 | 607,000 | 148 |
MEMBSUMSAMP | WCA | 607 | 1,000 | 607,000 | 148 |
MEMCTGSUMT | WCA | 63 | 1,000 | 63,000 | 15 |
MEMCTGYSAMP | WCA | 537 | 1,000 | 537,000 | 131 |
MEMCTGYSUM | WCA | 537 | 1,000 | 537,000 | 131 |
MEMORDSAMP | WCA | 538 | 1,000 | 538,000 | 131 |
MEMORDSUM | WCA | 538 | 1,000 | 538,000 | 131 |
MEMPRODSAMP | WCA | 549 | 1,000 | 549,000 | 134 |
MEMPRODSUM | WCA | 549 | 1,000 | 549,000 | 134 |
MODELS | WCA | 596 | 1,000 | 596,000 | 146 |
ORDAPP71 | WCA | 50 | 1,000 | 50,000 | 12 |
ORDAPP72 | WCA | 50 | 1,000 | 50,000 | 12 |
PRODAPP81 | WCA | 50 | 1,000 | 50,000 | 12 |
PRODAPP82 | WCA | 50 | 1,000 | 50,000 | 12 |
PRODAPP83 | WCA | 50 | 1,000 | 50,000 | 12 |
PRODAPP84 | WCA | 50 | 1,000 | 50,000 | 12 |
Tables in WSA schema |
|||||
ADDED_TO | WSA_DATA | 118 | 4 | 472 | 1 |
COOKIE_STATUS | WSA_DATA | 72 | 1 | 72 | 1 |
HIT_FACTS | WSA_HIT_FACTS | 162 | 0 | 0 | 1 |
HTTP_VERSION | WSA_HIT_FACTS | 272 | 0 | 0 | 1 |
NAV_PATH_RANGE | WSA_DATA | 520 | 6 | 3,120 | 1 |
NAVIGATION_FACT | WSA_NAV_FACT | 2,672 | 0 | 0 | 1 |
NETWORK_SUB_DOMAIN | WSA_DATA | 578 | 1 | 578 | 1 |
PROTOCOLS | WSA_DATA | 72 | 1 | 72 | 1 |
REFERRER | WSA_DATA | 526 | 1 | 526 | 1 |
RESET_STATUS | WSA_DATA | 72 | 1 | 72 | 1 |
RESOURCE | WSA_DATA | 285 | 1 | 285 | 1 |
RESULT | WSA_DATA | 272 | 1 | 272 | 1 |
RETURN_CODE | WSA_DATA | 122 | 1 | 122 | 1 |
SERVER | WCA | 272 | 1 | 272 | 1 |
SESSION_FACTS | WSA_SESS_FACTS | 216 | 0 | 0 | 1 |
SRCH_CLASS | WSA_DATA | 208 | 16 | 3,328 | 1 |
SRCH_CLASS_FACT | WSA_S_CLS_FT | 376 | 0 | 0 | 1 |
SRCH_COMPOSITE_FACT | WSA_S_COMP_FT | 115 | 0 | 0 | 1 |
SRCH_COMPOSITE_STRING | WSA_S_COMP_FT | 1,022 | 0 | 0 | 1 |
SRCH_CRITERIA | WSA_DATA | 298 | 6 | 1,788 | 1 |
SRCH_RESULT_FACT | WSA_S_RESLT_FT | 149 | 0 | 0 | 1 |
SRCH_RESULT_TYPE | WSA_DATA | 118 | 4 | 472 | 1 |
SRCH_SCOPE | WSA_DATA | 118 | 4 | 472 | 1 |
USER_AGENTS | WSA_DATA | 786 | 1 | 786 | 1 |
WSA_PARAMETER | WSA_DATA | 178 | 0 | 0 | 1 |