3.1.1.1.14.1 Data Model

RecordId : primary key: A 64-bit, unique signed integer that is unique for each entry in the table. The store assigns a unique value when a new row is inserted into the table. This forms the RecordId for the CustomFieldValue data structure.

CustomFieldRecordId: 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: This 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

Region

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

Apart from these, the Country/Region custom field is added the list of country names as listed in [ISO-3166].