product


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idproduct int4 10 null
client.idproduct fk_client_idproduct R
client_pos_status_conf.idproduct fk_client_pos_status_conf_idproduct R
device.idproduct fk_device_idproduct R
product_feature.idproduct fk_product_feature_idproduct R
technicalaccount.idproduct fk_technicalaccount_idproduct R
tmp_device.idproduct Implied Constraint R
vw_active_no_report.idproduct Implied Constraint R
vw_units.idproduct Implied Constraint R
alias varchar 50 √ null
enabled bool 1 √ null
description varchar 2147483647 √ null
erpname varchar 2147483647 √ null
ignition_on_delay_thr int4 10 √ null
ignition_off_delay_thr int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
product_pkey Primary key Asc idproduct

Relationships

Close relationships within degrees of separation