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