Prior Table Table LOCATIONS Next Table

Comment for Table LOCATIONS
Comment 
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 of Table LOCATIONS
Column ID Column Name Datatype Not Null Data Default Comments
1 LOCATION_ID NUMBER(4) Y   Primary key of locations table
2 STREET_ADDRESS VARCHAR2(40 BYTE)     Street address of an office, warehouse, or production site of a company. Contains building number and street name
3 POSTAL_CODE VARCHAR2(12 BYTE)     Postal code of the location of an office, warehouse, or production site of a company.
4 CITY VARCHAR2(30 BYTE) Y   A not null column that shows city where an office, warehouse, or production site of a company is located.
5 STATE_PROVINCE VARCHAR2(25 BYTE)     State or Province where an office, warehouse, or production site of a company is located.
6 COUNTRY_ID CHAR(2 BYTE)     Country where an office, warehouse, or production site of a company is located. Foreign key to country_id column of the countries table.

Indexes on Table LOCATIONS
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE LOC_CITY_IX NORMAL CITY <none>        
NON-UNIQUE LOC_COUNTRY_IX NORMAL COUNTRY_ID <none>        
UNIQUE LOC_ID_PK NORMAL LOCATION_ID <none>        
NON-UNIQUE LOC_STATE_PROVINCE_IX NORMAL STATE_PROVINCE <none>        

Foreign Key Constraints on Table LOCATIONS
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
LOC_C_ID_FK COUNTRY_ID HR COUNTRIES COUNTRY_ID NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table LOCATIONS
Constraint Name Type Condition Status Columns
LOC_CITY_NN Check "CITY" IS NOT NULL ENABLED CITY
LOC_ID_PK Primary Key   ENABLED LOCATION_ID

Table LOCATIONS does not have...
Partitions
Redaction Policies