device_profiledata


Columns

Column Type Size Nulls Auto Default Children Parents Comments
zone_id int4 10 null
device_id int4 10 null
device.id fk_dev_pd_dev C
profiledata_id int4 10 null
profiledata.id fk_dev_pd_data C
type_id int4 10 null
profiledatatype.id fk_dev_pd_datat C
port int4 10 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_dev_pd Primary key Asc/Asc/Asc/Asc device_id + profiledata_id + type_id + port
idx_device_profiledata_devicea_id Performance Asc device_id
idx_device_profiledata_profiledata_id Performance Asc profiledata_id
idx_device_profiledata_profiledatatype_id Performance Asc type_id

Relationships

Close relationships within degrees of separation