SQLOnAir Data model

<< Back Interactive Object Explorer

Table of Contents

  1. CartItem
  2. Customer
  3. Product
  4. ShoppingCart

CartItem

CRUDNameTypeOriginal Name
CartItemIdNTEXT
ShoppingCart Parent
Product Parent
Quantitydecimal
CartItem Query
SELECT CartItemId, ShoppingCart, Product, Quantity FROM CartItem

Customer

Each Customer may have zero or more associated ShoppingCarts
CRUDNameTypeOriginal Name
CustomerIdNTEXT
NameNTEXT
PhoneNumberNTEXT
EmailAddressNTEXT
TaxRatedecimal
Customer Query
SELECT CustomerId, Name, PhoneNumber, EmailAddress, TaxRate FROM Customer

Product

Each Product may have zero or more associated CartItems
CRUDNameTypeOriginal Name
ProductIdNTEXT
NameNTEXT
UnitPricedecimal
Product Query
SELECT ProductId, Name, UnitPrice FROM Product

ShoppingCart

Each ShoppingCart may have zero or more associated CartItems
CRUDNameTypeOriginal Name
ShoppingCartIdNTEXT
Customer Parent
CartNumberINT32
CartDateDATETIME
ShoppingCart Query
SELECT ShoppingCartId, CartNumber, CartDate, Customer FROM ShoppingCart