3.1.1.1.3.1 Data Model

RecordId: A 64-bit unsigned integer which is unique for each row in the table. The data store assigns a unique value when a new row is inserted into the table. This forms the RecordId of IpamIPAddress.

RangeRecordId: A foreign key (ADM_DHCPScopesTable, RecordId); on delete cascade. If the IP address is associated with an address range, this specifies the RecordId in the ADM_IPRangeTable for the range corresponding to this IP address. This forms the ParentIPRangeRecordId of the IpamIPAddress.

AddressSpaceRecordId: A foreign key (ADM_AddressSpaceTable, RecordId) on update no action, on delete no action. Specifies the AddressSpace to which this IPAddress maps.

AddressDetails: This forms the common set of properties associated with the address:

  • AddressAssignment

  • AddressCategory

  • AssignedDate

  • ChangedDate

  • ExpiryDate

  • ExpiryAlertStatus

  • AssetTag

  • IpAddress

  • IsDuplicate

  • MacAddress

  • Notes

  • OSName

  • OSVersion

  • Owner

  • SerialNumber

  • DeviceName

  • VirtualizationType

  • IsCreatedFromDNS

ManagedByValue: This is a computed value for each row of this table. This is computed by looking up the ADM_CustomFieldValuesAssociationTable for the row with the following:

  • UsedById is the RecordId value of the address.

  • ObjectType is EnumerationObjectType.IPAddress.

  • Af is InterNetwork for an IPv4Address.

  • InterNetworkV6 for an IPv6Address, and the CustomFieldId is of value ADM_ManagedByCustomFieldId.

ManagedByEntityValue: This is a computed value for each row of this table. This is computed by looking up the ADM_CustomFieldValuesAssociationTable for the row with the following:

  • UsedById is the RecordId value of the address.

  • ObjectType is EnumerationObjectType.IPAddress.

  • Af is InterNetwork for an IPv4Address.

  • InterNetworkV6 for an IPv6Address.

  • CustomFieldId to be of value ADM_ManagedByEntityCustomFieldId.

For the IPv4-specific table, the following additional property of IpamIPv4Address is associated with the address:

  • ReservationType

For the IPv6-specific table, the following additional properties of IpamIPv6Address are associated with the address:

  • Duid

  • Iaid