test

Tables (38)

addr

  • addr_id — NOT — Primary key — NOT NULL
  • addr_title — NOT — NOT NULL
  • addr_receiver — NOT — NOT NULL
  • addr_zipcode — NOT — NOT NULL
  • addr_address1 — NOT — NOT NULL
  • addr_address2 — NOT — NOT NULL
  • addr_phone — NOT — NOT NULL
  • mem_id — NOT — Foreign key → mem.mem_id — NOT NULL
  • addr_wireline — NOT — NOT NULL
  • addr_base — NULL

attd

  • attd_id — NOT — Primary key — NOT NULL
  • mem_id — NOT — Foreign key → mem.mem_id — NOT NULL
  • attd_date — NULL
  • attd_runcount — NOT — NOT NULL
  • reward — VARCHAR(255)
  • reward_icon — NOT — NOT NULL
  • info_step1 — NOT — NOT NULL

attd_reward

  • attd_reward_id — NOT — Primary key — NOT NULL
  • mem_id — NOT — Foreign key → mem.mem_id — NOT NULL
  • attd_reward_date — NULL
  • pt_point — NOT — NOT NULL
  • attd_reward_type — NOT — NOT NULL

ban

  • ban_id — NOT — Primary key — NOT NULL
  • ban_start_date — NULL
  • ban_end_dated — NULL
  • bng_id — NOT — Foreign key → bng.bng_id — NOT NULL
  • bng_name — NOT — NOT NULL
  • ban_title — NOT — NOT NULL
  • ban_url — NOT — NOT NULL
  • ban_width — VARCHAR(255)
  • ban_height — NOT — NOT NULL
  • ban_hit — NOT — NOT NULL
  • ban_order — NOT — NOT NULL
  • ban_image — NOT — NOT NULL
  • ban_activated — VARCHAR(255)
  • ban_datetime — NULL
  • ban_ip — NOT — NOT NULL
  • mem_id — NOT — NOT NULL
  • Field — VARCHAR(255)

bank

  • bank_id — NOT — Primary key — NOT NULL
  • bank_title — NOT — NOT NULL

bng

  • bng_id — NOT — Primary key — NOT NULL
  • bng_name — NOT — NOT NULL
  • Field — VARCHAR(255)

bo

  • board_id — NOT — Primary key — NOT NULL
  • board_title — NOT — NOT NULL
  • board_content — NOT — NOT NULL
  • board_file — NOT — NOT NULL
  • board_on — NOT — NOT NULL
  • bo_cat_id — NOT — Foreign key → bo_cat.bo_cat_id — NOT NULL
  • mem_id — NOT — Foreign key → mem.mem_id — NOT NULL
  • board_user — NOT — NOT NULL
  • board_date — NULL
  • board_pw — NOT — NOT NULL
  • board_view — NOT — NOT NULL
  • board_else1 — NOT — NOT NULL
  • prd_id — NOT — Foreign key → prd.prd_id — NOT NULL
  • board_reply_id — NOT — NOT NULL

bo_cat

  • bo_cat_id — NOT — Primary key — NOT NULL
  • bo_id — NOT — NOT NULL
  • bo_cat_key — NOT — NOT NULL
  • bo_cat_value — NOT — NOT NULL
  • bo_cat_parent — NOT — NOT NULL
  • bo_cat_order — NOT — NOT NULL

bo_re

  • board_re_id — NOT — Primary key — NOT NULL
  • board_re_content — NOT — NOT NULL
  • board_re_date — NULL
  • board_id — NOT — Foreign key → bo.board_id — NOT NULL

brn

  • brn_id — NOT — Primary key — NOT NULL
  • brn_name — NOT — NOT NULL

brn_off

  • brn_id — NOT — Primary key — NOT NULL
  • brand_off_name — NOT — NOT NULL

cart

  • cart_id — NOT — Primary key — NOT NULL
  • cart_items — NOT — NOT NULL
  • cart_expire_date — NULL
  • cart_paid — NOT — NOT NULL
  • cart_shipped — NOT — NOT NULL
  • mem_id — NOT — Foreign key → mem.mem_id — NOT NULL
  • prd_id — NOT — NOT NULL

cat

  • cat_id — NOT — Primary key — NOT NULL
  • cat_name — NOT — NOT NULL
  • cat_parent — NOT — NOT NULL

cat_off

  • cat_id — NOT — Primary key — NOT NULL
  • cat_name — NOT — NOT NULL
  • cat_parent — NOT — NOT NULL

cp

  • cp_id — NOT — Primary key — NOT NULL
  • cp_name — NOT — NOT NULL
  • cp_code — NOT — NOT NULL
  • cp_start — NULL
  • cp_expiration — NULL
  • cp_use — NOT — NOT NULL
  • cp_type — NOT — NOT NULL
  • mem_id — NOT — NOT NULL
  • cp_register — NULL
  • cp_discount — NOT — NOT NULL
  • cp_discount_amount — NOT — NOT NULL

