iisCART Documentation | ![]() |
iisCART DataBase Structure | ||
Tables | Fields | Field Type: |
Items | ID ItemID (primary key) ItemName ItemDescription ItemPrice ItemWeight Custom1 Custom2 Custom3 Custom4 Custom5 |
autonumber Text Text Text Currency Number Text Text Text Text Text |
Orders | ID SessionID Name Company Address1 Address2 Address3 City StateProvince ZipPostal Country Phone BillingSameAsShipping ShipName ShipCompany ShipAddress1 ShipAddress2 ShipAddress3 ShipCity ShipStateProvince ShipZipPostal ShipCountry ShipPhone ShipEmail Resident CountryResident Tax Shipping OrderTotal CCType CCNumber CCMonth CCYear CCName OrderDate ShippingType |
AutoNumber Text Text Text Text Text Text Text Text Text Text Text Yes/No Text Text Text Text Text Text Text Text Text Text Text Text Yes/No Yes/No Currency Currency Currency Text Text Text Text Number Number Text Date/Time Text |
Order Items | ID OrderID ItemID Quantity Property1 Property2 Property3 Property4 Property5 |
AutoNumber Number Text Number Text Text Text Text Text |
Description / Comments: | ||
iisCART requires a backend structure identical to this as is looks for specific field names. There is backend flexibility however as a DSN is used rather than connecting directly to the DB. | ||
© Corporate Web Solutions 1998, 1999. | ![]() |