COUNTRY

249 rows


Description

This is a table for Country. Stores countries and their information.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
COUNTRY_ID NUMBER 18 null
COUNTRY_EXTERNAL_LINK.COUNTRY_ID COUNTRY_EXTERNAL_LINK_COU_FK1R
DISPENSATION.COUNTRY_ID DISPENSATION_COUNTRY_FK1R
FINDINGS_BASE_VIEW.COUNTRY_ID Implied ConstraintR
FINDINGS_CORRELATED_VIEW.COUNTRY_ID Implied ConstraintR
FINDINGS_DIRECT_VIEW.COUNTRY_ID Implied ConstraintR
FINDINGS_TOTAL_CORRELATED_VIEW.COUNTRY_ID Implied ConstraintR
FINDINGS_TOTAL_DIRECT_VIEW.COUNTRY_ID Implied ConstraintR
FRAUDULENT_CERTIFICATE.COUNTRY_ID FRAUDULENT_CERTIFICATE_CO_FK1R
LEGAL_ENTITY.COUNTRY_ID LEGAL_ENTITY_COUNTRY_FK1R
LEGISLATION.COUNTRY_ID LEGISLATION_COUNTRY_FK1R
METC_SYSTEM.COUNTRY_ID METC_SYSTEM_COUNTRY_FK1R
NEW_STAT_COUNT_BASE.COUNTRY_ID Implied ConstraintR
NEW_STAT_COUNT_BASE_1.COUNTRY_ID Implied ConstraintR
NEW_STAT_COUNT_BASE_2.COUNTRY_ID Implied ConstraintR
NEW_STAT_COUNT_BASE_3.COUNTRY_ID Implied ConstraintR
NEW_STAT_COUNT_BASE_4.COUNTRY_ID Implied ConstraintR
NEW_STAT_COUNT_BASE_5.COUNTRY_ID Implied ConstraintR
NEW_STAT_COUNT_BASE_6.COUNTRY_ID Implied ConstraintR
RECOGNISED_COUNTRY.COUNTRY_ID RECOGNISED_COUNTRY_COUNTR_FK1R
RECOGNISED_COUNTRY.COUNTRY_REF_ID RECOGNISED_COUNTRY_COUNTR_FK2R
VIEW_ADMIN_CERTIFICATES.COUNTRY_ID Implied ConstraintR
VIEW_ADMIN_QUALITY_SYSTEMS.COUNTRY_ID Implied ConstraintR
VIEW_ADMIN_STRUCTURE.COUNTRY_ID Implied ConstraintR
VIEW_CERTIFICATE_MATRIX.COUNTRY_ID Implied ConstraintR
VIEW_CERTIFICATE_MATRIX_INT.COUNTRY_ID Implied ConstraintR
VIEW_COUNT_MET_PROGRAMANS.COUNTRY_ID Implied ConstraintR
VIEW_DISPENSATIONS.COUNTRY_ID Implied ConstraintR
VIEW_FINAL_STAT_COUNT_LR.COUNTRY_ID Implied ConstraintR
VIEW_FINAL_STAT_COUNT_LR_NEW.COUNTRY_ID Implied ConstraintR
VIEW_FINAL_STAT_COUNT_P.COUNTRY_ID Implied ConstraintR
VIEW_FINDING_AUX.COUNTRY_ID Implied ConstraintR
VIEW_FRAUDULENT_CERTIFICATES.COUNTRY_ID Implied ConstraintR
VIEW_INSPECTION_FINDING.COUNTRY_ID Implied ConstraintR
VIEW_INSPECTIONS.COUNTRY_ID Implied ConstraintR
VIEW_INSPECTIONS_ENTITY.COUNTRY_ID Implied ConstraintR
VIEW_LEGISLATION.COUNTRY_ID Implied ConstraintR
VIEW_MET_PROGRAMANS.COUNTRY_ID Implied ConstraintR
VIEW_MET_QUALITY_SYSTEMS.COUNTRY_ID Implied ConstraintR
VIEW_MET_STUDENTS.COUNTRY_ID Implied ConstraintR
VIEW_RECOGNISED_COUNTRY.COUNTRY_ID Implied ConstraintR
VIEW_STAT_COUNT_DIRECT.COUNTRY_ID Implied ConstraintR
VIEW_STAT_COUNT_LR.COUNTRY_ID Implied ConstraintR
VIEW_STATISTICS_ALL_FINDING_LR.COUNTRY_ID Implied ConstraintR
VIEW_STATISTICS_ALL_FINDING_P.COUNTRY_ID Implied ConstraintR
VIEW_STATISTICS_ALL_P.COUNTRY_ID Implied ConstraintR
VIEW_STATISTICS_COUNT_FIND_LR.COUNTRY_ID Implied ConstraintR
VIEW_STATISTICS_FINDING_AUX.COUNTRY_ID Implied ConstraintR
VIEW_STATISTICS_MET_PROGRAMANS.COUNTRY_ID Implied ConstraintR

Field Country ID. Stores primary key for this table.

ENUM_COUNTRY_GROUP_ID NUMBER 18 null
ENUM_COUNTRY_GROUP.ENUM_COUNTRY_GROUP_ID COUNTRY_COUNTRY_FK1R

Field Enumeration Country Group ID. Stores group that this country belong, foreign key to table enum_country_group.

OFFICIAL_NAME VARCHAR2 250 null

Field Official Name. Stores the official name given to the country of the record.

CAPITAL VARCHAR2 250 null

Field Capital. Stores the capital of this country.

ENUM_CURRENCY_ID NUMBER 18 null
ENUM_CURRENCY.ENUM_CURRENCY_ID COUNTRY_ENUM_CURRENCY_FK1R

Field Enumeration Currency ID. Stores the currency of this country, foreign key to table enum_currency.

ENUM_TIMEZONE_ID NUMBER 18 null
ENUM_TIMEZONE.ENUM_TIMEZONE_ID COUNTRY_ENUM_TIMEZONE_FK1R

Field Enumeration Timezone ID. Stores timezone of this country, foreign key to table enum_timezone.

INSPECTED NUMBER 1 null

Field Inspected. Stores if the country was already inspected or not.

DESCRIPTION VARCHAR2 4000 null

Field Description. Stores the description given to this record.

LANGUAGE VARCHAR2 250 null

Field Language. Stores the principal language used in this country.

SOURCE VARCHAR2 250 null

Field Source. Stores a link that give the information about this country.

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.

DOCUMENT_ID NUMBER 18 null
DOCUMENT.DOCUMENT_ID COUNTRY_DOCUMENT_FK1R

Field Document ID. Stores foreign key to table documents of this record.

COUNTRY_REF VARCHAR2 200 null

Field Country Ref. Stores the alias to the folders created in sftp server.

Indexes

Constraint Name Type Sort Column(s)
COUNTRY_PK Primary key Asc COUNTRY_ID
COUNTRY_COUNTRY_GROUP_ID_IDX Performance Asc ENUM_COUNTRY_GROUP_ID
COUNTRY_CURRENCY_ID_IDX Performance Asc ENUM_CURRENCY_ID
COUNTRY_DOCUMENT_ID_IDX Performance Asc DOCUMENT_ID
COUNTRY_TIMEZONE_ID_IDX Performance Asc ENUM_TIMEZONE_ID
COUNTRY_UK1 Must be unique Asc OFFICIAL_NAME

Relationships