cr

  • cr_id — NOT — Primary key — NOT NULL
  • cp_id — NOT — Foreign key → cp.cp_id — NOT NULL
  • cp_name — NOT — NOT NULL
  • cp_code — NOT — NOT NULL
  • mem_id — NOT — NOT NULL
  • mem_name — NOT — NOT NULL
  • cr_used — NOT — NOT NULL
  • cr_used_date — NULL
  • prd_id — NOT — Foreign key → prd.prd_id — NOT NULL
  • txn_id — NOT — Foreign key → txn.txn_id — NOT NULL

event

  • event_id — NOT — Primary key — NOT NULL
  • event_title — NOT — NOT NULL
  • event_content — VARCHAR(255)
  • event_user — NOT — NOT NULL
  • event_date — NULL
  • event_start_date — NULL
  • event_end_date — NULL
  • event_on — NOT — NOT NULL
  • event_cat_id — NOT — Foreign key → event_cat.event_cat_id — NOT NULL

event_cat

  • event_cat_id — NOT — Primary key — NOT NULL
  • event_cat_name — NOT — NOT NULL
  • event_cat_parent — NOT — NOT NULL

faq

  • faq_id — NOT — Primary key — NOT NULL
  • faq_name — NOT — NOT NULL
  • faq_content — VARCHAR(255)
  • faq_cat_id — NOT — Foreign key → faq_cat.faq_cat_id — NOT NULL
  • faq_update_date — NULL
  • faq_writer — NOT — NOT NULL

faq_cat

  • faq_cat_id — NOT — Primary key — NOT NULL
  • faq_cat_name — NOT — NOT NULL
  • faq_cat_parent — NOT — NOT NULL

mem

  • mem_id — NOT — Primary key — NOT NULL
  • mem_username — VARCHAR(255)
  • mem_password — VARCHAR(255)
  • mem_email — VARCHAR(255)
  • mem_name — VARCHAR(255)
  • mem_register_date — VARCHAR(255)
  • mem_lastlogin — VARCHAR(255)
  • mem_phone — VARCHAR(255)
  • mem_gender — VARCHAR(255)
  • mem_dob — NULL
  • mem_admin — VARCHAR(255)
  • mem_method — NOT — NOT NULL
  • mem_level — 0
  • mem_activated — 0
  • mem_attendence — NOT — NOT NULL
  • mem_deactivated_mem — NOT — NOT NULL
  • mem_refund_name — NULL
  • bank_id — NULL — Foreign key → bank.bank_id — NOT NULL
  • mem_refund_bank — NULL
  • mem_refund_account — NULL
  • mem_additional1 — NULL
  • mem_additional2 — NULL
  • mem_additional3 — NULL

mog

  • mog_idx — NOT — Primary key — NOT NULL
  • txn_id — NOT — Foreign key → txn.txn_id — NOT NULL
  • prd_id — NOT — Foreign key → prd.prd_id — NOT NULL
  • mg_code — NOT — NOT NULL
  • mg_name — NOT — NOT NULL
  • mog_option — NOT — NOT NULL
  • mog_qty — NOT — NOT NULL
  • mog_part_cancel_qty — NOT — NOT NULL
  • mog_price — NOT — NOT NULL
  • mog_total_price — NOT — NOT NULL
  • mog_total_dis_price — NOT — NOT NULL
  • mog_order_status — NOT — NOT NULL
  • Field — NULL
  • mog_delivery_name — NOT — NOT NULL
  • mog_delivery_num — NULL

noti

  • noti_id — NOT — Primary key — NOT NULL
  • noti_date — NULL
  • noti_title — NOT — NOT NULL
  • noti_content — NOT — NOT NULL
  • noti_deleted — NOT — NOT NULL
  • mem_id — NOT — Foreign key → mem.mem_id — NOT NULL

noti_

  • noti_id — NOT — Primary key — NOT NULL
  • noti_title — NOT — NOT NULL
  • noti_content — NOT — NOT NULL
  • noti_seen — VARCHAR(255)
  • noti_date — NULL
  • mem_id — NOT — Foreign key → mem.mem_id — NOT NULL

pcolor

  • pcolor_id — NOT — Primary key — NOT NULL
  • pcolor_name — NOT — NOT NULL
  • pcolor_value — NOT — NOT NULL

po

  • po_id — NOT — Primary key — NOT NULL
  • po_value1 — NOT — NOT NULL
  • po_value2 — NOT — NOT NULL
  • po_value3 — NOT — NOT NULL
  • po_value4 — NULL
  • po_value5 — NULL
  • po_price — NOT — NOT NULL
  • po_inventory — NOT — NOT NULL
  • po_code — NULL
  • po_exhibition — NOT — NOT NULL
  • po_status — NOT — NOT NULL
  • po_memo — NOT — NOT NULL
  • po_update_date — NOTNULL
  • po_edit_date — NULL
  • prd_id — NOT — NOT NULL
  • po_color — NOT — NOT NULL

