HR.LOCATIONS (table)

From dbscript Online Help
Revision as of 18:05, 2 May 2009 by Bot (talk | contribs) (New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | HR.LOCATIONS |- |} {| border="1" cellpadding="5" cellspacing="0" style="bord...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

wikibot

Table HR.LOCATIONS


Column Data Type Nullable Default PK Index
LOCATION_ID NUMBER not null LOC_ID_PK
STREET_ADDRESS VARCHAR2 null
POSTAL_CODE VARCHAR2 null
CITY VARCHAR2 not null LOC_CITY_IX
STATE_PROVINCE VARCHAR2 null LOC_STATE_PROVINCE_IX
COUNTRY_ID CHAR(2) null LOC_COUNTRY_IX


Relation Column Referenced Column
HR.COUNTRIES COUNTRY_ID COUNTRY_ID


Detail Table Column Referencing Column
HR.DEPARTMENTS LOCATION_ID LOCATION_ID
OE.WAREHOUSES LOCATION_ID LOCATION_ID