HR.LOCATIONS (table)

From dbscript Online Help
Jump to: navigation, search

wikibot[edit]

Table HR.LOCATIONS
Description Locations table that contains specific address of a specific office,

warehouse, and/or production site of a company. Does not store addresses / locations of customers. Contains 23 rows; references with the departments and countries tables.

Columns[edit]

Column Data Type Nullable Default Description
LOCATION_ID NUMBER(4, 0) not null Primary key of locations table
STREET_ADDRESS VARCHAR2(40) null Street address of an office, warehouse, or production site of a company.

Contains building number and street name

POSTAL_CODE VARCHAR2(12) null Postal code of the location of an office, warehouse, or production site

of a company.

CITY VARCHAR2(30) not null A not null column that shows city where an office, warehouse, or

production site of a company is located.

STATE_PROVINCE VARCHAR2(25) null State or Province where an office, warehouse, or production site of a

company is located.

COUNTRY_ID CHAR(2) null Country where an office, warehouse, or production site of a company is

located. Foreign key to country_id column of the countries table.

Primary Key[edit]

Primary Key Columns
LOC_ID_PK LOCATION_ID

Indexes[edit]

Index Type Columns
LOC_CITY_IX CITY
LOC_COUNTRY_IX COUNTRY_ID
LOC_STATE_PROVINCE_IX STATE_PROVINCE

Check Constraints[edit]

Check Constraint Expression Description
LOC_CITY_NN "CITY" IS NOT NULL

Foreign Keys[edit]

Relation Column Referenced Column
HR.COUNTRIES COUNTRY_ID COUNTRY_ID

Detail Tables[edit]

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