Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

wikibot

TableSH.PRODUCTS
Descriptiondimension table

Columns

ColumnData TypeNullableDefaultDescription
PROD_IDNUMBER(6, 0)not null primary key
PROD_NAMEVARCHAR2(50)not null product name
PROD_DESCVARCHAR2(4000)not null product description
PROD_SUBCATEGORYVARCHAR2(50)not null product subcategory
PROD_SUBCATEGORY_IDNUMBERnot null  
PROD_SUBCATEGORY_DESCVARCHAR2(2000)not null product subcategory description
PROD_CATEGORYVARCHAR2(50)not null product category
PROD_CATEGORY_IDNUMBERnot null  
PROD_CATEGORY_DESCVARCHAR2(2000)not null product category description
PROD_WEIGHT_CLASSNUMBER(3, 0)not null product weight class
PROD_UNIT_OF_MEASUREVARCHAR2(20)null product unit of measure
PROD_PACK_SIZEVARCHAR2(30)not null product package size
SUPPLIER_IDNUMBER(6, 0)not null this column
PROD_STATUSVARCHAR2(20)not null product status
PROD_LIST_PRICENUMBER(8, 2)not null product list price
PROD_MIN_PRICENUMBER(8, 2)not null product minimum price
PROD_TOTALVARCHAR2(13)not null  
PROD_TOTAL_IDNUMBERnot null  
PROD_SRC_IDNUMBERnull  
PROD_EFF_FROMDATE(7)null  
PROD_EFF_TODATE(7)null  
PROD_VALIDVARCHAR2(1)null  

Primary Key

Primary KeyColumns
PRODUCTS_PKPROD_ID

Indexes

IndexTypeColumns
PRODUCTS_PROD_CAT_IX PROD_CATEGORY
PRODUCTS_PROD_STATUS_BIX PROD_STATUS
PRODUCTS_PROD_SUBCAT_IX PROD_SUBCATEGORY

Check Constraints

Check ConstraintExpressionDescription
SYS_C005127"PROD_ID" IS NOT NULL 
SYS_C005128"PROD_NAME" IS NOT NULL 
SYS_C005129"PROD_DESC" IS NOT NULL 
SYS_C005130"PROD_SUBCATEGORY" IS NOT NULL 
SYS_C005131"PROD_SUBCATEGORY_ID" IS NOT NULL 
SYS_C005132"PROD_SUBCATEGORY_DESC" IS NOT NULL 
SYS_C005133"PROD_CATEGORY" IS NOT NULL 
SYS_C005134"PROD_CATEGORY_ID" IS NOT NULL 
SYS_C005135"PROD_CATEGORY_DESC" IS NOT NULL 
SYS_C005136"PROD_WEIGHT_CLASS" IS NOT NULL 
SYS_C005137"PROD_PACK_SIZE" IS NOT NULL 
SYS_C005138"SUPPLIER_ID" IS NOT NULL 
SYS_C005139"PROD_STATUS" IS NOT NULL 
SYS_C005140"PROD_LIST_PRICE" IS NOT NULL 
SYS_C005141"PROD_MIN_PRICE" IS NOT NULL 
SYS_C005142"PROD_TOTAL" IS NOT NULL 
SYS_C005143"PROD_TOTAL_ID" IS NOT NULL 

Detail Tables

Detail TableColumnReferencing Column
SH.COSTSPROD_IDPROD_ID
SH.SALESPROD_IDPROD_ID

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.