| 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. |