AfterStore

Tables (69)

tb_ad_hist

  • base_ymd — varchar(10) — Primary key — NOT NULL — base ymd
  • pre_id — varchar(128) — Foreign key → tb_advertise.pre_id — NOT NULL — premium id
  • ad_seq — int — Foreign key → tb_advertise.ad_seq — NOT NULL — advertisement sequnce
  • click_cnt — int — NOT NULL — click count
  • view_cnt — int — NOT NULL — view count

tb_advertise

  • pre_id — varchar(128) — Primary key — NOT NULL — premium id
  • ad_seq — int — Primary key — NOT NULL — advertisement sequnce
  • title — varchar(512) — advertisement title
  • ad_name — varchar(128) — NOT NULL — advertisement name
  • file_path — varchar(128) — NOT NULL — file path
  • file_type — varchar(30) — NOT NULL — file type
  • click_cnt — int — NOT NULL — clicked count
  • view_cnt — int — NOT NULL — view count
  • is_intro — varchar(1) — is intro video
  • confirm_yn — varchar(1) — confirm_yn
  • confirm_dt — datetime — confirm date
  • reg_id — varchar(128) — NOT NULL — added by
  • reg_dt — datetime — NOT NULL — added on

tb_barcode

  • pno — varchar(30) — Foreign key → tb_product_stock.pno — NOT NULL — product no
  • short_cd — varchar(150) — Foreign key → tb_product_stock.short_cd — NOT NULL — short_cd(opt_cd+detail_cd+child_opt_cd +child_detail_cd)
  • stock_seq — int — Foreign key → tb_product_stock.stock_seq — NOT NULL — stock sequnce
  • file_path — varchar(128) — NOT NULL — file path
  • reg_id — varchar(128) — NOT NULL — added by
  • reg_dt — datetime — NOT NULL — added on

tb_brand_setting

  • set_key — varchar(30) — Primary key — NOT NULL — key code of setting
  • pre_id — varchar(128) — Primary key — NOT NULL — premium id
  • value — varchar(256) — NOT NULL — value of key code
  • reg_id — varchar(128) — NOT NULL — who added
  • reg_dt — datetime — NOT NULL — when added
  • mod_id — varchar(128) — NOT NULL — who modified
  • mod_dt — datetime — NOT NULL — when modified

tb_cafe24_evt

  • pre_id — varchar(128) — Primary key — NOT NULL — premium_id
  • evt_seq — int — Primary key — NOT NULL — event sequence
  • title — varchar(128) — NOT NULL — title
  • context — text — NOT NULL — context
  • title_img_path — varchar(256) — NOT NULL — title image path
  • reg_dt — datetime — NOT NULL — when added
  • mod_dt — datetime — NOT NULL — when modified
  • del_dt — datetime — when deleted

tb_client_version (Untitled)

  • seq — int — Primary key — NOT NULL — sequence
  • p_type — varchar(30) — NOT NULL — program type
  • latest_ver — varchar(30) — NOT NULL — latest version
  • reg_dt — datetime — NOT NULL — added on

tb_code

  • code — varchar(30) — Primary key — NOT NULL — code
  • type_code — varchar(30) — Foreign key → tb_type_code.type_code — NOT NULL — type of code
  • p_code — varchar(30) — parent code
  • value — varchar(128) — NOT NULL — value of code
  • sort — int(11) — NOT NULL — priority of code
  • use_yn — varchar(1) — use yn
  • mod_id — varchar(128) — NOT NULL — user who modified data
  • mod_dt — datetime — NOT NULL — date when modified data
  • reg_id — varchar(129) — NOT NULL — user who registed data
  • reg_dt — datetime — NOT NULL — date when registed data

tb_coupon

  • cp_seq — int — Primary key — NOT NULL — sequence of coupon
  • inv_seq — int — Foreign key → tb_invitation.inv_seq — NOT NULL — invitation sequence
  • pre_id — varchar(128) — Foreign key → tb_invitation.pre_id — NOT NULL — premium id
  • cp_type — varchar(30) — NOT NULL — coupon type(%할인,특정금액할인)
  • cp_name — varchar(128) — NOT NULL — coupon name
  • dis_title — varchar(128) — NOT NULL — discount title
  • discount — int — NOT NULL — discount
  • context — varchar(512) — NOT NULL — context of coupon
  • exp_st_dt — varchar(10) — NOT NULL — expired date of start
  • exp_ed_dt — varchar(10) — NOT NULL — expired date of end
  • status_cd — varchar(30) — NOT NULL — state of coupon(01:NOT_PUBLISH,02:PUBLISH,03:ENDED)
  • qty_fcfs — int — quantity served
  • del_id — varchar(128) — who deleted
  • del_dt — datetime — when deleted
  • reg_id — varchar(128) — NOT NULL — who added
  • reg_dt — datetime — NOT NULL — when added
  • max_price — int — maximum discount price

tb_coupon_hist

  • phone — varchar(15) — Primary key — NOT NULL — user phone
  • cp_no — varchar(256) — Primary key — NOT NULL — coupon no
  • cp_seq — int — Foreign key → tb_coupon.cp_seq — NOT NULL — sequence of coupon
  • use_yn — varchar(1) — NOT NULL — is used coupon
  • spase_seq (space_seq) — int — space sequence
  • use_dt — datetime — when used
  • reg_dt — datetime — NOT NULL — when added
  • event_id — varchar(12) — 관련이벤트 아이디
  • event_user_id — varchar(128) — 관련 이벤트 브랜드 아이디
  • ord_no — varchar(30) — 사용한 주문번호
  • coupon_price — int — 사용된 쿠폰금액
  • pre_id — varchar(128) — 사용된 프리미엄 아이디

tb_cs_answer

  • an_seq — int — Primary key — NOT NULL — answer sequence
  • cs_seq — int — Foreign key → tb_cs_board.cs_seq — NOT NULL — sequence of customer service
  • title — varchar(128) — NOT NULL — title
  • context — text — NOT NULL — context
  • reg_id — varchar(128) — NOT NULL — who added
  • reg_dt — datetime — NOT NULL — when added
  • mod_id — varchar(128) — NOT NULL — who modified
  • mod_dt — datetime — NOT NULL — when modified

