업무사이트_미사용
테이블 (33)
account
- idx — int — 기본 키 — NOT NULL
- gubun — tinyint — code_master : class = 'account_gubun'
- IO_gubun — tinyint — code_master : class = 'account_IOgubun'
- shop_chk — char(1)
- customer_code — varchar(20)
- 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'
admin
- idx — int — 기본 키 — NOT NULL
- id — varchar(20)
- pw — varchar(30)
- grade — tinyint
- team — tinyint — NOT NULL — code_master : class = 'admin_team'
- name — varchar(20) — NOT NULL
- isActive — char(1)
- turn_num — tinyint
- position — tinyint — NOT NULL — code_master : class = 'admin_position'
- email — varchar(50)
- com_phone — varchar(20)
- hp — varchar(20)
- hire_date — datetime
- d_chk — char(1) — 1 : 삭제, 0 : 정상
- birth_date — datetime
- lunar_chk — char(1) — NOT NULL — 음력 1, 양력 0
admin_menu
- idx — int — 기본 키 — NOT NULL
- l_code — int — NOT NULL
- m_code — int — NOT NULL
- s_code — int — NOT NULL
- img — varchar(50)
- comment — varchar(50) — NOT NULL
- url — varchar(100)
- grade — tinyint — NOT NULL
- turn_num — smallint
- v_chk — char(1) — NOT NULL
annual
- idx — int — 기본 키 — NOT NULL — 자동증가
- user_idx — int — NOT NULL
- annual_year — char(4) — NOT NULL
- annual — float — NOT NULL
- admin — int — NOT NULL
- memo — varchar(300)
annual_use
- idx — int — 기본 키 — NOT NULL — 자동증가
- user_idx — int — NOT NULL
- use_date — datetime — NOT NULL
- type — tinyint — NOT NULL — code_master : class = 'annual_type' 1 : 오전반차, 2 : 연차, 3 : 유급휴가, 4 : 오후반차
- reason — tinyint — NOT NULL — code_master : class = 'annual_reason' 1: 육아/가사, 2 : 병원진료, 3 : 은행업무, 4: 이사, 5 : 연차소진, 7 : 기타, 8 : 여름휴가
- reason_detail — varchar(200)
- input_date — datetime — NOT NULL
- result — tinyint — NOT NULL — code_master : class = 'annual_result' 1: 대기, 2 : 승인, 3 : 보류
- result_detail — tinyint — code_master : class = 'annual_result_detail' 1: 날짜변경요망, 2 : 잔여연차부족, 3: 기타
b_data
- idx — int — 기본 키 — NOT NULL — 자동증가
- category — tinyint — NOT NULL — code_master : class = 'data_category'
- subject — varchar(50) — NOT NULL
- memo — text
- admin — int — NOT NULL
- input_day — datetime — NOT NULL
b_data_file
- idx — int — 기본 키 — NOT NULL
- data_idx — int — NOT NULL
- input_file — varchar(50) — NOT NULL
cal
- idx — int — 기본 키 — NOT NULL
- subject — varchar(50)
- content — text
- cal_year — varchar(5)
- cal_month — varchar(3)
- cal_date — varchar(3)
- add_file — varchar(100)
checkitem
- idx — int — 기본 키 — NOT NULL
- gubun — tinyint — NOT NULL — code_master : class = 'checkitem_gubun'
- mat_code1 — varchar(50) — NOT NULL
- mat_name1 — varchar(300) — NOT NULL
- mat_code2 — varchar(50)
- mat_name2 — varchar(300)
- mat_code3 — varchar(50)
- mat_name3 — varchar(300)
- mat_code4 — varchar(50)
- mat_name4 — varchar(300)
- mat_code5 — varchar(50)
- mat_name5 — varchar(300)
- chg_content — varchar(500)
- mat_image — varchar(100)
- warehousing_date1 — datetime
- apply_date1 — datetime
- issue_content1 — varchar(500)
- warehousing_date2 — datetime
- apply_date2 — datetime
- issue_content2 — varchar(500)
- warehousing_date3 — datetime
- apply_date3 — datetime
- issue_content3 — varchar(500)
- warehousing_date4 — datetime
- apply_date4 — datetime
- issue_content4 — varchar(500)
- warehousing_date5 — datetime
- apply_date5 — datetime
- issue_content5 — varchar(500)
- input_day — datetime — NOT NULL
- admin — int — NOT NULL
- d_chk — char(1) — NOT NULL
checkitem_charge
- idx — int — 기본 키 — NOT NULL
- checkitem_idx — int
- charge — int
- open_chk — char(1)
- input_day — datetime
- open_day — datetime
- alarm_gubun — tinyint — code_master : class = 'checkitem_alarm_gubun'
- alarm_reason — varchar(1000)
checkitem_file
- idx — int — 기본 키 — NOT NULL
- checkitem_idx — int — NOT NULL
- input_file — varchar(100) — NOT NULL
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 — 1 : 삭제, 0 : 정상
- turn_num — tinyint
develop2
- idx — int — 기본 키 — NOT NULL
- dev_gubun — tinyint — code_master : class = 'develop_gubun'
- mat_code — varchar(30)
- pro_name — varchar(100)
- wdate — datetime
- admin — int
- dev_class — int — code_master : class = 'develop_class'
- comment — varchar(500) — archar(500) NUL
- d_chk — char(1)
- file1 — varchar(150)
- file2 — varchar(150)
- file3 — varchar(150)
dew_board_bell
- ref — int — 기본 키 — NOT NULL
- step — int — 기본 키 — NOT NULL
- lev — int — 기본 키 — NOT NULL
- bbsid — varchar(30) — 기본 키 — NOT NULL
- writer — varchar(50) — NOT NULL
- email — varchar(50)
- subject — varchar(200) — NOT NULL
- content — text
- password — varchar(30) — NOT NULL
- readcnt — int — NOT NULL
- filename — varchar(200)
- filesize — int
- download — int
- ip — varchar(20) — NOT NULL
- wtime — varchar(50) — NOT NULL
dew_board_bell_charge
- idx — int — NOT NULL
- board_ref — int — NOT NULL
- board_step — int
- board_lev — int
- bbsid — varchar(30) — NOT NULL
- charge — int — NOT NULL
- open_chk — char(1) — NOT NULL
- input_day — datetime — NOT NULL
- open_day — datetime
export_manage
- idx — int — 기본 키 — NOT NULL
- export_declaration_date — datetime
- invoice_date — datetime
- release_date — datetime
- order_date — datetime
- export_declaration_num — varchar(50)
- exchange_rate — varchar(50)
- exchange_date — datetime
- nation — tinyint — code_master : class = 'nation'
- entry_company — varchar(50)
- account — int
- export_form — tinyint — code_master : class = 'export_form'
- export_form_etc — varchar(100)
- shipping_method — tinyint — NOT NULL — code_master : class = 'export_shippingmethod'
- shipping_method_etc — varchar(100)
- cost_bear — tinyint — code_master : class = 'export_cost_bear'
- sales_money — float
- sales_money_unit — tinyint — code_master : class = 'export_sales_money_unit'
- shipping_cost — float
- clear_cost — float
- etc_cost — float
- etc_cost_item — varchar(100)
- memo — text
- admin — int — NOT NULL
- input_day — datetime — NOT NULL
- d_chk — char(1) — NOT NULL — 1 : 삭제, 0 : 정상
export_manage_file
- idx — int — 기본 키 — NOT NULL
- export_manage_idx — int — NOT NULL
- input_file — varchar(150) — NOT NULL
export_manage_product
- idx — int — 기본 키 — NOT NULL
- export_manage_idx — int — NOT NULL
- mat_code — varchar(50)
- p_name — text
- p_content — text
- p_ordernum — int
- p_unitprice — float
- p_price — float
- p_unitprice_unit — tinyint — code_master : class = 'export_sales_money_unit'
extended
- idx — int — 기본 키 — NOT NULL — 자동증가
- user_idx — int — NOT NULL
- use_date — date — NOT NULL
- use_time — float — NOT NULL
- reason — nvarchar(1000)
- input_date — datetime — NOT NULL
lunardate
- lunar_date — nvarchar(255)
- sun_date — nvarchar(255)
meeting
- idx — int — 기본 키 — NOT NULL
- meeting_gubun — tinyint — NOT NULL — code_master : class = 'meeting_gubun'
- status — tinyint — NOT NULL — 1. 회의예정 2. 회의완료(회의록)
- pre_admin — int — NOT NULL
- pre_attendancelist — varchar(1000) — NOT NULL
- pre_item — varchar(1000) — NOT NULL
- pre_plan — text
- pre_datetime — datetime — NOT NULL
- meeting_sdate — datetime
- meeting_edate — datetime
- meeting_attendancelist — varchar(1000)
- meeting_item — varchar(1000)
- meeting_content — text
- meeting_decision — varchar(4000)
- meeting_memo — varchar(4000)
- meeting_admin — int
- input_day — datetime — NOT NULL
- d_chk — char(1) — NOT NULL
meeting_file
- idx — int — 기본 키 — NOT NULL
- meeting_idx — int — NOT NULL
- gubun — tinyint — NOT NULL — 1. 회의사전자료 2. 회의록자료
- filename — varchar(100) — NOT NULL
namecard
- idx — int — 기본 키 — NOT NULL
- company — varchar(50)
- com_title — varchar(30)
- name — varchar(20)
- handphone — char(20)
- phone — char(20)
- faxnum — char(20)
- email — varchar(50)
- homepage — varchar(50)
- com_address — varchar(60)
- meet_date — varchar(50)
- work_item — varchar(50)
- etc — varchar(60)
- input_day — datetime
namecard_file
- idx — int — 기본 키 — NOT NULL
- namecard_idx — int — NOT NULL
- filename — varchar(50) — NOT NULL
- regdate — datetime — NOT NULL
overtime
- idx — int — 기본 키 — NOT NULL
- user_idx — int
- use_date — datetime
- plan_memo — text
- status — tinyint — code_master : class = 'overtime_status' 1 : 입력, 2 : 신청, 3 : 승인, 4 : 완료
- request_date — datetime
- approve_date — datetime
- result_memo — text
- result_etc — text
- result_date — datetime
- approve_useridx — int
- use_time — smallint
spend_approval
- idx — int — 기본 키 — NOT NULL — 자동증가
- spend_idx — int — NOT NULL
- spend_div — tinyint — NOT NULL — 1 : 품의서, 2 : 보고서
- approval_cnt — tinyint
- approval_admin1 — int — NOT NULL
- approval_chk1 — char(1) — NOT NULL — 0 : 결재대기 1 : 결재승인 2 : 결재반려 3 : 결재중지
- approval_date1 — datetime
- approval_return_reason1 — varchar(300)
- approval_admin2 — int
- approval_chk2 — char(1) — 0 : 결재대기 1 : 결재승인 2 : 결재반려 3 : 결재중지
- approval_date2 — datetime
- approval_return_reason2 — varchar(300)
- approval_admin3 — int
- approval_chk3 — char(1) — 0 : 결재대기 1 : 결재승인 2 : 결재반려 3 : 결재중지
- approval_date3 — datetime
- approval_return_reason3 — varchar(300)
- v_chk — char(1) — NOT NULL — 유효성 체크(1일 경우에만 결재상태에 보임)
spend_cancel
- idx — int — 기본 키 — NOT NULL — 자동증가
- spend_idx — int — NOT NULL
- spend_div — tinyint — NOT NULL — 1 : 품의서, 2 : 보고서
- cancel_div — tinyint — NOT NULL — code_master : class = 'spend_cancel' 1 : 수정후재결재, 2 : 구매불필요, 3 : 기타
- cancel_memo — varchar(200)
- admin — int — NOT NULL
- input_date — datetime — NOT NULL
- approval_admin1 — int
- approval_chk1 — char(1)
- approval_date1 — datetime
- approval_admin2 — int
- approval_chk2 — char(1)
- approval_date2 — datetime
- approval_admin3 — int
- approval_chk3 — char(1)
- approval_date3 — datetime
spend_class
- idx — int — 기본 키 — NOT NULL — 자동증가
- lclass — smallint
- mclass — smallint — 중분류 : 현재 미사용이나 추후 사용할수 있어 남겨놓았음. mclass가 0인것만 사용되고 있음
- class_name — nvarchar(50)
- d_chk — char(1) — NOT NULL — 1 : 삭제, 0 : 정상
- turn_num — smallint
spend_manage
- idx — int — 기본 키 — NOT NULL — 자동증가
- spend_idx — int — 기본 키 — NOT NULL
- spend_div — tinyint — 기본 키 — NOT NULL — 1 : 품의서, 2 : 보고서
- document_num — char(12) — 품의서 : SA(날짜)_(일련번호) 사후보고서 : SB(날짜)_(일련번호) 일반보고서 : SC(날짜)_(일련번호)
- subject — varchar(200) — NOT NULL
- status — smallint — NOT NULL — code_master : class = 'spend_status' 1: 품의서작성중, 2 : 품의서결재중, 3 : 구매진행, 4 : 직구매진행, 5 : 구매완료&보고서작성중, 6 : 보고서 결재중, 7 : 완료,…
- pay_method1 — smallint — NOT NULL — code_master : class = 'spend_pay_method1' 1 : 직접구매, 2 : 구매요청
- pay_method2 — smallint — code_master : class = 'spend_pay_method2' 1 : 기업카드, 2 : 개인카드, 3 : 개인현금, 4 : 없음
- pay_method_memo — varchar(80)
- purpose — varchar(200)
- amount — float — NOT NULL
- content — text
- delivery_com — varchar(50)
- delivery_apply_date — datetime
- delivery_end_date — datetime
- make_admin — int — NOT NULL
- make_depart — smallint — NOT NULL — code_master : class = 'admin_team' 부서코드
- input_date — datetime — NOT NULL
- input_idx — int — NOT NULL
- approval_apply_date — datetime
- approval_end_date — datetime
- execute_admin — int
- execute_depart — smallint — code_master : class = 'admin_team' 부서코드
- report — text
spend_manage_file
- idx — int — 기본 키 — NOT NULL
- spend_idx — int — NOT NULL
- spend_div — tinyint — NOT NULL — 1 : 품의서, 2 : 보고서
- depart_div — char(1) — NOT NULL — 1 : 구매부서 업로드파일 0 : 일반 업로드파일
- input_file — nvarchar(50) — NOT NULL
spend_manage_goods
- idx — int — 기본 키 — NOT NULL — 자동증가
- spend_idx — int — NOT NULL
- spend_div — tinyint — NOT NULL — 1 : 품의서, 2 : 보고서
- lclass — smallint — mclass = 0인것
- goods_name — varchar(200) — NOT NULL
- quantity — float — NOT NULL
- unit_cost — float — NOT NULL
- vat_chk — char(1) — NOT NULL — 1 : 포함, 0 : 미포함
- shipping_charge — float — NOT NULL
- input_date — datetime — NOT NULL
tmp_reorder
- receiver — nvarchar(100) — 재구매율을 구할때 사용하는 임시테이블
- rec_zipcode — varchar(15)
- wdate — datetime
w_commercial
- idx — int — 기본 키 — NOT NULL
- auction — int
- auction_m — int
- gmarket — int
- gmarket_m — int
- st_11 — int
- st_11_m — int
- qoo10_s — int
- etc — int
- naver_shop1 — int
- wdate — datetime
- c_date — datetime
- d_chk — char(1) — 1:삭제, 0:정상
- naver_shop2 — int
- naver_store — int
- naver_brand — int
- naver_shop3 — int
- naver_shop4 — int
- naver_shop5 — int
- naver_shop6 — int
- sns_1 — int
- sns_2 — int
- sns_3 — int
- sns_4 — int
- sns_5 — int
- viral_1 — int
- viral_2 — int
- viral_3 — int
- viral_4 — int