RECOGNISED_COUNTRY

524 rows


Description

This is a table for Recognised Countries. Stores Countries that recognize other countries.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
RECOGNISED_COUNTRY_ID NUMBER 18 null

Field Recognised Country ID. Stores primary key for this table.

COUNTRY_ID NUMBER 18 null
COUNTRY.COUNTRY_ID RECOGNISED_COUNTRY_COUNTR_FK1R

Field Country ID. Stores foreign key to table country in this record.

COUNTRY_REF_ID NUMBER 18 null
COUNTRY.COUNTRY_ID RECOGNISED_COUNTRY_COUNTR_FK2R

Field Country Reference ID. Stores wich country this country recognised, foreign key to table country.

OBSERVATIONS VARCHAR2 4000 null

Field Observations. Stores observation of this recognision.

ENUM_STATUS_ID NUMBER 18 null
ENUM_STATUS.ENUM_STATUS_ID Implied ConstraintR

Field Status. Stores the status of the record, foreign key to table enum_status.

VERSION_ID NUMBER 18 0

Field Version. Stores the version of the record.

CUSER VARCHAR2 75 null

Field Create User. Stores who create the record.

CDATE TIMESTAMP(6) 11,6 SYSTIMESTAMP

Field Create Date. Stores when the record was created.

MUSER VARCHAR2 75 null

Field Modified User. Stores who modified the record.

MDATE TIMESTAMP(6) 11,6 SYSTIMESTAMP

Field Modified Date. Stores when the record was modified.

Indexes

Constraint Name Type Sort Column(s)
RECOGNISED_COUNTRY_PK Primary key Asc RECOGNISED_COUNTRY_ID
RECOGNISED_COUNTRY_UK1 Must be unique Asc/Asc COUNTRY_ID + COUNTRY_REF_ID

Relationships