The IP Mapping Countries table contains the list of the countries of the world and their country codes.
In this initial release this table is used to provide the drop down list for the filters used in the IP Mapping. Their usage is expected to be expanded with later releases.
Table 8.3. Countries Table description
Column Name |
Type |
Size |
Not Null? |
Constraints |
Description |
|---|---|---|---|---|---|
id |
Number |
n/a |
Yes |
primary key |
A unique numeric ID that identifies a country. Populated by an auto sequence. |
country_name |
Varchar |
80 |
Yes |
None |
The name of the country. |
country_code |
Varchar |
3 |
No |
None |
The short two letter code for the country. |
state |
Number |
4 |
No |
None |
Indicates country is selectable. |
ordering |
Number |
11 |
No |
None |
Specifies ordering of countries. |
checked_out |
Number |
11 |
Yes |
None |
Joomla field record locking |
checked_out_time |
Date |
n/a |
Yes |
None |
Joomla field record locking |