column|product_id|not_nullable|number(6)
column|product_name|nullable|varchar2(50)
column|product_description|nullable|varchar2(2000)
column|category_id|nullable|number(2)
column|weight_class|nullable|number(1)
column|warranty_period|nullable|interval
column|supplier_id|nullable|number(6)
column|product_status|nullable|varchar2(20)
column|list_price|nullable|number(8,2)
column|min_price|nullable|number(8,2)
column|catalog_url|nullable|varchar2(50)
check|(product_status in ('orderable' ,'planned' ,'under development' ,'obsolete') ) 
pkey|product_id