From dbscript Online Help
wikibot
| Table
|
HR.COUNTRIES
|
| Description
|
country table. Contains 25 rows. References with locations table.
|
Columns
| Column
|
Data Type
|
Nullable
|
Default
|
Description
|
| COUNTRY_ID
|
CHAR(2)
|
not null
|
|
Primary key of countries table.
|
| COUNTRY_NAME
|
VARCHAR2(40)
|
null
|
|
Country name
|
| REGION_ID
|
NUMBER
|
null
|
|
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
|
Expression
|
Description
|
| COUNTRY_ID_NN
|
"COUNTRY_ID" IS NOT NULL
|
|
Foreign Keys
| Relation
|
Column
|
Referenced Column
|
| HR.REGIONS
|
REGION_ID
|
REGION_ID
|
Detail Tables
| Detail Table
|
Column
|
Referencing Column
|
| HR.LOCATIONS
|
COUNTRY_ID
|
COUNTRY_ID
|