tb_cs_board

  • cs_seq — int — Primary key — NOT NULL — sequence of customer service
  • title — varchar(128) — NOT NULL — title
  • type — varchar(30) — NOT NULL — type of cs
  • status_cd — varchar(30) — NOT NULL — status code
  • context — text — NOT NULL — context
  • reg_id — varchar(128) — NOT NULL — who added
  • reg_dt — datetime — NOT NULL — when added
  • mod_id — varchar(128) — NOT NULL — who modified
  • mod_dt — datetime — NOT NULL — when modified
  • del_id — varchar(128) — who deleted
  • del_dt — datetime — when deleted

tb_cs_file

  • file_seq — int — Primary key — NOT NULL — sequence of file
  • cs_seq — int — Foreign key → tb_cs_board.cs_seq — NOT NULL — sequence of customer service
  • file_path — varchar(256) — NOT NULL — file path
  • file_name — varchar(128) — NOT NULL — file name
  • reg_dt — datetime — NOT NULL — when added

tb_customer

  • phone — varchar(15) — Primary key — NOT NULL — user phone
  • pre_id — varchar(128) — Primary key — NOT NULL — premium id
  • name — varchar(20) — customer name
  • email — varchar(256) — customer email
  • point — int — customer point
  • cum_amt — int — cumulate amount
  • reg_id — varchar(128) — who added
  • reg_dt — datetime — when added
  • mod_id — varchar(128) — who modified
  • mod_dt — datetime — when modified
  • del_id — varchar(128) — who deleted
  • del_dt — datetime — when deleted

tb_customer_visit

  • seq — int — Primary key — NOT NULL — sequence
  • space_seq — int — Primary key — NOT NULL — space sequence
  • phone — varchar(15) — Foreign key → tb_customer.phone — NOT NULL — user phone
  • reg_id — varchar(128) — who added
  • reg_dt — datetime — when added

tb_exchange

  • ord_no — varchar(30) — Foreign key → tb_order_prods.ord_no — NOT NULL — order no
  • pno — varchar(30) — Foreign key → tb_order_prods.pno — NOT NULL — product no
  • short_cd — varchar(150) — Foreign key → tb_order_prods.short_cd — NOT NULL — short_cd(opt_cd+detail_cd+child_opt_cd +child_detail_cd)
  • stock_seq — int — Foreign key → tb_order_prods.stock_seq — NOT NULL — stock sequnce
  • cnt — int — NOT NULL — quantity of exchange
  • to_pno — varchar(30) — NOT NULL — wants product no
  • to_short_cd — varchar(150) — NOT NULL — wants product short_cd
  • to stock_seq (to_stock_seq) — int — NOT NULL — wants product stock seq
  • to_cnt — int — NOT NULL — want to exchange quentity of product
  • status_cd — varchar(30) — NOT NULL — status code
  • reason — varchar(512) — NOT NULL — reason why wants to exchange
  • answer — varchar(512) — answer
  • reg_id — varchar(128) — NOT NULL — added by
  • reg_dt — datetime — NOT NULL — added on

tb_instagram

  • insta_id — varchar(128) — Primary key — NOT NULL — instagram id
  • seq — int — Primary key — NOT NULL — sequnce
  • img_path — varchar(256) — NOT NULL — image path
  • context — text — context
  • likes — varchar(20) — NOT NULL — likes
  • refer_url — varchar(128) — NOT NULL — refer url
  • reg_dt — datetime — NOT NULL — added on

tb_instagram_token

  • pre_id — varchar(128) — Primary key — NOT NULL — premium id
  • insta_id — varchar(128) — Primary key — NOT NULL — instagram id
  • auth_code — varchar(256) — NOT NULL — auth_code
  • acc_code — varchar(256) — access code
  • user_id — varchar(256) — user id by number
  • reg_dt — datetime — NOT NULL — when added
  • mod_dt — datetime — NOT NULL — when modified

tb_integration_log

  • pre_id — varchar(128) — Primary key — NOT NULL — premium id
  • seq — int — Primary key — NOT NULL — sequence of log
  • log_path — varchar(256) — NOT NULL — log path
  • end_yn — varchar(1) — NOT NULL — is ended
  • reg_dt — datetime — NOT NULL — when started
  • reg_id — varchar(128) — NOT NULL — who started
  • end_dt — datetime — when ended
  • log_type — varchar(30) — log type
  • success_yn — varchar(1) — success yn

tb_invitation

  • inv_seq — int — Primary key — NOT NULL — invitation sequence
  • pre_id — varchar(128) — Primary key — NOT NULL — premium id
  • title — varchar(128) — NOT NULL — title of invitation
  • insta_id — varchar(128) — instagram id
  • start_dt — varchar(10) — NOT NULL — start date
  • end_dt — varchar(10) — NOT NULL — end date
  • use_yn — varchar(30) — NOT NULL — use yn
  • reg_id — varchar(128) — NOT NULL — added by
  • reg_dt — datetime — NOT NULL — added on
  • mod_id — varchar(128) — NOT NULL — modified by
  • mod_dt — datetime — NOT NULL — modified on
  • introduce — varchar(512) — introduce
  • view_cnt — int — count of viewing

tb_invitation_event

  • inv_seq — int — Foreign key → tb_invitation.inv_seq — NOT NULL — invitation sequence
  • evt_quest — varchar(128) — NOT NULL — event quest
  • evt_answer — varchar(64) — NOT NULL — answer the event
  • hint — varchar(256) — hint
  • reg_dt — datetime — NOT NULL — added on

tb_invitation_file

  • file_seq — int — Primary key — NOT NULL — sequnce of file
  • inv_seq — int — Foreign key → tb_invitation.inv_seq — NOT NULL — invitation sequence
  • file_nm — varchar(128) — NOT NULL — file name
  • file_path — varchar(256) — NOT NULL — fil path
  • reg_dt — datetime — NOT NULL — added on

tb_invitation_hist

  • tel — varchar(15) — Primary key — NOT NULL — tel
  • inv_seq — int — Foreign key → tb_invitation.inv_seq — NOT NULL — invitation sequence
  • space_seq — int — NOT NULL — space seq of visiting
  • agree_yn — varchar(1) — NOT NULL — agreement type01
  • agree2_yn — varchar(1) — NOT NULL — agreement type 02
  • reg_id — varchar(128) — NOT NULL — added by
  • reg_dt — datetime — NOT NULL — added on

