systemnetaddressv4


Description

The list of IPv4 address associated to a system

Columns

Column Type Size Nulls Auto Default Children Parents Comments
mgm_id numeric 131089 null
systemnetinterface.mgm_id systemnetaddressv4_interface_fkeyR

The id of the SUSE Manager instance that contains this data

system_id numeric 131089 null
systemnetinterface.system_id systemnetaddressv4_interface_fkeyR

The id of the system

interface_id numeric 131089 null
systemnetinterface.interface_id systemnetaddressv4_interface_fkeyR

The id of the network interface

address varchar 64 null

The IPv4 address of the system

netmask varchar 64 null

The netmask associated to this address

broadcast varchar 64 null

The broadcast address associated to the network of this IPv4 host address

synced_date timestamptz 35,6 CURRENT_TIMESTAMP

The timestamp of when this data was last refreshed.

Indexes

Constraint Name Type Sort Column(s)
systemnetaddressv4_pk Primary key Asc/Asc/Asc/Asc mgm_id + system_id + interface_id + address

Check Constraints

Constraint Name Constraint
vn_systemnetaddressv4_broadcast (((broadcast)::text <> ''::text))
vn_systemnetaddressv4_netmask (((netmask)::text <> ''::text))
vn_systemnetaddressv4_address (((address)::text <> ''::text))

Relationships