HR.LOCATIONS (table)

From dbscript Online Help
Revision as of 08:26, 11 February 2010 by Bot (talk | contribs)
Jump to: navigation, search

wikibot

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

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

Primary Key Columns
LOC_ID_PK LOCATION_ID

Indexes

Index Type Columns
LOC_STATE_PROVINCE_IX STATE_PROVINCE
LOC_COUNTRY_IX COUNTRY_ID
LOC_CITY_IX CITY

Check Constraints

Check Constraint Expression Description
LOC_CITY_NN "CITY" IS NOT NULL

Foreign Keys

Relation Column Referenced Column
HR.COUNTRIES COUNTRY_ID COUNTRY_ID

Detail Tables

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