Table: addresses
- id: integer
- address1: character varying
- company_name: character varying
- country_code: character varying
- city: character varying
- zipcode: character varying
- first_name: character varying
- last_name: character varying
- address2: character varying
- state: character varying
- email: text
- phone: text

Table: adyen_sessions
- id: integer
- cart_id: text
- adyen_session_id: text
- content: jsonb
- payment_complete_response: text
- authorisation_webhook: text
- status: text
- order_id: integer
- inserted: timestamp with time zone
- updated: timestamp with time zone
- authorisation_webhook_timestamp: timestamp with time zone

Table: article_article_categories
- article_id: integer
- category_id: integer
- main: integer

Table: article_categories
- id: integer
- name: text
- slug: text

Table: article_content
- id: integer
- article_id: integer
- title: text
- preamble: text
- body: text
- body_saved: timestamp with time zone
- meta_title: text
- meta_description: text
- slug: text
- market_locale_id: integer

Table: articles
- id: integer
- created: timestamp with time zone
- published: timestamp with time zone
- deleted: timestamp with time zone
- name: text

Table: avalara
- id: integer
- order_id: integer
- success: boolean
- completed_at: timestamp with time zone
- response: text
- extracted: jsonb

Table: cache
- id: integer
- method: character varying
- params: text
- content: text
- inserted: timestamp with time zone
- updated: timestamp with time zone

Table: cart_sessions
- id: integer
- market_locale_id: integer
- public_id: text
- active: boolean
- content: text
- revision: integer
- inactive_reason: text
- created: timestamp with time zone
- last_modified: timestamp with time zone

Table: carts
- uuid: uuid
- inserted: timestamp with time zone
- order_id: integer
- klarna_order_id: text
- content: jsonb
- klarna_order_data: json

Table: categories
- id: integer
- name: character varying
- lft: integer
- rgt: integer
- photo_wallpaper_image_id: integer
- design_wallpaper_image_id: integer
- canvas_image_id: integer
- poster_image_id: integer
- framed_print_image_id: integer

Table: category_images
- id: integer
- category_id: integer
- product_group: integer
- url: character varying

Table: category_keyword
- id: integer
- category_id: integer
- keyword_id: integer

Table: category_metadata
- category_id: integer
- canonical: integer
- panel_visibility: integer

Table: category_texts
- id: integer
- category_id: integer
- locale_id: integer
- wallpaper_name: character varying
- wallpaper_h1: character varying
- wallpaper_description: text
- canvas_name: character varying
- canvas_h1: character varying
- canvas_description: text
- name: character varying
- design_wallpaper_h1: character varying
- design_wallpaper_description: text
- poster_name: character varying
- poster_h1: character varying
- poster_description: text
- framed_print_name: character varying
- framed_print_h1: character varying
- framed_print_description: text
- updated: timestamp with time zone
- display_name: text
- text_length: character varying
- wallpaper_keywords: ARRAY
- design_wallpaper_keywords: ARRAY
- canvas_keywords: ARRAY
- poster_keywords: ARRAY

Table: category_texts_updated
- id: integer
- category_texts_id: integer
- product_type: character varying
- updated: timestamp without time zone

Table: categorydata
- category_id: integer
- datakey_id: integer
- locale_id: integer
- text: text

Table: categorydatakeys
- id: integer
- name: character varying

Table: collections
- id: integer
- name: text
- inserted: timestamp with time zone
- deleted: timestamp with time zone
- wallpaper_image_id: integer
- canvas_image_id: integer
- poster_image_id: integer
- framed_print_image_id: integer
- default_product_list_tab: text
- face_image_key: text
- author: text
- author_handle: text
- show_only_default: boolean

Table: collections_blacklist
- id: integer
- collection_id: integer
- market_id: integer

Table: collections_products
- id: integer
- collection_id: integer
- product_id: integer
- inserted: timestamp with time zone

Table: collections_texts
- id: integer
- collection_id: integer
- meta_title: text
- meta_description: text
- title: text
- description: text
- slug: text
- locale_id: integer

