HR.LOCATIONS (table)

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