product_template_attribute_value

-1 rows


Description

Product Template Attribute Value

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('product_template_attribute_value_id_seq'::regclass)
mrp_bom_byproduct_product_template_attribute_value_rel.product_template_attribute_value_id mrp_bom_byproduct_product_tem_product_template_attribute_v_fkey R
mrp_bom_line_product_template_attribute_value_rel.product_template_attribute_value_id mrp_bom_line_product_template_product_template_attribute_v_fkey R
mrp_routing_workcenter_product_template_attribute_value_rel.product_template_attribute_value_id mrp_routing_workcenter_produc_product_template_attribute_v_fkey R
product_attr_exclusion_value_ids_rel.product_template_attribute_value_id product_attr_exclusion_value__product_template_attribute_v_fkey C
product_attribute_custom_value.custom_product_template_attribute_value_id product_attribute_custom_valu_custom_product_template_attr_fkey R
product_template_attribute_exclusion.product_template_attribute_value_id product_template_attribute_ex_product_template_attribute_v_fkey C
product_template_attribute_value_sale_order_line_rel.product_template_attribute_value_id product_template_attribute_va_product_template_attribute_v_fkey R
product_variant_combination.product_template_attribute_value_id product_variant_combination_product_template_attribute_val_fkey R
product_attribute_value_id int4 10 null
product_attribute_value.id product_template_attribute_valu_product_attribute_value_id_fkey C

Attribute Value
attribute_line_id int4 10 null
product_template_attribute_line.id product_template_attribute_value_attribute_line_id_fkey C

Attribute Line
product_tmpl_id int4 10 √ null
product_template.id product_template_attribute_value_product_tmpl_id_fkey N

Product Template
attribute_id int4 10 √ null
product_attribute.id product_template_attribute_value_attribute_id_fkey N

Attribute
color int4 10 √ null

Color
create_uid int4 10 √ null
res_users.id product_template_attribute_value_create_uid_fkey N

Created by
write_uid int4 10 √ null
res_users.id product_template_attribute_value_write_uid_fkey N

Last Updated by
price_extra numeric 0 √ null

Value Price Extra
ptav_active bool 1 √ null

Active
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on

Indexes

Constraint Name Type Sort Column(s)
product_template_attribute_value_pkey Primary key Asc id
product_template_attribute_value__attribute_id_index Performance Asc attribute_id
product_template_attribute_value__attribute_line_id_index Performance Asc attribute_line_id
product_template_attribute_value__product_attribute_va_63041d9e Performance Asc product_attribute_value_id
product_template_attribute_value__product_tmpl_id_index Performance Asc product_tmpl_id
product_template_attribute_value_attribute_value_unique Must be unique Asc/Asc attribute_line_id + product_attribute_value_id

Relationships

Close relationships within degrees of separation