systemnetinterface


Description

The list of network interfaces installed on a system

Columns

Column Type Size Nulls Auto Default Children Parents Comments
mgm_id numeric 0 null
systemnetaddressv4.mgm_id systemnetaddressv4_interface_fkeyR
systemnetaddressv6.mgm_id systemnetaddressv6_interface_fkeyR
system.mgm_id systemnetinterface_system_fkeyR

The id of the SUSE Manager instance that contains this data
system_id numeric 0 null
systemnetaddressv4.system_id systemnetaddressv4_interface_fkeyR
systemnetaddressv6.system_id systemnetaddressv6_interface_fkeyR
system.system_id systemnetinterface_system_fkeyR

The id of the system
interface_id numeric 0 null
systemnetaddressv4.interface_id systemnetaddressv4_interface_fkeyR
systemnetaddressv6.interface_id systemnetaddressv6_interface_fkeyR

The id of the network interface
name varchar 32 √ null

The unique name of the interface
hardware_address varchar 96 √ null

the MAC address of this network interface
module varchar 128 √ null

The module of this network interface
primary_interface bool 1 false

True if the interface is marked as primary for this system
synced_date timestamptz 35,6 √ CURRENT_TIMESTAMP

The timestamp of when this data was last refreshed.

Indexes

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

Check Constraints

Constraint Name Constraint
vn_systemnetinterface_hardware_address (((hardware_address)::text <> ''::text))
vn_systemnetinterface_name (((name)::text <> ''::text))
vn_systemnetinterface_module (((module)::text <> ''::text))

Relationships

Close relationships within degrees of separation