AdventureWorksLT2019

Note that there are some explanatory texts on larger screens.

plurals

PRTouring-1000 Yellow, 46
primarykey
ProductID
954
data
StandardCost
1481.9379
ListPrice
2384.0700
Weight
11398.72
ProductCategoryID
7
ProductModelID
34
SellStartDate
2007-07-01T00:00:00
SellEndDate
DiscontinuedDate
ThumbNailPhoto
R0lGODlhUAAxAPcAAHh8fWhvLcjQOnR3edrb2+nqK/b2O/f30/b2GsHDw/39Qvz8/Lq8vPb29mVoacrMy+TjOu7t7u7t8Ly7yJSYs1NZWP3+JLOrbm98qfr6+vj4+KqrrNrZ6LbFYfv7e3t9IKGkpP7+/uXlabK0tE90TLe2rfT09Ono6srImPf4i+blWX+Eg+XmiIaIVfn58KW3o9TUiujoDTxCRbe4KpKUleTjH/Ly8kFHTObm6cfHpisyOJqcnTE3OXeHeoODhfT09k1RVObmd8LHvPn5/iMnK/HxVc3M0d/fLuXl5qShjIqNjP//ZOrqqG1wcRohJsbBbP//W+7tt56ioFRaYsS5oGt0UairtSctMfv8mhIYHGdrcrzA1JWdmOXlS9DR0rLArV5jZaepqsTEx9XV1Tg8Q0dMUQwTF+Dg4erq687R1P//URYdIZeimvLy88vXxNzcZff2+Pz8/42Pkf7+Avj4+pmacP394dTKcvDx8LS4t4uWOsjIwP//7/v7p/Hw8fTy9PPyBP3+99joRIeUhv//buXkmrG3EPLy/tPOw/z8wOzt4oaJiq+xsIKNhvX14be3utbW16yuqeLi46KnpKWmqPHy+eHa3Pv6/fn29pSalYSFiZualfX1Xml1bgEIC9bZ1m9weevr+I2Tk4Soe/v7+PT0Yr6/wNjY28bGw//8/Pf09f79Dd7j4AYOEens6iwxL+Xo5v3+//b39fT29u/v8efi4sfUEdLT0//+/P39/ff39/Ly8PLw8X1/gvv7+5+fo8jJzPn6+vHx8uzs7vn5+fn6+NPU1O/v797eftTT183Vkt3bnd7e3NHV093e4PHxD87JecLGLdfXreTk71ZgGvb2bvf36Lm8t/HwyuTk5c7P0Ojowx8iI+rj5LW0xPz5+bi4uV1eX9jX1KenrcnKxbavqfX19vX29cfHyPb49k9RTNTVyaKhP6SSbsrQgYuNgd7cQPj6YJSMnMS9Pufn6JaXme7w79/YuPLv7MnTvfPz8/Pz9PP09Ozu7Pn8+v///yH5BAAAAAAALAAAAABQADEAAAj/AP8JHEiwoMGDCBMqXMiwYcM8DiA5nEixosMdPNY8ssixY8UFG8wQqbDBo8mTCMeEAwJGiqtiGlAKzNXGnMyKp+QQoJeABptPqCRSNFZPjhIfi5T0kmNKioNbNx3ayCUwgjMrK5pkq4juV5gwIGjcuAIECI8dDaJWDAYJBShvJ02VAZLN1Bi1HNcdmceEj8lfZH7h7RgHhYE5FqB4SBTIYi4fcgZ3HHPHwrMCBtRAWZIiEa6JZ8qgk2yxUo5Sc1alYAEBs2ZCWA40NAJqGOmKaZBZWAXFgp042IK0zgwF9oEQCENQoHCbIg5EF+DVMNDb7z/gwjFDUdzHjsFDGLY0/3cYZw8VeeUcQVDAPhZBX8GHb/bQHXkcK1NOjW/IAUY7Cof840gNvRGCXEGkYCOCfEssZo0Ahkizn0ELUCXQJejAcwEHA2ETwxIWYJFQMVGIAE8XnCxxmAJRTPgPAZQAEE4F4TgAwC9WoIAAPAEOxEQMhFiQyIEIxVFINAjMMUcMLRaUwRiM1KNJLz7U8wgzHYEDxhVOEHHFl18SscYFFsBgEAvPgOgdQgcEoUI1CMQggmwERcAIGDJw6cSeXfIQDiMxOWQMGE5kkYUON9wwVxky6PDKGxY4UBJBsaiAABQKNFZQmygWAQELjhS0QBhA6LBGFk7oAEQFUwBxgw5OrP9RhikNbfBKFmvwAMYK9eRhSgIMLKJFFUvMkMUVPuhCUDEQZBaPewIdIEIXpRTRBQvWGIRGE1ecyoMWlIBjhBfoMBCGEmDcUKgmCyi0AzdZENHEBkY0oOyBYWjxhBpVoCqvCQQNqIYCKcSiYAyciPBGIS4c5AwQ8F4xgBjZhJDBP7lcggst+OyhRBmttNKELwhtAC8Z9RiRgS8LNJCLLhUO884bKnjTC5dEgHJxhzFgqkIMgBzxBhOkIITDDWZkIQMlJ/yjiwbELABzLnD88wMSYVRghicDHOTFFWaQQUk2GWQQgj66+KJLCAuEkkM1KPyTgRKwEkFDQT8Ssgogb2z/Y+FBxDhwqjoPpPKNCbkIQ0wGafmiQQbKDgNOOGa0wkVBxABhxiu/6PePPgsQ44cvDYRATCUwwKCfOTZowuUr2hSEJiEGNKzQL7HekIBAJuiTgQkmQP4PMcQ04Isww28ARCtOfEIQJbj6QMA/9oQQwj4h0NJA1ZcogkwJl+hjEy2gEMFNOO0OFIIICCwRz98G4UDGGjpQgjEmC/BigwYRaEDHP1D7AeI0wA8/YMQTYBhIMG7QCiCYQh8h8IUN/uGLHzRgGFUbAhMEMAENxARy2ihDl8RQEGZZQA0eSIgc1rCGAWTAHBqQWirg0AA0VO0fDTAHLXxhDnMgJxkOMFQz/wQiBjOsQQ5N00cuiKEPAO5jGD/4xyHewA4OUIUYyPuHJsTUBINYowYKUAMWiDQQWpAhC2QQA8uCpwFVhAATtQhDAk5ADDSYwwTEwFgb4AACHnBNIL3whAwYUBMN2MBxabmgJMzhDAEkYRo4hKAudBHCNZDhGAbx0MASYZBHsFBnpGvAMXTxB1X8wxJNuIEcfnACXVAlA20g2QOm0AoepCMEy4vIP0J3wTb4IWpiGMEv6lGHCjwiDuf4nbL20YsRHiQKPVPAb3ahiH78oxfME8xAMhCBCNCiHxsAgyd0cIqdweEHC9CACejRzCw04xg8MIP0nkYMXxyPFsMQAwNOAP+KXgwACL2QxA9oYQ5d9BAEptoBQlgACEDUwQpS4MIOxKAFMpDBG6GYRihCcYhDhIID45DDALQABBooSxf22ocrQ0CDK7SCEQQQEw3QEDoNoFQX+3CGKbThAB2Egwc3CAc69qEBlgnEFGf0QXKCoAcSjOILQuDCCwLwAT084Q5YfQI0nvCEC7SgBXUYRCccAA5anGAYwjCBOfZhgj56QhS34IYT6jGMXMDvH5LwwjjWQAQdlOEGIzCdBrZnwQTcIAtdQ4gY2DCIHjwVBGxoATX00IHKVlYAmLWFLQyxDHFswgGLyIYw9tGAoiJnBGTwxAogIVcaZKMBOTRHafcxhkf/gOBLoBhHPRACjMMm1iC5mEQavtDYTOzgBST4QDQEIYgCFOAIBagBdCEwjyfcowSd+MUZMOY4c9QkDKldARKukIVFNI1tCzDHMNAgCQakoR69EIMpTEELOtDBg4vzRQJkkAWlHiQDUmAAIxpRhkF8AbnUYEcH3KEMFOQgB/lwgxAo0QgwVKAKPWDAKcxx11/4URTEkIHIvKBWfXTzD8dYgJ3EcAsxAMMeSBhGA1a2AMYxggdZ0KZBQgCCMOwgD4sIgxGAIQNPTAGSsRjCJf6h5H+YggaMMMU4GJDPVt6xoCbYoidK4gBPONBpwijbH6higjEYwwsJiIkG/OAHE3gw/xf6eBcRRoOQB4AgEpHoxSQiQQ4tCFIbPczFAvSRxxAAo8fm0sYZIOHNDFQoA6cAQxZaEbsNtOIK9UCCTXRhA+SYAw1oEAgO/ODpwabNF6dogtKyeJBcgCMSmchEAq4hC0aYwQkbqJoulOg0YgADCA+QxC1MQQ+o2SCt+8gFA8rgCR7kcRhEMIMDgPG5JoZAGA04AcAWMIwIRPFzUjNHBpCK2IUQ4xqNAAEqTpABHOjAE01AAg0x5rs/nKEXTqNFoIQBZ5idYBF+/C0Amk2DM6RlAaPzA7blZoII4BRjnc5FMlawBm5QWyER4HMujnEGZkiiCUANA/LS+49g+CEZYP9gRghkjDxftOEfwvCFKYJI6YGcIdokEfQxctGACBDDJsTQgDAmmRbGSeDGWXAAQz4hBWsOJBeQkAEPHJAAL5yCHpLIhgY04QkAEMMERLWJbP9hhEW8W+kE2QHzAMCAJmpAfKTrdQOSXdB/SIABFaDf9BIi6DBM4iAAYB4XIJEBNDDDGZIYRxNGAAcsXi+PunCGFCrQile4oiCxAMOlfcCAP3AYgptu2e8AiIMEgIGF9lMIHhihhE3gwSBtKINIpHCKP+CQggKRWg5D8PJTSEHSWdidQSLAwCsAYAO1CN0/xJ4Lm2igDae4Ewv9q5AQMIMAe9jFQU6hg1YQAa4+/8f/OZbP81xEUQKmAIGkW/F3hKBheU6YwiZMYYkIIO8H10bCLUagBBlMn4we8QA6YERaUAJ7wAxNsw//AAeY0A3B1H9JIwUL0QADkAVmcAUVsAggAA6IQA5CwAg70AtlAC9EoFBRcQogYwY60ARyAAJCYAqoUA7lEAkrAAROcGkM4BAMcFitkCs3sCpAkCenQgQO4AWDoQtK8Aoh4wRkAARTUAEVkCdb4wSdAAsLwTYZkEcyNwDxFDKtYAa3JgMrYIRRYT25kAH8sABnIAo3sAat4AlwCIdmwAMA4AX+EAwLAIAEEQJnGDUDEQEbMAAOMIgrAAx59A9scxOCVgyzEAFoHeAK9sAKIyAjUFgBncAFDwAL9AALriALufAZAxEQADs=
rowguid
83B77413-8C8A-4AF1-93E4-136EDB7FF15F
ModifiedDate
2008-03-11T10:01:36.827
ProductNumber
BK-T79Y-46
Color
Yellow
Size
46
text
Name
Touring-1000 Yellow, 46
ThumbnailPhotoFileName
julianax_r_02_yellow_small.gif
singulars
ProductModelProductModelID
1. PMTouring-1000
ProductCategoryProductCategoryID
1. PCTouring Bikes
  singulars
  ProductCategoryParentProductCategoryID
  PCBikes
plurals
SalesOrderDetailProductID
1. SO
  singulars
  SalesOrderHeaderSalesOrderID
  SASO71782
  ProductProductID
  PRTouring-1000 Yellow, 46
2. SO
  singulars
  SalesOrderHeaderSalesOrderID
  SASO71784
  ProductProductID
  PRTouring-1000 Yellow, 46
3. SO
  singulars
  SalesOrderHeaderSalesOrderID
  SASO71796
  ProductProductID
  PRTouring-1000 Yellow, 46

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.