category

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('Insights.category_id_seq'::regclass)
category.parent_category_id fk_category_parent_category_id_category_id R
product_category_mapping.category_id fk_product_category_mapping_category_id_category_id C
name text 2147483647 √ null
short_description text 2147483647 √ null
parent_category_id int4 10 √ null
category.id fk_category_parent_category_id_category_id R
storefront_id int4 10 null
storefront.id fk_category_storefront_id_storefront_id C
status text 2147483647 √ null
external_ref uuid 2147483647 null
source_id int4 10 null
uid varchar 200 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_category Primary key Asc id
ixcategory_parent_category_id Performance Asc parent_category_id
ixcategory_storefront_id Performance Asc storefront_id

Relationships

Close relationships within degrees of separation