macvendor_pattern


Description

This table contains mapping of a macvendor id to existing pattern id. This table gets populated as part of macvendor pattern upload.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
macvendor_id int4 10 null
macvendor.id fk_macvendor_pattern_macvendor C

MacVendor id for macvendor_pattern record. It maps to system.macvendor.id

pattern_id int4 10 null
pattern.id fk_macvendor_pattern_pattern C

Pattern Id for macvendor_pattern record. It maps to profile.pattern.id

Table contained 3194 rows

Indexes

Constraint Name Type Sort Column(s)
pk_macvendor_pattern Primary key Asc/Asc macvendor_id + pattern_id

Relationships