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

From dbscript Online Help
Jump to: navigation, search
Line 5: Line 5:
 
| '''Table
 
| '''Table
 
| SH.PRODUCTS
 
| SH.PRODUCTS
 +
|- valign="top"
 +
| '''Description
 +
| dimension table
 
|-
 
|-
 
|}
 
|}
  
  
 +
=== Columns ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 15: Line 19:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description
−
| '''Index
 
 
 
 
|-
 
|-
Line 23: Line 26:
 
| not null
 
| not null
 
|  
 
|  
−
| PRODUCTS_PK
+
| primary key
−
|
 
 
|-
 
|-
 
| PROD_NAME
 
| PROD_NAME
Line 30: Line 32:
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| product name
−
|
 
 
|-
 
|-
 
| PROD_DESC
 
| PROD_DESC
Line 37: Line 38:
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| product description
−
|
 
 
|-
 
|-
 
| PROD_SUBCATEGORY
 
| PROD_SUBCATEGORY
Line 44: Line 44:
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| product subcategory
−
| PRODUCTS_PROD_SUBCAT_IX
 
 
|-
 
|-
 
| PROD_SUBCATEGORY_ID
 
| PROD_SUBCATEGORY_ID
 
| NUMBER
 
| NUMBER
 
| not null
 
| not null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 58: Line 56:
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| product subcategory description
−
|
 
 
|-
 
|-
 
| PROD_CATEGORY
 
| PROD_CATEGORY
Line 65: Line 62:
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| product category
−
| PRODUCTS_PROD_CAT_IX
 
 
|-
 
|-
 
| PROD_CATEGORY_ID
 
| PROD_CATEGORY_ID
 
| NUMBER
 
| NUMBER
 
| not null
 
| not null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 79: Line 74:
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| product category description
−
|
 
 
|-
 
|-
 
| PROD_WEIGHT_CLASS
 
| PROD_WEIGHT_CLASS
Line 86: Line 80:
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| product weight class
−
|
 
 
|-
 
|-
 
| PROD_UNIT_OF_MEASURE
 
| PROD_UNIT_OF_MEASURE
Line 93: Line 86:
 
| null
 
| null
 
|  
 
|  
−
|  
+
| product unit of measure
−
|
 
 
|-
 
|-
 
| PROD_PACK_SIZE
 
| PROD_PACK_SIZE
Line 100: Line 92:
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| product package size
−
|
 
 
|-
 
|-
 
| SUPPLIER_ID
 
| SUPPLIER_ID
Line 107: Line 98:
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| this column
−
|
 
 
|-
 
|-
 
| PROD_STATUS
 
| PROD_STATUS
Line 114: Line 104:
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| product status
−
| PRODUCTS_PROD_STATUS_BIX
 
 
|-
 
|-
 
| PROD_LIST_PRICE
 
| PROD_LIST_PRICE
Line 121: Line 110:
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| product list price
−
|
 
 
|-
 
|-
 
| PROD_MIN_PRICE
 
| PROD_MIN_PRICE
Line 128: Line 116:
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| product minimum price
−
|
 
 
|-
 
|-
 
| PROD_TOTAL
 
| PROD_TOTAL
 
| VARCHAR2(13)
 
| VARCHAR2(13)
 
| not null
 
| not null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 141: Line 127:
 
| NUMBER
 
| NUMBER
 
| not null
 
| not null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 148: Line 133:
 
| NUMBER
 
| NUMBER
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 155: Line 139:
 
| DATE(7)
 
| DATE(7)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 162: Line 145:
 
| DATE(7)
 
| DATE(7)
 
| null
 
| null
−
|
 
 
|  
 
|  
 
|  
 
|  
Line 171: Line 153:
 
|  
 
|  
 
|  
 
|  
 +
|}
 +
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|-
 +
| PRODUCTS_PK
 +
| PROD_ID
 +
|}
 +
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
 +
 +
|-
 +
| PRODUCTS_PROD_CAT_IX
 
|  
 
|  
 +
| PROD_CATEGORY
 +
|-
 +
| PRODUCTS_PROD_SUBCAT_IX
 +
|
 +
| PROD_SUBCATEGORY
 +
|-
 +
| PRODUCTS_PROD_STATUS_BIX
 +
|
 +
| PROD_STATUS
 
|}
 
|}
  
 +
=== Check Constraints ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''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 ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"

Revision as of 08:29, 11 February 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=2326"