Table: contract_customers
- contractcustomerid: integer
- companyname: character varying
- code: character varying
- address: character varying
- zipcode: character varying
- city: character varying
- country: character varying
- delivery-address: character varying
- delivery-zipcode: character varying
- delivery-city: character varying
- delivery-country: character varying
- firstname: character varying
- lastname: character varying
- phone: character varying
- email: character varying
- designerid: integer
- comment: text
- inserted: timestamp with time zone
- updated: timestamp with time zone
- dealerstore: boolean
- dealerurl: character varying
- hideprices: boolean
- delivery-company: character varying
- pricepremium: numeric
- reseller-companyname: character varying
- reseller-address: character varying
- reseller-zipcode: character varying
- reseller-city: character varying
- reseller-phone: character varying
- reseller-email: character varying
- vat_reg_nr: character varying
- send_invoice: character varying
- deleted: integer
- contact-us-text: text
- head-logo: character varying
- payment_type: character varying
- email_invoice: character varying
- state: character varying
- delivery-state: character varying
- discount: integer
- delivery-firstname: character varying
- delivery-lastname: character varying
- delivery-email: character varying
- delivery-phone: character varying
- address2: character varying
- delivery-address2: character varying

Table: database_versions
- version: character varying
- is_active: boolean
- creation_date: timestamp without time zone

Table: delayed_orders_email
- id: integer
- order_id: integer
- type: USER-DEFINED
- status: USER-DEFINED
- date: timestamp with time zone

Table: delivery-methods
- id: integer
- name: character varying
- inserted: timestamp with time zone
- updated: timestamp with time zone

Table: delivery-methods_prices
- method: integer
- option: character varying
- option_value: character varying
- currency: character varying
- price: numeric
- inserted: timestamp with time zone
- updated: timestamp with time zone
- territory: character varying

Table: designer_texts
- id: integer
- designerid: integer
- locale_id: integer
- header: character varying
- description: text

Table: designers
- designerid: integer
- name: character varying
- path: character varying
- username: character varying
- password: character varying
- co: character varying
- street: character varying
- zipcode: character varying
- city: character varying
- territory: character varying
- phone: character varying
- email: character varying
- orgnr: character varying
- currency: character varying
- commission: numeric
- commission_resale: numeric
- balance: numeric
- description: text
- comments: text
- status: integer
- inserted: timestamp with time zone
- updated: timestamp with time zone
- license_image: character varying
- type: character varying
- segmentation: integer
- visible_search: integer
- visible_list: integer
- visible_productpage: integer
- visible_designerpage: integer
- sort_desc: boolean
- no_follow: integer
- logotype: character varying
- automatic_payout: integer
- pricepremium_wallpaper: numeric
- pricepremium_canvas: numeric
- pricepremium_poster: numeric
- pricepremium_framed_print: numeric
- wallpaper_image_id: integer
- canvas_image_id: integer
- poster_image_id: integer
- framed_print_image_id: integer
- payout_platform_id: text
- enable_retouch: integer

Table: designers-blocked
- designerid: integer
- domain: character varying

Table: designers_history
- designerhistoryid: integer
- designerid: integer
- currency_from: character varying
- currency_to: character varying
- rowid: integer
- inserted: timestamp with time zone
- updated: timestamp with time zone

Table: discount_code_filters
- id: integer
- filter_name: character varying
- filter_value: character varying
- discount_code_id: integer

Table: discount_codes
- discountid: integer
- name: character varying
- value: integer
- type: character varying
- start: timestamp with time zone
- end: timestamp with time zone
- code: character varying
- inserted: timestamp with time zone
- updated: timestamp with time zone
- no_shipping: boolean
- completion_limit: integer
- group: character varying
- applicable_on_sales: boolean

Table: editorial_content
- id: integer
- editorial_page_id: integer
- inserted: timestamp with time zone
- updated: timestamp with time zone
- title: text
- body: text
- meta_title: text
- meta_description: text
- slug: text
- market_locale_id: integer
- noindex: boolean
- highlighted: boolean
- description: text
- editorial_page_type: USER-DEFINED
- add_to_menu: boolean
- menu_title: text
- visible: boolean

Table: editorial_pages
- id: integer
- inserted: timestamp with time zone
- published: timestamp with time zone
- deleted: timestamp with time zone
- name: text
- description: text
- updated: timestamp with time zone
- metadata: jsonb
- type: USER-DEFINED

