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