public vlan (table)

wikibot

Tablepublic.vlan

Columns

ColumnData TypeNullableDefaultDescription
nodeidintegernot null  
vlanidintegernot null  
vlannamevarchar(64)not null  
vlantypeintegernull  
vlanstatusintegernull  
statuschar(1)not null  
lastpolltimetimestamp without time zonenot null  

Primary Key

Primary KeyColumns
pk_vlannodeid, vlanid

Indexes

IndexTypeColumns
vlan_vlanname_idx vlanname

Foreign Keys

RelationColumnReferenced Column
public.nodenodeidnodeid