HR

Basic Index   Expanded Index

Table Name: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.
Primary Keys:LOCATION_ID
FieldTypeDefaultsNulls?Comments
LOCATION_IDNUMBER (4)NoneNoPrimary key of locations table
STREET_ADDRESSVARCHAR2 (40)NoneYesStreet address of an office, warehouse, or production site of a company.
Contains building number and street name
POSTAL_CODEVARCHAR2 (12)NoneYesPostal code of the location of an office, warehouse, or production site
of a company.
CITYVARCHAR2 (30)NoneNoA not null column that shows city where an office, warehouse, or
production site of a company is located.
STATE_PROVINCEVARCHAR2 (25)NoneYesState or Province where an office, warehouse, or production site of a
company is located.
COUNTRY_IDCHAR (2)NoneYesCountry where an office, warehouse, or production site of a company is
located. Foreign key to country_id column of the countries table.

IndexTypeUnique?Fields
LOC_CITY_IXNORMALYesCITY
LOC_COUNTRY_IXNORMALNoCOUNTRY_ID
LOC_ID_PKNORMALNoLOCATION_ID
LOC_STATE_PROVINCE_IXNORMALNoSTATE_PROVINCE

No check constraints
Internal Foreign Key ConstraintAffected FieldSource TableSource Schema
LOC_C_ID_FKCOUNTRY_IDCOUNTRIESHR

Primary Key as Foreign Key ConstraintAffected SchemaAffected TableAffected Field
DEPT_LOC_FKHRDEPARTMENTSLOCATION_ID
WAREHOUSES_LOCATION_FKOEWAREHOUSESLOCATION_ID

No triggers