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`)