Welcome Guest, you are in: <root> • Login

Page History: OE WAREHOUSES (table)

Compare Page Revisions

1 0 Current 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: 2010/02/11 09:19

wikibot ¶

Table	OE.WAREHOUSES
Description	Warehouse data unspecific to any industry.

Columns ¶

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 ¶

Primary Key	Columns
WAREHOUSES_PK	WAREHOUSE_ID

Indexes ¶

Index	Type	Columns
WHS_LOCATION_IX		LOCATION_ID

Foreign Keys ¶

Relation	Column	Referenced Column
HR.LOCATIONS	LOCATION_ID	LOCATION_ID

Detail Tables ¶

Detail Table	Column	Referencing Column
OE.INVENTORIES	WAREHOUSE_ID	WAREHOUSE_ID