Difference between revisions of "SH.PRODUCTS (table)"

From dbscript Online Help
Jump to: navigation, search
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| SH.PRODUCTS
 
| SH.PRODUCTS
Line 8: Line 8:
 
| '''Description
 
| '''Description
 
| dimension table
 
| dimension table
−
|-
 
 
|}
 
|}
−
 
  
 
=== Columns ===
 
=== Columns ===
Line 20: Line 18:
 
| '''Default
 
| '''Default
 
| '''Description
 
| '''Description
−
+
 
−
|-
+
|- valign="top"
 
| PROD_ID
 
| PROD_ID
 
| NUMBER(6, 0)
 
| NUMBER(6, 0)
Line 27: Line 25:
 
|  
 
|  
 
| primary key
 
| primary key
−
|-
+
|- valign="top"
 
| PROD_NAME
 
| PROD_NAME
 
| VARCHAR2(50)
 
| VARCHAR2(50)
Line 33: Line 31:
 
|  
 
|  
 
| product name
 
| product name
−
|-
+
|- valign="top"
 
| PROD_DESC
 
| PROD_DESC
 
| VARCHAR2(4000)
 
| VARCHAR2(4000)
Line 39: Line 37:
 
|  
 
|  
 
| product description
 
| product description
−
|-
+
|- valign="top"
 
| PROD_SUBCATEGORY
 
| PROD_SUBCATEGORY
 
| VARCHAR2(50)
 
| VARCHAR2(50)
Line 45: Line 43:
 
|  
 
|  
 
| product subcategory
 
| product subcategory
−
|-
+
|- valign="top"
 
| PROD_SUBCATEGORY_ID
 
| PROD_SUBCATEGORY_ID
 
| NUMBER
 
| NUMBER
Line 51: Line 49:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| PROD_SUBCATEGORY_DESC
 
| PROD_SUBCATEGORY_DESC
 
| VARCHAR2(2000)
 
| VARCHAR2(2000)
Line 57: Line 55:
 
|  
 
|  
 
| product subcategory description
 
| product subcategory description
−
|-
+
|- valign="top"
 
| PROD_CATEGORY
 
| PROD_CATEGORY
 
| VARCHAR2(50)
 
| VARCHAR2(50)
Line 63: Line 61:
 
|  
 
|  
 
| product category
 
| product category
−
|-
+
|- valign="top"
 
| PROD_CATEGORY_ID
 
| PROD_CATEGORY_ID
 
| NUMBER
 
| NUMBER
Line 69: Line 67:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| PROD_CATEGORY_DESC
 
| PROD_CATEGORY_DESC
 
| VARCHAR2(2000)
 
| VARCHAR2(2000)
Line 75: Line 73:
 
|  
 
|  
 
| product category description
 
| product category description
−
|-
+
|- valign="top"
 
| PROD_WEIGHT_CLASS
 
| PROD_WEIGHT_CLASS
 
| NUMBER(3, 0)
 
| NUMBER(3, 0)
Line 81: Line 79:
 
|  
 
|  
 
| product weight class
 
| product weight class
−
|-
+
|- valign="top"
 
| PROD_UNIT_OF_MEASURE
 
| PROD_UNIT_OF_MEASURE
 
| VARCHAR2(20)
 
| VARCHAR2(20)
Line 87: Line 85:
 
|  
 
|  
 
| product unit of measure
 
| product unit of measure
−
|-
+
|- valign="top"
 
| PROD_PACK_SIZE
 
| PROD_PACK_SIZE
 
| VARCHAR2(30)
 
| VARCHAR2(30)
Line 93: Line 91:
 
|  
 
|  
 
| product package size
 
| product package size
−
|-
+
|- valign="top"
 
| SUPPLIER_ID
 
| SUPPLIER_ID
 
| NUMBER(6, 0)
 
| NUMBER(6, 0)
Line 99: Line 97:
 
|  
 
|  
 
| this column
 
| this column
−
|-
+
|- valign="top"
 
| PROD_STATUS
 
| PROD_STATUS
 
| VARCHAR2(20)
 
