듀벨업무사이트_판매&상담
테이블 (33)
P_lclass
- l_code — int — 기본 키 — NOT NULL
- lclass_name — varchar(200) — NOT NULL
- wdate — datetime — NOT NULL
- d_chk — char(1) — NOT NULL
- turn — tinyint
P_master
- idx — int — 기본 키 — NOT NULL
- l_code — int — NOT NULL
- m_code — int — NOT NULL
- s_code — int — NOT NULL
- p_name — varchar(200) — NOT NULL
- p_price — int
- p_code — varchar(50) — 현재 미사용
- p_barcode — char(14) — NOT NULL
- wdate — datetime — NOT NULL
- d_chk — char(1) — NOT NULL
- sch_text — text
- each_num — int
- v_chk — char(1) — NOT NULL
- p_weight1 — float — 현재 사용안함
- p_weight2 — float — 현재 사용안함
- refilstandard_chk — char(1) — NOT NULL
- admin — int
- re_mat_code — nvarchar(30)
- re_mat_use_count — float
- ABAIL — float
P_master_part
- idx — int — 기본 키 — NOT NULL
- pmaster_idx — int — NOT NULL
- pro_idx — int — NOT NULL
- pro_count — int — NOT NULL
- tmp_pmaster_idx — int
P_master_refil
- idx — int — 기본 키 — NOT NULL
- pmaster_idx — int — NOT NULL
- refil_count — int — NOT NULL
- pro_idx — int
- tmp_pmaster_idx — int
P_mat
- idx — int — 기본 키 — NOT NULL
- pro_idx — int — NOT NULL
- mat_idx — int — mat_master2 : idx (현재 미사용)
- mat_code — nvarchar(30)
- mat_unit — nvarchar(20)
- use_count — float — NOT NULL
- regdate — datetime — NOT NULL
- warehousing — varchar(20)
- customer_code — varchar(20)
P_mclass
- m_code — int — 기본 키 — NOT NULL
- l_code — int — 외래 키 → P_lclass.l_code — NOT NULL
- mclass_name — varchar(200) — NOT NULL
- wdate — datetime — NOT NULL
- d_chk — char(1) — NOT NULL
- turn — tinyint
P_sclass
- s_code — int — 기본 키 — NOT NULL
- m_code2 — int — 외래 키 → P_mclass.m_code — NOT NULL
- l_code2 — int — 외래 키 → P_mclass.l_code — NOT NULL
- sclass_name — varchar(200) — NOT NULL
- wdate — datetime — NOT NULL
- d_chk — char(1) — NOT NULL
- turn — tinyint
TTB
- idx — int — 기본 키 — NOT NULL
- gubun — varchar(20)
- buyer — varchar(50)
- receiver — varchar(50)
- rec_zipcode — varchar(15)
- rec_addr — varchar(300)
- rec_phone1 — varchar(40)
- rec_phone2 — varchar(40)
- buy_num — int
- sum_money — float
- deliver_charge — varchar(20)
- ori_choice_order — varchar(2000)
- choice_order — varchar(2000)
- choice_order1 — varchar(500) — 경우에 따라 choice_order1사용
- add_order — varchar(500)
- requirement — varchar(500)
- buy_phone1 — varchar(40)
- wdate — datetime
- status — char(2)
- status_mat — char(2) — 현재 미사용이나 주문엑셀업로드시 값이 'N'으로 들어가고 있음. 삭제하려면 소스수정 필요
- cancel_date — datetime
- memo — text
- input_bank — tinyint
- admin — int
- waybill_num — char(14)
- send_chk — char(1)
- delivery_chk — char(1) — 현재 미사용
- customer — nvarchar(20) — NOT NULL — 주문사이트가 거래처인 경우 추가로 들어감(거래처코드)
- order_num — varchar(50)
- d_chk — char(1) — NOT NULL
- tmp_idx — int
- sabang_ordernum — varchar(50)
- repre_phone1 — varchar(40) — 택배 합포장시 사용
- repre_phone2 — varchar(40) — 택배 합포장시 사용
- ship_div — char(1) — NOT NULL
- release_date — datetime
- pro_gubun — char(1) — 택배자료다운시 같은 상품군끼리 묶을때 사용
- shoppro_code — varchar(50)
- release_schedule — datetime
- v_list — char(1) — NOT NULL
TTB_netgain
- idx — int — 기본 키 — NOT NULL
- auction — float
- gmarket — float
- st_11 — float
- interpark — float
- lotte — float
- daiso — float
- uniwater — float
- storefarm — float
- lala — float
- cjoshopping — float
- hnshop — float
- nhmarket — float — 현재는 미사용
- ssg — float
- emart — float
- gsshop — float
- kakao_P — float
- immall — float
- wemake — float
- qoo10 — float
- amazon — float
- coupang — float
- tmon — float
- moongory — float
- smartwell — float
- lotteimall — float
- todayhome — float
- wdate — datetime
- sale_date — date
- d_chk — char(1) — 1:삭제, 0:정상
- admin — int
- eland — float
- happy — float
- apmall — float
TTB_release
- idx — int — 기본 키 — NOT NULL
- TTB_idx — int
- pro_idx — int
- order_num — int
- cancel_num — int
- waybill_num — char(15)
- wdate — datetime — NOT NULL
- status — char(1) — NOT NULL — code_master : class = 'release_status'
- pro_name — varchar(300)
- d_chk — char(1) — NOT NULL
- tmp_ttb_idx — int
- release_schedule — datetime
- P_lcode — int
- P_mcode — int
- P_scode — int
- ttb_gubun — varchar(20)
- ttb_customer — varchar(20)
- p_name — varchar(200)
- ship_div — char(1)
- tmp — int
- p_price — float — NOT NULL
TTB_release_mat
- idx — int — 기본 키 — NOT NULL
- ttb_idx — int
- rocket_idx — int
- waybill_num — nvarchar(20)
- pro_idx — int
- pro_order_num — int
- mat_code — nvarchar(20)
- mat_order_num — float
- input_day — datetime
- admin — varchar(20) — 담당자 ID
- customer_code — nvarchar(20)
- receiver — nvarchar(50)
- mat_unit — nvarchar(10)
- ship_div — nvarchar(10)
- release_pro_idx — int
- use_count — float
- P_ship_no — nvarchar(30)
- P_status — nchar(10) — 아무내용도 없으면 정상
- gubun — nchar(15) — TTB : 판매관리, rocket : 쿠팡로켓, mat_interlock : 직접출하
- warehousing — varchar(20)
- reason — varchar(300) — 직접출하시 입력
TTB_release_pro
- idx — int — 기본 키 — NOT NULL
- receiver — nchar(50)
- waybill_num — nchar(14)
- p_barcode — nchar(13)
- pro_idx — int — NOT NULL
- order_num — int — NOT NULL
- release_num — int
- c_release_num — int
- input_day — datetime — NOT NULL
- admin — int
- ttb_idx — int
- d_chk — char(1) — NOT NULL
- status — char(1) — NOT NULL — 0 : 바코드출고, 1 : 자재출고
- ship_div — char(1)
- customer_code — varchar(20)
- mat_prog_chk — tinyint
- P_ship_no — nvarchar(30)
- end_chk — nchar(1)
- release_schedule — datetime
- P_lcode — int
- P_mcode — int
- P_scode — int
- ttb_gubun — varchar(20)
- ttb_customer — varchar(20)
- p_name — varchar(300)
- v_list — char(1) — NOT NULL
- re_mat_code — nvarchar(50)
- re_mat_use_count — float
account
- idx — int — 기본 키 — NOT NULL
- customer_code — varchar(20)
- gubun — tinyint — code_master : class = 'account_gubun'
- IO_gubun — tinyint — code_master : class = 'account_IOgubun'
- shop_chk — char(1)
- nation — tinyint — code_master : class = 'nation'
- com_registnum — varchar(50)
- com_name — nvarchar(150) — NOT NULL
- com_ceo — nchar(50)
- com_tel — nchar(30) — NOT NULL
- com_fax — nchar(30)
- com_email — varchar(150)
- com_zipcode — nchar(15)
- com_address — nvarchar(150)
- charge_name — nvarchar(100)
- charge_position — nvarchar(100)
- charge_tel — nchar(30)
- memo — text
- input_idx — int — NOT NULL
- input_day — datetime — NOT NULL
- d_chk — char(1) — NOT NULL
- agent_chk — tinyint — code_master : class = 'account_agent'
code_master
- code — nchar(10) — 기본 키 — NOT NULL
- class — nchar(50) — 기본 키 — NOT NULL
- idx — int — NOT NULL
- code_name — nchar(50) — NOT NULL
- class_name — nchar(50)
- isActive — char(1) — NOT NULL
- d_chk — char(1) — NOT NULL
- turn_num — tinyint
consult_data
- idx — int — 기본 키 — NOT NULL
- gubun — tinyint — code_master : class = 'o_consult_gubun'
- admin — int
- input_admin — int
- wdate — datetime
- d_chk — char(1)
- inquiry — text
- answer — text
mat_arrival_schedule
- idx — int — 기본 키 — NOT NULL
- status — tinyint — NOT NULL — code_master : class = 'matwarehousing_status'
- fixed_date — date — NOT NULL
- fixed_date_chk — char(1) — NOT NULL — 1 : 납기일 무시, 지속체크품목
- customer_idx — int
- mat_code — varchar(50) — NOT NULL
- mat_name — varchar(100) — NOT NULL
- mat_spec — varchar(300)
- order_num — float — NOT NULL
- arrival_num — float
- warehousingwill_num — float
- mat_unit — tinyint — NOT NULL — code_master : class = 'mat_unit'
- order_code — nchar(13)
- input_idx — int — NOT NULL
- input_date — datetime — NOT NULL
- modify_idx — int
- modify_date — datetime
- order_date — date
- order_name — varchar(20)
- memo — varchar(300)
- d_chk — char(1) — NOT NULL
- customer_name — nvarchar(150)
- order_idx — int
- order_status — tinyint — NOT NULL — code_master : class = 'mat_arrival_schedule_orderstatus'
- order_maildate — datetime
- mat_price — float
- t_mat_price — float
- test_chk — char(1)
mat_arrival_schedule_order
- idx — int — 기본 키 — NOT NULL
- memo — varchar(2000)
- send_date — datetime
- admin — int
- from_email — nvarchar(60)
- to_email — nvarchar(60)
- open_chk — char(1)
- open_day — datetime
- subject — nvarchar(200)
- reference_email — nvarchar(60)
- vendor — nvarchar(200)
- ordermat_idx — nvarchar(1000) — mat_arrival_schedule의 idx(복수의 경우 쉼표(,)로 구분)
- customer_name — nvarchar(150)
- file1 — nvarchar(50)
- arrival_adminidx — int
mat_orcl_error
- idx — int — 기본 키 — NOT NULL
- release_pro_idx — int
- pro_idx — int
- mat_code — nvarchar(50)
- mat_unit — nvarchar(50)
- use_count — float
- p_ship_no — nvarchar(50)
- p_status — nvarchar(50)
- p_code — nvarchar(50)
- input_day — datetime
pro_keyword_log
- idx — int — 기본 키 — NOT NULL
- ttb_idx — int
- p_keyword — nvarchar(100)
- admin — int
- input_day — date
- only_chk — char(1) — NOT NULL
ql_class
- lclass_code — int — 기본 키 — NOT NULL
- mclass_code — int — 기본 키 — NOT NULL
- class_name — varchar(50) — NOT NULL
- d_chk — char(1) — NOT NULL
- input_date — datetime — NOT NULL
- idx — int — NOT NULL
ql_master
- idx — int — 기본 키 — NOT NULL
- occur_date — date — NOT NULL
- buy_date — date — NOT NULL
- lclass_code — int — NOT NULL
- mclass_code — int — NOT NULL
- type_idx — int — NOT NULL
- position_idx — int
- result_idx — int — NOT NULL
- comment — text — ext NUL
- ttb_idx — int — NOT NULL
- input_idx — int — NOT NULL
- input_date — datetime — NOT NULL
- d_chk — char(1) — NOT NULL
- name — varchar(50) — NOT NULL
- phone — char(20)
- p_name — varchar(300)
- mod_idx — int
- mod_date — datetime
- shop_ordernum — varchar(30)
- TTB_gubun — varchar(20)
- pro_idx — int
- pro_cnt — smallint
- LOT_NO — varchar(50)
- examine_chk — char(1) — NOT NULL — 1 : 품질검사대상, 0 : 해당없음
- pickup_chk — char(1) — NOT NULL — 1 : 수거신청, 0 : 해당없음
- pickup_date — datetime
ql_position
- idx — int — 기본 키 — NOT NULL
- lclass_code — int — NOT NULL
- mclass_code — int — NOT NULL
- position_name — varchar(50) — NOT NULL
- d_chk — char(1) — NOT NULL
- input_date — datetime — NOT NULL
ql_pro
- idx — int — 기본 키 — NOT NULL
- lclass_code — int — NOT NULL
- mclass_code — int — NOT NULL
- pro_idx — int — NOT NULL — 필드품질분류에 따른 판매갯수 산정을 위함
- use_num — smallint
- input_date — datetime — NOT NULL
ql_result
- idx — int — 기본 키 — NOT NULL
- result_name — varchar(50) — NOT NULL
- d_chk — char(1) — NOT NULL
ql_type
- idx — int — 기본 키 — NOT NULL
- type_name — varchar(50) — NOT NULL
- d_chk — char(1) — NOT NULL
- input_date — datetime — NOT NULL
returnform
- idx — int — 기본 키 — NOT NULL
- consult_idx — int
- ttb_idx — int
- pro_status — char(1)
- name — nvarchar(20) — NOT NULL
- phone — nvarchar(20)
- p_name — nvarchar(200)
- account — nvarchar(50)
- accept_date — datetime — NOT NULL
- warehousing_date — datetime — NOT NULL
- admin_name — nvarchar(20)
- reason — int
- comment — text — ext NUL
- admin — int
- input_day — datetime — NOT NULL
- status — tinyint — NOT NULL — code_master : class = 'returnform_status'
- d_chk — char(1) — NOT NULL
- examine_chk — char(1) — NOT NULL
returnform_detail
- idx — int — 기본 키 — NOT NULL
- returnform_idx — int — NOT NULL
- status — tinyint — NOT NULL — code_master : class = 'returnform_status'
- input_day — datetime — NOT NULL
- memo — text
- admin — int — NOT NULL
- d_chk — char(1) — NOT NULL
returnform_pro
- idx — int — 기본 키 — NOT NULL
- returnform_idx — int — NOT NULL
- num — smallint
- pro_idx — int — NOT NULL
- pro_cnt — smallint — NOT NULL
- tmp_returnform_idx — int
- input_day — datetime — NOT NULL
- d_chk — char(1)
rocket_districenter
- idx — int — 기본 키 — NOT NULL
- distri_name — varchar(50) — NOT NULL
- phone — varchar(30) — NOT NULL
- zipcode — varchar(15)
- address — varchar(150) — NOT NULL
- d_chk — bit
rocket_sale
- idx — int — 기본 키 — NOT NULL
- order_num — int — NOT NULL
- sku_id — int — NOT NULL
- sku_name — varchar(100) — NOT NULL
- barcode — varchar(20) — NOT NULL
- order_amount — int — NOT NULL
- delivery_amount — int — NOT NULL
- return_amount — int — NOT NULL
- distri_center — int
- order_date — date — NOT NULL
- ship_date — date — NOT NULL
- delivery_date — date
- money — float — NOT NULL
- delivery_method — tinyint — code_master : class = 'rocket_delivery_method'
- pro_idx — int
- wdate — datetime — NOT NULL
- admin — int — NOT NULL
- d_chk — char(1) — NOT NULL
- keyword_chk — char(1)
- status — tinyint — code_master : class = 'rocket_status'
- box_no — smallint
- waybill_num — varchar(20)
- mat_prog_chk — char(1)
- P_ship_no — nchar(30)
- mat_stock — float
- mes_release_date — datetime
- turn_num — smallint
- memo — varchar(100)
rocket_sale_pro
- idx — int — 기본 키 — NOT NULL
- distri_center — varchar(50)
- sku_name — varchar(100) — NOT NULL
- rocket_order_num — varchar(10) — NOT NULL
- order_num — int — NOT NULL
- release_num — int — NOT NULL
- c_release_num — int — NOT NULL
- wdate — datetime — NOT NULL
- waybill_num — nchar(14) — NOT NULL
- pro_idx — int — NOT NULL
- p_barcode — nchar(13) — NOT NULL
- d_chk — char(1) — NOT NULL
- turn_num — smallint
rocket_shipdown_num
- chk_data — nvarchar(3000) — 쿠팡로켓 쉽먼트자료다운 - 한번에 20개이상 선택시 엑셀다운 문제가 생겨 임시로 저장하여 처리하는 TABLE
tmp_TTB_gurae_release_calendar
- release_schedule_date — varchar(10)
- customer — nvarchar(13)
- receiver — nvarchar(50)
- com_name — nvarchar(100)
- status — nvarchar(20)