From dbscript Online Help
wikibot[edit]
| Table
|
OE.WAREHOUSES
|
| Description
|
Warehouse data unspecific to any industry.
|
Columns[edit]
| Column
|
Data Type
|
Nullable
|
Default
|
Description
|
| WAREHOUSE_ID
|
NUMBER(3, 0)
|
not null
|
|
Primary key column.
|
| WAREHOUSE_SPEC
|
SYS.XMLTYPE
|
null
|
|
|
| WAREHOUSE_NAME
|
VARCHAR2(35)
|
null
|
|
|
| LOCATION_ID
|
NUMBER(4, 0)
|
null
|
|
|
| WH_GEO_LOCATION
|
MDSYS.SDO_GEOMETRY
|
null
|
|
Primary key column, references hr.locations.location_id.
|
Primary Key[edit]
| Primary Key
|
Columns
|
| WAREHOUSES_PK
|
WAREHOUSE_ID
|
Indexes[edit]
| Index
|
Type
|
Columns
|
| WHS_LOCATION_IX
|
|
LOCATION_ID
|
Foreign Keys[edit]
| Relation
|
Column
|
Referenced Column
|
| HR.LOCATIONS
|
LOCATION_ID
|
LOCATION_ID
|
Detail Tables[edit]
| Detail Table
|
Column
|
Referencing Column
|
| OE.INVENTORIES
|
WAREHOUSE_ID
|
WAREHOUSE_ID
|