tb_invitation_program

  • prog_seq — int — Primary key — NOT NULL — program sequnce
  • inv_seq — int — Foreign key → tb_invitation.inv_seq — NOT NULL — invitation sequence
  • title — varchar(128) — NOT NULL — title of program
  • context — text — NOT NULL — context of program
  • pic_path — varchar(256) — NOT NULL — picture of program
  • start_dt — varchar(10) — date of start of program
  • end_dt — varchar(10) — date of end of program
  • reg_dt — datetime — NOT NULL — added on

tb_kiosk

  • space_seq — int — Primary key — NOT NULL — sequence of space
  • kisok_seq (kiosk_seq) — int — Primary key — NOT NULL — sequence of kiosk
  • name — varchar(30) — NOT NULL — name of kiosk
  • sec_key — varchar(512) — NOT NULL — security code
  • mac — varchar(30) — mac address in kiosk device
  • busi_no — varchar(20) — business no
  • pay_key — varchar(128) — payment key
  • type_cd — varchar(30) — NOT NULL — type code
  • reg_id — varchar(128) — NOT NULL — added by
  • reg_dt — datetime — NOT NULL — added on
  • del_dt — datetime — NOT NULL — when deteled
  • del_id — varchar(128) — NOT NULL — who deleted

tb_kiosk_history

  • hist_seq — int — Primary key — NOT NULL — sequence of history
  • space_seq — int — Foreign key → tb_kiosk.space_seq — NOT NULL — sequence of space
  • kisok_seq (kiosk_seq) — int — Foreign key → tb_kiosk.kisok_seq — NOT NULL — sequence of kiosk
  • hist_type — varchar(30) — NOT NULL — history type of kiosk( 01 : connect,02:disconnect))
  • mac — varchar(30) — NOT NULL — mac address in kiosk device
  • ip — varchar(30) — NOT NULL — ip address in kiosk device
  • reg_dt — datetime — NOT NULL — added by

