Overview Tables Views Indexes Constraints Triggers Procedures Functions Packages Sequences Index

HR
Description  Columns  Primary key  Check constraints  Foreign keys  Unique keys  Indexes  Options  Referenced by  Triggers  

COUNTRIES

Description

country table. Contains 25 rows. References with locations table.

Columns

Column Datatype Nullable Default value Comment
COUNTRY_ID CHAR(2) N   Primary key of countries table.
COUNTRY_NAME VARCHAR2(40) Y   Country name
REGION_ID NUMBER(,) Y   Region ID for the country. Foreign key to region_id column in the departments table.

Primary key

Primary key Columns
COUNTRY_C_ID_PK COUNTRY_ID

Check constraints

Check constraint Check condition
COUNTRY_ID_NN "COUNTRY_ID" IS NOT NULL

Foreign keys

Foreign key Referenced table Referenced constraint Delete rule Columns
COUNTR_REG_FK REGIONS REG_ID_PK NO ACTION REGION_ID

Indexes

Index Type Uniqueness Columns
COUNTRY_C_ID_PK IOT - TOP UNIQUE COUNTRY_ID

Options

Option Setting
Clustered N
Generated by Oracle N
Index Organized Y
Logging Y
Partitioned N
Temporary N
Nested N

Referenced by

Referenced by Constraint
LOCATIONS LOC_C_ID_FK

Generated by OraDoclet, Copyright © Oracle Corporation 2005      Last updated: 01.01.2005