pop

  • pop_id — NOT — Primary key — NOT NULL
  • pop_group — NOT — NOT NULL
  • pop_title — NOT — NOT NULL
  • pop_content — NOT — NOT NULL
  • pop_use — NOT — NOT NULL
  • pop_update_date — NULL
  • pop_start_date — NULL
  • pop_end_date — NULL

prd

  • prd_id — NOT — Primary key — NOT NULL
  • prd_title — NOT — NOT NULL
  • prd_price — NOT — NOT NULL
  • prd_list_price — NOT — NOT NULL
  • prd_sale_rate — NOT — NOT NULL
  • prd_earn_rate — NOT — NOT NULL
  • prd_shipping — NOT — NOT NULL
  • brn_id — NOT — Foreign key → brn.brn_id — NOT NULL
  • cat_id — NOT — Foreign key → cat.cat_id — NOT NULL
  • prd_img — NOT — NOT NULL
  • prd_img_2 — NOT — NOT NULL
  • prd_img_3 — NOT — NOT NULL
  • prd_img_4 — NOT — NOT NULL
  • prd_img_5 — NOT — NOT NULL
  • prd_detail — VARCHAR(255)
  • prd_detail_m — NOT — NOT NULL
  • prd_details — NOT — NOT NULL
  • prd_detials_m — NOT — NOT NULL
  • prd_min_qty — NOT — NOT NULL
  • prd_max_qty — NOT — NOT NULL
  • prd_hit — NOT — NOT NULL
  • prd_sold_accumulated — NOT — NOT NULL
  • prd_soldout — NOT — NOT NULL
  • prd_supply — NOT — NOT NULL
  • prd_stock_qty — NOT — NOT NULL
  • prd_featured — NOT — NOT NULL
  • prd_sizes — NOT — NOT NULL
  • prd_delted — NOT — NOT NULL
  • mem_username — NOT — NOT NULL
  • prd_update_date — NULL
  • prd_edit_username — NOT — NOT NULL
  • prd_edit_date — NULL
  • prd_shop_memo — NOT — NOT NULL
  • prd_additional1 — NOT — NOT NULL
  • prd_additional2 — NOT — NOT NULL
  • prd_additional3 — NOT — NOT NULL
  • prd_additional4 — NOT — NOT NULL
  • prd_additional5 — NOT — NOT NULL
  • prd_seo_title — NOT — NOT NULL
  • prd_seo_description — NOT — NOT NULL
  • prd_api — NOT — NOT NULL
  • ptag_id — NOT — Foreign key → ptag.ptag_id — NOT NULL
  • po_id — NOT — Foreign key → po.po_id — NOT NULL

pt

  • pt_id — NOT — Primary key — NOT NULL
  • mem_id — NOT — Foreign key → mem.mem_id — NOT NULL
  • pt_datetime — NULL
  • pt_content — NOT — NOT NULL
  • pt_point — NOT — NOT NULL
  • prd_id — NOT — Foreign key → prd.prd_id — NOT NULL
  • pt_related_id — NOT — NOT NULL
  • pt_action — VARCHAR(255)
  • pt_start_date — NULL
  • pt_end_date — NULL
  • pt_type — NOT — NOT NULL
  • attd_reward_id — NOT — Foreign key → attd_reward.attd_reward_id — NOT NULL

ptag

  • ptag_id — NOT — Primary key — NOT NULL
  • ptag_name — NOT — NOT NULL
  • ptag_img — NOT — NOT NULL
  • ptag_width — NOT — NOT NULL
  • ptag_height — NOT — NOT NULL
  • Field — VARCHAR(255)

rev

  • rev_id — NOT — Primary key — NOT NULL
  • rev_title — NOT — NOT NULL
  • rev_content — NOT — NOT NULL
  • rev_content_reply — NOT — NOT NULL
  • rev_content_reply_date — NULL
  • rev_photo — NOT — NOT NULL
  • rev_file — NOT — NOT NULL
  • rev_date — NULL
  • rev_best — NOT — NOT NULL
  • mem_id — NOT — Foreign key → mem.mem_id — NOT NULL
  • mem_name — VARCHAR(255)
  • prd_id — NOT — Foreign key → prd.prd_id — NOT NULL
  • rev_child — VARCHAR(255)
  • rev_score — NOT — NOT NULL
  • rev_deleted — NOT — NOT NULL
  • rev_personal1 — NOT — NOT NULL
  • rev_personal2 — NOT — NOT NULL
  • rev_personal3 — NOT — NOT NULL
  • rev_additional1 — NOT — NOT NULL
  • rev_additional2 — NOT — NOT NULL
  • rev_additional3 — NOT — NOT NULL
  • rev_helped — NOT — NOT NULL
  • rev_view — NOT — NOT NULL
  • mog_idx — NOT — NOT NULL

