tttt
Tables (20)
basket
- basket_key — INT — Primary key — NOT NULL
- u_idx — INT
- option_key — INT
- b_qty — INT
- b_totalprice — INT
- create_dtm — DATE
board
- b_idx — INT — Primary key — NOT NULL
- u_idx — INT — NOT NULL
- bc_key — INT — NOT NULL
- title — VARCHAR(50)
- content — TEXT
- crt_dtm — DATE
- upt_dtm — DATE
- hit — INT
- up — INT
- status — INT
board_category
- bc_key — INT — Primary key — NOT NULL
- bc_option1 — VARCHAR(50)
- bc_option2 — VARCHAR(50)
board_file
- bf_key — INT — Primary key — NOT NULL
- b_idx — INT — NOT NULL
- f_name — VARCHAR(50)
- o_name — VARCHAR(50)
brand
- brand_key — INT — Primary key — NOT NULL
- brand_name — VARCHAR(20)
category
- category_key — INT — Primary key — NOT NULL
- brand_key — INT — NOT NULL
- category_name — VARCHAR(50)
comment_t
- c_idx — INT — Primary key — NOT NULL
- b_idx — INT — NOT NULL
- writer — VARCHAR(50)
- content — TEXT
- write_date — DATE
- ip — VARCHAR(50)
coupon
- c_idx — INT — Primary key — NOT NULL
- issue_sort — VARCHAR(20)
- issue_at — DATE
- c_name — VARCHAR(50)
- d_type — VARCHAR(20)
- d_price — INT
- max_discount — INT
- min_order_price — INT
- due_date — DATE
- category_key — INT
- c_img — VARCHAR(50)
couponlist
- cl_idx — INT — Primary key — NOT NULL
- u_idx — INT — NOT NULL
- c_idx — INT — NOT NULL
- c_qty — INT
- createdtm — DATE
delivery
- delivery_key — INT — Primary key — NOT NULL
- d_status — VARCHAR(20)
option
- option_key — INT — Primary key — NOT NULL
- product_key — INT — NOT NULL
- size — VARCHAR(30)
- color — VARCHAR(30)
- prod_stock — INT
order
- order_key — INT — Primary key — NOT NULL
- u_idx — INT — NOT NULL
- delivery_key — INT — NOT NULL
- paymethod — VARCHAR(20)
- delivery_price — INT
- delivery_msg — TEXT
- confirm — INT
- grade — VARCHAR(20)
- ratio_mile — INT
- mile — INT
- usedmile — INT
- d_price — INT
- b_discount — INT
- t_discount — INT
- destination — VARCHAR(50)
- receiver — VARCHAR(20)
- zip_code — INT
- receiver_tel — VARCHAR(20)
- is_allcancel — INT
- total_cancel_price — INT
- is_allrefund — INT
- total_refund_price — INT
- order_dtm — DATE
- order_qty — INT
- order_changed_qty — INT
- primary_price — INT
- final_price — INT
order_detail
- od_key — INT — Primary key — NOT NULL
- order_key — INT — NOT NULL
- option_key — INT — NOT NULL
- delivery_key — INT — NOT NULL
- c_idx — INT — NOT NULL
- od_delivery_start — DATE
- od_delivery_end — DATE
- od_waybill — VARCHAR(30)
- od_confirm — INT
- od_iscoupon — INT
- od_mile — INT
- d_price — INT
- od_usedmile — INT
- cancel_qty — INT
- refund_qty — INT
- cancel_price — INT
- refund_price — INT
- od_qty — INT
- od_changed_qty — INT
- od_totalprice — INT
- od_changed_price — INT
- isexchanged — INT
- od_price — INT
- cell_price — INT
order_status
- os_key — INT — Primary key — NOT NULL
- od_key — INT — NOT NULL
- os_option — INT
- os_qty — INT
- os_price — INT
- os_msg — TEXT
- os_create_dtm — DATE
- os_confirm — INT
p_interest
- interest_key — INT — Primary key — NOT NULL
- u_idx — INT
- product_key — INT
- create_dtm — DATE
pro_file
- pf_key — INT — Primary key — NOT NULL
- product_key — INT — NOT NULL
- f_name — VARCHAR(50)
- o_name — VARCHAR(50)
product
- product_key — INT — Primary key — NOT NULL
- category_key — INT — NOT NULL
- isnew — INT
- isrecommend — INT
- prod_name — VARCHAR(30)
- prod_desc1 — VARCHAR(50)
- prod_desc2 — TEXT
- ori_price — INT
- cell_price — INT
- img_url — VARCHAR(100)
- stock — INT
- factory — VARCHAR(30)
- season — INT
- material — VARCHAR(50)
- alt_text — VARCHAR(50)
- create_dtm — DATE
- view_qty — INT
- del — INT — NOT NULL
review
- review_key — Primary key — NOT NULL
u_grade
- ug_idx — INT — Primary key — NOT NULL
- grade — VARCHAR(20)
- ratio_mile — INT
user
- u_idx — INT — Primary key — NOT NULL
- ug_idx — INT — NOT NULL
- admin — INT
- id — VARCHAR(20)
- pw — VARCHAR(20)
- name — VARCHAR(20)
- addr — VARCHAR(50)
- addr_detail — VARCHAR(30)
- zip_code — INT
- sex — INT
- btd — DATE
- email — VARCHAR(50)
- phone — VARCHAR(20)
- total_spend — INT
- total_mile — INT
- avail_mile — INT
- reg_dtm — DATE
- del — INT
- del_dtm — DATE
- del_reason — VARCHAR(20)