COLUMN_NAME |
DATA_TYPE |
NULLABLE |
DATA_DEFAULT |
COLUMN_ID |
COMMENTS |
LOCATION_ID |
NUMBER(4,0) |
No |
null |
1 |
Primary key of locations table |
STREET_ADDRESS |
VARCHAR2(40 BYTE) |
Yes |
null |
2 |
Street address of an office, warehouse, or production site of a company.
Contains building number and street name |
POSTAL_CODE |
VARCHAR2(12 BYTE) |
Yes |
null |
3 |
Postal code of the location of an office, warehouse, or production site
of a company. |
CITY |
VARCHAR2(30 BYTE) |
No |
null |
4 |
A not null column that shows city where an office, warehouse, or
production site of a company is located. |
STATE_PROVINCE |
VARCHAR2(25 BYTE) |
Yes |
null |
5 |
State or Province where an office, warehouse, or production site of a
company is located. |
COUNTRY_ID |
CHAR(2 BYTE) |
Yes |
null |
6 |
Country where an office, warehouse, or production site of a company is
located. Foreign key to country_id column of the countries table. |