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