product_attribute

-1 rows


Description

Product Attribute

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('product_attribute_id_seq'::regclass)
product_attribute_product_template_rel.product_attribute_id product_attribute_product_template_re_product_attribute_id_fkey C
product_attribute_value.attribute_id product_attribute_value_attribute_id_fkey C
product_template_attribute_line.attribute_id product_template_attribute_line_attribute_id_fkey R
product_template_attribute_value.attribute_id product_template_attribute_value_attribute_id_fkey N
sequence int4 10 √ null

Sequence
create_uid int4 10 √ null
res_users.id product_attribute_create_uid_fkey N

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

Last Updated by
create_variant varchar 2147483647 null

Variants Creation Mode
display_type varchar 2147483647 null

Display Type
name jsonb 2147483647 null

Attribute
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_attribute_pkey Primary key Asc id
product_attribute__sequence_index Performance Asc sequence

Check Constraints

Constraint Name Constraint
product_attribute_check_multi_checkbox_no_variant ((((display_type)::text <> 'multi'::text) OR ((create_variant)::text = 'no_variant'::text)))

Relationships

Close relationships within degrees of separation