Addresses 

AddressCodeID int NOT NULL PRIMARY KEY 
name nvarchar 255  
company nvarchar 255  
address nvarchar 255  
city nvarchar 50  
state nvarchar 50  
zip nvarchar 20  
country nvarchar 50  
phone nvarchar 20  
email nvarchar 100  
fax nvarchar 40  
altphone nvarchar 20  
url nvarchar 255  
international nvarchar 50 NULL


Captcha

code int NOT NULL PRIMARY KEY 
Captcha char 12  
Timestamp datetime NULL


ColorPallet

IndexKey int NOT NULL PRIMARY KEY 
PalletName nvarchar 10  
ColorName nvarchar 20  
ColorChip nvarchar 100 NULL

Listing

indexkey int NOT NULL PRIMARY KEY
orderLineItemID int NULL
customerID int NULL
DateSubmitted datetime NULL
FullName nvarchar (20) NULL
ApprovedForDisplay int NULL
ProcessingStep int NULL					
description ntext NULL
SearchableDescription nvarchar (255) NULL 
Featured nvarchar (20) NULL
FeaturedDesc nText NULL
ListingType int NULL
Category nvarchar(100) NULL
SubCategory nvarchar(100) NULL
geozip nvarchar (20) NULL
geocity nvarchar (50) NULL
geostate nvarchar (50) NULL
geocountry nvarchar (20) NULL
picturefileA nvarchar (255) NULL 
picturefileB nvarchar (255) NULL 
picturefileC nvarchar (255) NULL 
picturefileD nvarchar (255) NULL 
picturefileE nvarchar (255) NULL 
picturefileF nvarchar (255) NULL 
picturefileG nvarchar (255) NULL
LELastShown datetime NULL
LEImpressionCnt int null
LEClickCnt int null
LERanking int NULL
LEVotes int NULL
LEImpressionBalancer int null
LELastRevised datetime NULL
LERevisionCount int null

ListingExt1

indexkey int NOT NULL PRIMARY KEY


ListingExt2

indexkey int NOT NULL PRIMARY KEY


Coupons

CouponNumber nvarchar 100  
active bit NOT  
totaldollarvalue float  
remainingdollarvalue float  
buyn int  
getxfree int  
begindate datetime  
enddate datetime  
validateproducttypes nvarchar 255  
usesleft int  
percentdiscount int  
issuedto nvarchar 80  
issuedby nvarchar 80 NOT  
issued bit NOT  
CouponTemplate bit NOT  
AutoCoupon bit NOT  
AutoCouponProductId nvarchar 255  
AutoCouponProductType nvarchar 255  
StoreCode nvarchar 40  
IssuedFrom nvarchar 80  
CodeDescriptor nvarchar 80  
RequiredDiscountPlan nvarchar 40  
indexkey int NOT NULL PRIMARY KEY


CustomerNotes 

IndexId int NOT NULL PRIMARY KEY 
DateCreated datetime  
RefCustomerId int  
RefTransactionId int  
AdminCustomerID int  
Note ntext NULL


Customers

CustomerID int NOT NULL PRIMARY KEY 
addressid int  
ntusername nvarchar 20  
ntuserpassword nvarchar 20  
discountplan nvarchar 40  
lastpurchasedate datetime  
orderingpreferences nvarchar 255 NULL


CustomersExt

CustomerId int NOT NULL PRIMARY KEY 
DateCreated datetime  
AssignedDealerID int  
OrderCount int  
CustomerComment ntext  
MBOwnerFlag int  
MBMembership char 300  
MBBlockedFlag int  
MBBlockedExplaination ntext  
MBOptIn int  
MIReferrer char 200  
MIMarketingInfo ntext NULL


CustomerSID

Indexkey int NOT NULL PRIMARY KEY 
CustomerId int NOT  
Entity int  
ReadPerm char 500  
WritePerm char 500 NULL


DealerExt

