COUNTRY |
Default Table Name | COUNTRY |
Definition |
COUNTRY Columns |
ColumnName | Domain | Datatype | NULL | Definition |
COUNTRY_CD![]() |
VARCHAR2(8) | NO | ||
COUNTRY_NAME | VARCHAR2(25) | NO | ||
PRINT_FL | VARCHAR2(1) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
MAG_MEDIA_CD | VARCHAR2(2) | YES | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
LOCALE_ID | VARCHAR2(6) | YES | ||
ISO2_CD | VARCHAR2(2) | YES | ||
ISO3_CD | VARCHAR2(3) | YES | ||
NATO_FL | VARCHAR2(1) | YES |
COUNTRY Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0035 | PrimaryKey | COUNTRY_CD |
COUNTRY Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
EC_COUNTRY | Non-Identifying | One To Zero or More | F00001 | NO | NO | NO | |||
MAIL_STATE | Identifying | One To Zero or More | F02370 | NO | NO | NO | |||
TVL_PER_DIEM | Non-Identifying | One To Zero or More | F20558 | NO | NO | NO | |||
CITIZEN_STATUS | Non-Identifying | One To Zero or More | FK_CITIZEN_STATUS_CO_IDX | NO | NO | NO | |||
EMPL | Non-Identifying | One To Zero or More | FK_EMPL_BI_IDX | NO | NO | NO | |||
EMPL | Non-Identifying | One To Zero or More | FK_EMPL_CC_IDX | NO | NO | NO | |||
LAB_LOCATION | Non-Identifying | One To Zero or More | FK_LAB_LOCATION_CO_IDX | NO | NO | NO | |||
LICAGR_COUNTRY | Identifying | One To Zero or More | FK_LICAGR_COUNTRY_CO_IDX | NO | NO | NO | |||
PO_LN_RESOURCE | Non-Identifying | One To Zero or More | FK_PO_LN_RESOURCE_C_IDX | NO | NO | NO | |||
PO_LN_RESOURCE_HS | Non-Identifying | One To Zero or More | FK_PO_LN_RESOURCE_HS_CO_IDX | NO | NO | NO | |||
QT_LN_RESOURCE | Non-Identifying | One To Zero or More | FK_QT_LN_RESOURCE_CO_IDX | NO | NO | NO | |||
RFQ_LN_RESOURCE | Non-Identifying | One To Zero or More | FK_RFQ_LN_RESOURCE_CO_IDX | NO | NO | NO | |||
RQ_HDR_PO_RSRCE | Non-Identifying | One To Zero or More | FK_RQ_HDR_PO_RSRCE_CO_IDX | NO | NO | NO | |||
RQ_LN_PO_RSRCE | Non-Identifying | One To Zero or More | FK_RQ_LN_PO_RSRCE_CO_IDX | NO | NO | NO | |||
RQ_LN_RESOURCE | Non-Identifying | One To Zero or More | FK_RQ_LN_RESOURCE_CO_IDX | NO | NO | NO | |||
RQ_PO_RSRCE | Non-Identifying | One To Zero or More | FK_RQ_PO_RSRCE_CO_IDX | NO | NO | NO |