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.

CONSTRAINT_NAME	CONSTRAINT_TYPE	SEARCH_CONDITION	R_OWNER	R_TABLE_NAME	R_CONSTRAINT_NAME	DELETE_RULE	STATUS	DEFERRABLE	VALIDATED	GENERATED	BAD	RELY	LAST_CHANGE	INDEX_OWNER	INDEX_NAME	INVALID	VIEW_RELATED
LOC_C_ID_FK	Foreign_Key	null	HR	COUNTRIES	COUNTRY_C_ID_PK	NO ACTION	ENABLED	NOT DEFERRABLE	VALIDATED	USER NAME	null	null	2011/08/28	null	null	null	null
LOC_CITY_NN	Check	"CITY" IS NOT NULL	null	null	null	null	ENABLED	NOT DEFERRABLE	VALIDATED	USER NAME	null	null	2011/08/28	null	null	null	null
LOC_ID_PK	Primary_Key	null	null	null	null	null	ENABLED	NOT DEFERRABLE	VALIDATED	USER NAME	null	null	2011/08/28	null	LOC_ID_PK	null	null

Columns

COLUMN_NAME	COLUMN_POSITION
COUNTRY_ID	1

COLUMN_NAME	COLUMN_POSITION
CITY	null

COLUMN_NAME	COLUMN_POSITION
LOCATION_ID	1

PRIVILEGE	GRANTEE	GRANTABLE	GRANTOR	OBJECT_NAME

Column Statistics

TRIGGER_NAME	TRIGGER_TYPE	TRIGGER_OWNER	TRIGGERING_EVENT	STATUS	TABLE_NAME

OWNER	NAME	TYPE	REFERENCED_OWNER	REFERENCED_NAME	REFERENCED_TYPE
HR	EMP_DETAILS_VIEW	VIEW	HR	LOCATIONS	TABLE

References

OWNER	NAME	TYPE	REFERENCED_OWNER	REFERENCED_NAME	REFERENCED_TYPE

NAME	VALUE
CREATED	2011/08/28
LAST_DDL_TIME	2011/08/28
OWNER	HR
TABLE_NAME	LOCATIONS
TABLESPACE_NAME	USERS
CLUSTER_NAME	null
IOT_NAME	null
STATUS	VALID
PCT_FREE	10
PCT_USED	null
INI_TRANS	1
MAX_TRANS	255
INITIAL_EXTENT	65536
NEXT_EXTENT	1048576
MIN_EXTENTS	1
MAX_EXTENTS	2147483645
PCT_INCREASE	null
FREELISTS	null
FREELIST_GROUPS	null
LOGGING	YES
BACKED_UP	N
NUM_ROWS	23
BLOCKS	5
EMPTY_BLOCKS	0
AVG_SPACE	0
CHAIN_CNT	0
AVG_ROW_LEN	49
AVG_SPACE_FREELIST_BLOCKS	0
NUM_FREELIST_BLOCKS	0
DEGREE	1
INSTANCES	1
CACHE	N
TABLE_LOCK	ENABLED
SAMPLE_SIZE	23
LAST_ANALYZED	2016/09/23
PARTITIONED	NO
IOT_TYPE	null
OBJECT_ID_TYPE	null
TABLE_TYPE_OWNER	null
TABLE_TYPE	null
TEMPORARY	N
SECONDARY	N
NESTED	NO
BUFFER_POOL	DEFAULT
ROW_MOVEMENT	DISABLED
GLOBAL_STATS	YES
USER_STATS	NO
DURATION	null
SKIP_CORRUPT	DISABLED
MONITORING	YES
CLUSTER_OWNER	null
DEPENDENCIES	DISABLED
COMPRESSION	DISABLED
COMPRESS_FOR	null
DROPPED	NO
COMMENTS	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.

PARTITION_NAME	LAST_ANALYZED	NUM_ROWS	BLOCKS	SAMPLE_SIZE	HIGH_VALUE

INDEX_OWNER	INDEX_NAME	UNIQUENESS	STATUS	INDEX_TYPE	TEMPORARY	PARTITIONED	FUNCIDX_STATUS	JOIN_INDEX	COLUMNS	COLUMN_EXPRESSION
HR	LOC_ID_PK	UNIQUE	VALID	NORMAL	N	NO	null	NO	LOCATION_ID	null
HR	LOC_CITY_IX	NONUNIQUE	VALID	NORMAL	N	NO	null	NO	CITY	null
HR	LOC_COUNTRY_IX	NONUNIQUE	VALID	NORMAL	N	NO	null	NO	COUNTRY_ID	null
HR	LOC_STATE_PROVINCE_IX	NONUNIQUE	VALID	NORMAL	N	NO	null	NO	STATE_PROVINCE	null

INDEX_OWNER	INDEX_NAME	TABLE_OWNER	TABLE_NAME	COLUMN_NAME	COLUMN_POSITION	COLUMN_LENGTH	CHAR_LENGTH	DESCEND
HR	LOC_ID_PK	HR	LOCATIONS	LOCATION_ID	1	22	0	ASC

INDEX_OWNER	INDEX_NAME	TABLE_OWNER	TABLE_NAME	COLUMN_NAME	COLUMN_POSITION	COLUMN_LENGTH	CHAR_LENGTH	DESCEND
HR	LOC_CITY_IX	HR	LOCATIONS	CITY	1	30	30	ASC

INDEX_OWNER	INDEX_NAME	TABLE_OWNER	TABLE_NAME	COLUMN_NAME	COLUMN_POSITION	COLUMN_LENGTH	CHAR_LENGTH	DESCEND
HR	LOC_COUNTRY_IX	HR	LOCATIONS	COUNTRY_ID	1	2	2	ASC

INDEX_OWNER	INDEX_NAME	TABLE_OWNER	TABLE_NAME	COLUMN_NAME	COLUMN_POSITION	COLUMN_LENGTH	CHAR_LENGTH	DESCEND
HR	LOC_STATE_PROVINCE_IX	HR	LOCATIONS	STATE_PROVINCE	1	25	25	ASC

LOCATIONS