Table: external_print_products
- id: integer
- orientation: USER-DEFINED
- accessory: text
- width_mm: numeric
- height_mm: numeric
- width_inch: numeric
- height_inch: numeric
- external_product_id: text
- inserted: timestamp with time zone
- updated: timestamp with time zone
- price_sek: numeric
- group_id: integer
- stock_status: jsonb

Table: external_print_products_out_of_stock
- external_product_id: text
- region: text
- inserted: timestamp without time zone

Table: flyers
- flyerid: integer
- name: character varying
- start: timestamp with time zone
- end: timestamp with time zone
- completion_limit: integer
- territory: character
- inserted: timestamp with time zone
- updated: timestamp with time zone

Table: i18n-currencies
- iso3char: character varying
- symbol: character varying
- fractional_parts: integer
- exchange_rate: numeric
- locale: character varying
- inserted: timestamp with time zone
- updated: timestamp with time zone

Table: i18n-currencies_names
- currency: character varying
- language: character varying
- name: character varying
- name_counted: character varying
- inserted: timestamp with time zone
- updated: timestamp with time zone

Table: i18n-currencies_territories
- territory: character varying
- currency: character varying
- inserted: timestamp with time zone
- updated: timestamp with time zone

Table: i18n-languages
- iso3char: character varying
- inserted: timestamp with time zone
- updated: timestamp with time zone

Table: i18n-languages_names
- iso3char: character varying
- language: character varying
- name: character varying
- inserted: timestamp with time zone
- updated: timestamp with time zone

Table: i18n-languages_territories
- language: character varying
- territory: character varying
- inserted: timestamp with time zone
- updated: timestamp with time zone

Table: i18n-territories
- iso2char: character varying
- inserted: timestamp with time zone
- updated: timestamp with time zone
- vat: numeric

Table: i18n-territories_names
- territory: character varying
- language: character varying
- name: character varying
- inserted: timestamp with time zone
- updated: timestamp with time zone

Table: i18n-texts
- textid: integer
- name: character varying
- category: character varying
- inserted: timestamp with time zone
- updated: timestamp with time zone

Table: i18n-texts_data
- textid: integer
- text: text
- inserted: timestamp with time zone
- updated: timestamp with time zone
- locale_id: integer

Table: ingrid_deliveries
- id: integer
- order_id: integer
- ingrid_checkout_session_id: text
- complete_session_response: text
- completed_at: timestamp with time zone

Table: inquiries
- inquiryid: integer
- company: character varying
- firstname: character varying
- lastname: character varying
- email: character varying
- phone: character varying
- submitted: timestamp with time zone
- status: integer
- product_group: character varying
- msg: text
- msg_internal: text
- msg_effect: text
- price_m2: numeric
- price_effect: numeric
- price_retouch: numeric
- width: integer
- height: integer
- x: numeric
- y: numeric
- effect: integer
- inserted: timestamp with time zone
- updated: timestamp with time zone
- dealer_store: integer
- mirrored: integer
- imagedonotprint: character varying
- artNo: character varying
- materialid: integer
- pricepremium: numeric
- productId: integer
- timer: integer
- uploaded: integer
- in_cart: integer
- automated: integer
- img_hash: character varying
- img_width: integer
- img_height: integer
- img_size: bigint
- img_format: character varying
- img_timestamp: bigint
- hanger: character varying
- deleted: timestamp with time zone
- zendesk_ticket: integer
- market_id: integer
- locale_id: integer
- pre_payment_order_row_id: integer
- repaid_order_id: integer
- duplicate_of: integer
- original_width: integer
- original_height: integer

Table: inquiry_markers
- id: integer
- inquiry_id: integer
- comment: text
- number: integer

Table: inquiry_messages
- id: integer
- inquiry_id: integer
- message: text
- message_type: integer
- created_at: timestamp without time zone
- user_id: integer
- price: numeric
- price_premium: numeric
- price_total: numeric
- material_id: integer

Table: interiors
- id: integer
- print_id: integer
- room_id: integer
- position: smallint
- create_date: timestamp with time zone

Table: interiors2
- id: integer
- print_id: integer
- room_id: integer
- position: smallint
- create_date: timestamp with time zone

Table: invoices
- id: integer
- inserted: timestamp with time zone
- order_id: integer
- invoice_date: date
- invoice_sent: integer