| VARCHAR2(20)
Line 105: Line 103:
 
|  
 
|  
 
| product status
 
| product status
−
|-
+
|- valign="top"
 
| PROD_LIST_PRICE
 
| PROD_LIST_PRICE
 
| NUMBER(8, 2)
 
| NUMBER(8, 2)
Line 111: Line 109:
 
|  
 
|  
 
| product list price
 
| product list price
−
|-
+
|- valign="top"
 
| PROD_MIN_PRICE
 
| PROD_MIN_PRICE
 
| NUMBER(8, 2)
 
| NUMBER(8, 2)
Line 117: Line 115:
 
|  
 
|  
 
| product minimum price
 
| product minimum price
−
|-
+
|- valign="top"
 
| PROD_TOTAL
 
| PROD_TOTAL
 
| VARCHAR2(13)
 
| VARCHAR2(13)
Line 123: Line 121:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| PROD_TOTAL_ID
 
| PROD_TOTAL_ID
 
| NUMBER
 
| NUMBER
Line 129: Line 127:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| PROD_SRC_ID
 
| PROD_SRC_ID
 
| NUMBER
 
| NUMBER
Line 135: Line 133:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| PROD_EFF_FROM
 
| PROD_EFF_FROM
 
| DATE(7)
 
| DATE(7)
Line 141: Line 139:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| PROD_EFF_TO
 
| PROD_EFF_TO
 
| DATE(7)
 
| DATE(7)
Line 147: Line 145:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| PROD_VALID
 
| PROD_VALID
 
| VARCHAR2(1)
 
| VARCHAR2(1)
Line 160: Line 158:
 
| '''Primary Key
 
| '''Primary Key
 
| '''Columns
 
| '''Columns
−
|-
+
|- valign="top"
 
| PRODUCTS_PK
 
| PRODUCTS_PK
 
| PROD_ID
 
| PROD_ID
Line 171: Line 169:
 
| '''Type
 
| '''Type
 
| '''Columns
 
| '''Columns
−
+
 
−
|-
+
|- valign="top"
 
| PRODUCTS_PROD_CAT_IX
 
| PRODUCTS_PROD_CAT_IX
 
|  
 
|  
 
| PROD_CATEGORY
 
| PROD_CATEGORY
−
|-
+
|- valign="top"
 
| PRODUCTS_PROD_SUBCAT_IX
 
| PRODUCTS_PROD_SUBCAT_IX
 
|  
 
|  
 
| PROD_SUBCATEGORY
 
| PROD_SUBCATEGORY
−
|-
+
|- valign="top"
 
| PRODUCTS_PROD_STATUS_BIX
 
| PRODUCTS_PROD_STATUS_BIX
 
|  
 
|  
Line 192: Line 190:
 
| '''Expression
 
| '''Expression
 
| '''Description
 
| '''Description
−
+
 
−
|-
+
|- valign="top"
 
| SYS_C005127
 
| SYS_C005127
 
| "PROD_ID" IS NOT NULL
 
| "PROD_ID" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005128
 
| SYS_C005128
 
| "PROD_NAME" IS NOT NULL
 
| "PROD_NAME" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005129
 
| SYS_C005129
 
| "PROD_DESC" IS NOT NULL
 
| "PROD_DESC" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005130
 
| SYS_C005130
 
| "PROD_SUBCATEGORY" IS NOT NULL
 
| "PROD_SUBCATEGORY" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005131
 
| SYS_C005131
 
| "PROD_SUBCATEGORY_ID" IS NOT NULL
 
| "PROD_SUBCATEGORY_ID" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005132
 
| SYS_C005132
 
| "PROD_SUBCATEGORY_DESC" IS NOT NULL
 
| "PROD_SUBCATEGORY_DESC" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005133
 
| SYS_C005133
 
| "PROD_CATEGORY" IS NOT NULL
 
| "PROD_CATEGORY" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005134
 
| SYS_C005134
 
| "PROD_CATEGORY_ID" IS NOT NULL
 
| "PROD_CATEGORY_ID" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005135
 
| SYS_C005135
 
