shop1
Tables (35)
admin
- id — int — Primary key — NOT NULL
- username — varchar(50) — NOT NULL
- password — varchar(255) — NOT NULL
- type — enum('admin', 'master') — NOT NULL — Member type (master: cannot be deleted)
- active — enum('Y', 'N') — NOT NULL — Whether the administrator is active
- verify_password — varchar(255) — NOT NULL
- name — varchar(50) — NOT NULL
- phone — varchar(20) — NOT NULL
- email — varchar(255) — NOT NULL
- job_title — varchar(50)
- department — varchar(50)
- reg_admin_id — varchar(50) — Registered Administrator
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
banner
- id — int — Primary key — NOT NULL
- location — varchar(100) — NOT NULL — Position value
- img — varchar(100)
- link — varchar(200)
- target — enum('NONE', 'SELF', 'BLANK') — NOT NULL
- view — enum('Y', 'N') — NOT NULL
- title — varchar(255)
- info — varchar(255)
- sub_info — varchar(255)
- idx — int — NOT NULL
- none_limit — enum('Y', 'N') — NOT NULL
- color — varchar(10)
- site_skin — varchar(100) — NOT NULL
- start_date — date
- end_date — date
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
brand
- id — int — Primary key — NOT NULL
- name — varchar(50) — NOT NULL
- view — enum('Y', 'N') — Display or not
- img — varchar(50)
- depth — tinyint — Brand depth, starting from 1
- idx — int — Brand order, valid only with the same parent brand
- parent — int
- product_count — int
- prefix_str — varchar(10) — brand initial information
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
cart
- id — int — Primary key — NOT NULL
- member_id — varchar(255) — Foreign key → member.id — NOT NULL
- product_id — int — Foreign key → product.id — NOT NULL
- is_addoption — enum('Y','N') — NOT NULL
- option1_id — int — Foreign key → product_option.id
- option2_id — int — Foreign key → product_option.id
- option3_id — int — Foreign key → product_option.id
- addoption1_id — int — Foreign key → product_addoption.id
- addoption2_id — int — Foreign key → product_addoption.id
- quantity — int
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
- INDEX — `member_id`(`member_id`)
- INDEX — `product_id`(`product_id`)
- INDEX — `option1_id`(`option1_id`)
- INDEX — `option2_id`(`option2_id`)
- INDEX — `option3_id`(`option3_id`)
- INDEX — `addoption1_id`(`addoption1_id`)
- INDEX — `addoption2_id`(`addoption2_id`)
category
- id — int — Primary key — NOT NULL
- name — varchar(50) — NOT NULL
- view — enum('Y', 'N') — Display or not
- img — varchar(50)
- img_on — varchar(50) — Category image (on mouse over)
- img_top_banner — varchar(50)
- depth — tinyint — Category depth, starting from 1
- idx — int — Category order, valid only with the same parent category
- parent — int — Foreign key → category.id
- product_count — int
- img_top_banner_target — enum('NONE', 'SELF', 'BLANK') — Category Banner link target
- img_top_banner_link — varchar(200)
- img_top_banner_use — enum('Y', 'N') — Whether the top banner is activated
- img_top_mobile_banner — varchar(200)
- img_top_mobile_banner_target — enum('NONE', 'SELF', 'BLANK') — Category Banner Link Target (mobile)
- img_top_mobile_banner_link — varchar(200)
- img_top_mobile_banner_use — enum('Y', 'N') — Whether to use category banners (mobile)
- best_product_view — enum('Y', 'N') — Best exposure
- best_product_display — int
- best_product_mobile_view — enum('Y', 'N') — Best exposure (mobile)
- best_product_mobile_display — int
- list_product_view — enum('Y', 'N') — Whether the list is exposed
- list_product_display — int
- list_product_mobile_view — enum('Y', 'N') — List exposure (mobile)
- list_product_mobile_display — int
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
- INDEX — `parent`(`parent`)
common_option
- id — int — Primary key — NOT NULL
- common_option_set_id — int — NOT NULL
- name — varchar(200) — NOT NULL
- stock — int — NOT NULL
- price — int — NOT NULL
- supply_price — int — NOT NULL
- depth — tinyint — NOT NULL
- parent — int — Foreign key → common_option.id
- view — enum('Y', 'N') — NOT NULL
- sort — int — NOT NULL
- color_type — enum('color', 'img', '')
- color_name — varchar(50) — Designated value according to color_type - colorpicker in case of color, file name in case of img
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
- INDEX — `parent`(`parent`)
common_option_set
- id — int — Primary key — NOT NULL
- name — varchar(255) — NOT NULL — Common option set name
- type — enum('option', 'addoption') — NOT NULL — Common option set types (options, additional options)
- depth — tinyint — NOT NULL — The depth of option of common option set
- option1_type — enum('normal', 'color', 'size') — 1st option type ( normal, size, color )
- option2_type — enum('normal', 'color', 'size') — 2nd option type ( normal, size, color )
- option3_type — enum('normal', 'color', 'size') — 3rd option type ( normal, size, color )
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
company
- id — varchar(50) — Primary key — NOT NULL
- password — varchar(255) — NOT NULL
- name — varchar(100) — NOT NULL
- email — varchar(50) — NOT NULL
- number — varchar(20) — business number
- snumber — varchar(50) — store company mail order number
- ceo_name — varchar(30) — representative name
- address — varchar(100) — NOT NULL
- item1 — varchar(50) — business condition
- item2 — varchar(50) — sectors
- charge — varchar(50) — manager
- tel — varchar(20) — NOT NULL
- tel2 — varchar(20)
- fax — varchar(50)
- delivery_use — enum('Y', 'N') — NOT NULL — whether to use product shipping policy
- delivery_price — int — shipping information - basic shipping cost
- delivery_free_price — int — shipping information - free shipping
- delivery_company — varchar(50)
- delivery_date — varchar(50)
- delivery_complain_price — varchar(100) — return/exchange shipping cost
- delivery_return_address — varchar(100)
- delivery_add_price_use — enum('Y', 'N') — NOT NULL — whether additional shipping cost is applied
- delivery_add_price_use_normal — enum('Y', 'N') — NOT NULL — whether or not additional shipping cost is applied when free shipping is applied by purchasing a product with more than…
- delivery_add_price_use_unit — enum('Y', 'N') — NOT NULL — whether additional shipping costs apply to individual delivery products
- delivery_add_price_use_free — enum('Y', 'N') — NOT NULL — whether additional shipping charges apply to free shipping products
- vat_delivery — enum('Y', 'N') — NOT NULL — Whether or not to set additional tax for shipping costs
- homepage — varchar(100)
- complain_ok — text — 교환/반품/환불이 가능한 경우
- complain_fail — text — when exchange/return/refund is not possible
- shop_view — enum('Y', 'N') — NOT NULL — minishop exposure settings
- shop_use_content — enum('Y', 'N') — NOT NULL — PC, MOBILE mini shop introduction together
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
company_shop
- company_id — varchar(255) — Foreign key → company.id — NOT NULL
- idx — int — exposure ranking
- sort_idx — decimal(8, 1) — rank within priority group
- sort_group — int — priority group
- shop_ceo — varchar(50) — mini shop representative name
- shop_name — varchar(100)
- shop_tel — varchar(20)
- shop_email — varchar(50)
- shop_address — varchar(100)
- shop_cs — text — mini shop hours of operation
- shop_info — text
- shop_img_logo — varchar(100)
- shop_img_list — varchar(100)
- shop_img_banner_pc — varchar(100)
- shop_img_banner_mo — varchar(100)
- shop_type — varchar(100)
coupon_set
- id — int — Primary key — NOT NULL
- name — varchar(30) — NOT NULL
- description — varchar(255)
- type — enum('order', 'delivery')
- dtype — enum('price', 'per') — Loại số lượng phiếu thưởng
- price — int
- per — decimal(3, 1)
- issued_type — enum('manual', 'auto')
- issued_type_auto — int — 1: First purchase/payment completed, 2: Purchase/Payment Complete, 3: Happy Birthday , 4: Join The Membership
- price_max — int
- price_max_use — enum('Y', 'N')
- product_code — varchar(20)
- currency — enum('KR', 'US')
- limit — int
- use_date_type — enum('date', 'expire')
- expire — int
- start_date — date
- end_date — date
- benefit_type — enum('discount', 'save', 'delivery')
- issued_limit_type — enum('limit', 'no_limit')
- issued_limit_value — int
- issued_duplicate_type — enum('Y', 'N')
- issued_group — varchar(255)
- duplicate_use — enum('Y', 'N')
- view — enum('Y', 'N')
- log — varchar(255)
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
delivery_addprice
- id — int — Primary key — NOT NULL
- address — varchar(255) — NOT NULL
- price — int
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
display_main_product
- id — int — Primary key — NOT NULL
- product_id — int — Foreign key → product.id — NOT NULL
- display_main_set_id — int — Foreign key → display_main_set.id — NOT NULL
- created_at — datetime
- updated_at — datetime
- INDEX — `display_main_set_id`(`display_main_set_id`)
display_main_set
- id — int — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- view — enum('Y','N') — NOT NULL
- idx — int — NOT NULL
- list_product_view — enum('Y','N') — NOT NULL
- list_product_mobile_view — enum('Y','N') — NOT NULL
- list_product_display — int — NOT NULL
- list_product_mobile_display — int — NOT NULL
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
member
- id — varchar(30) — Primary key — NOT NULL
- password — varchar(255) — NOT NULL
- name — varchar(30) — NOT NULL
- staff — char(10)
- birthday — date
- sex — enum('MALE', 'FEMALE')
- email — varchar(50) — NOT NULL
- tel — varchar(20) — Phone call
- tel2 — varchar(20) — NOT NULL — Cell phone
- zip1 — char(3)
- zip2 — char(3)
- zone_code — varchar(10) — National Basic Area No
- address1 — varchar(255)
- address2 — varchar(255)
- address_doro — varchar(255) — Street name address
- email_send — enum('Y', 'N') — Whether to receive e-mail
- sms_send — enum('Y', 'N') — Whether to receive text messages
- last_login_date — datetime
- withdraw_type — varchar(10) — Withdrawal type (member, admin) - member, administrator
- withdraw_status — enum('Y', 'N') — Withdrawal status - if Y is withdrawn
- withdraw_date — datetime — Membership withdrawal date
- ip — varchar(20)
- point — int — Member Owned Points
- user_level — int — Membership Level - General Members:2 , Administrators:9
- sleep_type — enum('Y', 'N') — Dormant transition type
- sleep_request — enum('Y', 'N') — Request to be authenticated when logging in if the member is dormant (Y: Cancel dormancy when logging in, N move to the…
- password_change_date — datetime
- cancel_bank — varchar(100) — Refund bank
- cancel_bank_name — varchar(100) — Refund account holder
- cancel_bank_account — varchar(100) — Refund account number
- division — enum('I', 'B') — Membership Classification Individual Member/Business Member (I: Individual Member, B: Business Member - Basic I)
- join_ua — enum('PC', 'MOBILE') — Device connected when signing up
- auth — enum('Y', 'N') — NOT NULL — Approval
- auth_date — datetime — Approved & Unapproved Last Change Date
- msg_uid — int — Group unique number
- msg_uid_old — int — previous order level
- msg_date — datetime — Membership Level Last Renewed Date
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
member-group-set
- id — int — Primary key — NOT NULL
- rank — int — NOT NULL — Rank (The higher the rank, the higher the rank)
- idx — int — NOT NULL — Rank exposure order
- name — varchar(50) — NOT NULL — Grade name (directly entered grade name)
- icon — varchar(200) — Icon by Rating (PC)
- mobile_icon — varchar(200) — Icon by Rating (MOBILE)
- condition_total_price — int — NOT NULL — Grade Condition Order Amount
- condition_total_count — int — NOT NULL — Rating Conditions: Number of Purchases
- give_point_per — float — NOT NULL — Grade Benefits: Earned Points
- sale_price_per — float — NOT NULL — Grade Benefits: Discount Points
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
member-policy
- id — int — Primary key — NOT NULL
- birth — enum('Y', 'N')
- birth_require — enum('Y', 'N')
- sex — enum('Y', 'N')
- sex_require — enum('Y', 'N')
- tel — enum('Y', 'N')
- tel_require — enum('Y', 'N')
- address — enum('Y', 'N')
- address_require — enum('Y', 'N')
- approve — enum('Y', 'N') — Membership approval (Y: automatic approval, N: sign up after approval)
- ban_id — text — Membership Restricted ID
- id_limit_min — int — ID minimum number of characters
- id_limit_max — int — ID maximum number of characters
- password_limit_min — int — Minimum number of characters in password
- password_limit_max — int — Maximum number of characters in password
- password_special_use — enum('Y', 'N') — Mixed special characters required (Y: use, N: not use)
- password_special_length — int — Number of mixed special characters
- password_uppercase_use — enum('Y', 'N') — Mixed capital letters required (Y: use, N: do not use)
- password_uppercase_length — int — Number of mixed uppercase letters
- email_list — text — Subscription Email Default List
- spam — enum('Y', 'N') — Whether to use anti-spam (Y: use, N: not use)
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
- group_set_auto_use — enum('Y', 'N') — Whether or not to use automatic rating evaluation (Y: use automatic evaluation, N: manual evaluation)
- group_set_auto_daily — enum('day', 'week', 'month') — Membership level evaluation period setting (daily, weekly, monthly)
- group_set_check_term — enum('monthlast', 'month1', 'month2', 'month3', 'month4', 'month5', 'month6') — Member rating evaluation period (last month, last 1 month, last 2 months, last 3 months, last 4 months, last 5 months,…
- member_return_type — enum('login', 'auth') — How to release sleep (login: Cancel sleep without authentication after logging in, auth: Cancel sleep after verifying e…
- member_return_group_init — enum('Y', 'N') — Membership level initialization setting when dormancy is released
- member_sleep_period — int — Number of days of dormant account conversion
member-sleep
- id — int — Primary key — NOT NULL
- member_id — varchar(30) — Foreign key → member.id — NOT NULL
- mailing — enum('Y', 'N') — Whether to send dormant account e-mail
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
- INDEX — `member_id`(`member_id`)
order
- id — varchar(20) — Primary key — NOT NULL — Order number - 15 letters applied as a combination of numbers, e.g. 12545-12345-12365
- member_id — varchar(30) — Foreign key → member.id — Orderer ID, if you are not a member, save the shopping cart c_cookie information
- member_coupon_id — text — User coupon uid, separated by comma
- status — varchar(50) — Order Status, Shipping, Payment Waiting, Payment Complete, Delivery Progress, Delivery Complete, Order Cancellation, Re…
- content — mediumtext — text on delivery
- admin_note — mediumtext — Administrator note
- member_type — enum('Y', 'N') — Member type, Y: member, N: non-member
- cancel_member_type — enum('member', 'admin') — Partial cancellation request (membership cancellation, manager cancellation)
- orderer_name — varchar(30)
- orderer_tel — varchar(30) — Orderer-Contact
- orderer_home_phone — varchar(30) — NOT NULL — orderer cell phone
- orderer_email — varchar(100)
- receiver_name — varchar(30)
- receiver_tel — varchar(30)
- receiver_home_phone — varchar(30) — NOT NULL
- receiver_post — varchar(7) — Recipient-Postal Code , ex) 123-567
- receiver_zone_code — varchar(10) — NOT NULL — National Basic Area No.
- receiver_address1 — varchar(100) — Recipient-Address1
- receiver_address2 — varchar(100) — Recipient-Address2
- receiver_address_doro — varchar(255) — Street name address
- apply_point — enum('Y', 'N') — Addition and subtraction of points, coupons, etc. according to payment
- price_real — int — Actual settlement price
- price_total — int — Total purchase
- price_delivery — int — Shipping amount
- price_supply_point — int — Points provided, must be provided according to the order
- price_use_point — int — NOT NULL — Points used
- price_coupon_product — int — NOT NULL — Product coupon usage amount
- price_coupon_member — int — NOT NULL — Bonus coupon usage
- price_refund — int — Refund/cancellation amount in case of partial cancellation
- price_use_point_refund — int — Points refunded in case of partial cancellation
- save_price_coupon_member — int — NOT NULL — Total amount of member coupon accumulated
- price_discount_refund — int — Partially canceled discount (non-refundable, bonus coupon + promo code + app order discount)
- price_product_refund — int — Partially canceled individual discount (product coupon)
- price_to_use_point_refund — int — Card/cash refund, but if the points are refunded, it is indicated separately and included in o_price_refund
- payment_method — enum('card', 'iche', 'online', 'point', 'virtual', 'hpp', 'payco', 'payple') — Payment method, add payple
- payment_status — enum('Y', 'N') — NOT NULL — Payment status - Y: payment confirmation, N: unpaid
- canceled — enum('Y', 'N', 'R') — Payment cancellation status, Y: Payment cancellation confirmation, N: Payment not canceled, R: Refund request
- payment_settlement_status — enum('none', 'ready', 'complete') — Order settlement status - none : Settlement irrelevant, ready : Settlement waiting, complete : Settlement complete
- payment_cancel_method — enum('B', 'D') — NOT NULL — Point refund method when payment is canceled
- payment_date — datetime — Payment completion date
- cancel_date — datetime — Order cancellation date
- easypay_payment_method_type — varchar(30) — Credit card easy payment method (defined in var.php - arr_available_easypay_pg )
- payco_payment_method_code — varchar(10) — Payco Payment Method Code
- payco_payment_method_name — varchar(30) — Payco payment method name
- npay_order — enum('Y', 'N') — Whether to purchase with NPay
- npay_uniq — varchar(255) — Unique ID for NPay purchase
- npay_status — varchar(255) — NPay state propagation value
- npay_order_group — varchar(255) — Naver order code
- bank — varchar(50) — When depositing without bankbook - Deposit account information
- deposit — varchar(50) — When depositing without bankbook - name of depositor
- get_tax — enum('Y', 'N') — NOT NULL — Issuance of cash receipts
- tax_trade_usage — char(1) — Use of cash receipt transaction
- tax_trade_method — char(1) — Cash receipt identification number classification - 1: card number, 3: resident registration number, 4: business number…
- tax_identify_number — varchar(100) — Identification number
- tax_error — varchar(255) — Error message when issuing cash receipts
- promotion_code — varchar(200) — Applied promo code
- promotion_price — int — Applied promo code discount amount
- area — varchar(10) — NOT NULL — Order area - for statistics
- mobile — enum('Y', 'N') — NOT NULL — Mobile purchase status (Y: Mobile purchase, N: PC purchase)
- device_info — text — NOT NULL — Ordering device information
- … +15
order-product
- id — int — Primary key — NOT NULL
- order_id — varchar(20) — Foreign key → order.id — NOT NULL
- product_id — int — Foreign key → product.id — NOT NULL
- product_option_id — int — Foreign key → product_option.id — NOT NULL
- option1 — varchar(100) — Choice option 1
- option2 — varchar(100) — Choice option 2
- option3 — varchar(100) — Choice option 3
- supply_price — int — NOT NULL — Supply price
- price — int — NOT NULL — Order product price
- point — int — NOT NULL — Points earned per order product
- add_delivery_price — int — NOT NULL — Additional shipping cost
- old_price — int — Existing price
- old_point — int — Existing points
- count — int — Number of product orders
- payment_date — datetime — Order product payment date
- send_company — varchar(30) — Courier
- send_number — varchar(20) — Invoice number
- send_status — varchar(50) — NOT NULL — Waiting for delivery, preparing for delivery, in progress, delivery completion
- send_date — datetime — Delivery date
- complete_date — datetime — Delivery completion date (purchase confirmation date)
- complain — varchar(50) — NULL, exchange/return request, exchange/return completed
- complain_date — datetime — Complaint application date
- complain_comment — text — Complaint memo
- settlement_status — enum('none', 'ready', 'complete') — Settlement status of ordered products - none : Settlement irrelevant , ready : Settlement waiting , complete : Settleme…
- settlement_reday — datetime — Settlement standby transition date
- settlement_complete — datetime — Settlement completion date of conversion
- is_add_option — enum('Y', 'N') — Whether additional options
- add_option_parent — int — Required option uid for additional options
- cancel — enum('Y', 'N', 'R') — Partial cancellation (Y: Cancellation, N: Basic, R: Cancellation acceptance)
- cancel_type — enum('pg', 'point')
- cancel_tid — varchar(100) — PG\'s partial cancellation tid', `cancel_return_msg` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL…
- cancel_msg — text — User partial cancellation message
- cancel_bank — varchar(100) — Refund account bank code
- cancel_bank_name — varchar(100) — Refund account holder
- cancel_bank_account — varchar(100) — Refund account number
- cancel_date — datetime — Date of cancellation
- cancel_complete_date — datetime — Cancellation completion date
- cancel_discount_price — int — Discount upon cancellation - (Excluding points used and product coupons)
- cancel_member_type — enum('member', 'admin') — Partial cancellation request (membership cancellation, manager cancellation)
- cancel_price — int — Amount in case of partial cancellation
- cancel_use_point — int — Half points in case of partial cancellation
- partner_code — varchar(100) — Vendor Code
- use_point — int — Sharing of points used for settlement
- use_discount_price — int — Sharing of discount for settlement/partial cancellation (excluding points used and product coupons)
- use_product_coupon — int — Product coupon usage amount
- commission_type — enum('fees', 'supplier') — Settlement form of order products
- commission — float — Fee rate when the settlement form is a fee
- delivery_price — int — Shipping fee
- delivery_type — enum('entry', 'individual', 'free', 'by product') — Shipping cost type by product
- vat — enum('Y', 'N') — Taxation status - Y: taxation, N: tax exemption
- is_cash_bill — enum('Y', 'N') — Cash receipt issuance
- free_delivery_event_use — enum('Y', 'N') — Free Shipping Event Eligibility
- group_set_use — enum('Y', 'N') — Membership level discount applied
- group_set_price_per — decimal(10, 0) — Discount rate
- group_set_point_per — decimal(10, 0) — Additional accrual rate
- npay_order_code — varchar(255) — Naver Pay product order code
- npay_order_group — varchar(255) — Naver order code
- npay_uniq — varchar(255) — Unique ID for NPay purchase
- npay_status — varchar(255) — NPay state propagation value
- npay_point — varchar(11) — Naver Pay Points
- … +8
policy
- id — int — Primary key — NOT NULL
- use — enum('Y','N') — NOT NULL
- name — varchar(50) — NOT NULL
- title — varchar(255) — NOT NULL
- content — text
- created_at — datetime
- updated_at — datetime
popup
- id — int — Primary key — NOT NULL
- img — varchar(100)
- title — varchar(255) — NOT NULL
- link — varchar(200)
- target — enum('NONE', 'SELF', 'BLANK') — NOT NULL
- view — enum('Y', 'N') — NOT NULL
- idx — int — NOT NULL
- left — int — NOT NULL — Pop-up position - from left
- top — int — NOT NULL — Pop-up position - from above
- mobile_top — int — NOT NULL — Pop-up location - from above (mobile)
- start_date — date — NOT NULL
- end_date — date — NOT NULL
- none_limit — enum('Y', 'N') — NOT NULL
- type — enum('A', 'P', 'M') — NOT NULL — Exposure Category (A: All, P: PC, M: Mobile)
- mode — enum('I', 'E') — NOT NULL — Pop-up mode (I: image type, E: editor type)
- content — longtext
- background_color — varchar(10)
- width — int — NOT NULL
- height — int — NOT NULL
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
product
- id — int — Primary key — NOT NULL
- code — varchar(20) — Primary key — NOT NULL — 15 letters in alphanumeric combination, e.g. A1234-B1234-C1234
- company_id — varchar(255) — Foreign key → company.id — NOT NULL
- stock — int — NOT NULL
- sales_quantity — int — NOT NULL
- price — int — NOT NULL
- point_percent — decimal(10, 0) — NOT NULL
- name — varchar(255) — NOT NULL
- sub_name — varchar(255) — NOT NULL
- view — enum('Y', 'N') — NOT NULL
- option_valid_check — enum('Y', 'N') — NOT NULL
- new_review — enum('Y', 'N') — NOT NULL
- sale_review — enum('Y', 'N') — NOT NULL
- best_review — enum('Y', 'N') — NOT NULL
- content — varchar(255)
- mobile_content — varchar(255)
- use_content — enum('Y', 'N') — NOT NULL
- img_list — varchar(255)
- img_list2 — varchar(255)
- img_list_square — varchar(255)
- img_b1 — varchar(255)
- img_b2 — varchar(255)
- img_b3 — varchar(255)
- img_b4 — varchar(255)
- img_b5 — varchar(255)
- coupon — varchar(255)
- idx — int — NOT NULL
- option_type_check — enum('nooption', '1depth', '2depth', '3depth') — NOT NULL
- shorten_url — varchar(255)
- origin — varchar(255) — NOT NULL
- maker — varchar(255) — NOT NULL
- shipping_fee_use — enum('Y', 'N', 'F', 'P') — NOT NULL — Whether to use product shipping policy
- shipping_fee — int — NOT NULL
- shipping_fee_free — int — NOT NULL
- shipping_fee_per_product — int — NOT NULL — Shipping cost per product - Basic shipping cost per product; When shipping_fee_use equal P
- shipping_fee_per_product_free — int — NOT NULL — Shipping cost per product - Basic shipping cost per product; When shipping_fee_use equal P
- commission_type — enum('persent', 'supplyprice') — NOT NULL — Settlement method for vendors (fee/supplier price)
- fees — varchar(255) — NOT NULL — When commission_type equal to persent
- supplier_price — int — NOT NULL — When commission_type equal to supplyprice
- icon — varchar(255) — NOT NULL
- normal_price — int — NOT NULL
- delivery_info — varchar(255) — NOT NULL
- relation — varchar(255) — NOT NULL
- relation_type — enum('none', 'category', 'manual') — NOT NULL — Related product exposure format (none: non-exposure, category: random exposure of products in the same category, manual…
- naver_switch — enum('Y', 'N') — NOT NULL
- daum_switch — enum('Y', 'N') — NOT NULL
- option1_type — enum('normal', 'size', 'color')
- option2_type — enum('normal', 'size', 'color')
- option3_type — enum('normal', 'size', 'color')
- soldout_check — enum('Y', 'N') — NOT NULL
- use_free_delivery_event — enum('Y', 'N') — NOT NULL
- brand — int
- use_group_set — enum('Y', 'N') — NOT NULL
- sort_idx — decimal(10, 0) — NOT NULL
- sort_group — int — NOT NULL
- vat — enum('Y', 'N') — NOT NULL
- use_npay — enum('Y', 'N') — NOT NULL
- hashtag_shuffle — enum('Y', 'N') — NOT NULL
- hashtag — varchar(255) — NOT NULL
- created_at — datetime
- … +5
product_addoption
- id — int — Primary key — NOT NULL
- product_id — int — Foreign key → product.id — NOT NULL
- name — varchar(200) — NOT NULL
- sales_quantity — int — NOT NULL
- stock — int — NOT NULL
- price — int — NOT NULL
- supply_price — int — NOT NULL
- depth — tinyint — NOT NULL
- parent — int — Foreign key → product_addoption.id
- view — enum('Y','N') — NOT NULL
- sort — int — NOT NULL
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
- INDEX — `product_id`(`product_id`)
- INDEX — `parent`(`parent`)
product_category
- product_id — int — Foreign key → product.id — NOT NULL
- category_id — int — Foreign key → category.id — NOT NULL
- created_at — datetime
- updated_at — datetime
- show_on_home — enum('Y','N') — NOT NULL
- INDEX — `category_id`(`category_id`)
- INDEX — `product_category_product_id`(`product_id`)
product_display_setting
- id — int — Primary key — NOT NULL
- main_review — enum('Y', 'N') — NOT NULL
- main_review_order — enum('S', 'I', 'R') — Sorting criteria for review products (S: product sales, I: product sort order, R: general review highest order)
- main_review_score — int
- main_review_view — enum('A', 'P') — Review output conditions (A: all reviews, P: photo reviews)
- main_review_limit — int — Maximum number of outputs
- display_product_info_pc — varchar(255)
- display_product_info_mobile — varchar(255)
- display_product_info_mobile_use_pc — enum('Y', 'N') — NOT NULL
- display_product_info_additional — varchar(255)
- display_relation_pc_use — enum('Y', 'N') — NOT NULL
- display_relation_pc_col — tinyint — NOT NULL
- display_relation_pc_row — tinyint — NOT NULL
- display_relation_mobile_use — enum('Y', 'N') — NOT NULL
- display_relation_mobile_col — tinyint — NOT NULL
- display_relation_mobile_row — tinyint — NOT NULL
- created_at — datetime
- updated_at — datetime
product_guide
- id — int — Primary key — NOT NULL
- company_id — varchar(50) — Foreign key → company.id — NOT NULL — Applicable store ID
- type — tinyint — NOT NULL
- is_default — enum('Y', 'N') — NOT NULL
- title — varchar(100) — NOT NULL
- content — longtext — NOT NULL — Information on use
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
- INDEX — `company_id`(`company_id`)
product_icon
- id — int — Primary key — NOT NULL
- type — enum('product_coupon_small_icon', 'product_freedelivery_small_icon', 'product_name_small_icon', 'product_promotion_small_icon') — NOT NULL
- title — varchar(200) — NOT NULL
- pc_image — varchar(255) — NOT NULL
- mobile_image — varchar(255)
- idx — int — Exposure order
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
product_option
- id — int — Primary key — NOT NULL
- product_id — int — Foreign key → product.id — NOT NULL
- name — varchar(200) — NOT NULL
- sales_quantity — int — NOT NULL
- stock — int — NOT NULL
- price — int — NOT NULL
- supply_price — int — NOT NULL
- depth — tinyint — NOT NULL
- parent — int — Foreign key → product_option.id
- view — enum('Y', 'N') — NOT NULL
- sort — int — NOT NULL
- color_type — enum('color', 'img', '')
- color_name — varchar(50) — Designated value according to color_type - colorpicker in case of color, file name in case of img
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
- INDEX — `product_id`(`product_id`)
- INDEX — `parent`(`parent`)
product_talk
- id — int — Primary key — NOT NULL
- type — enum('qna', 'eval') — NOT NULL — Comment type: qna => product inquiry, evel => product review
- product_id — int — Foreign key → product.id — NOT NULL
- member_id — varchar(50) — Foreign key → member.id — NOT NULL
- writer — varchar(50) — NOT NULL
- member_type — enum('normal', 'admin', 'company') — NOT NULL
- title — varchar(255) — NOT NULL
- content — text — NOT NULL
- depth — tinyint — NOT NULL — 1: Parent , 2: Child division
- relation — int — Foreign key → product_talk.id
- eval_point — int
- img — varchar(255)
- views — int
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
- INDEX — `product_id`(`product_id`)
- INDEX — `member_id`(`member_id`)
- INDEX — `relation`(`relation`)
product_wish
- id — int — Primary key — NOT NULL
- product_id — int — Foreign key → product.id — NOT NULL
- member_id — varchar(30) — Foreign key → member.id — NOT NULL
- created_at — datetime
- updated_at — datetime
- INDEX — `product_wish_product_id`(`product_id`)
- INDEX — `member_id`(`member_id`)
promotion_code
- id — int — Primary key — NOT NULL
- name — varchar(200) — NOT NULL
- code — varchar(200) — NOT NULL
- amount — int — NOT NULL
- use — enum('Y', 'N') — NOT NULL — Whether to use (Y: use, N: not use)
- type — enum('P', 'A') — NOT NULL — Type (P: discount rate, A: discount amount)
- expire — enum('Y', 'N') — NOT NULL — Expiration (Y: Expired, N: Available)
- expire_date — date — NOT NULL
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
promotion_plan
- id — int — Primary key — NOT NULL
- title — varchar(200) — NOT NULL
- content — text
- content_mobile — text
- view — enum('Y','N') — NOT NULL
- start_date — datetime — NOT NULL
- end_date — datetime — NOT NULL
- img — varchar(255) — NOT NULL
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
promotion_plan_product
- id — int — Primary key — NOT NULL
- promotion_plan_id — int — Foreign key → promotion_plan.id — NOT NULL
- product_id — int — Foreign key → product.id — NOT NULL
- created_at — datetime
- updated_at — datetime
- INDEX — `product_id`(`product_id`)
shipping_setting
- id — int — Primary key — NOT NULL
- delprice — int — NOT NULL — Basic shipping cost
- delprice_free — int — NOT NULL
- del_company — varchar(255)
- del_date — varchar(255)
- del_complain_price — int — NOT NULL — Return shipping cost
- del_return_addr — varchar(255)
- complain_ok — text — When exchange/return is possible
- complain_fail — text — If exchange/return is not possible
- del_addprice_use — enum('Y', 'N') — NOT NULL — Whether additional shipping cost is applied
- del_addprice_use_normal — enum('Y', 'N') — NOT NULL — Whether or not additional shipping cost is applied when free shipping is applied by purchasing a product with more than…
- del_addprice_use_product — enum('Y', 'N') — NOT NULL — Shipping by product Whether additional shipping cost is applied when a product is purchased with more than the free shi…
- del_addprice_use_unit — enum('Y', 'N') — NOT NULL — Whether additional shipping costs apply to individual delivery products
- del_addprice_use_free — enum('Y', 'N') — NOT NULL — Whether additional shipping charges apply to free shipping products
- product_auto_C — int — NOT NULL — Delivery product automatic settlement conversion (card)
- product_auto_L — int — NOT NULL — Automatic settlement of delivery products (real-time account transfer)
- product_auto_B — int — NOT NULL — Automatic settlement of delivery products (deposit without bankbook)
- product_auto_G — int — NOT NULL — Conversion to automatic settlement of delivery products (full points)
- product_auto_V — int — NOT NULL — Conversion to automatic settlement of delivery products (virtual account)
- product_auto_H — int — NOT NULL — Delivery product automatic settlement conversion (mobile phone)
- product_auto_P — int — NOT NULL — Automatic payment conversion for delivery products (Payco)
- product_auto_on — int — NOT NULL — Whether to use automatic settlement processing
- product_auto_PP — int — NOT NULL — Add the number of days for automatic settlement of PayPal easy payment
- delivery_auto — int — NOT NULL — Set up automatic delivery completion processing
- today_view_time — int — NOT NULL — Last viewed product retention time
- today_view_max — int — NOT NULL — Maximum quantity of recently viewed products
- created_at — datetime
- updated_at — datetime
shopping_mall_setting
- id — int — Primary key — NOT NULL
- admin_id — int — Foreign key → admin.id — NOT NULL
- representative_tel — varchar(50) — It is used as the calling number when using the SMS service
- manager_tel — varchar(50) — This is the mobile phone number to receive inquiries/reports/settlement requests
- admin_email — varchar(255)
- admin_shop — varchar(50)
- company_name — varchar(255)
- ceo_name — varchar(255)
- company_number — varchar(50)
- company_sale_number — varchar(50)
- company_address — varchar(255)
- item1 — varchar(100)
- item2 — varchar(100)
- fax — varchar(20)
- view_network_company_info — enum('Y', 'N') — NOT NULL
- customer_service_info — text
- privacy_name — varchar(20)
- login_page_phone — varchar(20)
- login_page_email — varchar(100)
- ssl_domain — varchar(255)
- none_member_buy — enum('Y', 'N') — NOT NULL
- none_member_login_skip — enum('Y', 'N') — NOT NULL
- member_login_count — int — NOT NULL
- naver_switch — enum('Y', 'N') — NOT NULL
- daum_switch — enum('Y', 'N') — NOT NULL
- site_meta_title — varchar(255)
- site_meta_description — varchar(255)
- site_meta_keywords — varchar(255)
- site_meta_tag — text
- created_at — datetime
- updated_at — datetime
- INDEX — `admin_id`(`admin_id`)