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

From dbscript Online Help
Jump to: navigation, search
 
(2 intermediate revisions by the same user not shown)
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
−
|-
+
|- 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 17:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description
−
| '''Index
+
 
−
+
|- valign="top"
−
|-
 
 
| PROD_ID
 
| PROD_ID
 
| NUMBER(6, 0)
 
| NUMBER(6, 0)
 
| not null
 
| not null
 
|  
 
|  
−
| PRODUCTS_PK
+
| primary key
−
|
+
|- valign="top"
−
|-
 
 
| PROD_NAME
 
| PROD_NAME
 
| VARCHAR2(50)
 
| VARCHAR2(50)
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| product name
−
|
+
|- valign="top"
−
|-
 
 
| PROD_DESC
 
| PROD_DESC
 
| VARCHAR2(4000)
 
| VARCHAR2(4000)
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| product description
−
|
+
|- valign="top"
−
|-
 
 
| PROD_SUBCATEGORY
 
| PROD_SUBCATEGORY
 
| VARCHAR2(50)
 
| VARCHAR2(50)
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| product subcategory
−
| PRODUCTS_PROD_SUBCAT_IX
+
|- valign="top"
−
|-
 
 
| PROD_SUBCATEGORY_ID
 
| PROD_SUBCATEGORY_ID
 
| NUMBER
 
| NUMBER
Line 52: Line 49:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| PROD_SUBCATEGORY_DESC
 
| PROD_SUBCATEGORY_DESC
 
| VARCHAR2(2000)
 
| VARCHAR2(2000)
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| product subcategory description
−
|
+
|- valign="top"
−
|-
 
 
| PROD_CATEGORY
 
| PROD_CATEGORY
 
| VARCHAR2(50)
 
| VARCHAR2(50)
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| product category
−
| PRODUCTS_PROD_CAT_IX
+
|- valign="top"
−
|-
 
 
| PROD_CATEGORY_ID
 
| PROD_CATEGORY_ID
 
| NUMBER
 
| NUMBER
Line 73: Line 67:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| PROD_CATEGORY_DESC
 
| PROD_CATEGORY_DESC
 
| VARCHAR2(2000)
 
| VARCHAR2(2000)
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| product category description
−
|
+
|- valign="top"
−
|-
 
 
| PROD_WEIGHT_CLASS
 
| PROD_WEIGHT_CLASS
 
| NUMBER(3, 0)
 
| NUMBER(3, 0)
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| product weight class
−
|
+
|- valign="top"
−
|-
 
 
| PROD_UNIT_OF_MEASURE
 
| PROD_UNIT_OF_MEASURE
 
| VARCHAR2(20)
 
| VARCHAR2(20)
 
| null
 
| null
 
|  
 
|  
−
|  
+
| product unit of measure
−
|
+
|- valign="top"
−
|-
 
 
| PROD_PACK_SIZE
 
| PROD_PACK_SIZE
 
| VARCHAR2(30)
 
| VARCHAR2(30)
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| product package size
−
|
+
|- valign="top"
−
|-
 
 
| SUPPLIER_ID
 
| SUPPLIER_ID
 
| NUMBER(6, 0)
 
| NUMBER(6, 0)
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| this column
−
|
+
|- valign="top"
−
|-
 
 
| PROD_STATUS
 
| PROD_STATUS
 
| VARCHAR2(20)
 
| VARCHAR2(20)
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| product status
−
| PRODUCTS_PROD_STATUS_BIX
+
|- valign="top"
−
|-
 
 
| PROD_LIST_PRICE
 
| PROD_LIST_PRICE
 
| NUMBER(8, 2)
 
| NUMBER(8, 2)
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| product list price
−
|
+
|- valign="top"
−
|-
 
 
| PROD_MIN_PRICE
 
| PROD_MIN_PRICE
 
| NUMBER(8, 2)
 
| NUMBER(8, 2)
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| product minimum price
−
|
+
|- valign="top"
−
|-
 
 
| PROD_TOTAL
 
| PROD_TOTAL
 
| VARCHAR2(13)
 
| VARCHAR2(13)
Line 136: Line 121:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| PROD_TOTAL_ID
 
| PROD_TOTAL_ID
 
| NUMBER
 
| NUMBER
Line 143: Line 127:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| PROD_SRC_ID
 
| PROD_SRC_ID
 
| NUMBER
 
| NUMBER
Line 150: Line 133:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| PROD_EFF_FROM
 
| PROD_EFF_FROM
 
| DATE(7)
 
| DATE(7)
Line 157: Line 139:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| PROD_EFF_TO
 
| PROD_EFF_TO
 
| DATE(7)
 
| DATE(7)
Line 164: Line 145:
 
|  
 
|  
 
|  
 
|  
−
|
+
|- valign="top"
−
|-
 
 
| PROD_VALID
 
| PROD_VALID
 
| VARCHAR2(1)
 
| VARCHAR2(1)
Line 171: Line 151:
 
|  
 
|  
 
|  
 
|  
 +
|}
 +
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| PRODUCTS_PK
 +
| PROD_ID
 +
|}
 +
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
 +
 +
|- valign="top"
 +
| PRODUCTS_PROD_CAT_IX
 +
|
 +
| PROD_CATEGORY
 +
|- valign="top"
 +
| PRODUCTS_PROD_STATUS_BIX
 +
|
 +
| PROD_STATUS
 +
|- valign="top"
 +
| PRODUCTS_PROD_SUBCAT_IX
 
|  
 
|  
 +
| PROD_SUBCATEGORY
 
|}
 
|}
  
 +
=== Check Constraints ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Check Constraint
 +
| '''Expression
 +