Table: keyword_type
- keyword_id: integer
- type_id: integer

Table: keywords
- id: integer
- value: character varying

Table: keywords_i18n
- id: integer
- keyword_id: integer
- locale_id: integer
- value: text

Table: keywordtypes
- id: integer
- name: character varying

Table: locales
- id: integer
- value: character
- fallback_id: integer
- name: text

Table: market_locales
- id: integer
- market_id: integer
- locale_id: integer
- name: text

Table: markets
- id: integer
- name: character varying
- vat: numeric
- currency: text
- price_adjustment: numeric

Table: my-test_table
- id: integer
- a: text

Table: order_rows
- id: integer
- type: USER-DEFINED
- sub_type: USER-DEFINED
- status: USER-DEFINED
- order_id: integer
- designer_id: integer
- inserted: timestamp with time zone
- updated: timestamp with time zone
- price: numeric
- commission_amount: numeric
- data: jsonb
- external_status: text

Table: orderlogs
- id: integer
- created: timestamp with time zone

Table: orders
- id: integer
- inserted: timestamp with time zone
- paid: integer
- confirmed: integer
- delivered: integer
- newsletter: integer
- credit_invoice: integer
- canceled: integer
- reminder: integer
- delivered_date: date
- country_code: character varying
- language: character varying
- delivery_country_code: character varying
- delivery_method: text
- delivery_price: numeric
- delivery_vat: numeric
- customer_type: text
- payment_type: text
- attention: text
- currency: character varying
- exchange_rate: numeric
- exchange_rate_eur: numeric
- invoice_id: text
- contract_customer_id: integer
- vat_number: text
- comment: text
- cancels_order_id: integer
- cancelled_by_order_id: integer
- orderlog_id: integer
- reseller_store: text
- order_sum: numeric
- klarna_order_id: text
- pwinty_id: integer
- email: text
- phone: text
- delivery_email: text
- delivery_phone: text
- customer_firstname: text
- customer_lastname: text
- customer_email: text
- customer_cellphone: text
- billing_address_id: integer
- delivery_address_id: integer
- flyer_ids: text
- market: text
- locale: text
- paypal_transaction_id: text
- external_order_id: text
- gdpr_removal: timestamp with time zone
- delivery_method_name: text
- price_decimals: integer
- purchase_event_sent: timestamp with time zone

Table: paint
- id: integer
- color: text
- name: text
- path: character varying
- hex: character varying
- article_number: character varying
- paint_primer_id: integer
- created: timestamp with time zone
- updated: timestamp with time zone

Table: paint_card_samples
- id: integer
- paint_id: integer
- stock: integer
- created: timestamp with time zone
- updated: timestamp with time zone
- packing_slot: character varying

Table: paint_prices
- liters: numeric
- market_id: integer
- price: numeric
- created: timestamp with time zone
- updated: timestamp with time zone

Table: paint_primer
- id: integer
- name: text
- created: timestamp with time zone
- updated: timestamp with time zone

Table: paint_primer_sizes
- id: integer
- paint_primer_id: integer
- liters: numeric
- stock: integer
- created: timestamp with time zone
- updated: timestamp with time zone
- coverage_m2: numeric

Table: price_adjustments
- market_id: integer
- material_id: integer
- product_type: USER-DEFINED
- value: numeric
- inserted: timestamp with time zone
- updated: timestamp with time zone

Table: price_file_imports
- id: integer
- inserted: timestamp with time zone
- comment: text
- csv_content: text
- active: boolean
- deleted: timestamp with time zone
- meta: jsonb

Table: price_file_imports_history
- import_id: integer
- type: USER-DEFINED
- date: timestamp with time zone

Table: price_segmentations
- product_id: integer
- designer_id: integer
- custom: boolean
- segment_id: integer

Table: price_segments
- id: integer
- name: text

Table: prices_external_products
- id: integer
- external_product_id: text
- segment_id: integer
- market_id: integer
- price: numeric
- updated: timestamp with time zone

Table: prices_other_products
- market_id: integer
- wallpaper_kit_price: numeric
- wallpaper_sample_price: numeric
- updated: timestamp with time zone
- peel_and_stick_wallpaper_kit_price: numeric
- paint_card_sample_price: numeric
- wall_paint_kit_price: numeric
- wallpaper_glue_price: numeric

