From dbscript Online Help
|
|
| Line 114: |
Line 114: |
| | | PRODUCT_ID | | | PRODUCT_ID |
| | | PRODUCT_ID | | | PRODUCT_ID |
| − | |}
| |
| − |
| |
| − | === Dependencies ===
| |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |- style="background:silver"
| |
| − | | '''Reference Type
| |
| − | | '''Object Type
| |
| − | | '''Referencing Object
| |
| − |
| |
| − | |- valign="top"
| |
| − | | Select
| |
| − | | View
| |
| − | | [[OE.OC_CORPORATE_CUSTOMERS_(view)|OE.OC_CORPORATE_CUSTOMERS]]
| |
| − |
| |
| − | |- valign="top"
| |
| − | | Select
| |
| − | | View
| |
| − | | [[OE.OC_CUSTOMERS_(view)|OE.OC_CUSTOMERS]]
| |
| − |
| |
| − | |- valign="top"
| |
| − | | Select
| |
| − | | View
| |
| − | | [[OE.OC_ORDERS_(view)|OE.OC_ORDERS]]
| |
| − |
| |
| − | |- valign="top"
| |
| − | | Select
| |
| − | | Trigger
| |
| − | | [[OE.INSERT_ORD_LINE_()|OE.INSERT_ORD_LINE]]
| |
| − |
| |
| | |} | | |} |
Latest revision as of 10:35, 27 August 2011
wikibot[edit]
| Table
|
OE.ORDER_ITEMS
|
| Description
|
Example of many-to-many resolution.
|
Columns[edit]
| Column
|
Data Type
|
Nullable
|
Default
|
Description
|
| ORDER_ID
|
NUMBER(12, 0)
|
not null
|
|
Part of concatenated primary key, references orders.order_id.
|
| LINE_ITEM_ID
|
NUMBER(3, 0)
|
not null
|
|
Part of concatenated primary key.
|
| PRODUCT_ID
|
NUMBER(6, 0)
|
not null
|
|
References product_information.product_id.
|
| UNIT_PRICE
|
NUMBER(8, 2)
|
null
|
|
|
| QUANTITY
|
NUMBER(8, 0)
|
null
|
|
|
Primary Key[edit]
| Primary Key
|
Columns
|
| ORDER_ITEMS_PK
|
ORDER_ID, LINE_ITEM_ID
|
Indexes[edit]
| Index
|
Type
|
Columns
|
| ITEM_ORDER_IX
|
|
ORDER_ID
|
| ITEM_PRODUCT_IX
|
|
PRODUCT_ID
|
| ORDER_ITEMS_UK
|
|
ORDER_ID, PRODUCT_ID
|
Check Constraints[edit]
| Check Constraint
|
Expression
|
Description
|
| SYS_C005039
|
"LINE_ITEM_ID" IS NOT NULL
|
|
| SYS_C005040
|
"PRODUCT_ID" IS NOT NULL
|
|
Foreign Keys[edit]
