storefront

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('Insights.storefront_id_seq'::regclass)
address.storefront_id fk_address_storefront_id_storefront_id C
budget.storefront_id fk_budget_storefront_id_storefront_id C
category.storefront_id fk_category_storefront_id_storefront_id C
customer.storefront_id fk_customer_storefront_id_storefront_id C
department.storefront_id fk_department_storefront_id_storefront_id C
mis_plugin.storefront_id fk_mis_plugin_storefront_id_storefront_id C
order.storefront_id fk_order_storefront_id_storefront_id C
order_discount.storefront_id fk_order_discount_storefront_id_storefront_id C
orderline.storefront_id fk_orderline_storefront_id_storefront_id C
product.storefront_id fk_product_storefront_id_storefront_id C
name varchar 100 null
status varchar 100 null
type varchar 100 null
url varchar 500 √ null
source_id int4 10 null
external_ref uuid 2147483647 null
currency_code text 2147483647 √ null
weight_unit text 2147483647 √ null
dimension_unit text 2147483647 √ null
language_culture text 2147483647 √ null
date_format text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_storefront Primary key Asc id

Relationships

Close relationships within degrees of separation