업무사이트_미사용

테이블 (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