DealerId int NOT NULL PRIMARY KEY 
CurrentDefault int  
District nvarchar 2  
Mas90Code nvarchar 11  
BOACode nvarchar 10 NULL


Dealers

DealerID int NOT NULL PRIMARY KEY 
addressid int  
ntusername nvarchar 20  
ntuserpassword nvarchar 20  
activiated int NOT  
commission int  
businessidcode nvarchar 50 NULL


EMBroadcast

MBJobTrackingId int NOT NULL PRIMARY KEY 
MBJobOwnerCustomerID int  
MBMailCount int  
MBStartDateTime datetime  
MBEndDateTime datetime NULL


EventLog

IndexKey int NOT NULL PRIMARY KEY IDENTITY11 
timestamp datetime  
eventtype int NOT  
ip char 20  
customerid int  
info char 256  
reported bit NOT 
CTracker char 20  


EventLogArchive

IndexKey int NOT NULL PRIMARY KEY
timestamp datetime
eventtype int
ip char20
customerid int
info char256
reported bit


Items

ItemCodeID int NOT NULL PRIMARY KEY 
sku nvarchar 40  
description nvarchar 255 NOT  
fullname nvarchar 255  
nickname nvarchar 20 NOT  
priceea float NOT  
picturefilea nvarchar 255  
picturefileb nvarchar 255  
category nvarchar 255  
subcategory nvarchar 255  
informationlink nvarchar 255  
qtyinstock int  
payloadloc nvarchar 255  
producttype nvarchar 40 (older DB's may be 20)
keywords nvarchar 255  
chargesalestax int  
shipwt float  
defaultshipmode int  
fixedshipcost nvarchar 20  
attributelist nvarchar 255  
dateadded datetime NULL


ItemsExt

ItemCodeId int NOT NULL PRIMARY KEY 
RetailPrice float  
SpecialPrice float  
LongDesc ntext  
ProductSize nvarchar 20  
OutOfStockMsg nvarchar 200  
Logo nvarchar 255  
Featured nvarchar 30  
FeaturedDesc ntext  
FeaturedLogo nvarchar 255  
Brands nvarchar 255  
FFParams ntext  
SubscriptionPeriodLength int  
SubscriptionFreecount int  
SubscriptionType int  
SubscriptionForcedOrderSKU nvarchar 40  
SilentOrder int NULL
MinQtyPerLineItem int NULL
Surcharge float NULL
CheckForDups int NULL


JobQueue

IndexKey int NOT NULL PRIMARY KEY IDENTITY11 
jobcode int NOT  
store nvarchar 40 NOT  
scheduling nvarchar 100  
enabled bit NOT  
runable int NOT  
param1 char 2000  
param2 char 2000  
param3 char 2000  
nextrun datetime  
lastrun datetime  
statuscode int  
statusmsg nvarchar 100 NULL


LogonSession

TokenA int NOT NULL PRIMARY KEY 
SessionID int  
Sid char 20 NULL


LogonToken

TokenA int NOT NULL PRIMARY KEY 
CustomerId int  
timestamp datetime NULL


OrderLineItem

LineItemID int NOT NULL PRIMARY KEY 
transactionid int NOT  
itemcodeid int NOT  
itemparameter nvarchar 60  
quantity int  
priceea float  
shipmethod nvarchar 100  
shiptoaddressid int  
requiredshipdate datetime  
altitemdescription nvarchar 100  
orderflags nvarchar 100  
comment nvarchar 300 NULL


OrderLineItemExt

LineItemId int NOT NULL PRIMARY KEY 
FreeFormParams ntext  
SubscriptionEnabed int  
SubscriptionPeriodsLeft int  
NextOrderDate datetime  
ServiceContract char 20  
InspectedBy int  
SerialNumber char 50  
RMADisposition char 20 NULL
AppliedSurchargeAmt float NULL
AppliedSurchargeMsg char (256) NULL
AppliedQtyChargeAmt float NULL


Orders

TransactionID int NOT NULL PRIMARY KEY 
sendsafetxnum int  
date datetime  
customerid int NOT  
storecode nvarchar 40  
creditcard nvarchar 25  
couponnumber nvarchar 100  
subtotalitems float  
subtotalshipping float  
subtotalsalestax float  
totalamount float  
status nvarchar 255  
cctxstatus nvarchar 255  
approvalcode nvarchar 255  
dealeridcode int  
stdealeridcode int  
ipaddress nvarchar 20  
qtypricetable nvarchar 100  
couponadjustment float NULL


OrdersPostProc

TransactionID int NOT NULL PRIMARY KEY 
fulfillment nvarchar 255  
postprocstatus nvarchar 255  
Serializer int  
ProcessStep int  
AcklFulFillmentCompleted datetime  
AckRMACheckIssued datetime  
NagIssued datetime NULL


ContextSensitiveContent

IndexKey int NOT NULL PRIMARY KEY
Key1 nvarchar255 
Key2 nvarchar255 
Key3 nvarchar255 
Key4 nvarchar255 
ContentType int 
ContentLocation nvarchar255
Content ntext 
Refdate datetime  
Enabled int NULL

CSCAuthor nvarchar(255)
CSCAltSummary nText NULL
CSCReadMoreLink char(100)
CSCBoBackLink char(20)
CSCheadlineFormatCode int null
CSCArticleFormatCode int null
CSCLastShown datetime NULL
CSCImpressionCnt int null
CSCClickCnt int null
CustomerID int NULL
CSCRanking int NULL
CSCVotes int NULL
CSCImpressionBalancer int null

CSCLastRevised datetime NULL
RevisionCount int null
CSCLinkageCode int null
CSCPublicationProcessingStep int NULL					
CSCProcessingStatusMessage nvarchar(255) null

CSCPicturefileA nvarchar (150) NULL 
CSCPicturefileB nvarchar (150) NULL 
CSCPicturefileC nvarchar (150) NULL 
CSCPicturefileD nvarchar (150) NULL 
CSCPicturefileE nvarchar (150) NULL 
CSCPicturefileF nvarchar (150) NULL 
CSCPicturefileG nvarchar (150) NULL
CSCPicturefileH nvarchar (150) NULL
CSCPicturefileI nvarchar (150) NULL
CSCPicturefileJ nvarchar (150) NULL
CSCPicturefileK nvarchar (150) NULL
CSCPicturefileL nvarchar (150) NULL
CSCPicturefileM nvarchar (150) NULL


PricingMatrix

IndexKey int NOT NULL PRIMARY KEY
SKU nvarchar40
RowVal int
ColVal int
Amount float


StateControl

IndexKey int NOT NULL PRIMARY KEY IDENTITY11 
CustomerID int NOT  
timestamp datetime  
keyname nvarchar 50  
value nvarchar 100 NULL


StoreConfig

EntryIndex int NOT NULL PRIMARY KEY 
storefront nvarchar 20  
tablename nvarchar 80  
keyword nvarchar 40  
value1 nvarchar 100  
value2 ntext NULL


Advertisement

AdIDCode int NOT NULL PRIMARY KEY 
AdName char 40 null
AdContent ntext 
BeginTime datetime 
EndTime datetime 
TODBeginTime int 
TODEndTime int 
LastShown datetime 
Type int 
ClickLinkURL nvarchar 255 
Enabled int 
zip nvarchar 20 
ImpressionCnt int 
ClickCnt int 
CustomerID int 
Ranking int 
AdWidth int 
AdHeight int NULL
ImpressionBalancer int NULL

ADMTableLock

RecordLocator int NOT NULL
PrimaryTableName char (20) NOT NULL
LockType int
CID int
Timestamp datetime
PRIMARY KEY ( RecordLocator PrimaryTableName )

CreditCard

TransactionId int NOT NULL 
creditcardnumber nvarchar (80) NULL 
expdate nvarchar (12) NULL
csvCode nvarchar (25) NULL