Difference between revisions of "SH.PRODUCTS (table)"
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | SH.PRODUCTS |- |} {| border="1" cellpadding="5" cellspacing="0" style="borde...) |
|||
| Line 20: | Line 20: | ||
|- | |- | ||
| PROD_ID | | PROD_ID | ||
| − | | NUMBER | + | | NUMBER(6, 0) |
| not null | | not null | ||
| | | | ||
| Line 27: | Line 27: | ||
|- | |- | ||
| PROD_NAME | | PROD_NAME | ||
| − | | VARCHAR2 | + | | VARCHAR2(50) |
| not null | | not null | ||
| | | | ||
| Line 34: | Line 34: | ||
|- | |- | ||
| PROD_DESC | | PROD_DESC | ||
| − | | VARCHAR2 | + | | VARCHAR2(4000) |
| not null | | not null | ||
| | | | ||
| Line 41: | Line 41: | ||
|- | |- | ||
| PROD_SUBCATEGORY | | PROD_SUBCATEGORY | ||
| − | | VARCHAR2 | + | | VARCHAR2(50) |
| not null | | not null | ||
| | | | ||
| Line 55: | Line 55: | ||
|- | |- | ||
| PROD_SUBCATEGORY_DESC | | PROD_SUBCATEGORY_DESC | ||
| − | | VARCHAR2 | + | | VARCHAR2(2000) |
| not null | | not null | ||
| | | | ||
| Line 62: | Line 62: | ||
|- | |- | ||
| PROD_CATEGORY | | PROD_CATEGORY | ||
| − | | VARCHAR2 | + | | VARCHAR2(50) |
| not null | | not null | ||
| | | | ||
| Line 76: | Line 76: | ||
|- | |- | ||
| PROD_CATEGORY_DESC | | PROD_CATEGORY_DESC | ||
| − | | VARCHAR2 | + | | VARCHAR2(2000) |
| not null | | not null | ||
| | | | ||
| Line 83: | Line 83: | ||
|- | |- | ||
| PROD_WEIGHT_CLASS | | PROD_WEIGHT_CLASS | ||
| − | | NUMBER | + | | NUMBER(3, 0) |
| not null | | not null | ||
| | | | ||
| Line 90: | Line 90: | ||
|- | |- | ||
| PROD_UNIT_OF_MEASURE | | PROD_UNIT_OF_MEASURE | ||
| − | | VARCHAR2 | + | | VARCHAR2(20) |
| null | | null | ||
| | | | ||
| Line 97: | Line 97: | ||
|- | |- | ||
| PROD_PACK_SIZE | | PROD_PACK_SIZE | ||
| − | | VARCHAR2 | + | | VARCHAR2(30) |
| not null | | not null | ||
| | | | ||
| Line 104: | Line 104: | ||
|- | |- | ||
| SUPPLIER_ID | | SUPPLIER_ID | ||
| − | | NUMBER | + | | NUMBER(6, 0) |
| not null | | not null | ||
| | | | ||
| Line 111: | Line 111: | ||
|- | |- | ||
| PROD_STATUS | | PROD_STATUS | ||
| − | | VARCHAR2 | + | | VARCHAR2(20) |
| not null | | not null | ||
| | | | ||
| Line 118: | Line 118: | ||
|- | |- | ||
| PROD_LIST_PRICE | | PROD_LIST_PRICE | ||
| − | | NUMBER | + | | NUMBER(8, 2) |
| not null | | not null | ||
| | | | ||
| Line 125: | Line 125: | ||
|- | |- | ||
| PROD_MIN_PRICE | | PROD_MIN_PRICE | ||
| − | | NUMBER | + | | NUMBER(8, 2) |
| not null | | not null | ||
| | | | ||
| Line 132: | Line 132: | ||
|- | |- | ||
| PROD_TOTAL | | PROD_TOTAL | ||
| − | | VARCHAR2 | + | | VARCHAR2(13) |
| not null | | not null | ||
| | | | ||
| Line 153: | Line 153: | ||
|- | |- | ||
| PROD_EFF_FROM | | PROD_EFF_FROM | ||
| − | | DATE | + | | DATE(7) |
| null | | null | ||
| | | | ||
| Line 160: | Line 160: | ||
|- | |- | ||
| PROD_EFF_TO | | PROD_EFF_TO | ||
| − | | DATE | + | | DATE(7) |
| null | | null | ||
| | | | ||
| Line 167: | Line 167: | ||
|- | |- | ||
| PROD_VALID | | PROD_VALID | ||
| − | | VARCHAR2 | + | | VARCHAR2(1) |
| null | | null | ||
| | | | ||
Revision as of 21:01, 24 August 2009
wikibot
| Table | SH.PRODUCTS |
| Column | Data Type | Nullable | Default | PK | Index |
| PROD_ID | NUMBER(6, 0) | not null | PRODUCTS_PK | ||
| PROD_NAME | VARCHAR2(50) | not null | |||
| PROD_DESC | VARCHAR2(4000) | not null | |||
| PROD_SUBCATEGORY | VARCHAR2(50) | not null | PRODUCTS_PROD_SUBCAT_IX | ||
| PROD_SUBCATEGORY_ID | NUMBER | not null | |||
| PROD_SUBCATEGORY_DESC | VARCHAR2(2000) | not null | |||
| PROD_CATEGORY | VARCHAR2(50) | not null | PRODUCTS_PROD_CAT_IX | ||
| PROD_CATEGORY_ID | NUMBER | not null | |||
| PROD_CATEGORY_DESC | VARCHAR2(2000) | not null | |||
| PROD_WEIGHT_CLASS | NUMBER(3, 0) | not null | |||
| PROD_UNIT_OF_MEASURE | VARCHAR2(20) | null | |||
| PROD_PACK_SIZE | VARCHAR2(30) | not null | |||
| SUPPLIER_ID | NUMBER(6, 0) | not null | |||
| PROD_STATUS | VARCHAR2(20) | not null | PRODUCTS_PROD_STATUS_BIX | ||
| PROD_LIST_PRICE | NUMBER(8, 2) | not null | |||
| PROD_MIN_PRICE | NUMBER(8, 2) | not null | |||
| 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 |
| Detail Table | Column | Referencing Column |
| SH.COSTS | PROD_ID | PROD_ID |
| SH.SALES | PROD_ID | PROD_ID |