tb_order

  • ord_no — varchar(30) — Primary key — NOT NULL — order no
  • spaceSeq — int — NOT NULL — space sequnce
  • ord_type — varchar(30) — NOT NULL — order type(01:kiosk-pickup, 02:kiosk-delivery,03:online)
  • ord_nm — varchar(128) — NOT NULL — order name
  • ord_tel — varchar(15) — NOT NULL — tel of orderer
  • rec_nm — varchar(128) — NOT NULL — recipient name
  • rec_tel — varchar(15) — NOT NULL — recipient tel
  • rec_addr — varchar(256) — NOT NULL — rec_addr
  • rec_addr_detail — varchar(128) — rec addr detail
  • rec_zipcd — varchar(6) — NOT NULL — rec zip code
  • memo — varchar(512) — memo
  • base_price — int — NOT NULL — base price of product
  • pay_price — int — NOT NULL — pay price of product
  • status_cd — varchar(30) — NOT NULL — status code
  • ship_price — int — NOT NULL — shipping price
  • delivery_comp_cd — varchar(30) — delivery company code --not use
  • delivery_num — varchar(50) — delivery number --not use
  • main_prod_pic_path — varchar(128) — main picture of product
  • temp_yn — varchar(1) — temp yn
  • paid_yn — varchar(1) — paid yn
  • reg_id — varchar(128) — NOT NULL — added by
  • reg_dt — datetime — NOT NULL — added on
  • kiosk_seq — int — sequence of kiosk
  • rc_ceo — varchar(10) — ceo name for receipt
  • rc_busi_no — varchar(30) — busi no for receipt
  • rc_addr — varchar(512) — busi address for receipt
  • rc_brand_nm — varchar(30) — brand name for receipt
  • pay_method — varchar(1) — 1:cash ,2: card
  • service_order — varchar(1) — 서비스 주문건 여부
  • refund_price — int — 환불한금액
  • refund_change — int — 환불가능금액
  • temp_ord_no — varchar(30) — 임시주문번호 또는 외부주문번호
  • temp_ord_no2 — varchar(50) — 임시주문번호 또는 외부주문번호2
  • integ_log_seq_01 — varchar(1) — 주문연동여부1
  • integ_log_seq_02 — varchar(1) — 주문연동여부2
  • integ_ord_yn — varchar(1) — 주문연동 주문건
  • integ_dt — datetime — 연동일자
  • member_ord_yn — varchar(1) — 회원이 주문여부(Y,N)
  • bat_sync_yn — varchar(1) — 배치 완료여부(Y,N)
  • event_dis_price — int — 이벤트 할인 총금액
  • tax_refund_amt — int — 택스리펀금액
  • user_key — varchar(128) — 연관된 사용자 키
  • tax_free_price — int — 면세 금액
  • ins_chk — varchar(1) — 입력 구분(M:'모바일)
  • member_dis_price — int — 맴버쉽 할인 금액
  • member_cls_no — varchar(5) — 맴버쉽 적용 등급

tb_order_ext

  • pre_id — varchar(128) — Primary key — NOT NULL — premium id
  • ord_no — varchar(64) — Primary key — NOT NULL — order no
  • space_seq — int — NOT NULL — space number
  • kiosk_seq — int — kiosk number
  • reg_dt — datetime — NOT NULL — when added
  • space_nm — varchar(64) — space name

tb_order_integ_log

  • ord_no — varchar(30) — Primary key — NOT NULL — order no
  • pre_id — varchar(128) — Primary key — NOT NULL — premium id
  • seq — int — Primary key — NOT NULL — sequence
  • space_seq — int — space sequence
  • type — varchar(3) — I : 등록, R:반품
  • issue — text — 연동 이슈
  • suc_yn — varchar(1) — Y:성공, E : 오류
  • integ_dt — datetime — 연동시간
  • request — text — 요청사항
  • response — text — 응답사항

tb_order_prod_ext

  • pno — varchar(64) — Primary key — NOT NULL — product_code
  • pre_id — varchar(128) — Foreign key → tb_order_ext.pre_id — NOT NULL — premium id
  • ord_no — varchar(64) — Foreign key → tb_order_ext.ord_no — NOT NULL — order no
  • qty — int — NOT NULL — quentity
  • price — int — NOT NULL — price
  • reg_dt — datetime — NOT NULL — when added
  • prod_nm — varchar(128) — product name
  • image_path — varchar(256) — image path
  • ctgr_nm — varchar(256) — category name
  • ctgr_cd — varchar(30) — category code

tb_order_prods

  • ord_no — varchar(30) — Foreign key → tb_order.ord_no — NOT NULL — order no
  • pno — varchar(30) — Foreign key → tb_product_stock.pno — NOT NULL — product no
  • short_cd — varchar(150) — Foreign key → tb_product_stock.short_cd — NOT NULL — short_cd(opt_cd+detail_cd+child_opt_cd +child_detail_cd)
  • stock_seq — int — Foreign key → tb_product_stock.stock_seq — NOT NULL — stock sequnce
  • status_cd — varchar(30) — NOT NULL — status code
  • price — int — NOT NULL — price of product
  • cnt — int — NOT NULL — quantity of order
  • delivery_cd — varchar(30) — delivery company code
  • delivery_no — varchar(64) — delivery company tracking code
  • reg_dt — datetime — NOT NULL — added on
  • pickup_type_cd — varchar(30) — pickup type code
  • dis_price — int — discount price
  • cp_no — varchar(30) — coupon no
  • used_point — int — used point
  • prod_nm — varchar(60) — product name
  • option_nm — varchar(60) — product option name
  • prod_ori_price — int — product original price
  • prod_serv_price — int — product served price
  • ctgr_cd — varchar(30) — category code
  • ctgr_nm — varchar(30) — category name
  • pre_id — varchar(128) — premium id
  • product_image — varchar(256) — product image path
  • is_real_order — varchar(1) — is real time order
  • etc1 — varchar(30) — etc1
  • etc2 — varchar(30) — etc2
  • service_prod — varchar(1) — 서비스 제공 상품건
  • ord_no_attr1 — varchar(64) — 추가 주문번호(외부연동용)
  • event_dis_price — int — 이벤트 금액
  • event_id — varchar(12) — 적용이벤트 아이디

tb_passwd

  • user_id — varchar(128) — Foreign key → tb_user.user_id — NOT NULL — user_id
  • password — varchar(256) — NOT NULL — password
  • mod_id — varchar(128) — NOT NULL — mod_id
  • mod_dt — datetime — NOT NULL — modified on
  • reg_id — varchar(128) — NOT NULL — added by
  • reg_dt — datetime — NOT NULL — added on

tb_payment

  • ord_no — varchar(30) — Foreign key → tb_order.ord_no — NOT NULL — order no
  • result_cd — varchar(5) — NOT NULL — result code
  • result_msg — varchar(128) — NOT NULL — result message
  • tid — varchar(50) — NOT NULL — tid
  • moid — varchar(64) — NOT NULL — shop order identify
  • pay_method — varchar(30) — NOT NULL — pay method
  • amt — int — NOT NULL — price of product
  • auth_date — varchar(12) — authenticate date
  • auth_cd — varchar(30) — authenticate code
  • card_cd — varchar(30) — card code
  • card_nm — varchar(30) — card name
  • card_no — varchar(20) — card number
  • card_quota — varchar(2) — payment quota
  • card_ci — varchar(1) — card type
  • split_cancel_yn — varchar(1) — split cancel yn
  • bank_cd — varchar(30) — back code
  • back_nm (bank_nm) — varchar(30) — bank name
  • bank_recipt_type — varchar(30) — bank recipt type
  • pay_tel_no — varchar(16) — if paid phone, that number
  • cancel_amt — int — cancel amount
  • cancel_msg — varchar(512) — cancel request message
  • cancel_moid — varchar(64) — specific cancel order number
  • cancel_result_cd — varchar(30) — cancel result code
  • cancel_result_msg — varchar(128) — cancel result message
  • cancel_date — varchar(12) — cancel date
  • mod_id — varchar(128) — NOT NULL — modified by
  • mod_dt — datetime — NOT NULL — modified on
  • reg_id — varchar(128) — NOT NULL — added by
  • reg_dt — datetime — NOT NULL — added on

tb_payment_split

  • seq — int — Primary key — NOT NULL — sequence of payment
  • ord_no — varchar(30) — Foreign key → tb_order.ord_no — NOT NULL — order no
  • result_cd — varchar(5) — NOT NULL — result code
  • result_msg — varchar(128) — NOT NULL — result message
  • tid — varchar(50) — NOT NULL — tid
  • moid — varchar(64) — NOT NULL — shop order identify
  • pay_method — varchar(30) — NOT NULL — pay method
  • amt — int — NOT NULL — price of product
  • auth_date — varchar(12) — authenticate date
  • auth_cd — varchar(30) — authenticate code
  • card_cd — varchar(30) — card code
  • card_nm — varchar(30) — card name
  • card_no — varchar(20) — card number
  • card_quota — varchar(2) — payment quota
  • card_ci — varchar(1) — card type
  • split_cancel_yn — varchar(1) — split cancel yn
  • bank_cd — varchar(30) — back code
  • back_nm (bank_nm) — varchar(30) — bank name
  • bank_recipt_type — varchar(30) — bank recipt type
  • pay_tel_no — varchar(16) — if paid phone, that number
  • cancel_amt — int — cancel amount
  • cancel_msg — varchar(512) — cancel request message
  • cancel_moid — varchar(64) — specific cancel order number
  • cancel_result_cd — varchar(30) — cancel result code
  • cancel_result_msg — varchar(128) — cancel result message
  • cancel_date — varchar(12) — cancel date
  • mod_id — varchar(128) — NOT NULL — modified by
  • mod_dt — datetime — NOT NULL — modified on
  • reg_id — varchar(128) — NOT NULL — added by
  • reg_dt — datetime — NOT NULL — added on

tb_point

  • pre_id — varchar(128) — Primary key — NOT NULL — premium id
  • seq — int — Primary key — NOT NULL — sequence of point
  • from_point — int — NOT NULL — from point
  • to_point — int — NOT NULL — to point
  • sav_point — int — NOT NULL — save point
  • sav_type — varchar(30) — NOT NULL — save type
  • reg_dt — datetime — NOT NULL — when added
  • reg_id — varchar(128) — NOT NULL — who added
  • mod_dt — datetime — NOT NULL — when modified
  • mod_id — varchar(128) — NOT NULL — who modified

tb_pos_category

  • pre_id — varchar(128) — Primary key — NOT NULL — premium id
  • ctgr_seq — int — Primary key — NOT NULL — category sequence
  • space_seq — int — Primary key — NOT NULL — space sequence
  • ctgr_nm — varchar(60) — category name
  • pno — varchar(30) — Foreign key → tb_product_stock.pno — NOT NULL — product no
  • short_cd — varchar(150) — Foreign key → tb_product_stock.short_cd — NOT NULL — short_cd(opt_cd+detail_cd+child_opt_cd +child_detail_cd)
  • stock_seq — int — Foreign key → tb_product_stock.stock_seq — NOT NULL — stock sequnce
  • reg_dt — datetime — when added
  • reg_id — varchar(128) — who added

tb_prodcut_review (tb_product_review)

  • review_seq — int — Primary key — NOT NULL — sequnce of review
  • short_cd — varchar(150) — Foreign key → tb_product_stock.short_cd — NOT NULL — short_cd(opt_cd+detail_cd+child_opt_cd +child_detail_cd)
  • stock_seq — int — Foreign key → tb_product_stock.stock_seq — NOT NULL — stock sequnce
  • pno — varchar(30) — Foreign key → tb_product_stock.pno — NOT NULL — product no
  • context — text — NOT NULL — context
  • point — int — point of product
  • reg_id — varchar(128) — NOT NULL — added by
  • reg_dt — datetime — NOT NULL — added on

tb_product

  • pno — varchar(30) — Primary key — NOT NULL — product no
  • pre_id — varchar(128) — premium identify
  • name — varchar(128) — NOT NULL — name of product
  • ctgr_cd — varchar(30) — NOT NULL — category code
  • short_desc — text — short describe
  • describe — text — NOT NULL — describe of product
  • view_yn — varchar(1) — NOT NULL — view yn
  • base_price — int — NOT NULL — base price
  • dis_price — int — NOT NULL — discount price
  • reg_id — varchar(128) — NOT NULL — added by
  • reg_dt — datetime — NOT NULL — added on
  • mod_id — varchar(128) — NOT NULL — modified by
  • mod_dt — datetime — NOT NULL — modified on
  • delete_yn — varchar(1) — delete yn
  • delete_dt — datetime — delete date
  • confirm_yn — varchar(1) — confirm yn
  • confirm_dt — datetime — confirm_dt
  • serv_price — int — NOT NULL — served price
  • made_in — varchar(30) — made in
  • made_year — varchar(4) — made year
  • etc1 — varchar(255) — etc
  • etc2 — varchar(255) — etc 2
  • etc3 — varchar(255) — etc3
  • realtime_yn — varchar(1) — realtime order product
  • ship_price — int — shipping price
  • is_stock_alarm — varchar(1) — 재고알림 여부
  • is_no_discount — varchar(1) — 할인적용금지 제품
  • is_default — varchar(1) — 기본여부(쇼핑백등)
  • is_cafe24_prod — varchar(1) — cafe24 product

tb_product_category

  • pre_id — varchar(128) — Primary key — NOT NULL — premium id
  • ctgr_cd — varchar(30) — Primary key — NOT NULL — category code
  • name — varchar(128) — NOT NULL — category name
  • sort — int — NOT NULL
  • order_sort — varchar(30) — NOT NULL — order sort
  • order_by — varchar(30) — NOT NULL — order by
  • reg_id — varchar(128) — NOT NULL — added by
  • reg_dt — datetime — NOT NULL — added on
  • delete_yn — varchar(1) — delete yn
  • delete_dt — datetime — date of deleted
  • is_no_discount — varchar(1) — 할인적용금지 카테고리

tb_product_file

  • file_seq — int — Primary key — NOT NULL — sequnce of history
  • pno — varchar(30) — Foreign key → tb_product.pno — NOT NULL — product no
  • file_type — varchar(30) — NOT NULL — file type
  • file_nm — varchar(128) — NOT NULL — file name
  • file_path — varchar(256) — NOT NULL — file path
  • reg_dt — datetime — NOT NULL — added on

tb_product_option

  • opt_cd — varchar(30) — Primary key — NOT NULL — option code
  • pre_id — varchar(128) — Primary key — NOT NULL — premium id
  • opt_nm — varchar(128) — NOT NULL — option name
  • reg_id — varchar(128) — NOT NULL — added by
  • reg_dt — datetime — NOT NULL — added on
  • mod_id — varchar(128) — NOT NULL — modified by
  • mod_dt — datetime — NOT NULL — modified on
  • delete_yn — varchar(1) — delete yn
  • delete_dt — datetime — delete date
  • b_short_cd — varchar(2) — barcode short cd

tb_product_option_detail

  • detail_cd — varchar(30) — Primary key — NOT NULL — option detail code
  • opt_cd — varchar(30) — Foreign key → tb_product_option.opt_cd — NOT NULL — option code
  • detail_nm — varchar(128) — NOT NULL — option detail detail
  • reg_id — varchar(128) — NOT NULL — added by
  • reg_dt — datetime — NOT NULL — added on
  • mod_id — varchar(128) — NOT NULL — modifid by
  • mod_dt — datetime — NOT NULL — modified on
  • delete_yn — varchar(1) — delete_yn
  • delete_dt — datetime — delete_dt
  • b_short_cd — varchar(2) — barcode short_cd

tb_product_qna

  • qna_seq — int — Primary key — NOT NULL — sequnce of board
  • pno — varchar(30) — Foreign key → tb_product.pno — NOT NULL — product no
  • title — varchar(256) — NOT NULL — subject
  • context — text — NOT NULL — context
  • name — varchar(128) — name of customer
  • tel — varchar(15) — tel of customer
  • reg_id — varchar(128) — NOT NULL — added by
  • reg_dt — datetime — NOT NULL — added on

tb_product_qna_answer

  • qna_seq — int — Foreign key → tb_product_qna.qna_seq — NOT NULL — sequnce of board
  • pno — varchar(30) — Foreign key → tb_product_qna.pno — NOT NULL — product no
  • context — text — NOT NULL — answer of quest context
  • reg_id — varchar(128) — NOT NULL — added by
  • reg_dt — datetime — NOT NULL — added on

tb_product_review_file

  • file_seq — int — Primary key — NOT NULL — sequnce of file
  • review_seq — int — Foreign key → tb_prodcut_review.review_seq — NOT NULL — sequnce of review
  • short_cd — varchar(150) — Foreign key → tb_prodcut_review.short_cd — NOT NULL — short_cd(opt_cd+detail_cd+child_opt_cd +child_detail_cd)
  • stock_seq — int — Foreign key → tb_prodcut_review.stock_seq — NOT NULL — stock sequnce
  • pno — varchar(30) — Foreign key → tb_prodcut_review.pno — NOT NULL — product no
  • file_nm — varchar(128) — NOT NULL — file name
  • file_path — varchar(256) — NOT NULL — file path
  • reg_dt — datetime — NOT NULL — added on

tb_product_stock

  • short_cd — varchar(150) — Primary key — NOT NULL — short_cd(opt_cd+detail_cd+child_opt_cd +child_detail_cd)
  • stock_seq — int — Primary key — NOT NULL — stock sequnce
  • pno — varchar(30) — Foreign key → tb_product.pno — NOT NULL — product no
  • opt_cd — varchar(30) — NOT NULL — option code
  • detail_cd — varchar(30) — NOT NULL — option detail code
  • child_opt_cd — varchar(30) — children option code
  • child_detail_cd — varchar(30) — children option code
  • stock — int — NOT NULL — stock of product
  • add_price — int — NOT NULL — additional price
  • reg_id — varchar(128) — NOT NULL — added by
  • reg_dt — datetime — NOT NULL — added on
  • barcode — varchar(60) — barcode
  • subchild_opt_cd — varchar(30) — option code 3
  • subchild_detail_cd — varchar(30) — option detail code 3
  • opt_nm — varchar(64) — option name 1
  • opt_nm2 — varchar(64) — option name 2
  • opt_nm3 — varchar(64) — option name3
  • pre_id — varchar(128) — premium id
  • detail_nm — varchar(64) — detail name
  • detail_nm2 — varchar(64) — detail name2
  • detail_nm3 — varchar(64) — detail name3

tb_product_stock_hist

  • hist_seq — int — Primary key — NOT NULL — sequence of history
  • pre_id — varchar(128) — Primary key — NOT NULL — premium id
  • short_cd — varchar(150) — Foreign key → tb_product_stock.short_cd — NOT NULL — short_cd(opt_cd+detail_cd+child_opt_cd +child_detail_cd)
  • stock_seq — int — Foreign key → tb_product_stock.stock_seq — NOT NULL — stock sequnce
  • pno — varchar(30) — Foreign key → tb_product_stock.pno — NOT NULL — product no
  • qty — int — NOT NULL — qty
  • total_qty — int — NOT NULL — total qty
  • reg_id — varchar(128) — NOT NULL — who added
  • Field (reg_dt) — reg_dt — when added

tb_refund

  • ord_no — varchar(30) — Foreign key → tb_order_prods.ord_no — NOT NULL — order no
  • pno — varchar(30) — Foreign key → tb_order_prods.pno — NOT NULL — product no
  • short_cd — varchar(150) — Foreign key → tb_order_prods.short_cd — NOT NULL — short_cd(opt_cd+detail_cd+child_opt_cd +child_detail_cd)
  • stock_seq — int — Foreign key → tb_order_prods.stock_seq — NOT NULL — stock sequnce
  • cnt — int — NOT NULL — quantity of refund
  • status_cd — varchar(30) — NOT NULL — status code 01: request,02:process, 10:done, 99:refuse
  • reason — varchar(512) — NOT NULL — reason why wants to refund
  • answer — varchar(512) — answer
  • refund_price — int — refund price
  • reg_id — varchar(128) — NOT NULL — added by
  • reg_dt — datetime — NOT NULL — added on
  • refund_type — varchar(30) — NOT NULL — refund type
  • mod_id — varchar(128) — NOT NULL — who modified
  • mod_dt — datetime — NOT NULL — when modified
  • req_id — varchar(128) — request id
  • py_cancel_cd — varchar(30) — payment cancel code from api
  • py_cancel_msg — varchar(512) — payment cancel message from api
  • py_cancel_amt — int — exactly cancel amt
  • py_cancel_dt — datetime — exactly cancel date
  • group_seq — int — 환불같이한 그룹 일련번호
  • actual_refund_price — int — 환불그룹간 전체 환불금액
  • integ_log_seq1 — int — 주문연동 로그 일련번호
  • integ_log_seq2 (integ_log_seq_2) — int — 주문연동 로그 인련번호

tb_shipping_price

  • pre_id — varchar(128) — Primary key — NOT NULL — premium id
  • price — int — NOT NULL — shipping price
  • reg_id — varchar(128) — NOT NULL — added by
  • reg_dt — datetime — NOT NULL — added on
  • mod_id — varchar(128) — NOT NULL — modified by
  • mod_dt — datetime — NOT NULL — modified on

tb_sms_authcode

  • phone — varchar(15) — Primary key — NOT NULL — user phone
  • exp_time — varchar(12) — Primary key — NOT NULL — expired time
  • code — varchar(6) — NOT NULL — not null
  • reg_dt — datetime — NOT NULL — when added

tb_stock_slip

  • slip_no — varchar(15) — Primary key — NOT NULL — slop no
  • out_date — varchar(10) — NOT NULL — out date
  • pre_id — varchar(128) — NOT NULL — premium id
  • space_seq — int — NOT NULL — space sequence
  • slip_type — varchar(30) — NOT NULL — slip type
  • slip_state — varchar(30) — NOT NULL — slip process state
  • reg_id — varchar(128) — NOT NULL — who added
  • reg_dt — datetime — NOT NULL — when added
  • mod_id — varchar(128) — NOT NULL — who modified
  • mod_dt — datetime — NOT NULL — when modified
  • del_id — varchar(128) — who deleted
  • del_dt — datetime — when deleted

tb_store_stock(not used) (tb_store_stock)

  • space_seq — int — Primary key — NOT NULL — space seq
  • pno — varchar(30) — Foreign key → tb_product_stock.pno — NOT NULL — product no
  • short_cd — varchar(150) — Foreign key → tb_product_stock.short_cd — NOT NULL — short_cd(opt_cd+detail_cd+child_opt_cd +child_detail_cd)
  • stock_seq — int — Foreign key → tb_product_stock.stock_seq — NOT NULL — stock sequnce
  • stock — int — NOT NULL — store stock
  • confirm_yn — varchar(1) — NOT NULL — confirm yn
  • reg_id — varchar(128) — NOT NULL — added by
  • reg_dt — datetime — NOT NULL — added on

tb_store_stock_request_proc

  • proc_seq — int — Primary key — NOT NULL — sequence of process
  • hist_seq — int — Foreign key → tb_store_stock_requst.hist_seq — NOT NULL — history sequnce
  • space_seq — int — Foreign key → tb_store_stock_requst.space_seq — NOT NULL — space seq
  • pno — varchar(30) — Foreign key → tb_store_stock_requst.pno — NOT NULL — product no
  • short_cd — varchar(150) — Foreign key → tb_store_stock_requst.short_cd — NOT NULL — short_cd(opt_cd+detail_cd+child_opt_cd +child_detail_cd)
  • stock_seq — int — Foreign key → tb_store_stock_requst.stock_seq — NOT NULL — stock sequnce
  • status_cd — varchar(30) — NOT NULL — status code
  • msg — text — NOT NULL — message
  • reg_dt — datetime — NOT NULL — added on
  • reg_id — varchar(128) — NOT NULL — added by

tb_store_stock_requst (tb_store_stock_request)

  • hist_seq — int — Primary key — NOT NULL — history sequnce
  • space_seq — int — Foreign key → tb_store_stock(not used).space_seq — NOT NULL — space seq
  • pno — varchar(30) — Foreign key → tb_store_stock(not used).pno — NOT NULL — product no
  • short_cd — varchar(150) — Foreign key → tb_store_stock(not used).short_cd — NOT NULL — short_cd(opt_cd+detail_cd+child_opt_cd +child_detail_cd)
  • stock_seq — int — Foreign key → tb_store_stock(not used).stock_seq — NOT NULL — stock sequnce
  • cnt — int — request qty
  • req_user_type — varchar(30) — NOT NULL — request user type(01:space request,02:brand request)
  • req_type — varchar(30) — NOT NULL — request type(01:addtion, 02:return:03:move)
  • reg_id — varchar(128) — NOT NULL — added by
  • reg_dt — datetime — NOT NULL — added on
  • to_space_seq — int — if request to move stock to other space. the space sequence
  • slip_no — varchar(15) — Foreign key → tb_stock_slip.slip_no — NOT NULL — slop no
  • comp_yn — varchar(1) — complete yn
  • last_status_cd — varchar(30) — last status cd

tb_survey_answer

  • answer_seq — int — Primary key — NOT NULL — sequence of answer
  • survey_no — varchar(30) — Foreign key → tb_survey_quest.survey_no — NOT NULL — quest no
  • quest_seq — int — Foreign key → tb_survey_quest.quest_seq — NOT NULL — sequence of quest
  • type — varchar(30) — NOT NULL — type of answer
  • answer — varchar(512) — answer the quest
  • img_path — varchar(256) — image path
  • reg_dt — datetime — NOT NULL — when added
  • del_dt — datetime — when deleted

tb_survey_base

  • survey_no — varchar(30) — Primary key — NOT NULL — quest no
  • inv_seq — int — Foreign key → tb_invitation.inv_seq — NOT NULL — invitation sequence
  • pre_id — varchar(128) — Foreign key → tb_invitation.pre_id — NOT NULL — premium id
  • status_cd — varchar(30) — NOT NULL — status code
  • title — varchar(128) — NOT NULL — quest title
  • start_dt — varchar(10) — NOT NULL — start date
  • end_dt — varchar(10) — NOT NULL — end date
  • content — text — NOT NULL — content of survey
  • back_img_path — varchar(256) — NOT NULL — background image path
  • reg_dt — datetime — NOT NULL — when added
  • reg_id — varchar(128) — NOT NULL — who added
  • del_dt — datetime — when deleted
  • del_yn — varchar(1) — is deleted survey
  • result_desc — varchar(64) — description of survey result
  • result_link — varchar(256) — result link
  • survey_type — varchar(30) — NOT NULL — survey type

tb_survey_point

  • survey_no — varchar(30) — Foreign key → tb_survey_answer.survey_no — NOT NULL — quest no
  • quest_seq — int — Foreign key → tb_survey_answer.quest_seq — NOT NULL — sequence of quest
  • answer_seq — int — Foreign key → tb_survey_answer.answer_seq — NOT NULL — sequence of answer
  • type_seq — int — Foreign key → tb_survey_type.type_seq — NOT NULL — sequence of quest types
  • point — int — NOT NULL — point of the answer of the quest
  • reg_dt — datetime — NOT NULL — when added

tb_survey_quest

  • quest_seq — int — Primary key — NOT NULL — sequence of quest
  • survey_no — varchar(30) — Foreign key → tb_survey_base.survey_no — NOT NULL — quest no
  • context — varchar(256) — NOT NULL — quest context
  • step — int — NOT NULL — sort order
  • del_dt — datetime — when deleted
  • reg_dt — detetime — NOT NULL — when added

tb_survey_result

  • phone — varchar(15) — Primary key — NOT NULL — user phone
  • survey_no — varchar(30) — Foreign key → tb_survey_answer.survey_no — NOT NULL — quest no
  • quest_seq — int — Foreign key → tb_survey_answer.quest_seq — NOT NULL — sequence of quest
  • answer_seq — int — Foreign key → tb_survey_answer.answer_seq — NOT NULL — sequence of answer
  • space_seq — int — NOT NULL — sequence of space
  • reg_dt — datetime — NOT NULL — when added

tb_survey_type

  • type_seq — int — Primary key — NOT NULL — sequence of quest types
  • survey_no (suervey_no) — varchar(30) — Foreign key → tb_survey_base.survey_no — NOT NULL — quest no
  • name — varchar(40) — NOT NULL — type name
  • explain — text — NOT NULL — type explaain
  • img_path — varchar(256) — image path
  • rg_dt (reg_dt) — datetime — NOT NULL — when added
  • del_dt — datetime — when deleted
  • re_pno — varchar(30) — related to product no
  • re_short_cd — varchar(150) — related to product short code
  • re_stock_seq — int — related to product stock sequence
  • re_url — varchar(512) — related to link url

tb_tax_refund

  • ord_no — varchar(30) — Foreign key → tb_order.ord_no — NOT NULL — order no
  • refund_type — varchar(1) — NOT NULL — 환급방식(L:사후,R:즉시)
  • tid — varchar(10) — NOT NULL — tid
  • tax_type — varchar(2) — 세금유형 00:부가세,01:특소세
  • sel_price — int — 판매금액
  • sel_dt — varchar(6) — 판매일자
  • auth_no — varchar(15) — 원승인번호
  • auth_dt — varchar(12) — 원거래일자
  • tax_info — varchar(60) — 세금정보
  • buyer_info — varchar(512) — 구매자 정보
  • product_info — text — 품목정보
  • result_code — varchar(5) — 결과코드
  • tax_se_num — varchar(30) — 관세청 일련번호
  • refund_amt — int
  • vat_amt — int
  • comp_code — varchar(3) — 환급사 코드
  • notice — varchar(80)
  • cancel_auth_no — varchar(15) — 취소 승인번호
  • cancel_auth_dt — varchar(12) — 취소승인일자
  • reg_dt — datetime — NOT NULL — 등록일자
  • reg_id — varchar(128) — NOT NULL — 등록자

tb_tax_refund_log

  • req_seq — int — Primary key — NOT NULL — 요청일련번호
  • ord_no — varchar(30) — Foreign key → tb_tax_refund.ord_no — NOT NULL — order no
  • suc_yn — varchar(1) — NOT NULL — 성공여부 Y,N
  • req_text — text — 요청전문
  • res_text — text — 응답전문
  • req_dt — datetime — NOT NULL — 요청일자

tb_term

  • pre_id — varchar(128) — Primary key — NOT NULL — premium id
  • type — varchar(30) — Primary key — NOT NULL — 01:privacy
  • title — varchar(128) — NOT NULL — title of term
  • context — text — NOT NULL — context of term
  • mod_id — varchar(128) — who modified
  • mod_dt — datetime — when modified
  • reg_id — varchar(128) — NOT NULL — who added
  • reg_dt — datetime — NOT NULL — when added

tb_type_code

  • type_code — varchar(30) — Primary key — NOT NULL — type of code
  • p_type_code — varchar(30) — parent type code
  • value — varchar(128) — NOT NULL — discribe type_code
  • use_yn — varchar(1) — use yn
  • mod_id — varchar(128) — NOT NULL — who modified data
  • mod_dt — datetime — NOT NULL — when modified data
  • reg_id — varchar(128) — NOT NULL — who registed data
  • reg_dt — datetime — NOT NULL — when registed data

tb_user

  • user_id — varchar(128) — Primary key — NOT NULL — user_id
  • name — varchar(128) — NOT NULL — user name
  • email — varchar(128) — email
  • tel — varchar(15) — NOT NULL — tel
  • last_login_dt — datetime — date of last login
  • reg_dt — datetime — NOT NULL — added on
  • leave_dt (Field) — datetime — NOT NULL — when leave
  • leave_yn (Field2) — varchar(1) — NOT NULL — is leaved user
  • social_type (Field3) — varchar(30) — NOT NULL — social login type

tb_user_addr

  • addr_seq — int — Primary key — NOT NULL — sequence of history
  • user_id — varchar(128) — Foreign key → tb_user.user_id — NOT NULL — user_id
  • name — varchar(128) — NOT NULL — name
  • address — varchar(256) — NOT NULL — address
  • detail — varchar(256) — detail of address
  • zipcd — varchar(6) — NOT NULL — zip code
  • tel — varchar(15) — tel
  • request_msg — text — request message
  • is_default — varchar(1) — NOT NULL — is default address
  • reg_id — varchar(128) — NOT NULL — added by
  • reg_dt — datetime — NOT NULL — added on

tb_user_cart

  • seq — int — Primary key — NOT NULL — sequence of cart
  • user_id — varchar(128) — Foreign key → tb_user.user_id — NOT NULL — user_id
  • pno — varchar(30) — Foreign key → tb_product_stock.pno — NOT NULL — product no
  • short_cd — varchar(150) — Foreign key → tb_product_stock.short_cd — NOT NULL — short code
  • stock_seq — int — Foreign key → tb_product_stock.stock_seq — NOT NULL — stock sequnce
  • exp_date — varchar(8) — NOT NULL — expired date
  • qty — int — NOT NULL — quentity of buying
  • reg_dt — datetime — NOT NULL — when added

tb_user_point

  • hist_seq — int — Primary key — NOT NULL — sequence of history
  • phone — varchar(15) — Foreign key → tb_customer.phone — NOT NULL — user phone
  • pre_id — varchar(128) — Foreign key → tb_customer.pre_id — NOT NULL — premium id
  • point — int — NOT NULL — point
  • desc — varchar(256) — description of point
  • reg_dt — datetime — NOT NULL — when added
  • ord_no — varchar(30) — 주문번호
  • event_id — varchar(12) — 이벤트 번호
  • exp_dt — varchar(10) — 만료이랒

tb_user_roles

  • user_id — varchar(128) — Foreign key → tb_user.user_id — NOT NULL — user_id
  • roles — varchar(30) — NOT NULL — user roles
  • mod_dt — datetime — NOT NULL — modified on
  • mod_id — varchar(128) — NOT NULL — modifid by
  • reg_dt — datetime — NOT NULL — added on
  • reg_id — varchar(128) — NOT NULL — added by

tb_user_session

  • session_id — varchar(32) — Primary key — NOT NULL — session id
  • user_id — varchar(128) — Foreign key → tb_user.user_id — NOT NULL — user_id
  • login_time — datetime — NOT NULL — login time
  • logout_time — datetime — logout time