COUNTRY_EXTERNAL_LINK

91 rows


Description

This is a table for Country External Link. Stores External links relating to more info about each country.

Columns

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

Field Country External Link ID. Stores primary key for this table.

URL VARCHAR2 500 null

Field Url. Stores a url for a external link.

DESCRIPTION VARCHAR2 4000 null

Field Description. Stores the description given to this record.

COUNTRY_ID NUMBER 18 null
COUNTRY.COUNTRY_ID COUNTRY_EXTERNAL_LINK_COU_FK1R

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

NAME VARCHAR2 500 null

Field Name. Stores the name given to this record.

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)
COUNTRY_EXTERNAL_LINK_PK Primary key Asc COUNTRY_EXTERNAL_LINK_ID
CEXTERNAL_COUNTRY_ID_IDX Performance Asc COUNTRY_ID
CEXTERNAL_NAME_IDX Performance Asc NAME

Relationships