3.1.1.1.15.1 Data Model
RecordId: A primary key. A 64-bit, signed integer that is unique for each entry in the table. The data store assigns a unique value when a new row is inserted into the table. This forms the RecordId for the CustomFieldValue data structure.
CustomFieldRecordId: A foreign key (ADM_CustomFieldsTable, RecordId) on delete cascade. This specifies the custom field to which the specific custom field value belongs to in the possible value set. This forms the ParentCustomFieldRecordId of the CustomFieldValue data structure.
CustomFieldValueDetails: Specifies the set of properties pertaining to the custom field value. This is modeled on the following properties of the CustomFieldValue data structure:
Value
BuiltInCustomFieldValueId
When the IPAM data store is initialized, this table is initialized with the following default values. For convenience, the custom field for which the values are added to the table is represented by its name.
|
Custom Field |
Value |
BuiltInCustomFieldValueId |
|---|---|---|
|
RIR |
AFRINIC |
1 |
|
|
APNIC |
2 |
|
|
ARIN |
3 |
|
|
LACNIC |
4 |
|
|
RIPE |
5 |
|
RegionLegacy |
Asia |
1 |
|
|
Caribbean |
2 |
|
|
Central America |
3 |
|
|
Eastern Europe |
4 |
|
|
European Union |
5 |
|
|
Middle East |
6 |
|
|
North America |
7 |
|
|
Oceania |
8 |
|
|
South America |
9 |
|
Device type |
Firewall |
1 |
|
|
Host |
2 |
|
|
Load balancer |
3 |
|
|
Microsoft Servers |
4 |
|
|
Non-Microsoft servers |
5 |
|
|
Printer |
6 |
|
|
Routers |
7 |
|
|
Switch |
8 |
|
|
Terminal server |
9 |
|
|
VM |
10 |
|
|
VM Manager |
11 |
|
|
VOIP Gateway |
12 |
|
|
WAN optimizer |
13 |
|
|
Wireless AP |
14 |
|
|
Wireless controller |
15 |
|
Managed by |
IPAM |
1 |
|
|
MS DHCP |
2 |
|
|
Non-MS DHCP |
3 |
|
|
VM Manager |
4 |
|
|
Others |
5 |
|
Managed by entity |
Localhost |
1 |
|
IP Address State |
In-Use |
1 |
|
|
Reserved |
2 |
|
|
Inactive |
3 |
|
Isolation Method |
NVGRE |
1 |
|
|
VLAN |
2 |
|
|
VXLAN |
3 |
|
|
IPRewrite |
4 |
Apart from these, the Country/Region custom field is added the list of country names as listed in [ISO-3166].