Table: prices_wallpaper_m2
- id: integer
- material_id: integer
- segment_id: integer
- market_id: integer
- price: numeric
- updated: timestamp with time zone

Table: printproducts_defaults
- print_id: integer
- width_mm: numeric
- height_mm: numeric
- crop_x: numeric
- crop_y: numeric
- border: USER-DEFINED

Table: product-currencies
- iso3char: character varying
- exchange_rate: numeric

Table: product-fields
- fieldid: integer
- field: character varying
- inserted: timestamp with time zone
- updated: timestamp with time zone

Table: product-groups
- groupid: integer
- group: character varying
- inserted: timestamp with time zone
- updated: timestamp with time zone

Table: product-materials
- materialid: integer
- material: character varying
- inserted: timestamp with time zone
- updated: timestamp with time zone
- price: integer

Table: product-printprices
- groupid: integer
- materialid: integer
- price: numeric
- inserted: timestamp with time zone
- updated: timestamp with time zone

Table: product-printproducts
- printid: integer
- productid: integer
- groupid: integer
- inserted: timestamp with time zone
- updated: timestamp with time zone

Table: product-printproducts_materials
- printid: integer
- materialid: integer

Table: product-products
- productid: integer
- path: character varying
- visible: integer
- browsable: integer
- designerid: integer
- inserted: timestamp with time zone
- updated: timestamp with time zone
- ref1: text
- ref2: text
- ref3: text
- publishing_date: timestamp with time zone
- ref4: text

Table: product-products_fields
- productid: integer
- fieldid: integer
- value: character varying
- inserted: timestamp with time zone
- updated: timestamp with time zone

Table: product-products_products
- productid1: integer
- productid2: integer

Table: product-status-history
- id: integer
- rowid: integer
- action: integer
- reason: integer
- when_field: integer
- customer_satisfaction: integer
- added_at: timestamp with time zone

Table: product-status-history_lookup
- id: integer
- group_status: character varying
- name: character varying

Table: product_blacklist
- id: integer
- product_id: integer
- group_id: integer
- created_at: timestamp with time zone
- updated_at: timestamp with time zone
- market_id: integer

Table: product_category
- product_id: integer
- category_id: integer
- inserted: timestamp with time zone

Table: product_descriptions_updated
- id: integer
- productid: integer
- locale_id: integer
- product_type: character varying
- updated: timestamp without time zone

Table: product_keyword
- product_id: integer
- keyword_id: integer

Table: product_paint
- product_id: integer
- paint_id: integer
- visual_order: numeric

Table: product_wallpapertypes
- product_id: integer
- wallpapertype_id: integer

Table: redirects
- id: integer
- source_uri: character varying
- target_uri: character varying
- market_locale_id: integer

Table: room_types
- id: integer
- name: character varying

Table: rooms
- id: integer
- name: character varying
- room_type_id: integer
- s3_suffix: text
- poi_x: real
- poi_y: real

Table: sales
- id: integer
- sale_id: text
- name: text
- start_time: timestamp without time zone
- end_time: timestamp without time zone
- active: boolean
- discount_percent: integer
- segmentation: jsonb

Table: samples
- id: integer
- artno: character varying
- material_id: integer
- address_id: integer
- quantity: integer
- date_processed: timestamp with time zone
- status: character varying
- order_id: integer
- order_row_id: integer

Table: slideshow_slides
- id: integer
- inserted: timestamp with time zone
- visible: integer
- position: integer
- comment: text
- target_url: text
- desktop_image: text
- mobile_image: text
- tablet_image: text
- hide_resellers: integer
- name: text
- campaign: text
- market_locale_id: integer

Table: stockproducts
- id: integer
- product_id: integer
- name: text
- in_stock: boolean
- inserted: timestamp with time zone
- updated: timestamp with time zone

Table: teaser_images
- id: integer
- key: character varying

Table: temp_without_new_rooms
- interiors_id: integer
- print_id: integer
- room_id: integer
- interiors_position: integer
- room_name: text

Table: test1
- a: text

Table: test2
- id: integer
- a: text

Table: test3
- id: integer
- a: text

Table: test4
- id: integer
- a: text

Table: wallpapertypes
- id: integer
- name: character varying
