Prior Table Table COUNTRIES Next Table

Comment for Table COUNTRIES
Comment
country table. Contains 25 rows. References with locations table.

Columns of Table COUNTRIES
Column ID Column Name Datatype Not Null Data Default Comments
1 COUNTRY_ID CHAR(2 BYTE) Y   Primary key of countries table.
2 COUNTRY_NAME VARCHAR2(40 BYTE)     Country name
3 REGION_ID NUMBER     Region ID for the country. Foreign key to region_id column in the departments table.

Indexes on Table COUNTRIES
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
UNIQUE COUNTRY_C_ID_PK IOT - TOP COUNTRY_ID <none>        

Foreign Key Constraints on Table COUNTRIES
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
COUNTR_REG_FK REGION_ID HR REGIONS REGION_ID NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table COUNTRIES
Constraint Name Type Condition Status Columns
COUNTRY_ID_NN Check "COUNTRY_ID" IS NOT NULL ENABLED COUNTRY_ID
COUNTRY_C_ID_PK Primary Key   ENABLED COUNTRY_ID

Table COUNTRIES does not have...
Partitions
Redaction Policies