core_country
The table below describes the core_country table.
This table contains the following foldable columns:
- sys_id_value
- active_display_value
- active_value
- iana_display_value
- iana_value
- iso3166_2_display_value
- iso3166_2_value
- iso3166_3_display_value
- iso3166_3_value
- name_display_value
- name_value
- order_display_value
- order_value
- population_display_value
- population_value
- sys_created_by_display_value
- sys_created_by_value
- sys_created_on_display_value
- sys_created_on_value
- sys_id_display_value
- sys_mod_count_display_value
- sys_mod_count_value
- sys_tags_display_value
- sys_tags_value
- sys_updated_by_display_value
- sys_updated_by_value
- sys_updated_on_display_value
- sys_updated_on_value
- un_numeric_display_value
- un_numeric_value
The primary key columns in this table are returnable.
| Column Name | SQL Type | Updatable | Nullable |
|---|---|---|---|
|
sys_id_value Primary Key |
SQL_VARCHAR(64) | False | False |
|
active_display_value |
SQL_VARCHAR(500) | True | True |
|
active_value |
SQL_BIT | True | True |
|
iana_display_value |
SQL_VARCHAR(500) | True | True |
|
iana_value |
SQL_VARCHAR(6) | True | True |
|
iso3166_2_display_value |
SQL_VARCHAR(500) | True | True |
|
iso3166_2_value |
SQL_VARCHAR(4) | True | True |
|
iso3166_3_display_value |
SQL_VARCHAR(500) | True | True |
|
iso3166_3_value |
SQL_VARCHAR(6) | True | True |
|
name_display_value |
SQL_VARCHAR(500) | True | True |
|
name_value |
SQL_VARCHAR(160) | True | True |
|
order_display_value |
SQL_VARCHAR(500) | True | True |
|
order_value |
SQL_INTEGER(signed) | True | True |
|
population_display_value |
SQL_VARCHAR(500) | True | True |
|
population_value |
SQL_INTEGER(signed) | True | True |
|
sys_created_by_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_created_by_value |
SQL_VARCHAR(80) | False | True |
|
sys_created_on_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_created_on_value |
SQL_TIMESTAMP | False | True |
|
sys_id_display_value |
SQL_VARCHAR(500) | False | False |
|
sys_mod_count_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_mod_count_value |
SQL_INTEGER(signed) | False | True |
|
sys_tags_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_tags_value |
SQL_VARCHAR(256) | False | True |
|
sys_updated_by_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_updated_by_value |
SQL_VARCHAR(80) | False | True |
|
sys_updated_on_display_value |
SQL_VARCHAR(500) | False | True |
|
sys_updated_on_value |
SQL_TIMESTAMP | False | True |
|
un_numeric_display_value |
SQL_VARCHAR(500) | True | True |
|
un_numeric_value |
SQL_INTEGER(signed) | True | True |