쇼핑몰 _ 오픈마켓
Magento2 sales erd
테이블 (54)
customer_entity
- entity_id — int(10) — 기본 키 — NOT NULL — Entity Id
customer_group
- customer_group_id — int(10) — 기본 키 — NOT NULL
eav_attribute
- attribute_id — smallint(5) — 기본 키 — NOT NULL — Attribute Id
sales_bestsellers_aggregated_daily
- id — int(10) — 기본 키 — NOT NULL — Id
- period — date — Period
- store_id — smallint(5) — 외래 키 → store.store_id — Store Id
- product_id — int(10) — Product Id
- product_name — varchar(255) — Product Name
- product_price — decimal(12,4) — NOT NULL — Product Price
- qty_ordered — decimal(12,4) — NOT NULL — Qty Ordered
- rating_pos — smallint(5) — NOT NULL — Rating Pos
sales_bestsellers_aggregated_monthly
- id — int(10) — 기본 키 — NOT NULL — Id
- period — date — Period
- store_id — smallint(5) — 외래 키 → store.store_id — Store Id
- product_id — int(10) — Product Id
- product_name — varchar(255) — Product Name
- product_price — decimal(12,4) — NOT NULL — Product Price
- qty_ordered — decimal(12,4) — NOT NULL — Qty Ordered
- rating_pos — smallint(5) — NOT NULL — Rating Pos
sales_bestsellers_aggregated_yearly
- id — int(10) — 기본 키 — NOT NULL — Id
- period — date — Period
- store_id — smallint(5) — 외래 키 → store.store_id — Store Id
- product_id — int(10) — Product Id
- product_name — varchar(255) — Product Name
- product_price — decimal(12,4) — NOT NULL — Product Price
- qty_ordered — decimal(12,4) — NOT NULL — Qty Ordered
- rating_pos — smallint(5) — NOT NULL — Rating Pos
sales_creditmemo
- entity_id — int(10) — 기본 키 — NOT NULL — Entity Id
- order_id — int(10) — 외래 키 → sales_order.entity_id — NOT NULL — Order Id
- store_id — smallint(5) — 외래 키 → store.store_id — Store Id
- adjustment_positive — decimal(12,4) — Adjustment Positive
- base_shipping_tax_amount — decimal(12,4) — Base Shipping Tax Amount
- store_to_order_rate — decimal(12,4) — Store To Order Rate
- base_discount_amount — decimal(12,4) — Base Discount Amount
- base_to_order_rate — decimal(12,4) — Base To Order Rate
- grand_total — decimal(12,4) — Grand Total
- base_adjustment_negative — decimal(12,4) — Base Adjustment Negative
- base_subtotal_incl_tax — decimal(12,4) — Base Subtotal Incl Tax
- shipping_amount — decimal(12,4) — Shipping Amount
- subtotal_incl_tax — decimal(12,4) — Subtotal Incl Tax
- adjustment_negative — decimal(12,4) — Adjustment Negative
- base_shipping_amount — decimal(12,4) — Base Shipping Amount
- store_to_base_rate — decimal(12,4) — Store To Base Rate
- base_to_global_rate — decimal(12,4) — Base To Global Rate
- base_adjustment — decimal(12,4) — Base Adjustment
- base_subtotal — decimal(12,4) — Base Subtotal
- discount_amount — decimal(12,4) — Discount Amount
- subtotal — decimal(12,4) — Subtotal
- adjustment — decimal(12,4) — Adjustment
- base_grand_total — decimal(12,4) — Base Grand Total
- base_adjustment_positive — decimal(12,4) — Base Adjustment Positive
- base_tax_amount — decimal(12,4) — Base Tax Amount
- shipping_tax_amount — decimal(12,4) — Shipping Tax Amount
- tax_amount — decimal(12,4) — Tax Amount
- email_sent — smallint(5) — Email Sent
- send_email — smallint(5) — Send Email
- creditmemo_status — int(11) — Creditmemo Status
- state — int(11) — State
- shipping_address_id — int(11) — Shipping Address Id
- billing_address_id — int(11) — Billing Address Id
- invoice_id — int(11) — Invoice Id
- store_currency_code — varchar(3) — Store Currency Code
- order_currency_code — varchar(3) — Order Currency Code
- base_currency_code — varchar(3) — Base Currency Code
- global_currency_code — varchar(3) — Global Currency Code
- transaction_id — varchar(255) — Transaction Id
- increment_id — varchar(50) — Increment Id
- created_at — timestamp — NOT NULL — Created At
- updated_at — timestamp — NOT NULL — Updated At
- discount_tax_compensation_amount — decimal(12,4) — Discount Tax Compensation Amount
- base_discount_tax_compensation_amount — decimal(12,4) — Base Discount Tax Compensation Amount
- shipping_discount_tax_compensation_amount — decimal(12,4) — Shipping Discount Tax Compensation Amount
- base_shipping_discount_tax_compensation_amnt — decimal(12,4) — Base Shipping Discount Tax Compensation Amount
- shipping_incl_tax — decimal(12,4) — Shipping Incl Tax
- base_shipping_incl_tax — decimal(12,4) — Base Shipping Incl Tax
- discount_description — varchar(255) — Discount Description
- customer_note — text — Customer Note
- customer_note_notify — smallint(5) — Customer Note Notify
sales_creditmemo_comment
- entity_id — int(10) — 기본 키 — NOT NULL — Entity Id
- parent_id — int(10) — 외래 키 → sales_creditmemo.entity_id — NOT NULL — Parent Id
- is_customer_notified — int(11) — Is Customer Notified
- is_visible_on_front — smallint(5) — NOT NULL — Is Visible On Front
- comment — text — Comment
- created_at — timestamp — NOT NULL — Created At
sales_creditmemo_grid
- entity_id — int(10) — 기본 키 — NOT NULL — Entity Id
- increment_id — varchar(50) — Increment Id
- created_at — timestamp — Created At
- updated_at — timestamp — Updated At
- order_id — int(10) — NOT NULL — Order Id
- order_increment_id — varchar(50) — Order Increment Id
- order_created_at — timestamp — Order Created At
- billing_name — varchar(255) — Billing Name
- state — int(11) — Status
- base_grand_total — decimal(12,4) — Base Grand Total
- order_status — varchar(32) — Order Status
- store_id — smallint(5) — Store Id
- billing_address — varchar(255) — Billing Address
- shipping_address — varchar(255) — Shipping Address
- customer_name — varchar(128) — NOT NULL — Customer Name
- customer_email — varchar(128) — Customer Email
- customer_group_id — smallint(6) — Customer Group Id
- payment_method — varchar(32) — Payment Method
- shipping_information — varchar(255) — Shipping Method Name
- subtotal — decimal(12,4) — Subtotal
- shipping_and_handling — decimal(12,4) — Shipping and handling amount
- adjustment_positive — decimal(12,4) — Adjustment Positive
- adjustment_negative — decimal(12,4) — Adjustment Negative
- order_base_grand_total — decimal(12,4) — Order Grand Total
- FULLTEXT — KEY
sales_creditmemo_item
- entity_id — int(10) — 기본 키 — NOT NULL — Entity Id
- parent_id — int(10) — 외래 키 → sales_creditmemo.entity_id — NOT NULL — Parent Id
- base_price — decimal(12,4) — Base Price
- tax_amount — decimal(12,4) — Tax Amount
- base_row_total — decimal(12,4) — Base Row Total
- discount_amount — decimal(12,4) — Discount Amount
- row_total — decimal(12,4) — Row Total
- base_discount_amount — decimal(12,4) — Base Discount Amount
- price_incl_tax — decimal(12,4) — Price Incl Tax
- base_tax_amount — decimal(12,4) — Base Tax Amount
- base_price_incl_tax — decimal(12,4) — Base Price Incl Tax
- qty — decimal(12,4) — Qty
- base_cost — decimal(12,4) — Base Cost
- price — decimal(12,4) — Price
- base_row_total_incl_tax — decimal(12,4) — Base Row Total Incl Tax
- row_total_incl_tax — decimal(12,4) — Row Total Incl Tax
- product_id — int(11) — Product Id
- order_item_id — int(11) — Order Item Id
- additional_data — text — Additional Data
- description — text — Description
- sku — varchar(255) — Sku
- name — varchar(255) — Name
- discount_tax_compensation_amount — decimal(12,4) — Discount Tax Compensation Amount
- base_discount_tax_compensation_amount — decimal(12,4) — Base Discount Tax Compensation Amount
- tax_ratio — text — Ratio of tax in the creditmemo item over tax of the order item
- weee_tax_applied — text — Weee Tax Applied
- weee_tax_applied_amount — decimal(12,4) — Weee Tax Applied Amount
- weee_tax_applied_row_amount — decimal(12,4) — Weee Tax Applied Row Amount
- weee_tax_disposition — decimal(12,4) — Weee Tax Disposition
- weee_tax_row_disposition — decimal(12,4) — Weee Tax Row Disposition
- base_weee_tax_applied_amount — decimal(12,4) — Base Weee Tax Applied Amount
- base_weee_tax_applied_row_amnt — decimal(12,4) — Base Weee Tax Applied Row Amnt
- base_weee_tax_disposition — decimal(12,4) — Base Weee Tax Disposition
- base_weee_tax_row_disposition — decimal(12,4) — Base Weee Tax Row Disposition
sales_invoice
- entity_id — int(10) — 기본 키 — NOT NULL — Entity Id
- order_id — int(10) — 외래 키 → sales_order.entity_id — NOT NULL — Order Id
- store_id — smallint(5) — 외래 키 → store.store_id — Store Id
- base_grand_total — decimal(12,4) — Base Grand Total
- shipping_tax_amount — decimal(12,4) — Shipping Tax Amount
- tax_amount — decimal(12,4) — Tax Amount
- base_tax_amount — decimal(12,4) — Base Tax Amount
- store_to_order_rate — decimal(12,4) — Store To Order Rate
- base_shipping_tax_amount — decimal(12,4) — Base Shipping Tax Amount
- base_discount_amount — decimal(12,4) — Base Discount Amount
- base_to_order_rate — decimal(12,4) — Base To Order Rate
- grand_total — decimal(12,4) — Grand Total
- shipping_amount — decimal(12,4) — Shipping Amount
- subtotal_incl_tax — decimal(12,4) — Subtotal Incl Tax
- base_subtotal_incl_tax — decimal(12,4) — Base Subtotal Incl Tax
- store_to_base_rate — decimal(12,4) — Store To Base Rate
- base_shipping_amount — decimal(12,4) — Base Shipping Amount
- total_qty — decimal(12,4) — Total Qty
- base_to_global_rate — decimal(12,4) — Base To Global Rate
- subtotal — decimal(12,4) — Subtotal
- base_subtotal — decimal(12,4) — Base Subtotal
- discount_amount — decimal(12,4) — Discount Amount
- billing_address_id — int(11) — Billing Address Id
- is_used_for_refund — smallint(5) — Is Used For Refund
- email_sent — smallint(5) — Email Sent
- send_email — smallint(5) — Send Email
- can_void_flag — smallint(5) — Can Void Flag
- state — int(11) — State
- shipping_address_id — int(11) — Shipping Address Id
- store_currency_code — varchar(3) — Store Currency Code
- transaction_id — varchar(255) — Transaction Id
- order_currency_code — varchar(3) — Order Currency Code
- base_currency_code — varchar(3) — Base Currency Code
- global_currency_code — varchar(3) — Global Currency Code
- increment_id — varchar(50) — Increment Id
- created_at — timestamp — NOT NULL — Created At
- updated_at — timestamp — NOT NULL — Updated At
- discount_tax_compensation_amount — decimal(12,4) — Discount Tax Compensation Amount
- base_discount_tax_compensation_amount — decimal(12,4) — Base Discount Tax Compensation Amount
- shipping_discount_tax_compensation_amount — decimal(12,4) — Shipping Discount Tax Compensation Amount
- base_shipping_discount_tax_compensation_amnt — decimal(12,4) — Base Shipping Discount Tax Compensation Amount
- shipping_incl_tax — decimal(12,4) — Shipping Incl Tax
- base_shipping_incl_tax — decimal(12,4) — Base Shipping Incl Tax
- base_total_refunded — decimal(12,4) — Base Total Refunded
- discount_description — varchar(255) — Discount Description
- customer_note — text — Customer Note
- customer_note_notify — smallint(5) — Customer Note Notify
sales_invoice_comment
- entity_id — int(10) — 기본 키 — NOT NULL — Entity Id
- parent_id — int(10) — 외래 키 → sales_invoice.entity_id — NOT NULL — Parent Id
- is_customer_notified — smallint(5) — Is Customer Notified
- is_visible_on_front — smallint(5) — NOT NULL — Is Visible On Front
- comment — text — Comment
- created_at — timestamp — NOT NULL — Created At
sales_invoice_grid
- entity_id — int(10) — 기본 키 — NOT NULL — Entity Id
- increment_id — varchar(50) — Increment Id
- state — int(11) — State
- store_id — smallint(5) — Store Id
- store_name — varchar(255) — Store Name
- order_id — int(10) — NOT NULL — Order Id
- order_increment_id — varchar(50) — Order Increment Id
- order_created_at — timestamp — Order Created At
- customer_name — varchar(255) — Customer Name
- customer_email — varchar(255) — Customer Email
- customer_group_id — int(11)
- payment_method — varchar(128) — Payment Method
- store_currency_code — varchar(3) — Store Currency Code
- order_currency_code — varchar(3) — Order Currency Code
- base_currency_code — varchar(3) — Base Currency Code
- global_currency_code — varchar(3) — Global Currency Code
- billing_name — varchar(255) — Billing Name
- billing_address — varchar(255) — Billing Address
- shipping_address — varchar(255) — Shipping Address
- shipping_information — varchar(255) — Shipping Method Name
- subtotal — decimal(12,4) — Subtotal
- shipping_and_handling — decimal(12,4) — Shipping and handling amount
- grand_total — decimal(12,4) — Grand Total
- base_grand_total — decimal(12,4) — Base Grand Total
- created_at — timestamp — Created At
- updated_at — timestamp — Updated At
- FULLTEXT — KEY
sales_invoice_item
- entity_id — int(10) — 기본 키 — NOT NULL — Entity Id
- parent_id — int(10) — 외래 키 → sales_invoice.entity_id — NOT NULL — Parent Id
- base_price — decimal(12,4) — Base Price
- tax_amount — decimal(12,4) — Tax Amount
- base_row_total — decimal(12,4) — Base Row Total
- discount_amount — decimal(12,4) — Discount Amount
- row_total — decimal(12,4) — Row Total
- base_discount_amount — decimal(12,4) — Base Discount Amount
- price_incl_tax — decimal(12,4) — Price Incl Tax
- base_tax_amount — decimal(12,4) — Base Tax Amount
- base_price_incl_tax — decimal(12,4) — Base Price Incl Tax
- qty — decimal(12,4) — Qty
- base_cost — decimal(12,4) — Base Cost
- price — decimal(12,4) — Price
- base_row_total_incl_tax — decimal(12,4) — Base Row Total Incl Tax
- row_total_incl_tax — decimal(12,4) — Row Total Incl Tax
- product_id — int(11) — Product Id
- order_item_id — int(11) — Order Item Id
- additional_data — text — Additional Data
- description — text — Description
- sku — varchar(255) — Sku
- name — varchar(255) — Name
- discount_tax_compensation_amount — decimal(12,4) — Discount Tax Compensation Amount
- base_discount_tax_compensation_amount — decimal(12,4) — Base Discount Tax Compensation Amount
- tax_ratio — text — Ratio of tax invoiced over tax of the order item
- weee_tax_applied — text — Weee Tax Applied
- weee_tax_applied_amount — decimal(12,4) — Weee Tax Applied Amount
- weee_tax_applied_row_amount — decimal(12,4) — Weee Tax Applied Row Amount
- weee_tax_disposition — decimal(12,4) — Weee Tax Disposition
- weee_tax_row_disposition — decimal(12,4) — Weee Tax Row Disposition
- base_weee_tax_applied_amount — decimal(12,4) — Base Weee Tax Applied Amount
- base_weee_tax_applied_row_amnt — decimal(12,4) — Base Weee Tax Applied Row Amnt
- base_weee_tax_disposition — decimal(12,4) — Base Weee Tax Disposition
- base_weee_tax_row_disposition — decimal(12,4) — Base Weee Tax Row Disposition
sales_invoiced_aggregated
- id — int(10) — 기본 키 — NOT NULL — Id
- period — date — Period
- store_id — smallint(5) — 외래 키 → store.store_id — Store Id
- order_status — varchar(50) — Order Status
- orders_count — int(11) — NOT NULL — Orders Count
- orders_invoiced — decimal(12,4) — Orders Invoiced
- invoiced — decimal(12,4) — Invoiced
- invoiced_captured — decimal(12,4) — Invoiced Captured
- invoiced_not_captured — decimal(12,4) — Invoiced Not Captured
sales_invoiced_aggregated_order
- id — int(10) — 기본 키 — NOT NULL — Id
- period — date — Period
- store_id — smallint(5) — 외래 키 → store.store_id — Store Id
- order_status — varchar(50) — NOT NULL — Order Status
- orders_count — int(11) — NOT NULL — Orders Count
- orders_invoiced — decimal(12,4) — Orders Invoiced
- invoiced — decimal(12,4) — Invoiced
- invoiced_captured — decimal(12,4) — Invoiced Captured
- invoiced_not_captured — decimal(12,4) — Invoiced Not Captured
sales_order
- entity_id — int(10) — 기본 키 — NOT NULL — Entity Id
- state — varchar(32) — State
- status — varchar(32) — Status
- coupon_code — varchar(255) — Coupon Code
- protect_code — varchar(255) — Protect Code
- shipping_description — varchar(255) — Shipping Description
- is_virtual — smallint(5) — Is Virtual
- store_id — smallint(5) — 외래 키 → store.store_id — Store Id
- customer_id — int(10) — 외래 키 → customer_entity.entity_id — Customer Id
- base_discount_amount — decimal(12,4) — Base Discount Amount
- base_discount_canceled — decimal(12,4) — Base Discount Canceled
- base_discount_invoiced — decimal(12,4) — Base Discount Invoiced
- base_discount_refunded — decimal(12,4) — Base Discount Refunded
- base_grand_total — decimal(12,4) — Base Grand Total
- base_shipping_amount — decimal(12,4) — Base Shipping Amount
- base_shipping_canceled — decimal(12,4) — Base Shipping Canceled
- base_shipping_invoiced — decimal(12,4) — Base Shipping Invoiced
- base_shipping_refunded — decimal(12,4) — Base Shipping Refunded
- base_shipping_tax_amount — decimal(12,4) — Base Shipping Tax Amount
- base_shipping_tax_refunded — decimal(12,4) — Base Shipping Tax Refunded
- base_subtotal — decimal(12,4) — Base Subtotal
- base_subtotal_canceled — decimal(12,4) — Base Subtotal Canceled
- base_subtotal_invoiced — decimal(12,4) — Base Subtotal Invoiced
- base_subtotal_refunded — decimal(12,4) — Base Subtotal Refunded
- base_tax_amount — decimal(12,4) — Base Tax Amount
- base_tax_canceled — decimal(12,4) — Base Tax Canceled
- base_tax_invoiced — decimal(12,4) — Base Tax Invoiced
- base_tax_refunded — decimal(12,4) — Base Tax Refunded
- base_to_global_rate — decimal(12,4) — Base To Global Rate
- base_to_order_rate — decimal(12,4) — Base To Order Rate
- base_total_canceled — decimal(12,4) — Base Total Canceled
- base_total_invoiced — decimal(12,4) — Base Total Invoiced
- base_total_invoiced_cost — decimal(12,4) — Base Total Invoiced Cost
- base_total_offline_refunded — decimal(12,4) — Base Total Offline Refunded
- base_total_online_refunded — decimal(12,4) — Base Total Online Refunded
- base_total_paid — decimal(12,4) — Base Total Paid
- base_total_qty_ordered — decimal(12,4) — Base Total Qty Ordered
- base_total_refunded — decimal(12,4) — Base Total Refunded
- discount_amount — decimal(12,4) — Discount Amount
- discount_canceled — decimal(12,4) — Discount Canceled
- discount_invoiced — decimal(12,4) — Discount Invoiced
- discount_refunded — decimal(12,4) — Discount Refunded
- grand_total — decimal(12,4) — Grand Total
- shipping_amount — decimal(12,4) — Shipping Amount
- shipping_canceled — decimal(12,4) — Shipping Canceled
- shipping_invoiced — decimal(12,4) — Shipping Invoiced
- shipping_refunded — decimal(12,4) — Shipping Refunded
- shipping_tax_amount — decimal(12,4) — Shipping Tax Amount
- shipping_tax_refunded — decimal(12,4) — Shipping Tax Refunded
- store_to_base_rate — decimal(12,4) — Store To Base Rate
- store_to_order_rate — decimal(12,4) — Store To Order Rate
- subtotal — decimal(12,4) — Subtotal
- subtotal_canceled — decimal(12,4) — Subtotal Canceled
- subtotal_invoiced — decimal(12,4) — Subtotal Invoiced
- subtotal_refunded — decimal(12,4) — Subtotal Refunded
- tax_amount — decimal(12,4) — Tax Amount
- tax_canceled — decimal(12,4) — Tax Canceled
- tax_invoiced — decimal(12,4) — Tax Invoiced
- tax_refunded — decimal(12,4) — Tax Refunded
- total_canceled — decimal(12,4) — Total Canceled
- … +78
sales_order_address
- entity_id — int(10) — 기본 키 — NOT NULL — Entity Id
- parent_id — int(10) — 외래 키 → sales_order.entity_id — Parent Id
- customer_address_id — int(11) — Customer Address Id
- quote_address_id — int(11) — Quote Address Id
- region_id — int(11) — Region Id
- customer_id — int(11) — Customer Id
- fax — varchar(255) — Fax
- region — varchar(255) — Region
- postcode — varchar(255) — Postcode
- lastname — varchar(255) — Lastname
- street — varchar(255) — Street
- city — varchar(255) — City
- email — varchar(255) — Email
- telephone — varchar(255) — Phone Number
- country_id — varchar(2) — Country Id
- firstname — varchar(255) — Firstname
- address_type — varchar(255) — Address Type
- prefix — varchar(255) — Prefix
- middlename — varchar(255) — Middlename
- suffix — varchar(255) — Suffix
- company — varchar(255) — Company
- vat_id — text — Vat Id
- vat_is_valid — smallint(6) — Vat Is Valid
- vat_request_id — text — Vat Request Id
- vat_request_date — text — Vat Request Date
- vat_request_success — smallint(6) — Vat Request Success
sales_order_aggregated_created
- id — int(10) — 기본 키 — NOT NULL — Id
- period — date — Period
- store_id — smallint(5) — 외래 키 → store.store_id — Store Id
- order_status — varchar(50) — NOT NULL — Order Status
- orders_count — int(11) — NOT NULL — Orders Count
- total_qty_ordered — decimal(12,4) — NOT NULL — Total Qty Ordered
- total_qty_invoiced — decimal(12,4) — NOT NULL — Total Qty Invoiced
- total_income_amount — decimal(12,4) — NOT NULL — Total Income Amount
- total_revenue_amount — decimal(12,4) — NOT NULL — Total Revenue Amount
- total_profit_amount — decimal(12,4) — NOT NULL — Total Profit Amount
- total_invoiced_amount — decimal(12,4) — NOT NULL — Total Invoiced Amount
- total_canceled_amount — decimal(12,4) — NOT NULL — Total Canceled Amount
- total_paid_amount — decimal(12,4) — NOT NULL — Total Paid Amount
- total_refunded_amount — decimal(12,4) — NOT NULL — Total Refunded Amount
- total_tax_amount — decimal(12,4) — NOT NULL — Total Tax Amount
- total_tax_amount_actual — decimal(12,4) — NOT NULL — Total Tax Amount Actual
- total_shipping_amount — decimal(12,4) — NOT NULL — Total Shipping Amount
- total_shipping_amount_actual — decimal(12,4) — NOT NULL — Total Shipping Amount Actual
- total_discount_amount — decimal(12,4) — NOT NULL — Total Discount Amount
- total_discount_amount_actual — decimal(12,4) — NOT NULL — Total Discount Amount Actual
sales_order_aggregated_updated
- id — int(10) — 기본 키 — NOT NULL — Id
- period — date — Period
- store_id — smallint(5) — 외래 키 → store.store_id — Store Id
- order_status — varchar(50) — NOT NULL — Order Status
- orders_count — int(11) — NOT NULL — Orders Count
- total_qty_ordered — decimal(12,4) — NOT NULL — Total Qty Ordered
- total_qty_invoiced — decimal(12,4) — NOT NULL — Total Qty Invoiced
- total_income_amount — decimal(12,4) — NOT NULL — Total Income Amount
- total_revenue_amount — decimal(12,4) — NOT NULL — Total Revenue Amount
- total_profit_amount — decimal(12,4) — NOT NULL — Total Profit Amount
- total_invoiced_amount — decimal(12,4) — NOT NULL — Total Invoiced Amount
- total_canceled_amount — decimal(12,4) — NOT NULL — Total Canceled Amount
- total_paid_amount — decimal(12,4) — NOT NULL — Total Paid Amount
- total_refunded_amount — decimal(12,4) — NOT NULL — Total Refunded Amount
- total_tax_amount — decimal(12,4) — NOT NULL — Total Tax Amount
- total_tax_amount_actual — decimal(12,4) — NOT NULL — Total Tax Amount Actual
- total_shipping_amount — decimal(12,4) — NOT NULL — Total Shipping Amount
- total_shipping_amount_actual — decimal(12,4) — NOT NULL — Total Shipping Amount Actual
- total_discount_amount — decimal(12,4) — NOT NULL — Total Discount Amount
- total_discount_amount_actual — decimal(12,4) — NOT NULL — Total Discount Amount Actual
sales_order_grid
- entity_id — int(10) — 기본 키 — NOT NULL — Entity Id
- status — varchar(32) — Status
- store_id — smallint(5) — Store Id
- store_name — varchar(255) — Store Name
- customer_id — int(10) — Customer Id
- base_grand_total — decimal(12,4) — Base Grand Total
- base_total_paid — decimal(12,4) — Base Total Paid
- grand_total — decimal(12,4) — Grand Total
- total_paid — decimal(12,4) — Total Paid
- increment_id — varchar(50) — Increment Id
- base_currency_code — varchar(3) — Base Currency Code
- order_currency_code — varchar(255) — Order Currency Code
- shipping_name — varchar(255) — Shipping Name
- billing_name — varchar(255) — Billing Name
- created_at — timestamp — Created At
- updated_at — timestamp — Updated At
- billing_address — varchar(255) — Billing Address
- shipping_address — varchar(255) — Shipping Address
- shipping_information — varchar(255) — Shipping Method Name
- customer_email — varchar(255) — Customer Email
- customer_group — varchar(255) — Customer Group
- subtotal — decimal(12,4) — Subtotal
- shipping_and_handling — decimal(12,4) — Shipping and handling amount
- customer_name — varchar(255) — Customer Name
- payment_method — varchar(255) — Payment Method
- total_refunded — decimal(12,4) — Total Refunded
- FULLTEXT — KEY
sales_order_item
- item_id — int(10) — 기본 키 — NOT NULL — Item Id
- order_id — int(10) — 외래 키 → sales_order.entity_id — NOT NULL — Order Id
- parent_item_id — int(10) — Parent Item Id
- quote_item_id — int(10) — Quote Item Id
- store_id — smallint(5) — 외래 키 → store.store_id — Store Id
- created_at — timestamp — NOT NULL — Created At
- updated_at — timestamp — NOT NULL — Updated At
- product_id — int(10) — Product Id
- product_type — varchar(255) — Product Type
- product_options — text — Product Options
- weight — decimal(12,4) — Weight
- is_virtual — smallint(5) — Is Virtual
- sku — varchar(255) — Sku
- name — varchar(255) — Name
- description — text — Description
- applied_rule_ids — text — Applied Rule Ids
- additional_data — text — Additional Data
- is_qty_decimal — smallint(5) — Is Qty Decimal
- no_discount — smallint(5) — NOT NULL — No Discount
- qty_backordered — decimal(12,4) — Qty Backordered
- qty_canceled — decimal(12,4) — Qty Canceled
- qty_invoiced — decimal(12,4) — Qty Invoiced
- qty_ordered — decimal(12,4) — Qty Ordered
- qty_refunded — decimal(12,4) — Qty Refunded
- qty_shipped — decimal(12,4) — Qty Shipped
- base_cost — decimal(12,4) — Base Cost
- price — decimal(12,4) — NOT NULL — Price
- base_price — decimal(12,4) — NOT NULL — Base Price
- original_price — decimal(12,4) — Original Price
- base_original_price — decimal(12,4) — Base Original Price
- tax_percent — decimal(12,4) — Tax Percent
- tax_amount — decimal(12,4) — Tax Amount
- base_tax_amount — decimal(12,4) — Base Tax Amount
- tax_invoiced — decimal(12,4) — Tax Invoiced
- base_tax_invoiced — decimal(12,4) — Base Tax Invoiced
- discount_percent — decimal(12,4) — Discount Percent
- discount_amount — decimal(12,4) — Discount Amount
- base_discount_amount — decimal(12,4) — Base Discount Amount
- discount_invoiced — decimal(12,4) — Discount Invoiced
- base_discount_invoiced — decimal(12,4) — Base Discount Invoiced
- amount_refunded — decimal(12,4) — Amount Refunded
- base_amount_refunded — decimal(12,4) — Base Amount Refunded
- row_total — decimal(12,4) — NOT NULL — Row Total
- base_row_total — decimal(12,4) — NOT NULL — Base Row Total
- row_invoiced — decimal(12,4) — NOT NULL — Row Invoiced
- base_row_invoiced — decimal(12,4) — NOT NULL — Base Row Invoiced
- row_weight — decimal(12,4) — Row Weight
- base_tax_before_discount — decimal(12,4) — Base Tax Before Discount
- tax_before_discount — decimal(12,4) — Tax Before Discount
- ext_order_item_id — varchar(255) — Ext Order Item Id
- locked_do_invoice — smallint(5) — Locked Do Invoice
- locked_do_ship — smallint(5) — Locked Do Ship
- price_incl_tax — decimal(12,4) — Price Incl Tax
- base_price_incl_tax — decimal(12,4) — Base Price Incl Tax
- row_total_incl_tax — decimal(12,4) — Row Total Incl Tax
- base_row_total_incl_tax — decimal(12,4) — Base Row Total Incl Tax
- discount_tax_compensation_amount — decimal(12,4) — Discount Tax Compensation Amount
- base_discount_tax_compensation_amount — decimal(12,4) — Base Discount Tax Compensation Amount
- discount_tax_compensation_invoiced — decimal(12,4) — Discount Tax Compensation Invoiced
- base_discount_tax_compensation_invoiced — decimal(12,4) — Base Discount Tax Compensation Invoiced
- … +20
sales_order_payment
- entity_id — int(10) — 기본 키 — NOT NULL — Entity Id
- parent_id — int(10) — 외래 키 → sales_order.entity_id — NOT NULL — Parent Id
- base_shipping_captured — decimal(12,4) — Base Shipping Captured
- shipping_captured — decimal(12,4) — Shipping Captured
- amount_refunded — decimal(12,4) — Amount Refunded
- base_amount_paid — decimal(12,4) — Base Amount Paid
- amount_canceled — decimal(12,4) — Amount Canceled
- base_amount_authorized — decimal(12,4) — Base Amount Authorized
- base_amount_paid_online — decimal(12,4) — Base Amount Paid Online
- base_amount_refunded_online — decimal(12,4) — Base Amount Refunded Online
- base_shipping_amount — decimal(12,4) — Base Shipping Amount
- shipping_amount — decimal(12,4) — Shipping Amount
- amount_paid — decimal(12,4) — Amount Paid
- amount_authorized — decimal(12,4) — Amount Authorized
- base_amount_ordered — decimal(12,4) — Base Amount Ordered
- base_shipping_refunded — decimal(12,4) — Base Shipping Refunded
- shipping_refunded — decimal(12,4) — Shipping Refunded
- base_amount_refunded — decimal(12,4) — Base Amount Refunded
- amount_ordered — decimal(12,4) — Amount Ordered
- base_amount_canceled — decimal(12,4) — Base Amount Canceled
- quote_payment_id — int(11) — Quote Payment Id
- additional_data — text — Additional Data
- cc_exp_month — varchar(12) — Cc Exp Month
- cc_ss_start_year — varchar(12) — Cc Ss Start Year
- echeck_bank_name — varchar(128) — Echeck Bank Name
- method — varchar(128) — Method
- cc_debug_request_body — varchar(32) — Cc Debug Request Body
- cc_secure_verify — varchar(32) — Cc Secure Verify
- protection_eligibility — varchar(32) — Protection Eligibility
- cc_approval — varchar(32) — Cc Approval
- cc_last_4 — varchar(100) — Cc Last 4
- cc_status_description — varchar(32) — Cc Status Description
- echeck_type — varchar(32) — Echeck Type
- cc_debug_response_serialized — varchar(32) — Cc Debug Response Serialized
- cc_ss_start_month — varchar(128) — Cc Ss Start Month
- echeck_account_type — varchar(255) — Echeck Account Type
- last_trans_id — varchar(32) — Last Trans Id
- cc_cid_status — varchar(32) — Cc Cid Status
- cc_owner — varchar(128) — Cc Owner
- cc_type — varchar(32) — Cc Type
- po_number — varchar(32) — Po Number
- cc_exp_year — varchar(4) — Cc Exp Year
- cc_status — varchar(4) — Cc Status
- echeck_routing_number — varchar(32) — Echeck Routing Number
- account_status — varchar(32) — Account Status
- anet_trans_method — varchar(32) — Anet Trans Method
- cc_debug_response_body — varchar(32) — Cc Debug Response Body
- cc_ss_issue — varchar(32) — Cc Ss Issue
- echeck_account_name — varchar(32) — Echeck Account Name
- cc_avs_status — varchar(32) — Cc Avs Status
- cc_number_enc — varchar(128)
- cc_trans_id — varchar(32) — Cc Trans Id
- address_status — varchar(32) — Address Status
- additional_information — text — Additional Information
sales_order_status
- status — varchar(32) — 기본 키 — NOT NULL — Status
- label — varchar(128) — NOT NULL — Label
sales_order_status_history
- entity_id — int(10) — 기본 키 — NOT NULL — Entity Id
- parent_id — int(10) — 외래 키 → sales_order.entity_id — NOT NULL — Parent Id
- is_customer_notified — int(11) — Is Customer Notified
- is_visible_on_front — smallint(5) — NOT NULL — Is Visible On Front
- comment — text — Comment
- status — varchar(32) — Status
- created_at — timestamp — NOT NULL — Created At
- entity_name — varchar(32) — Shows what entity history is bind to.
sales_order_status_label
- status — varchar(32) — 외래 키 → sales_order_status.status — NOT NULL — Status
- store_id — smallint(5) — 외래 키 → store.store_id — NOT NULL — Store Id
- label — varchar(128) — NOT NULL — Label
sales_order_status_state
- state — varchar(32) — 기본 키 — NOT NULL — Label
- status — varchar(32) — 외래 키 → sales_order_status.status — NOT NULL — Status
- is_default — smallint(5) — NOT NULL — Is Default
- visible_on_front — smallint(5) — NOT NULL — Visible on front
sales_order_tax
- tax_id — int(10) — 기본 키 — NOT NULL — Tax Id
- order_id — int(10) — NOT NULL — Order Id
- code — varchar(255) — Code
- title — varchar(255) — Title
- percent — decimal(12,4) — Percent
- amount — decimal(12,4) — Amount
- priority — int(11) — NOT NULL — Priority
- position — int(11) — NOT NULL — Position
- base_amount — decimal(12,4) — Base Amount
- process — smallint(6) — NOT NULL — Process
- base_real_amount — decimal(12,4) — Base Real Amount
sales_order_tax_item
- tax_item_id — int(10) — 기본 키 — NOT NULL — Tax Item Id
- tax_id — int(10) — 외래 키 → sales_order_tax.tax_id — NOT NULL — Tax Id
- item_id — int(10) — 외래 키 → sales_order_item.item_id — Item Id
- tax_percent — decimal(12,4) — NOT NULL — Real Tax Percent For Item
- amount — decimal(12,4) — NOT NULL — Tax amount for the item and tax rate
- base_amount — decimal(12,4) — NOT NULL — Base tax amount for the item and tax rate
- real_amount — decimal(12,4) — NOT NULL — Real tax amount for the item and tax rate
- real_base_amount — decimal(12,4) — NOT NULL — Real base tax amount for the item and tax rate
- associated_item_id — int(10) — 외래 키 → sales_order_item.item_id — Id of the associated item
- taxable_item_type — varchar(32) — NOT NULL — Type of the taxable item
sales_payment_transaction
- transaction_id — int(10) — 기본 키 — NOT NULL — Transaction Id
- order_id — int(10) — 외래 키 → sales_order.entity_id — NOT NULL — Order Id
- payment_id — int(10) — 외래 키 → sales_order_payment.entity_id — NOT NULL — Payment Id
- parent_id — int(10) — 외래 키 → sales_payment_transaction.transaction_id — Parent Id
- txn_id — varchar(100) — Txn Id
- parent_txn_id — varchar(100) — Parent Txn Id
- txn_type — varchar(15) — Txn Type
- is_closed — smallint(5) — NOT NULL — Is Closed
- additional_information — blob — Additional Information
- created_at — timestamp — NOT NULL — Created At
sales_refunded_aggregated
- id — int(10) — 기본 키 — NOT NULL — Id
- period — date — Period
- store_id — smallint(5) — 외래 키 → store.store_id — Store Id
- order_status — varchar(50) — NOT NULL — Order Status
- orders_count — int(11) — NOT NULL — Orders Count
- refunded — decimal(12,4) — Refunded
- online_refunded — decimal(12,4) — Online Refunded
- offline_refunded — decimal(12,4) — Offline Refunded
sales_refunded_aggregated_order
- id — int(10) — 기본 키 — NOT NULL — Id
- period — date — Period
- store_id — smallint(5) — 외래 키 → store.store_id — Store Id
- order_status — varchar(50) — Order Status
- orders_count — int(11) — NOT NULL — Orders Count
- refunded — decimal(12,4) — Refunded
- online_refunded — decimal(12,4) — Online Refunded
- offline_refunded — decimal(12,4) — Offline Refunded
sales_sequence_meta
- meta_id — int(10) — 기본 키 — NOT NULL — Id
- entity_type — varchar(32) — NOT NULL — Prefix
- store_id — smallint(5) — NOT NULL — Store Id
- sequence_table — varchar(32) — NOT NULL — table for sequence
sales_sequence_profile
- profile_id — int(10) — 기본 키 — NOT NULL — Id
- meta_id — int(10) — 외래 키 → sales_sequence_meta.meta_id — NOT NULL — Meta_id
- prefix — varchar(32) — Prefix
- suffix — varchar(32) — Suffix
- start_value — int(10) — NOT NULL — Start value for sequence
- step — int(10) — NOT NULL — Step for sequence
- max_value — int(10) — NOT NULL — MaxValue for sequence
- warning_value — int(10) — NOT NULL — WarningValue for sequence
- is_active — tinyint(1) — NOT NULL — isActive flag
sales_shipment
- entity_id — int(10) — 기본 키 — NOT NULL — Entity Id
- order_id — int(10) — 외래 키 → sales_order.entity_id — NOT NULL — Order Id
- store_id — smallint(5) — 외래 키 → store.store_id — Store Id
- total_weight — decimal(12,4) — Total Weight
- total_qty — decimal(12,4) — Total Qty
- email_sent — smallint(5) — Email Sent
- send_email — smallint(5) — Send Email
- customer_id — int(11) — Customer Id
- shipping_address_id — int(11) — Shipping Address Id
- billing_address_id — int(11) — Billing Address Id
- shipment_status — int(11) — Shipment Status
- increment_id — varchar(50) — Increment Id
- created_at — timestamp — NOT NULL — Created At
- updated_at — timestamp — NOT NULL — Updated At
- packages — text — Packed Products in Packages
- shipping_label — mediumblob — Shipping Label Content
- customer_note — text — Customer Note
- customer_note_notify — smallint(5) — Customer Note Notify
sales_shipment_comment
- entity_id — int(10) — 기본 키 — NOT NULL — Entity Id
- parent_id — int(10) — 외래 키 → sales_shipment.entity_id — NOT NULL — Parent Id
- is_customer_notified — int(11) — Is Customer Notified
- is_visible_on_front — smallint(5) — NOT NULL — Is Visible On Front
- comment — text — Comment
- created_at — timestamp — NOT NULL — Created At
sales_shipment_grid
- entity_id — int(10) — 기본 키 — NOT NULL — Entity Id
- increment_id — varchar(50) — Increment Id
- store_id — smallint(5) — Store Id
- order_increment_id — varchar(32) — NOT NULL — Order Increment Id
- order_id — int(10) — NOT NULL — Order Id
- order_created_at — timestamp — NOT NULL — Order Increment Id
- customer_name — varchar(128) — NOT NULL — Customer Name
- total_qty — decimal(12,4) — Total Qty
- shipment_status — int(11) — Shipment Status
- order_status — varchar(32) — Order
- billing_address — varchar(255) — Billing Address
- shipping_address — varchar(255) — Shipping Address
- billing_name — varchar(128) — Billing Name
- shipping_name — varchar(128) — Shipping Name
- customer_email — varchar(128) — Customer Email
- customer_group_id — int(11)
- payment_method — varchar(32) — Payment Method
- shipping_information — varchar(255) — Shipping Method Name
- created_at — timestamp — Created At
- updated_at — timestamp — Updated At
- FULLTEXT — KEY
sales_shipment_item
- entity_id — int(10) — 기본 키 — NOT NULL — Entity Id
- parent_id — int(10) — 외래 키 → sales_shipment.entity_id — NOT NULL — Parent Id
- row_total — decimal(12,4) — Row Total
- price — decimal(12,4) — Price
- weight — decimal(12,4) — Weight
- qty — decimal(12,4) — Qty
- product_id — int(11) — Product Id
- order_item_id — int(11) — Order Item Id
- additional_data — text — Additional Data
- description — text — Description
- name — varchar(255) — Name
- sku — varchar(255) — Sku
sales_shipment_track
- entity_id — int(10) — 기본 키 — NOT NULL — Entity Id
- parent_id — int(10) — 외래 키 → sales_shipment.entity_id — NOT NULL — Parent Id
- weight — decimal(12,4) — Weight
- qty — decimal(12,4) — Qty
- order_id — int(10) — NOT NULL — Order Id
- track_number — text — Number
- description — text — Description
- title — varchar(255) — Title
- carrier_code — varchar(32) — Carrier Code
- created_at — timestamp — NOT NULL — Created At
- updated_at — timestamp — NOT NULL — Updated At
sales_shipping_aggregated
- id — int(10) — 기본 키 — NOT NULL — Id
- period — date — Period
- store_id — smallint(5) — 외래 키 → store.store_id — Store Id
- order_status — varchar(50) — Order Status
- shipping_description — varchar(255) — Shipping Description
- orders_count — int(11) — NOT NULL — Orders Count
- total_shipping — decimal(12,4) — Total Shipping
- total_shipping_actual — decimal(12,4) — Total Shipping Actual
sales_shipping_aggregated_order
- id — int(10) — 기본 키 — NOT NULL — Id
- period — date — Period
- store_id — smallint(5) — 외래 키 → store.store_id — Store Id
- order_status — varchar(50) — Order Status
- shipping_description — varchar(255) — Shipping Description
- orders_count — int(11) — NOT NULL — Orders Count
- total_shipping — decimal(12,4) — Total Shipping
- total_shipping_actual — decimal(12,4) — Total Shipping Actual
salesrule
- rule_id — int(10) — 기본 키 — NOT NULL — Rule Id
- name — varchar(255) — Name
- description — text — Description
- from_date — date — From
- to_date — date — To
- uses_per_customer — int(11) — NOT NULL — Uses Per Customer
- is_active — smallint(6) — NOT NULL — Is Active
- conditions_serialized — mediumtext — Conditions Serialized
- actions_serialized — mediumtext — Actions Serialized
- stop_rules_processing — smallint(6) — NOT NULL — Stop Rules Processing
- is_advanced — smallint(5) — NOT NULL — Is Advanced
- product_ids — text — Product Ids
- sort_order — int(10) — NOT NULL — Sort Order
- simple_action — varchar(32) — Simple Action
- discount_amount — decimal(12,4) — NOT NULL — Discount Amount
- discount_qty — decimal(12,4) — Discount Qty
- discount_step — int(10) — NOT NULL — Discount Step
- apply_to_shipping — smallint(5) — NOT NULL — Apply To Shipping
- times_used — int(10) — NOT NULL — Times Used
- is_rss — smallint(6) — NOT NULL — Is Rss
- coupon_type — smallint(5) — NOT NULL — Coupon Type
- use_auto_generation — smallint(6) — NOT NULL — Use Auto Generation
- uses_per_coupon — int(11) — NOT NULL — User Per Coupon
- simple_free_shipping — smallint(6)
salesrule_coupon
- coupon_id — int(10) — 기본 키 — NOT NULL — Coupon Id
- rule_id — int(10) — 외래 키 → salesrule.rule_id — NOT NULL — Rule Id
- code — varchar(255) — Code
- usage_limit — int(10) — Usage Limit
- usage_per_customer — int(10) — Usage Per Customer
- times_used — int(10) — NOT NULL — Times Used
- expiration_date — timestamp — Expiration Date
- is_primary — smallint(5) — Is Primary
- created_at — timestamp — Coupon Code Creation Date
- type — smallint(6) — Coupon Code Type
salesrule_coupon_aggregated
- id — int(10) — 기본 키 — NOT NULL — Id
- period — date — NOT NULL — Period
- store_id — smallint(5) — 외래 키 → store.store_id — Store Id
- order_status — varchar(50) — Order Status
- coupon_code — varchar(50) — Coupon Code
- coupon_uses — int(11) — NOT NULL — Coupon Uses
- subtotal_amount — decimal(12,4) — NOT NULL — Subtotal Amount
- discount_amount — decimal(12,4) — NOT NULL — Discount Amount
- total_amount — decimal(12,4) — NOT NULL — Total Amount
- subtotal_amount_actual — decimal(12,4) — NOT NULL — Subtotal Amount Actual
- discount_amount_actual — decimal(12,4) — NOT NULL — Discount Amount Actual
- total_amount_actual — decimal(12,4) — NOT NULL — Total Amount Actual
- rule_name — varchar(255) — Rule Name
salesrule_coupon_aggregated_order
- id — int(10) — 기본 키 — NOT NULL — Id
- period — date — NOT NULL — Period
- store_id — smallint(5) — 외래 키 → store.store_id — Store Id
- order_status — varchar(50) — Order Status
- coupon_code — varchar(50) — Coupon Code
- coupon_uses — int(11) — NOT NULL — Coupon Uses
- subtotal_amount — decimal(12,4) — NOT NULL — Subtotal Amount
- discount_amount — decimal(12,4) — NOT NULL — Discount Amount
- total_amount — decimal(12,4) — NOT NULL — Total Amount
- rule_name — varchar(255) — Rule Name
salesrule_coupon_aggregated_updated
- id — int(10) — 기본 키 — NOT NULL — Id
- period — date — NOT NULL — Period
- store_id — smallint(5) — 외래 키 → store.store_id — Store Id
- order_status — varchar(50) — Order Status
- coupon_code — varchar(50) — Coupon Code
- coupon_uses — int(11) — NOT NULL — Coupon Uses
- subtotal_amount — decimal(12,4) — NOT NULL — Subtotal Amount
- discount_amount — decimal(12,4) — NOT NULL — Discount Amount
- total_amount — decimal(12,4) — NOT NULL — Total Amount
- subtotal_amount_actual — decimal(12,4) — NOT NULL — Subtotal Amount Actual
- discount_amount_actual — decimal(12,4) — NOT NULL — Discount Amount Actual
- total_amount_actual — decimal(12,4) — NOT NULL — Total Amount Actual
- rule_name — varchar(255) — Rule Name
salesrule_coupon_usage
- coupon_id — int(10) — 외래 키 → salesrule_coupon.coupon_id — NOT NULL — Coupon Id
- customer_id — int(10) — 외래 키 → customer_entity.entity_id — NOT NULL — Customer Id
- times_used — int(10) — NOT NULL — Times Used
salesrule_customer
- rule_customer_id — int(10) — 기본 키 — NOT NULL — Rule Customer Id
- customer_id — int(10) — 외래 키 → customer_entity.entity_id — NOT NULL — Customer Id
- rule_id — int(10) — 외래 키 → salesrule.rule_id — NOT NULL — Rule Id
- times_used — smallint(5) — NOT NULL — Times Used
salesrule_customer_group
- customer_group_id — int(10) — 외래 키 → customer_group.customer_group_id — NOT NULL — Customer Group Id
- rule_id — int(10) — 외래 키 → salesrule.rule_id — NOT NULL — Rule Id
salesrule_label
- label_id — int(10) — 기본 키 — NOT NULL — Label Id
- rule_id — int(10) — 외래 키 → salesrule.rule_id — NOT NULL — Rule Id
- store_id — smallint(5) — 외래 키 → store.store_id — NOT NULL — Store Id
- label — varchar(255) — Label
salesrule_product_attribute
- attribute_id — smallint(5) — 외래 키 → eav_attribute.attribute_id — NOT NULL — Attribute Id
- customer_group_id — int(10) — 외래 키 → customer_group.customer_group_id — NOT NULL — Customer Group Id
- rule_id — int(10) — 외래 키 → salesrule.rule_id — NOT NULL — Rule Id
- website_id — smallint(5) — 외래 키 → store_website.website_id — NOT NULL — Website Id
salesrule_website
- rule_id — int(10) — 외래 키 → salesrule.rule_id — NOT NULL — Rule Id
- website_id — smallint(5) — 외래 키 → store_website.website_id — NOT NULL — Website Id
store
- store_id — smallint(5) — 기본 키 — NOT NULL — Store Id
store_website
- website_id — smallint(5) — 기본 키 — NOT NULL — Website Id