Table Layout

  1. Addresses
  2. Customers
  3. Orders
  4. Products
  5. __AttrLists__
  6. __Attributions__
  7. __Big__
  8. __Holds__
  9. __Nodes__
1. Addresses table
Addressesidaptstreetcitystatecontact
links to:Customers.id
u_apt_street_city_state U0123
example
1123 Elm StreetEdgeCityAV1
2. Customers table
CustomersidgivenNamefamilyNamebillingAddress
links to:Addresses.id
u_givenName_familyName_billingAddress U012
example
1BiffThompson1
3. Orders table
OrdersidcustomerproductorderDateshippingAddress
links to:Customers.idProducts.idAddresses.id
u_customer_product_orderDate U012
example
21851100420020907000000
4. Products table
ProductsidpartNodescriptionprice
u_name U0
example
1001G1wh01white house800000
5. __AttrLists__ table
__AttrLists__idlistIda
links to:__Attributions__.id
u_listId_a U01
example
6. __Attributions__ table
__Attributions__idtypedocauthmodifiedcreated
links to:__Nodes__.id__Nodes__.id
u_type_doc U01
example
7. __Big__ table
__Big__idhashstr
u_hash U0
example
8. __Holds__ table
__Holds__idpsora
links to:__Nodes__.id__Nodes__.id__Nodes__.id__Nodes__.id__AttrLists__.id
u_ U01234
example
9. __Nodes__ table
__Nodes__idtypehashstrbigattribOrDT
links to:__Big__.id__Attributions__.id
u_type_str_big_attribOrDT U0123
u_hash U01
example