| "PROD_CATEGORY_DESC" IS NOT NULL
 
| "PROD_CATEGORY_DESC" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005136
 
| SYS_C005136
 
| "PROD_WEIGHT_CLASS" IS NOT NULL
 
| "PROD_WEIGHT_CLASS" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005137
 
| SYS_C005137
 
| "PROD_PACK_SIZE" IS NOT NULL
 
| "PROD_PACK_SIZE" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005138
 
| SYS_C005138
 
| "SUPPLIER_ID" IS NOT NULL
 
| "SUPPLIER_ID" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005139
 
| SYS_C005139
 
| "PROD_STATUS" IS NOT NULL
 
| "PROD_STATUS" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005140
 
| SYS_C005140
 
| "PROD_LIST_PRICE" IS NOT NULL
 
| "PROD_LIST_PRICE" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005141
 
| SYS_C005141
 
| "PROD_MIN_PRICE" IS NOT NULL
 
| "PROD_MIN_PRICE" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005142
 
| SYS_C005142
 
| "PROD_TOTAL" IS NOT NULL
 
| "PROD_TOTAL" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| SYS_C005143
 
| SYS_C005143
 
| "PROD_TOTAL_ID" IS NOT NULL
 
| "PROD_TOTAL_ID" IS NOT NULL
Line 269: Line 267:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
−
+
 
−
|-
+
|- valign="top"
 
| [[SH.COSTS_(table)|SH.COSTS]]
 
| [[SH.COSTS_(table)|SH.COSTS]]
 
| PROD_ID
 
| PROD_ID
 
| PROD_ID
 
| PROD_ID
−
|-
+
|- valign="top"
 
| [[SH.SALES_(table)|SH.SALES]]
 
| [[SH.SALES_(table)|SH.SALES]]
 
| PROD_ID
 
| PROD_ID
 
| PROD_ID
 
| PROD_ID
 
|}
 
|}

Revision as of 07:16, 24 June 2010

wikibot

Table SH.PRODUCTS
Description dimension table

Columns

Column Data Type Nullable Default Description
PROD_ID NUMBER(6, 0) not null primary key
PROD_NAME VARCHAR2(50) not null product name
PROD_DESC VARCHAR2(4000) not null product description
PROD_SUBCATEGORY VARCHAR2(50) not null product subcategory
PROD_SUBCATEGORY_ID NUMBER not null
PROD_SUBCATEGORY_DESC VARCHAR2(2000) not null product subcategory description
PROD_CATEGORY VARCHAR2(50) not null product category
PROD_CATEGORY_ID NUMBER not null
PROD_CATEGORY_DESC VARCHAR2(2000) not null product category description
PROD_WEIGHT_CLASS NUMBER(3, 0) not null product weight class
PROD_UNIT_OF_MEASURE VARCHAR2(20) null product unit of measure
PROD_PACK_SIZE VARCHAR2(30) not null product package size
SUPPLIER_ID NUMBER(6, 0) not null this column
PROD_STATUS VARCHAR2(20) not null product status
PROD_LIST_PRICE NUMBER(8, 2) not null product list price
PROD_MIN_PRICE NUMBER(8, 2) not null product minimum price
PROD_TOTAL VARCHAR2(13) not null
PROD_TOTAL_ID NUMBER not null
PROD_SRC_ID NUMBER null
PROD_EFF_FROM DATE(7) null
PROD_EFF_TO DATE(7) null
PROD_VALID VARCHAR2(1) null

Primary Key

Primary Key Columns
PRODUCTS_PK PROD_ID

Indexes

Index Type Columns
PRODUCTS_PROD_CAT_IX PROD_CATEGORY
PRODUCTS_PROD_SUBCAT_IX PROD_SUBCATEGORY
PRODUCTS_PROD_STATUS_BIX PROD_STATUS

Check Constraints

Check Constraint Expression Description
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 Table Column Referencing Column
SH.COSTS PROD_ID PROD_ID
SH.SALES PROD_ID PROD_ID
Retrieved from "http://dbshelp.devio.at/index.php?title=SH.PRODUCTS_(table)&oldid=2819"