| Column
|
Datatype
|
Nullable
|
Default value
|
Comment
|
| LOCATION_ID
|
NUMBER(4,0)
|
N
|
|
Primary key of locations table
|
| STREET_ADDRESS
|
VARCHAR2(40)
|
Y
|
|
Street address of an office, warehouse, or production site of a company.
Contains building number and street name
|
| POSTAL_CODE
|
VARCHAR2(12)
|
Y
|
|
Postal code of the location of an office, warehouse, or production site
of a company.
|
| CITY
|
VARCHAR2(30)
|
N
|
|
A not null column that shows city where an office, warehouse, or
production site of a company is located.
|
| STATE_PROVINCE
|
VARCHAR2(25)
|
Y
|
|
State or Province where an office, warehouse, or production site of a
company is located.
|
| COUNTRY_ID
|
CHAR(2)
|
Y
|
|
Country where an office, warehouse, or production site of a company is
located. Foreign key to country_id column of the countries table.
|