review_like

  • revlike_id — NOT — Primary key — NOT NULL
  • med_id — NOT — NOT NULL
  • rev_id2 — NOT — Foreign key → rev.rev_id — NOT NULL

ru

  • ru_id — NOT — Primary key — NOT NULL
  • ru_link — NOT — NOT NULL
  • cat_id — NOT — Foreign key → cat.cat_id — NOT NULL
  • ru_image — NOT — NOT NULL
  • ru_activated — NOT — NOT NULL
  • ru_update — NOT — NOT NULL
  • ru_start_date — NOT — NOT NULL
  • ru_end_date — NOT — NOT NULL

rulist

  • rulist_id — NOT — Primary key — NOT NULL
  • ru_id — NOT — Foreign key → ru.ru_id — NOT NULL
  • prd_id2 — NOT — Foreign key → prd.prd_id — NOT NULL
  • rulist_text — NOT — NOT NULL

setpt

  • setpt_id — NOT — Primary key — NOT NULL
  • setpt_min_price — NOT — NOT NULL
  • setpt_min_point — VARCHAR(255)
  • setpt_earn_option — NOT — NOT NULL
  • setpt_earn_rate — NOT — NOT NULL
  • setpt_register_rate — NOT — NOT NULL
  • setpt_register_active — NOT — NOT NULL
  • setpt_review_rate — NOT — NOT NULL
  • setpt_review_rate_active — NOT — NOT NULL
  • setpt_photo_rate — NOT — NOT NULL
  • setpt_photo_rate_active — NOT — NOT NULL

tok

  • tok_id — NOT — Primary key — NOT NULL
  • tok_name — NOT — NOT NULL
  • tok_date — NULL

txn

  • txn_id — NOT — Primary key — NOT NULL
  • mem_id — NOT — Foreign key → mem.mem_id — NOT NULL
  • mem_name — Not — NOT NULL
  • mem_phone — NOT — NOT NULL
  • txn_currency — NOT — NOT NULL
  • txn_sub_total — NOT — NOT NULL
  • txn_coupon_discount — NOT — NOT NULL
  • txn_point_used — NOT — NOT NULL
  • txn_tax — NOT — NOT NULL
  • txn_shipping — NOT — NOT NULL
  • txn_order_price_amount — NOT — NOT NULL
  • txn_payment_amount — NOT — NOT NULL
  • txn_grand_total — NOT — NOT NULL
  • cart_id — NULL — Foreign key → cart.cart_id — NOT NULL
  • txn_description — NOT — NOT NULL
  • txn_payment_method — NOT — NOT NULL
  • txn_pg_name — NOT — NOT NULL
  • txn_pg_resultyn — NOT — NOT NULL
  • txn_type — NOT — NOT NULL
  • txn_status — NOT — NOT NULL
  • txn_order_state_name — NOT — NOT NULL
  • txn_date — NULL
  • tax_payment_date — NULL
  • tax_cancel_date — NULL
  • txn_refund_date — NULL
  • txn_refundend_date — NULL
  • txn_swap_date — NULL
  • txn_swapend_date — NULL
  • txn_actual_paid_amount — NOT — NOT NULL
  • tax_partial_cancel_date — NULL
  • inflow_name — NOT — NOT NULL
  • mem_email — NOT — NOT NULL
  • receiver_name — VARCHAR(255)
  • receiver_phone — VARCHAR(255)
  • receiver_zipcode — NOT — NOT NULL
  • receiver_address — NOT — NOT NULL
  • receiver_address2 — NOT — NOT NULL
  • receiver_memo — NOT — NOT NULL
  • delivery_date — NULL
  • delivery_name — VARCHAR(255)
  • delivery_code — VARCHAR(255)
  • delivered — NOT — NOT NULL
  • reserved_date — NULL
  • merchant_uid — NOT — NOT NULL
  • costomer_uid — NOT — NOT NULL
  • txn_count — NOT — NOT NULL
  • txn_memo — NOT — NOT NULL
  • txn_update_require — NOT — NOT NULL

txn_update

  • txnu_id — NOT — Primary key — NOT NULL
  • txnu_state — NOT — NOT NULL
  • txn_update_require — NOT — NOT NULL
  • mog_option — NULL
  • address — NULL
  • txn_id — NULL — Foreign key → txn.txn_id — NOT NULL
  • mog_idx — NULL — Foreign key → mog.mog_idx — NOT NULL
  • mem_id — NOT — NOT NULL
  • txnu_delete — NOT — NOT NULL
  • txnu_date — NULL