Database reference - demo

demo -  tables -  GROUPO.Products

Description

products sold by the sporting goods company 

Table properties

namevalue
nameGROUPO.Products
row count10
Maximum size of a single row92 bytes

Columns

columndatatypelengthdefaultnullsPKFKUQcomment
IDinteger4 no  yes     
Namechar(15)15 no       
Descriptionchar(30)30 no       
Sizechar(18)18 no       
Colorchar(6)6 no       
Quantityinteger4 no       
UnitPricenumeric(15,2)15 no       
Photoimage(n/a) yes       

Indexes

namedescriptioncolumncomment
IX_product_namenon-unique index on Name ascName 
IX_product_descriptionnon-unique index on Description ascDescription 
IX_product_sizenon-unique index on Size ascSize 
IX_product_colornon-unique index on Color ascColor 

Referenced by

name
MarketingInformation
SalesOrderItems

Foreign key graph

ProductsMarketingInformationSalesOrderItems

Dependency graph

imageProductsIX_product_colorIX_product_descriptionIX_product_nameIX_product_sizedebugger_tutorialShowCustomerProductsShowProductInfo

Objects that GROUPO.Products depends on

nameobject typelevel
imagetype1

Objects that depend on GROUPO.Products

nameobject typelevel
debugger_tutorialstored procedure1
ShowCustomerProductsstored procedure1
ShowProductInfostored procedure1

Sample rows

IDNameDescriptionSizeColorQuantityUnitPricePhoto
300  Tee Shirt  Tank Top  Small  White  28  9.00  System.Byte[] 
301  Tee Shirt  V-neck  Medium  Orange  54  14.00  System.Byte[] 
302  Tee Shirt  Crew Neck  One size fits all  Black  75  14.00  System.Byte[] 
400  Baseball Cap  Cotton Cap  One size fits all  Black  112  9.00  System.Byte[] 
401  Baseball Cap  Wool cap  One size fits all  White  12  10.00  System.Byte[] 
500  Visor  Cloth Visor  One size fits all  White  36  7.00  System.Byte[] 
501  Visor  Plastic Visor  One size fits all  Black  28  7.00  System.Byte[] 
600  Sweatshirt  Hooded Sweatshirt  Large  Green  39  24.00  System.Byte[] 
601  Sweatshirt  Zipped Sweatshirt  Large  Blue  32  24.00  System.Byte[] 
700  Shorts  Cotton Shorts  Medium  Black  80  15.00  System.Byte[] 

Code

CREATE TABLE "GROUPO"."Products" (
    "ID"                             integer NOT NULL
   ,"Name"                           char(15) NOT NULL
   ,"Description"                    char(30) NOT NULL
   ,"Size"                           char(18) NOT NULL
   ,"Color"                          char(6) NOT NULL
   ,"Quantity"                       integer NOT NULL
   ,"UnitPrice"                      numeric(15,2) NOT NULL
   ,"Photo"                          "image" NULL
   ,CONSTRAINT "ProductsKey" PRIMARY KEY ("ID") 
)



Documentation generated by SqlSpec