From dbscript Online Help
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_CITY_IX
|
|
CITY
|
| LOC_COUNTRY_IX
|
|
COUNTRY_ID
|
| LOC_STATE_PROVINCE_IX
|
|
STATE_PROVINCE
|
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
