product_attribute_value

-1 rows


Description

Attribute Value

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('product_attribute_value_id_seq'::regclass)
product_attribute_value_product_template_attribute_line_rel.product_attribute_value_id product_attribute_value_product_product_attribute_value_id_fkey C
product_template_attribute_value.product_attribute_value_id product_template_attribute_valu_product_attribute_value_id_fkey C
sequence int4 10 √ null

Sequence
attribute_id int4 10 null
product_attribute.id product_attribute_value_attribute_id_fkey C

Attribute
color int4 10 √ null

Color Index
create_uid int4 10 √ null
res_users.id product_attribute_value_create_uid_fkey N

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

Last Updated by
html_color varchar 2147483647 √ null

Color
name jsonb 2147483647 null

Value
is_custom bool 1 √ null

Is custom value
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
default_extra_price float8 17,17 √ null

Default Extra Price

Indexes

Constraint Name Type Sort Column(s)
product_attribute_value_pkey Primary key Asc id
product_attribute_value__attribute_id_index Performance Asc attribute_id
product_attribute_value__sequence_index Performance Asc sequence
product_attribute_value_value_company_uniq Must be unique Asc/Asc name + attribute_id

Relationships

Close relationships within degrees of separation