| '''Description
  
 +
|- valign="top"
 +
| SYS_C005127
 +
| "PROD_ID" IS NOT NULL
 +
|
 +
|- valign="top"
 +
| SYS_C005128
 +
| "PROD_NAME" IS NOT NULL
 +
|
 +
|- valign="top"
 +
| SYS_C005129
 +
| "PROD_DESC" IS NOT NULL
 +
|
 +
|- valign="top"
 +
| SYS_C005130
 +
| "PROD_SUBCATEGORY" IS NOT NULL
 +
|
 +
|- valign="top"
 +
| SYS_C005131
 +
| "PROD_SUBCATEGORY_ID" IS NOT NULL
 +
|
 +
|- valign="top"
 +
| SYS_C005132
 +
| "PROD_SUBCATEGORY_DESC" IS NOT NULL
 +
|
 +
|- valign="top"
 +
| SYS_C005133
 +
| "PROD_CATEGORY" IS NOT NULL
 +
|
 +
|- valign="top"
 +
| SYS_C005134
 +
| "PROD_CATEGORY_ID" IS NOT NULL
 +
|
 +
|- valign="top"
 +
| SYS_C005135
 +
| "PROD_CATEGORY_DESC" IS NOT NULL
 +
|
 +
|- valign="top"
 +
| SYS_C005136
 +
| "PROD_WEIGHT_CLASS" IS NOT NULL
 +
|
 +
|- valign="top"
 +
| SYS_C005137
 +
| "PROD_PACK_SIZE" IS NOT NULL
 +
|
 +
|- valign="top"
 +
| SYS_C005138
 +
| "SUPPLIER_ID" IS NOT NULL
 +
|
 +
|- valign="top"
 +
| SYS_C005139
 +
| "PROD_STATUS" IS NOT NULL
 +
|
 +
|- valign="top"
 +
| SYS_C005140
 +
| "PROD_LIST_PRICE" IS NOT NULL
 +
|
 +
|- valign="top"
 +
| SYS_C005141
 +
| "PROD_MIN_PRICE" IS NOT NULL
 +
|
 +
|- valign="top"
 +
| SYS_C005142
 +
| "PROD_TOTAL" IS NOT NULL
 +
|
 +
|- valign="top"
 +
| 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"
Line 181: 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
 
|}
 
|}

Latest revision as of 10:36, 27 August 2011

wikibot[edit]

Table SH.PRODUCTS
Description dimension table

Columns[edit]

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[edit]

Primary Key Columns
PRODUCTS_PK PROD_ID

Indexes[edit]

Index Type Columns
PRODUCTS_PROD_CAT_IX PROD_CATEGORY
PRODUCTS_PROD_STATUS_BIX PROD_STATUS
PRODUCTS_PROD_SUBCAT_IX PROD_SUBCATEGORY

Check Constraints[edit]

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[edit]

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=3093"