The IP Mapping Reason codes relate to the different reasons that an IP address is may be displayed on map. For example an IP address may be displayed as it is the address of a visitor to the site and we desire to map visitors locations. Alternatively we may desire to map the locations of IP addresses from where we have detected attempts to introduce ‘SPAM’ into the various articles etc. present upon the site.
Table 8.2. Reason Table description
Column Name |
Type |
Size |
Not Null? |
Constraints |
Description |
|---|---|---|---|---|---|
id |
Number |
n/a |
Yes |
primary key |
A unique numeric ID that identifies an IP Mapping reason. Populated by an auto sequence. |
reason_name |
Varchar |
60 |
Yes |
None |
The name used to display on the screens. |
description |
Varchar |
1024 |
No |
None |
A brief description of the reason. |
state |
Number |
4 |
No |
None |
Indicates record is visible in front end. |
ordering |
Number |
11 |
No |
None |
Specifies ordering of reasons. |
checked_out |
Number |
11 |
Yes |
None |
Joomla field record locking |
checked_out_time |
Date |
n/a |
Yes |
None |
Joomla field record locking |
created_on |
Date |
n/a |
Yes |
None |
Date the record was created. |
created_by |
Varchar |
255 |
Yes |
None |
The user who created the record. |
modified_on |
Date |
n/a |
Yes |
None |
The date the record was last modified. |
modified_by |
Varchar |
255 |
Yes |
None |
The user who last modified the record. |