| 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. |
| POSTAL_CODE | VARCHAR2(12) | null | | Postal code of the location of an office, warehouse, or production site |
| CITY | VARCHAR2(30) | not null | | A not null column that shows city where an office, warehouse, or |
| STATE_PROVINCE | VARCHAR2(25) | null | | State or Province where an office, warehouse, or production site of a |
| COUNTRY_ID | CHAR(2) | null | | Country where an office, warehouse, or production site of a company is |