CREATE TABLE blc_advanced_tag (id VARCHAR(36) NOT NULL, active_end_date TIMESTAMP WITHOUT TIME ZONE, active_start_date TIMESTAMP WITHOUT TIME ZONE, badge_asset VARCHAR(10485760), badge_message VARCHAR(10485760), context_id VARCHAR(36), name VARCHAR(255), position VARCHAR(255), priority BIGINT, searchable_by_name CHAR(1) DEFAULT 'N' NOT NULL, trk_application_context_id VARCHAR(36), trk_application_default_locale VARCHAR(255), trk_application_name VARCHAR(255), trk_archived CHAR(1) DEFAULT 'N' NOT NULL, audit_creation_time TIMESTAMP WITHOUT TIME ZONE, audit_creator VARCHAR(60), audit_update_time TIMESTAMP WITHOUT TIME ZONE, audit_updater VARCHAR(60), trk_change_details VARCHAR(10485760), trk_creating_application_id VARCHAR(36), trk_current_message VARCHAR(255), trk_level INTEGER, trk_max_field_versions VARCHAR(10485760), trk_sandbox_archived CHAR(1) DEFAULT 'N' NOT NULL, trk_sub_container_catalog VARCHAR(36), trk_change_container_id VARCHAR(36), trk_change_container_name VARCHAR(255), trk_change_container_route_key VARCHAR(60), trk_sub_container_name VARCHAR(255), trk_sandbox_change_type VARCHAR(60), trk_sandbox_context_id VARCHAR(36), trk_sandbox_name VARCHAR(255), trk_sandbox_owner VARCHAR(60), trk_sandbox_stage VARCHAR(60), trk_tenant_id VARCHAR(36), type VARCHAR(255), CONSTRAINT blc_advanced_tag_pkey PRIMARY KEY (id));
CREATE TABLE blc_application (id VARCHAR(36) NOT NULL, allowed_currencies VARCHAR(10485760), allowed_locales VARCHAR(10485760), deactivated CHAR(1) DEFAULT 'N' NOT NULL, default_currency VARCHAR(255), default_locale VARCHAR(255), identifier_type VARCHAR(60), identifier_value VARCHAR(255), is_marketplace CHAR(1) DEFAULT 'N' NOT NULL, name VARCHAR(255), updated_timestamp TIMESTAMP WITHOUT TIME ZONE, trk_archived CHAR(1) DEFAULT 'N' NOT NULL, audit_creation_time TIMESTAMP WITHOUT TIME ZONE, audit_creator VARCHAR(60), audit_update_time TIMESTAMP WITHOUT TIME ZONE, audit_updater VARCHAR(60), trk_change_details VARCHAR(10485760), trk_tenant_id VARCHAR(36), CONSTRAINT blc_application_pkey PRIMARY KEY (id));
CREATE TABLE blc_application_catalog (application_id VARCHAR(36) NOT NULL, catalog_status VARCHAR(60), context_id VARCHAR(36), exclude_from_add CHAR(1) DEFAULT 'N' NOT NULL, implicit VARCHAR(36), mutability_type VARCHAR(60), visible_as_assigned CHAR(1) DEFAULT 'Y' NOT NULL, isolated_catalogs_order INTEGER NOT NULL, CONSTRAINT blc_application_catalog_pkey PRIMARY KEY (application_id, isolated_catalogs_order));
CREATE TABLE blc_bulk_update (id VARCHAR(36) NOT NULL, errors VARCHAR(10485760), application_id VARCHAR(36), author VARCHAR(255), created TIMESTAMP WITHOUT TIME ZONE, exclusions VARCHAR(10485760), filter_string VARCHAR(65535), inclusions VARCHAR(10485760), last_updated TIMESTAMP WITHOUT TIME ZONE, name VARCHAR(255), number_of_records_processed BIGINT, production_bulk_update CHAR(1) DEFAULT 'N' NOT NULL, serialized_payload VARCHAR(10485760), status VARCHAR(60), target VARCHAR(60), tenant_id VARCHAR(36), total_records_to_process BIGINT, type VARCHAR(60), updating_application_id VARCHAR(36), updating_catalog_id VARCHAR(36), updating_customer_context_id VARCHAR(36), updating_sandbox_id VARCHAR(36), updating_sandbox_name VARCHAR(255), CONSTRAINT blc_bulk_update_pkey PRIMARY KEY (id));
CREATE TABLE blc_cart_field_mapping (id VARCHAR(255) NOT NULL, attribute_name VARCHAR(255), context_id VARCHAR(255), trk_application_context_id VARCHAR(36), trk_application_default_locale VARCHAR(255), trk_application_name VARCHAR(255), trk_archived CHAR(1) DEFAULT 'N' NOT NULL, audit_creation_time TIMESTAMP WITHOUT TIME ZONE, audit_creator VARCHAR(60), audit_update_time TIMESTAMP WITHOUT TIME ZONE, audit_updater VARCHAR(60), trk_change_details VARCHAR(10485760), trk_creating_application_id VARCHAR(36), trk_current_message VARCHAR(255), trk_level INTEGER, trk_max_field_versions VARCHAR(10485760), trk_sandbox_archived CHAR(1) DEFAULT 'N' NOT NULL, trk_sub_container_catalog VARCHAR(36), trk_change_container_id VARCHAR(36), trk_change_container_name VARCHAR(255), trk_change_container_route_key VARCHAR(60), trk_sub_container_name VARCHAR(255), trk_sandbox_change_type VARCHAR(60), trk_sandbox_context_id VARCHAR(36), trk_sandbox_name VARCHAR(255), trk_sandbox_owner VARCHAR(60), trk_sandbox_stage VARCHAR(60), trk_tenant_id VARCHAR(36), value_path VARCHAR(255), CONSTRAINT blc_cart_field_mapping_pkey PRIMARY KEY (id));
CREATE TABLE blc_catalog (id VARCHAR(36) NOT NULL, default_currency VARCHAR(255), hidden CHAR(1) DEFAULT 'N' NOT NULL, catalog_level BIGINT, catalog_locale VARCHAR(255), catalog_name VARCHAR(255), owning_application VARCHAR(36), updated_timestamp TIMESTAMP WITHOUT TIME ZONE, trk_archived CHAR(1) DEFAULT 'N' NOT NULL, audit_creation_time TIMESTAMP WITHOUT TIME ZONE, audit_creator VARCHAR(60), audit_update_time TIMESTAMP WITHOUT TIME ZONE, audit_updater VARCHAR(60), trk_change_details VARCHAR(10485760), trk_tenant_id VARCHAR(36), vendor_ref VARCHAR(255), CONSTRAINT blc_catalog_pkey PRIMARY KEY (id));
CREATE TABLE blc_category (id VARCHAR(36) NOT NULL, active_end_date TIMESTAMP WITHOUT TIME ZONE, active_start_date TIMESTAMP WITHOUT TIME ZONE, attributes VARCHAR(65535), context_id VARCHAR(36), description VARCHAR(10485760), display_template VARCHAR(255), external_id VARCHAR(255), meta_description VARCHAR(255), meta_title VARCHAR(255), name VARCHAR(255), parent_category_context_id VARCHAR(36), product_membership_locale VARCHAR(255), product_membership_rule VARCHAR(65535), product_membership_type VARCHAR(60), show_in_site_map CHAR(1) DEFAULT 'Y' NOT NULL, tax_code VARCHAR(255), trk_archived CHAR(1) DEFAULT 'N' NOT NULL, audit_creation_time TIMESTAMP WITHOUT TIME ZONE, audit_creator VARCHAR(60), audit_update_time TIMESTAMP WITHOUT TIME ZONE, audit_updater VARCHAR(60), trk_catalog_context_id VARCHAR(36), trk_catalog_level BIGINT, trk_catalog_locale VARCHAR(255), trk_catalog_name VARCHAR(255), trk_parent_cat_context_id VARCHAR(36), trk_parent_cat_level BIGINT, trk_parent_cat_locale VARCHAR(255), trk_parent_cat_name VARCHAR(255), trk_change_details VARCHAR(10485760), trk_composite_sort_level numeric(11, 5), trk_creating_application_id VARCHAR(36), trk_current_message VARCHAR(255), trk_field_overrides VARCHAR(10485760), trk_level INTEGER, trk_max_field_versions VARCHAR(10485760), trk_sandbox_archived CHAR(1) DEFAULT 'N' NOT NULL, trk_sub_container_catalog VARCHAR(36), trk_change_container_id VARCHAR(36), trk_change_container_name VARCHAR(255), trk_change_container_route_key VARCHAR(60), trk_sub_container_name VARCHAR(255), trk_sandbox_change_type VARCHAR(60), trk_sandbox_context_id VARCHAR(36), trk_sandbox_name VARCHAR(255), trk_sandbox_owner VARCHAR(60), trk_sandbox_stage VARCHAR(60), trk_tenant_id VARCHAR(36), url VARCHAR(255), CONSTRAINT blc_category_pkey PRIMARY KEY (id));
CREATE TABLE blc_category_asset (id VARCHAR(36) NOT NULL, alt_text VARCHAR(255), application_id VARCHAR(36), category_context_id VARCHAR(36), context_id VARCHAR(36), embed_code VARCHAR(10485760), is_primary CHAR(1) DEFAULT 'N' NOT NULL, provider VARCHAR(60), sorting VARCHAR(255), tenant_id VARCHAR(36), title VARCHAR(255), trk_archived CHAR(1) DEFAULT 'N' NOT NULL, audit_creation_time TIMESTAMP WITHOUT TIME ZONE, audit_creator VARCHAR(60), audit_update_time TIMESTAMP WITHOUT TIME ZONE, audit_updater VARCHAR(60), trk_catalog_context_id VARCHAR(36), trk_catalog_level BIGINT, trk_catalog_locale VARCHAR(255), trk_catalog_name VARCHAR(255), trk_parent_cat_context_id VARCHAR(36), trk_parent_cat_level BIGINT, trk_parent_cat_locale VARCHAR(255), trk_parent_cat_name VARCHAR(255), trk_change_details VARCHAR(10485760), trk_composite_sort_level numeric(11, 5), trk_creating_application_id VARCHAR(36), trk_current_message VARCHAR(255), trk_field_overrides VARCHAR(10485760), trk_level INTEGER, trk_max_field_versions VARCHAR(10485760), trk_sandbox_archived CHAR(1) DEFAULT 'N' NOT NULL, trk_sub_container_catalog VARCHAR(36), trk_change_container_id VARCHAR(36), trk_change_container_name VARCHAR(255), trk_change_container_route_key VARCHAR(60), trk_sub_container_name VARCHAR(255), trk_sandbox_change_type VARCHAR(60), trk_sandbox_context_id VARCHAR(36), trk_sandbox_name VARCHAR(255), trk_sandbox_owner VARCHAR(60), trk_sandbox_stage VARCHAR(60), trk_tenant_id VARCHAR(36), type VARCHAR(60), url VARCHAR(255), CONSTRAINT blc_category_asset_pkey PRIMARY KEY (id));
CREATE TABLE blc_category_product (id VARCHAR(36) NOT NULL, category_context_id VARCHAR(36), context_id VARCHAR(36), is_primary CHAR(1) DEFAULT 'N' NOT NULL, product_context_id VARCHAR(36), sorting VARCHAR(255), trk_archived CHAR(1) DEFAULT 'N' NOT NULL, audit_creation_time TIMESTAMP WITHOUT TIME ZONE, audit_creator VARCHAR(60), audit_update_time TIMESTAMP WITHOUT TIME ZONE, audit_updater VARCHAR(60), trk_catalog_context_id VARCHAR(36), trk_catalog_level BIGINT, trk_catalog_locale VARCHAR(255), trk_catalog_name VARCHAR(255), trk_parent_cat_context_id VARCHAR(36), trk_parent_cat_level BIGINT, trk_parent_cat_locale VARCHAR(255), trk_parent_cat_name VARCHAR(255), trk_change_details VARCHAR(10485760), trk_composite_sort_level numeric(11, 5), trk_creating_application_id VARCHAR(36), trk_current_message VARCHAR(255), trk_field_overrides VARCHAR(10485760), trk_level INTEGER, trk_max_field_versions VARCHAR(10485760), trk_sandbox_archived CHAR(1) DEFAULT 'N' NOT NULL, trk_sub_container_catalog VARCHAR(36), trk_change_container_id VARCHAR(36), trk_change_container_name VARCHAR(255), trk_change_container_route_key VARCHAR(60), trk_sub_container_name VARCHAR(255), trk_sandbox_change_type VARCHAR(60), trk_sandbox_context_id VARCHAR(36), trk_sandbox_name VARCHAR(255), trk_sandbox_owner VARCHAR(60), trk_sandbox_stage VARCHAR(60), trk_tenant_id VARCHAR(36), CONSTRAINT blc_category_product_pkey PRIMARY KEY (id));
CREATE TABLE blc_data_driven_enum (id VARCHAR(36) NOT NULL, context_id VARCHAR(36), display_value VARCHAR(255), trk_application_context_id VARCHAR(36), trk_application_default_locale VARCHAR(255), trk_application_name VARCHAR(255), trk_archived CHAR(1) DEFAULT 'N' NOT NULL, audit_creation_time TIMESTAMP WITHOUT TIME ZONE, audit_creator VARCHAR(60), audit_update_time TIMESTAMP WITHOUT TIME ZONE, audit_updater VARCHAR(60), trk_change_details VARCHAR(10485760), trk_creating_application_id VARCHAR(36), trk_current_message VARCHAR(255), trk_level INTEGER, trk_max_field_versions VARCHAR(10485760), trk_sandbox_archived CHAR(1) DEFAULT 'N' NOT NULL, trk_sub_container_catalog VARCHAR(36), trk_change_container_id VARCHAR(36), trk_change_container_name VARCHAR(255), trk_change_container_route_key VARCHAR(60), trk_sub_container_name VARCHAR(255), trk_sandbox_change_type VARCHAR(60), trk_sandbox_context_id VARCHAR(36), trk_sandbox_name VARCHAR(255), trk_sandbox_owner VARCHAR(60), trk_sandbox_stage VARCHAR(60), trk_tenant_id VARCHAR(36), type VARCHAR(255), value VARCHAR(255), CONSTRAINT blc_data_driven_enum_pkey PRIMARY KEY (id));
CREATE TABLE blc_mpl_appl_cat (id VARCHAR(36) NOT NULL, application_id VARCHAR(36) NOT NULL, catalog_id VARCHAR(36) NOT NULL, catalog_status VARCHAR(60), implicit VARCHAR(36), propagation_type VARCHAR(60), updated_timestamp TIMESTAMP WITHOUT TIME ZONE, trk_archived CHAR(1) DEFAULT 'N' NOT NULL, audit_creation_time TIMESTAMP WITHOUT TIME ZONE, audit_creator VARCHAR(60), audit_update_time TIMESTAMP WITHOUT TIME ZONE, audit_updater VARCHAR(60), trk_change_details VARCHAR(10485760), trk_tenant_id VARCHAR(36), vendor_ref VARCHAR(255), CONSTRAINT blc_mpl_appl_cat_pkey PRIMARY KEY (id));
CREATE TABLE blc_notification_state (id VARCHAR(36) NOT NULL, acked CHAR(1) DEFAULT 'N' NOT NULL, attempts INTEGER, change_timestamp TIMESTAMP WITHOUT TIME ZONE, change_timestamp_ack TIMESTAMP WITHOUT TIME ZONE, container VARCHAR(36), entity_type VARCHAR(255) NOT NULL, message_type VARCHAR(255), message_value VARCHAR(10485760), notification_name VARCHAR(255), next_attempt TIMESTAMP WITHOUT TIME ZONE, stopped CHAR(1) DEFAULT 'N' NOT NULL, CONSTRAINT blc_notification_state_pkey PRIMARY KEY (id));
CREATE TABLE blc_option_template (id VARCHAR(36) NOT NULL, ac_allowed_values VARCHAR(10485760), ac_attribute_name VARCHAR(255), ic_category_context_id VARCHAR(36), ic_choice_key VARCHAR(60), ac_type VARCHAR(60), context_id VARCHAR(36), ic_default_product_context_id VARCHAR(36), ic_default_prod_in_cat_ctx_id VARCHAR(36), ic_default_variant_context_id VARCHAR(36), ic_discount_allowed CHAR(1) DEFAULT 'Y' NOT NULL, option_display_order INTEGER, ac_error_code VARCHAR(255), ac_error_message VARCHAR(65535), option_label VARCHAR(255), ic_maximum_quantity INTEGER, ic_minimum_quantity INTEGER, name VARCHAR(255), option_type VARCHAR(60), ic_override_price numeric(19, 5), ic_pricing_key VARCHAR(60), option_product_context_id VARCHAR(36), ac_required CHAR(1) DEFAULT 'N' NOT NULL, ic_selection_type VARCHAR(60), ic_specific_choices VARCHAR(10485760), ic_target_type VARCHAR(60), option_template_context_id VARCHAR(36), trk_archived CHAR(1) DEFAULT 'N' NOT NULL, audit_creation_time TIMESTAMP WITHOUT TIME ZONE, audit_creator VARCHAR(60), audit_update_time TIMESTAMP WITHOUT TIME ZONE, audit_updater VARCHAR(60), trk_catalog_context_id VARCHAR(36), trk_catalog_level BIGINT, trk_catalog_locale VARCHAR(255), trk_catalog_name VARCHAR(255), trk_parent_cat_context_id VARCHAR(36), trk_parent_cat_level BIGINT, trk_parent_cat_locale VARCHAR(255), trk_parent_cat_name VARCHAR(255), trk_change_details VARCHAR(10485760), trk_composite_sort_level numeric(11, 5), trk_creating_application_id VARCHAR(36), trk_current_message VARCHAR(255), trk_field_overrides VARCHAR(10485760), trk_level INTEGER, trk_max_field_versions VARCHAR(10485760), trk_sandbox_archived CHAR(1) DEFAULT 'N' NOT NULL, trk_sub_container_catalog VARCHAR(36), trk_change_container_id VARCHAR(36), trk_change_container_name VARCHAR(255), trk_change_container_route_key VARCHAR(60), trk_sub_container_name VARCHAR(255), trk_sandbox_change_type VARCHAR(60), trk_sandbox_context_id VARCHAR(36), trk_sandbox_name VARCHAR(255), trk_sandbox_owner VARCHAR(60), trk_sandbox_stage VARCHAR(60), trk_tenant_id VARCHAR(36), ac_validation_rule VARCHAR(65535), ac_validation_strategy VARCHAR(60), ac_validation_type VARCHAR(60), CONSTRAINT blc_option_template_pkey PRIMARY KEY (id));
CREATE TABLE blc_option_template_group (id VARCHAR(36) NOT NULL, context_id VARCHAR(36), name VARCHAR(255), template_context_ids VARCHAR(65535), trk_archived CHAR(1) DEFAULT 'N' NOT NULL, audit_creation_time TIMESTAMP WITHOUT TIME ZONE, audit_creator VARCHAR(60), audit_update_time TIMESTAMP WITHOUT TIME ZONE, audit_updater VARCHAR(60), trk_catalog_context_id VARCHAR(36), trk_catalog_level BIGINT, trk_catalog_locale VARCHAR(255), trk_catalog_name VARCHAR(255), trk_parent_cat_context_id VARCHAR(36), trk_parent_cat_level BIGINT, trk_parent_cat_locale VARCHAR(255), trk_parent_cat_name VARCHAR(255), trk_change_details VARCHAR(10485760), trk_composite_sort_level numeric(11, 5), trk_creating_application_id VARCHAR(36), trk_current_message VARCHAR(255), trk_field_overrides VARCHAR(10485760), trk_level INTEGER, trk_max_field_versions VARCHAR(10485760), trk_sandbox_archived CHAR(1) DEFAULT 'N' NOT NULL, trk_sub_container_catalog VARCHAR(36), trk_change_container_id VARCHAR(36), trk_change_container_name VARCHAR(255), trk_change_container_route_key VARCHAR(60), trk_sub_container_name VARCHAR(255), trk_sandbox_change_type VARCHAR(60), trk_sandbox_context_id VARCHAR(36), trk_sandbox_name VARCHAR(255), trk_sandbox_owner VARCHAR(60), trk_sandbox_stage VARCHAR(60), trk_tenant_id VARCHAR(36), CONSTRAINT blc_option_template_group_pkey PRIMARY KEY (id));
CREATE TABLE blc_product (id VARCHAR(36) NOT NULL, active_end_date TIMESTAMP WITHOUT TIME ZONE, active_start_date TIMESTAMP WITHOUT TIME ZONE, attributes VARCHAR(65535), available_online CHAR(1) DEFAULT 'Y' NOT NULL, brand_context_id VARCHAR(36), context_id VARCHAR(36), cost numeric(19, 5), currency VARCHAR(255), default_price numeric(19, 5), depth numeric(19, 2), description VARCHAR(10485760), dimension_units VARCHAR(60), discountable CHAR(1) DEFAULT 'Y' NOT NULL, display_template VARCHAR(255), eligible_for_pickup CHAR(1) DEFAULT 'N' NOT NULL, external_id VARCHAR(255), fulfillment_flat_rates VARCHAR(10485760), height numeric(19, 2), included_products VARCHAR(10485760), individually_sold CHAR(1) DEFAULT 'Y' NOT NULL, inventory_check_strategy VARCHAR(60), inventory_reservation_strategy VARCHAR(60), inventory_type VARCHAR(60), keywords VARCHAR(10485760), max_threshold INTEGER, merchandising_product CHAR(1) DEFAULT 'N' NOT NULL, merchandising_type_context_id VARCHAR(36), merging_type VARCHAR(60), meta_description VARCHAR(255), meta_title VARCHAR(255), min_threshold INTEGER, msrp numeric(19, 5), name VARCHAR(255), reviews_number_of_reviews INTEGER, is_online CHAR(1) DEFAULT 'Y' NOT NULL, options VARCHAR(10485760), pricing_key VARCHAR(60), product_type VARCHAR(60), reviews_rating numeric(19, 2), reviews_rating_units VARCHAR(60), sale_price numeric(19, 5), searchable CHAR(1) DEFAULT 'Y' NOT NULL, sku VARCHAR(255), tags VARCHAR(255), target_demographic_context_id VARCHAR(36), tax_code VARCHAR(255), trk_archived CHAR(1) DEFAULT 'N' NOT NULL, audit_creation_time TIMESTAMP WITHOUT TIME ZONE, audit_creator VARCHAR(60), audit_update_time TIMESTAMP WITHOUT TIME ZONE, audit_updater VARCHAR(60), trk_catalog_context_id VARCHAR(36), trk_catalog_level BIGINT, trk_catalog_locale VARCHAR(255), trk_catalog_name VARCHAR(255), trk_parent_cat_context_id VARCHAR(36), trk_parent_cat_level BIGINT, trk_parent_cat_locale VARCHAR(255), trk_parent_cat_name VARCHAR(255), trk_change_details VARCHAR(10485760), trk_composite_sort_level numeric(11, 5), trk_creating_application_id VARCHAR(36), trk_current_message VARCHAR(255), trk_field_overrides VARCHAR(10485760), trk_level INTEGER, trk_max_field_versions VARCHAR(10485760), trk_sandbox_archived CHAR(1) DEFAULT 'N' NOT NULL, trk_sub_container_catalog VARCHAR(36), trk_change_container_id VARCHAR(36), trk_change_container_name VARCHAR(255), trk_change_container_route_key VARCHAR(60), trk_sub_container_name VARCHAR(255), trk_sandbox_change_type VARCHAR(60), trk_sandbox_context_id VARCHAR(36), trk_sandbox_name VARCHAR(255), trk_sandbox_owner VARCHAR(60), trk_sandbox_stage VARCHAR(60), trk_tenant_id VARCHAR(36), upc VARCHAR(255), uri VARCHAR(255), weight numeric(19, 2), weight_units VARCHAR(60), width numeric(19, 2), CONSTRAINT blc_product_pkey PRIMARY KEY (id));
CREATE TABLE blc_product_asset (id VARCHAR(36) NOT NULL, alt_text VARCHAR(255), application_id VARCHAR(36), context_id VARCHAR(36), embed_code VARCHAR(10485760), is_primary CHAR(1) DEFAULT 'N' NOT NULL, product_context_id VARCHAR(36), provider VARCHAR(60), sorting VARCHAR(255), tenant_id VARCHAR(36), title VARCHAR(255), trk_archived CHAR(1) DEFAULT 'N' NOT NULL, audit_creation_time TIMESTAMP WITHOUT TIME ZONE, audit_creator VARCHAR(60), audit_update_time TIMESTAMP WITHOUT TIME ZONE, audit_updater VARCHAR(60), trk_catalog_context_id VARCHAR(36), trk_catalog_level BIGINT, trk_catalog_locale VARCHAR(255), trk_catalog_name VARCHAR(255), trk_parent_cat_context_id VARCHAR(36), trk_parent_cat_level BIGINT, trk_parent_cat_locale VARCHAR(255), trk_parent_cat_name VARCHAR(255), trk_change_details VARCHAR(10485760), trk_composite_sort_level numeric(11, 5), trk_creating_application_id VARCHAR(36), trk_current_message VARCHAR(255), trk_field_overrides VARCHAR(10485760), trk_level INTEGER, trk_max_field_versions VARCHAR(10485760), trk_sandbox_archived CHAR(1) DEFAULT 'N' NOT NULL, trk_sub_container_catalog VARCHAR(36), trk_change_container_id VARCHAR(36), trk_change_container_name VARCHAR(255), trk_change_container_route_key VARCHAR(60), trk_sub_container_name VARCHAR(255), trk_sandbox_change_type VARCHAR(60), trk_sandbox_context_id VARCHAR(36), trk_sandbox_name VARCHAR(255), trk_sandbox_owner VARCHAR(60), trk_sandbox_stage VARCHAR(60), trk_tenant_id VARCHAR(36), type VARCHAR(60), url VARCHAR(255), CONSTRAINT blc_product_asset_pkey PRIMARY KEY (id));
CREATE TABLE blc_product_tag (id VARCHAR(36) NOT NULL, active_end_date TIMESTAMP WITHOUT TIME ZONE, active_start_date TIMESTAMP WITHOUT TIME ZONE, context_id VARCHAR(36), product_context_id VARCHAR(36), sorting VARCHAR(255), tag_context_id VARCHAR(36), trk_archived CHAR(1) DEFAULT 'N' NOT NULL, audit_creation_time TIMESTAMP WITHOUT TIME ZONE, audit_creator VARCHAR(60), audit_update_time TIMESTAMP WITHOUT TIME ZONE, audit_updater VARCHAR(60), trk_catalog_context_id VARCHAR(36), trk_catalog_level BIGINT, trk_catalog_locale VARCHAR(255), trk_catalog_name VARCHAR(255), trk_parent_cat_context_id VARCHAR(36), trk_parent_cat_level BIGINT, trk_parent_cat_locale VARCHAR(255), trk_parent_cat_name VARCHAR(255), trk_change_details VARCHAR(10485760), trk_composite_sort_level numeric(11, 5), trk_creating_application_id VARCHAR(36), trk_current_message VARCHAR(255), trk_field_overrides VARCHAR(10485760), trk_level INTEGER, trk_max_field_versions VARCHAR(10485760), trk_sandbox_archived CHAR(1) DEFAULT 'N' NOT NULL, trk_sub_container_catalog VARCHAR(36), trk_change_container_id VARCHAR(36), trk_change_container_name VARCHAR(255), trk_change_container_route_key VARCHAR(60), trk_sub_container_name VARCHAR(255), trk_sandbox_change_type VARCHAR(60), trk_sandbox_context_id VARCHAR(36), trk_sandbox_name VARCHAR(255), trk_sandbox_owner VARCHAR(60), trk_sandbox_stage VARCHAR(60), trk_tenant_id VARCHAR(36), variant_id VARCHAR(36), CONSTRAINT blc_product_tag_pkey PRIMARY KEY (id));
CREATE TABLE blc_promotional_category_product (id VARCHAR(36) NOT NULL, category_context_id VARCHAR(36), context_id VARCHAR(36), promotion_message VARCHAR(255), promotional_product_context_id VARCHAR(36), promotional_product_type VARCHAR(60), sorting VARCHAR(255), trk_archived CHAR(1) DEFAULT 'N' NOT NULL, audit_creation_time TIMESTAMP WITHOUT TIME ZONE, audit_creator VARCHAR(60), audit_update_time TIMESTAMP WITHOUT TIME ZONE, audit_updater VARCHAR(60), trk_catalog_context_id VARCHAR(36), trk_catalog_level BIGINT, trk_catalog_locale VARCHAR(255), trk_catalog_name VARCHAR(255), trk_parent_cat_context_id VARCHAR(36), trk_parent_cat_level BIGINT, trk_parent_cat_locale VARCHAR(255), trk_parent_cat_name VARCHAR(255), trk_change_details VARCHAR(10485760), trk_composite_sort_level numeric(11, 5), trk_creating_application_id VARCHAR(36), trk_current_message VARCHAR(255), trk_field_overrides VARCHAR(10485760), trk_level INTEGER, trk_max_field_versions VARCHAR(10485760), trk_sandbox_archived CHAR(1) DEFAULT 'N' NOT NULL, trk_sub_container_catalog VARCHAR(36), trk_change_container_id VARCHAR(36), trk_change_container_name VARCHAR(255), trk_change_container_route_key VARCHAR(60), trk_sub_container_name VARCHAR(255), trk_sandbox_change_type VARCHAR(60), trk_sandbox_context_id VARCHAR(36), trk_sandbox_name VARCHAR(255), trk_sandbox_owner VARCHAR(60), trk_sandbox_stage VARCHAR(60), trk_tenant_id VARCHAR(36), CONSTRAINT blc_promotional_category_product_pkey PRIMARY KEY (id));
CREATE TABLE blc_promotional_product (id VARCHAR(36) NOT NULL, context_id VARCHAR(36), product_context_id VARCHAR(36), promotion_message VARCHAR(255), related_product_context_id VARCHAR(36), sorting VARCHAR(255), trk_archived CHAR(1) DEFAULT 'N' NOT NULL, audit_creation_time TIMESTAMP WITHOUT TIME ZONE, audit_creator VARCHAR(60), audit_update_time TIMESTAMP WITHOUT TIME ZONE, audit_updater VARCHAR(60), trk_catalog_context_id VARCHAR(36), trk_catalog_level BIGINT, trk_catalog_locale VARCHAR(255), trk_catalog_name VARCHAR(255), trk_parent_cat_context_id VARCHAR(36), trk_parent_cat_level BIGINT, trk_parent_cat_locale VARCHAR(255), trk_parent_cat_name VARCHAR(255), trk_change_details VARCHAR(10485760), trk_composite_sort_level numeric(11, 5), trk_creating_application_id VARCHAR(36), trk_current_message VARCHAR(255), trk_field_overrides VARCHAR(10485760), trk_level INTEGER, trk_max_field_versions VARCHAR(10485760), trk_sandbox_archived CHAR(1) DEFAULT 'N' NOT NULL, trk_sub_container_catalog VARCHAR(36), trk_change_container_id VARCHAR(36), trk_change_container_name VARCHAR(255), trk_change_container_route_key VARCHAR(60), trk_sub_container_name VARCHAR(255), trk_sandbox_change_type VARCHAR(60), trk_sandbox_context_id VARCHAR(36), trk_sandbox_name VARCHAR(255), trk_sandbox_owner VARCHAR(60), trk_sandbox_stage VARCHAR(60), trk_tenant_id VARCHAR(36), type VARCHAR(60), CONSTRAINT blc_promotional_product_pkey PRIMARY KEY (id));
CREATE TABLE blc_resource_lock (id VARCHAR(36) NOT NULL, concept_key VARCHAR(255), context_id VARCHAR(36), lock_expiration_timestamp TIMESTAMP WITHOUT TIME ZONE, locked CHAR(1) DEFAULT 'N', sandbox_id VARCHAR(36), lock_timestamp TIMESTAMP WITHOUT TIME ZONE, token VARCHAR(255), type_alias VARCHAR(255), CONSTRAINT blc_resource_lock_pkey PRIMARY KEY (id));
CREATE TABLE blc_translation (id VARCHAR(36) NOT NULL, context_id VARCHAR(36), entity_field VARCHAR(255), entity_id VARCHAR(36), entity_type VARCHAR(255), locale VARCHAR(36), trk_application_context_id VARCHAR(36), trk_application_default_locale VARCHAR(255), trk_application_name VARCHAR(255), trk_archived CHAR(1) DEFAULT 'N' NOT NULL, audit_creation_time TIMESTAMP WITHOUT TIME ZONE, audit_creator VARCHAR(60), audit_update_time TIMESTAMP WITHOUT TIME ZONE, audit_updater VARCHAR(60), trk_catalog_context_id VARCHAR(36), trk_catalog_level BIGINT, trk_catalog_locale VARCHAR(255), trk_catalog_name VARCHAR(255), trk_parent_cat_context_id VARCHAR(36), trk_parent_cat_level BIGINT, trk_parent_cat_locale VARCHAR(255), trk_parent_cat_name VARCHAR(255), trk_change_details VARCHAR(10485760), trk_composite_sort_level numeric(11, 5), trk_creating_application_id VARCHAR(36), trk_current_message VARCHAR(255), trk_customer_context_id VARCHAR(36), trk_field_overrides VARCHAR(10485760), trk_level INTEGER, trk_max_field_versions VARCHAR(10485760), trk_sandbox_archived CHAR(1) DEFAULT 'N' NOT NULL, trk_sub_container_catalog VARCHAR(36), trk_change_container_id VARCHAR(36), trk_change_container_name VARCHAR(255), trk_change_container_route_key VARCHAR(60), trk_sub_container_name VARCHAR(255), trk_sandbox_change_type VARCHAR(60), trk_sandbox_context_id VARCHAR(36), trk_sandbox_name VARCHAR(255), trk_sandbox_owner VARCHAR(60), trk_sandbox_stage VARCHAR(60), trk_tenant_id VARCHAR(36), translation_value VARCHAR(10485760), CONSTRAINT blc_translation_pkey PRIMARY KEY (id));
CREATE TABLE blc_variant (id VARCHAR(36) NOT NULL, active_end_date TIMESTAMP WITHOUT TIME ZONE, active_start_date TIMESTAMP WITHOUT TIME ZONE, attributes VARCHAR(65535), context_id VARCHAR(36), cost numeric(19, 5), default_price numeric(19, 5), depth numeric(19, 2), description VARCHAR(255), dimension_units VARCHAR(60), discountable CHAR(1) DEFAULT 'Y' NOT NULL, external_id VARCHAR(255), fulfillment_flat_rates VARCHAR(10485760), height numeric(19, 2), inventory_check_strategy VARCHAR(60), inventory_reservation_strategy VARCHAR(60), max_threshold INTEGER, min_threshold INTEGER, name VARCHAR(255), reviews_number_of_reviews INTEGER, is_online CHAR(1) DEFAULT 'Y' NOT NULL, option_values VARCHAR(10485760), product_context_id VARCHAR(36), reviews_rating numeric(19, 2), reviews_rating_units VARCHAR(60), sale_price numeric(19, 5), sku VARCHAR(255), tax_code VARCHAR(255), trk_archived CHAR(1) DEFAULT 'N' NOT NULL, audit_creation_time TIMESTAMP WITHOUT TIME ZONE, audit_creator VARCHAR(60), audit_update_time TIMESTAMP WITHOUT TIME ZONE, audit_updater VARCHAR(60), trk_catalog_context_id VARCHAR(36), trk_catalog_level BIGINT, trk_catalog_locale VARCHAR(255), trk_catalog_name VARCHAR(255), trk_parent_cat_context_id VARCHAR(36), trk_parent_cat_level BIGINT, trk_parent_cat_locale VARCHAR(255), trk_parent_cat_name VARCHAR(255), trk_change_details VARCHAR(10485760), trk_composite_sort_level numeric(11, 5), trk_creating_application_id VARCHAR(36), trk_current_message VARCHAR(255), trk_field_overrides VARCHAR(10485760), trk_level INTEGER, trk_max_field_versions VARCHAR(10485760), trk_sandbox_archived CHAR(1) DEFAULT 'N' NOT NULL, trk_sub_container_catalog VARCHAR(36), trk_change_container_id VARCHAR(36), trk_change_container_name VARCHAR(255), trk_change_container_route_key VARCHAR(60), trk_sub_container_name VARCHAR(255), trk_sandbox_change_type VARCHAR(60), trk_sandbox_context_id VARCHAR(36), trk_sandbox_name VARCHAR(255), trk_sandbox_owner VARCHAR(60), trk_sandbox_stage VARCHAR(60), trk_tenant_id VARCHAR(36), upc VARCHAR(255), weight numeric(19, 2), weight_units VARCHAR(60), width numeric(19, 2), CONSTRAINT blc_variant_pkey PRIMARY KEY (id));
CREATE TABLE blc_catalog_ref (id VARCHAR(36) NOT NULL, exclusion_filters VARCHAR(10485760), inclusion_filters VARCHAR(10485760), mutability_type VARCHAR(60), parent_catalog_id VARCHAR(36), child_catalog_id VARCHAR(36) NOT NULL, parents_order INTEGER, CONSTRAINT blc_catalog_ref_pkey PRIMARY KEY (id));
ALTER TABLE blc_resource_lock ADD CONSTRAINT uk7iegjt4gojv24q9bw8k0i4j0c UNIQUE (context_id, type_alias, sandbox_id, concept_key);
CREATE TABLE blc_category_asset_tag (category_asset_id VARCHAR(255) NOT NULL, tag VARCHAR(255) NOT NULL, tags_order INTEGER, CONSTRAINT blc_category_asset_tag_pkey PRIMARY KEY (category_asset_id, tag));
CREATE TABLE blc_export (id VARCHAR(36) NOT NULL, addl_parameters VARCHAR(10485760), application_id VARCHAR(36), author VARCHAR(255), created TIMESTAMP WITHOUT TIME ZONE, error_message VARCHAR(65535), exclusions VARCHAR(10485760), exporting_application_id VARCHAR(36), exporting_catalog_id VARCHAR(36), exporting_customer_context_id VARCHAR(36), exporting_sandbox_id VARCHAR(36), file_location VARCHAR(500), file_type VARCHAR(60), filter_string VARCHAR(65535), inclusions VARCHAR(10485760), last_updated TIMESTAMP WITHOUT TIME ZONE, name VARCHAR(255), number_of_records_to_process BIGINT, parent_id VARCHAR(36), status VARCHAR(60), target VARCHAR(60), tenant_id VARCHAR(36), time_zone_id VARCHAR(255), total_records_to_process BIGINT, CONSTRAINT blc_export_pkey PRIMARY KEY (id));
CREATE TABLE blc_export_lob (id VARCHAR(36) NOT NULL, content TEXT, path VARCHAR(500), CONSTRAINT blc_export_lob_pkey PRIMARY KEY (id));
CREATE TABLE blc_product_asset_tag (product_asset_id VARCHAR(255) NOT NULL, tag VARCHAR(255) NOT NULL, tags_order INTEGER, CONSTRAINT blc_product_asset_tag_pkey PRIMARY KEY (product_asset_id, tag));
ALTER TABLE blc_application_catalog ADD CONSTRAINT fkdaeorqo87oh0rdu1lfkpv3qow FOREIGN KEY (application_id) REFERENCES blc_application (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
ALTER TABLE blc_catalog_ref ADD CONSTRAINT fkqa2huaj7r3r8ovdilb9h71x2k FOREIGN KEY (child_catalog_id) REFERENCES blc_catalog (id) ON UPDATE NO ACTION ON DELETE NO ACTION;