Untitled

Tables (44)

admin_alarmlog

  • alarmlog_idx — int(11) — Primary key — NOT NULL
  • alarmlog_title — varchar(200)
  • alarmlog_content — varchar(200)
  • admin_email — varchar(250)
  • show_yn — char(1)
  • regdate — varchar(20)

admin_billincomingmat

  • billincomingmat_idx — int(11) — Primary key — NOT NULL
  • billoffer_idx — int(11)
  • incomingdtl_idx — int(11)
  • incoming_idx — int(11)

admin_billoffer

  • billoffer_idx — int(11) — Primary key — NOT NULL
  • admclient_idx — int(11)
  • project_code — varchar(20)
  • billoffer_papernumber — varchar(50)
  • billoffer_number — varchar(50)
  • billoffer_info — varchar(2000)
  • billoffer_vat — int(11)
  • billoffer_officeprice — int(11)
  • overseas_yn — char(1)
  • mem_id — varchar(250)
  • regdate — varchar(20)
  • billoffer_price — int(11)
  • billoffer_bigo — varchar(2000)
  • billoffer_totalprice — int(11)
  • content_code — varchar(50)
  • overseas_name — varchar(50)
  • overseas_papernumber — varchar(50)
  • overseas_agentprice — int(11)
  • overseas_officeprice — int(11)
  • overseas_totalprice — int(11)
  • overseas_currency1 — varchar(10)
  • tax_yn — char(1)
  • billoffer_stats — varchar(50)
  • balance — int(11)
  • overseas_currency2 — varchar(10)
  • info_type — char(1)
  • confirm_yn — char(1)
  • infront_totalprice — int(11)
  • billoffer_pricecurrency — varchar(10)
  • billoffer_officepricecurrency — varchar(10)
  • taxInsub — enum('Y','N') — NOT NULL
  • taxInsub_date — date — NOT NULL
  • abroad_yn — char(1)
  • sumprice — int(11)
  • ordernum — int(11)

admin_board

  • board_idx — int(11) — Primary key — NOT NULL
  • content_code — varchar(50)
  • board_title — varchar(200)
  • board_content — text
  • mem_id — varchar(50)
  • regdate — varchar(20)
  • board_code — varchar(20)
  • board_part — varchar(20)
  • readcnt — int(11)
  • startdate — varchar(10)
  • enddate — varchar(10)
  • starttime — varchar(10)
  • endtime — varchar(10)
  • content_type — varchar(20)
  • agree_yn — char(1)
  • price — int(11)
  • confirm_id — varchar(50)
  • workdate — varchar(10)
  • filecnt — int(11)
  • todo_idx — int(11)
  • replycnt — int(11)

admin_client

  • admclient_idx — int(11) — Primary key — NOT NULL
  • client_kname — varchar(100)
  • client_ename — varchar(100)
  • client_group — varchar(50)
  • client_fname — varchar(100)
  • client_biznum — varchar(50)
  • client_initial — varchar(5)
  • client_gubn — varchar(20)
  • client_nation — varchar(20)
  • client_htel — varchar(20)
  • client_tel — varchar(20)
  • client_fax — varchar(20)
  • client_email — varchar(100)
  • client_post — varchar(10)
  • client_manager — varchar(50)
  • client_homepage — varchar(100)
  • client_kaddress — varchar(300)
  • client_eaddress — varchar(300)
  • client_post2 — varchar(10)
  • client_address2 — varchar(300)
  • client_post3 — varchar(10)
  • client_address3 — varchar(300)
  • client_bigo — varchar(1000)
  • client_offercode — varchar(50)
  • client_offercourtcode — varchar(50)
  • client_offerdisreason — varchar(1000)
  • client_offerindyn — varchar(5)
  • client_offercutreason — varchar(1000)
  • client_offercutdate — varchar(10)
  • client_taxcompanyname — varchar(100)
  • client_taxceoname — varchar(100)
  • client_taxpart — varchar(50)
  • client_taxtype — varchar(50)
  • client_taxbiznum — varchar(50)
  • client_taxtel — varchar(50)
  • client_taxhtel — varchar(50)
  • client_taxpost — varchar(10)
  • client_taxaddress — varchar(300)
  • client_taxoldaddress — varchar(300)
  • client_faddress — varchar(500)
  • client_taxemail — varchar(250)
  • regdate — varchar(20)
  • p1o_price — int(11)
  • p2o_price — int(11)
  • p3o_price — int(11)
  • p4o_price — int(11)
  • p1d_price — int(11)
  • p2d_price — int(11)
  • p3d_price — int(11)
  • p4d_price — int(11)

admin_comment

  • comment_idx — int(11) — Primary key — NOT NULL
  • commenttext — varchar(3000)
  • mem_id — varchar(50)
  • board_idx — int(11)
  • regdate — varchar(20)
  • board_code — varchar(20)

admin_exceldtl

  • exceldtl_idx — int(11) — Primary key — NOT NULL
  • exceldtl_part — varchar(10)
  • exceldtl_val1 — varchar(100)
  • exceldtl_val2 — varchar(100)
  • exceldtl_val3 — varchar(100)
  • exceldtl_val4 — varchar(100)
  • exceldtl_val5 — varchar(100)
  • ex_idx — int(11)

admin_incoming

  • incoming_idx — int(11) — Primary key — NOT NULL
  • incoming_date — varchar(10)
  • project_code — varchar(20)
  • admclient_idx — int(11)
  • incoming_price — int(11)
  • incoming_name — varchar(100)
  • incoming_yn — char(1)
  • incoming_currency — varchar(10)
  • mem_id — varchar(50)
  • regdate — varchar(20)
  • content_code — varchar(50)
  • incoming_step — varchar(20)
  • bcode — int(11)
  • incoming_code — varchar(50)
  • incoming_stats — char(1)

admin_incomingdtl

  • incomingdtl_idx — int(11) — Primary key — NOT NULL
  • incoming_date — varchar(10)
  • project_code — varchar(20)
  • admclient_idx — int(11)
  • incoming_price — int(11)
  • incoming_name — varchar(100)
  • incoming_yn — char(1)
  • incoming_currency — varchar(10)
  • mem_id — varchar(50)
  • regdate — varchar(20)
  • content_code — varchar(50)
  • incoming_step — varchar(20)
  • bcode — int(11)
  • incoming_idx — int(11)
  • incoming_code — varchar(50)

admin_invoice

  • invoice_idx — int(11) — Primary key — NOT NULL
  • project_code — varchar(20)
  • currency — varchar(10)
  • attoney_fee — double
  • office_fee — double
  • invoice_number — varchar(50)
  • invoice_date — varchar(10)
  • piipref — varchar(50)
  • total — double
  • dayofpayment — varchar(10)
  • balance — double
  • status — varchar(20)
  • mem_id — varchar(250)
  • regdate — varchar(20)
  • cinfo_idx — int(11)
  • agentcode — varchar(50)
  • content_code — varchar(50)

admin_kiprisoffer

  • kiprisoffer_idx — int(11) — Primary key — NOT NULL
  • kiprisoffer_title — varchar(200)
  • kiprisoffer_type — varchar(20)
  • project_code — varchar(20)
  • admclient_idx — int(11)
  • kiprisoffer_step — varchar(10)
  • regdate — varchar(20)
  • kiprisoffer_bigo — varchar(2000)
  • kiprisoffer_member — varchar(250)
  • billoffer_price — int(11)
  • billoffer_vat — int(11)
  • admin_email — varchar(250)
  • kiprisoffer_region — varchar(10)
  • content_code — varchar(50)

admin_loginlog

  • loginlog_idx — int(11) — Primary key — NOT NULL
  • admin_email — varchar(250)
  • ip_address — varchar(20)
  • regdate — varchar(20)

admin_member

  • admin_idx — int(11) — Primary key — NOT NULL
  • admin_pwd — varchar(50)
  • admin_name — varchar(50)
  • admin_email — varchar(250)
  • admin_tel — varchar(20)
  • admin_ip — varchar(20)
  • admin_lastlogin — varchar(20)
  • admin_stats — char(1)
  • team_code — varchar(50)
  • member_grade — varchar(5)
  • config_yn — char(1)
  • offwork_yn — char(1)
  • buyoffer_yn — char(1)
  • master_yn — char(1)
  • mem_initial — varchar(5)
  • invoice_yn — char(1)
  • sacks_yn — char(1)
  • kipris_yn — char(1)
  • kiprisoversea_yn — varchar(1)
  • admin_out — char(1) — 퇴사여부
  • admin_out_date — datetime — 퇴사일자

admin_outbillincomingmat

  • billoffer_idx — int(11)
  • incomingdtl_idx — int(11)
  • billincomingmat_idx — int(11) — NOT NULL
  • incoming_idx — int(11)

admin_project

  • project_idx — int(11) — Primary key — NOT NULL
  • project_code — varchar(20)
  • project_name — varchar(200)
  • admclient_idx — int(11)
  • project_type — varchar(20)
  • project_price — int(11)
  • project_enddate — varchar(20)
  • project_pricetype — varchar(20)
  • project_etc — varchar(2000)
  • project_sacks — varchar(50)
  • project_stats — varchar(10)
  • mem_id — varchar(50)
  • project_member — varchar(1000)
  • regdate — varchar(20)
  • project_deaddate — varchar(10)
  • content_code — varchar(20)
  • pay_type — varchar(10)
  • currency — varchar(5)
  • project_sacksdate — varchar(20)
  • brand_check — varchar(10)
  • review_member — varchar(50)

admin_siteconfig

  • title — varchar(50)
  • usd — int(11)
  • jpy — int(11)
  • eur — int(11)
  • cny — int(11)

admin_team

  • team_code — varchar(50) — NOT NULL
  • team_name — varchar(50)
  • team_cnt — int(11)

admin_todo

  • todo_idx — int(11) — Primary key — NOT NULL — 인덱스값
  • content_code — varchar(50)
  • todo_title — varchar(100)
  • todo_mainuser — varchar(50)
  • todo_subuser — varchar(200)
  • todo_startdate — varchar(10)
  • todo_enddate — varchar(10)
  • todo_content — text
  • todo_step — varchar(10)
  • regdate — varchar(20)
  • todo_completedate — varchar(20)
  • todo_threadcnt — int(11)
  • mem_id — varchar(50)
  • out_message — varchar(200)
  • hold_message — varchar(200)
  • hold_date — varchar(20)
  • out_date — varchar(20)
  • todo_type — varchar(1)
  • project_code — varchar(20)
  • target_email — varchar(50)
  • sack_email — varchar(50)
  • kiprisoffer_idx — int(11)

admin_todoworker

  • todoworker_idx — int(11) — Primary key — NOT NULL
  • admin_email — varchar(250)
  • project_code — varchar(100)

admin_weekwork

  • weekwork_idx — int(11) — Primary key — NOT NULL
  • content_code — varchar(50)
  • weekwork_startdate — varchar(20)
  • weekwork_enddate — varchar(20)
  • weekwork_title — varchar(80)
  • mem_id — varchar(50)
  • delay_comment — varchar(2000)
  • drop_comment — varchar(2000)
  • etc_comment — varchar(2000)
  • regdate — varchar(20)
  • work_stats — char(1)
  • sh_year — int(11)
  • sh_month — tinyint(4)
  • team_code — varchar(50)
  • weekwork_completedate — varchar(20)
  • weekwork_dropdate — varchar(20)

admin_weekworkdtl

  • weekworkdtl_idx — int(11) — Primary key — NOT NULL
  • content_code — varchar(50)
  • mem_id — varchar(50)
  • workdtl_comment — varchar(2000)
  • workdtl_stats — char(1)
  • admin_idx — int(11)

admin_worklog

  • worklog_idx — int(11) — Primary key — NOT NULL
  • worklog_date — varchar(10)
  • worklog_start — varchar(20)
  • worklog_end — varchar(20)
  • worklog_time — varchar(10)
  • worklog_etc — varchar(50)
  • worklog_startmsg — varchar(100)
  • worklog_endmsg — varchar(100)
  • regdate — varchar(20)
  • mem_id — varchar(50)
  • yoil — varchar(2)

client_info

  • cinfo_idx — int(11) — Primary key — NOT NULL
  • cinfo_biznum — varchar(20)
  • cinfo_name — varchar(100)
  • cinfo_ceo — varchar(100)
  • cinfo_memname — varchar(20)
  • cinfo_tel — varchar(20)
  • cinfo_email — varchar(200)
  • cinfo_bizpaper — varchar(20)
  • regdate — varchar(20)
  • content_code — varchar(50)
  • mem_id — varchar(50)

ctn_uploadfile_info

  • uploadfile_infoidx — int(11) — Primary key — NOT NULL
  • work_upfile_code — varchar(50)
  • fileOrgName — varchar(100)
  • fileSaveName — varchar(100)
  • fileSize — varchar(100)
  • fileType — varchar(100)
  • fileuptype — varchar(50)

dcs_tree

  • dcs_idx — int(11) — Primary key — NOT NULL — 인덱스값
  • ctn_idx — int(11) — work_content idx
  • work_code — varchar(100) — 업무코드
  • dcs_depth — char(1) — NOT NULL — 업무계층 지시를 내릴 시에 표시
  • dcs_order — varchar(40) — 업무지시자
  • dcs_worker — varchar(40) — 업무작업자
  • dcs_request — enum('Y','N') — Y-> 작업 완료 요청
  • dcs_confirm — enum('Y','N') — Y-> 작업 완료 확인
  • dcs_adj_request — enum('Y','N') — Y-> 일정 조정 요청
  • dcs_adj_confirm — enum('Y','N') — Y-> 일정 조정 확인
  • dcs_app_request — enum('Y','N') — Y-> 결재 요청
  • dcs_app_confirm — enum('Y','N') — Y-> 결재완료
  • dcs_progres — enum('WI','AR','AC','WC','AD','AJ','WR') — NOT NULL — WI->진행,AR->결재신청,AC->결재완료, WR-> 작업완료요청 ,WC->작업완료, AD-> 일정조정신청, AJ-> 일정신청완료
  • dcs_enddate — date — NOT NULL — 작업종료일
  • dcs_regdate — datetime — NOT NULL — 등록일
  • dcs_completedate — datetime — NOT NULL — 작업 완료일

docu_cli_lib

  • docu_idx — int(11) — Primary key — NOT NULL
  • docu_cli1 — varchar(40) — 업체구분
  • docu_cli2 — varchar(40) — 국문명
  • docu_cli3 — varchar(40) — 영문명
  • docu_cli4 — varchar(100) — 회사명(고객명)
  • docu_cli5 — varchar(20) — 대표이사
  • docu_cli6 — varchar(40) — 사업자등록번호
  • docu_cli7 — varchar(20) — 이니셜
  • docu_cli8 — varchar(20) — 우편번호
  • docu_cli9 — varchar(60) — 주소(국문)
  • docu_cli10 — varchar(60) — 주소(영문)
  • docu_cli11 — varchar(60) — 주소(외국어)
  • docu_cli12 — varchar(20) — 우편번호(우편물주소)
  • docu_cli13 — varchar(60) — 우편물주소
  • docu_cli14 — varchar(60) — 우편번호(기타주소)
  • docu_cli15 — varchar(60) — 기타주소
  • docu_cli16 — varchar(20) — 유형
  • docu_cli17 — varchar(20) — 대표자
  • docu_cli18 — varchar(20) — 성명
  • docu_cli19 — varchar(20) — 부서
  • docu_cli20 — varchar(20) — 직위
  • docu_cli21 — varchar(20) — 휴대전화
  • docu_cli22 — varchar(20) — 전화번호
  • docu_cli23 — varchar(20) — 팩스
  • docu_cli24 — varchar(40) — 이메일
  • docu_cli25 — varchar(60) — 주소
  • docu_cli26 — varchar(20) — 우편번호
  • docu_cli27 — varchar(20) — 주소구분
  • docu_cli28 — varchar(255) — 비고
  • docu_cli29 — varchar(60) — 신청자코드(applicant code)

docu_cri_lib

  • docu_idx — int(11) — Primary key — NOT NULL
  • docu_cri1 — varchar(20) — 범위
  • docu_cri2 — varchar(20) — Our Ref. No
  • docu_cri3 — varchar(40) — Your Ref. No
  • docu_cri4 — varchar(100) — 제안명칭
  • docu_cri5 — varchar(200) — 출원명칭(국문)
  • docu_cri6 — varchar(200) — 출원명칭(영문)
  • docu_cri7 — varchar(40) — 출원번호
  • docu_cri8 — date — NOT NULL — 출원일
  • docu_cri9 — date — NOT NULL — 포대접수일
  • docu_cri10 — date — NOT NULL — 실제마감일
  • docu_cri11 — date — NOT NULL — 당소마감일
  • docu_cri12 — varchar(20) — 권리구분
  • docu_cri13 — varchar(20) — 출원구분
  • docu_cri14 — varchar(40) — 출원인
  • docu_cri15 — varchar(40) — 의뢰인
  • docu_cri16 — varchar(20) — 발명자
  • docu_cri17 — varchar(20) — 사건담당자
  • docu_cri18 — varchar(20) — 행정담당자
  • docu_cri19 — varchar(20) — 책임담당자
  • docu_cri20 — varchar(10) — 심사청구여부
  • docu_cri21 — date — NOT NULL — 심사청구 마감일
  • docu_cri22 — date — NOT NULL — 심사청구일
  • docu_cri23 — date — NOT NULL — 등록일
  • docu_cri24 — varchar(40) — 등록번호
  • docu_cri25 — varchar(40) — 등록결정일
  • docu_cri26 — varchar(40) — 등록료납부일
  • docu_cri27 — varchar(40) — 등록료마감일
  • docu_cri28 — varchar(40) — 등록과태마감일
  • docu_cri29 — varchar(255) — 우선권번호
  • docu_cri30 — varchar(255) — 우선권주장일
  • docu_cri31 — varchar(20) — PCT 출원번호
  • docu_cri32 — date — NOT NULL — PCT 출원일
  • docu_cri33 — varchar(20) — PCT지정국/선택국
  • docu_cri34 — varchar(20) — 출원인 관리번호
  • docu_cri35 — varchar(20) — 상품및서비스업분류
  • docu_cri36 — text — 지정상품및서비스업
  • docu_cri37 — varchar(10) — 상품류개수
  • docu_cri38 — varchar(10) — 해외진행여부
  • docu_cri39 — date — NOT NULL — 해외출원마감일
  • docu_cri40 — varchar(200) — 비고
  • docu_cri41 — varchar(10) — 이관확인여부
  • docu_cri42 — date — NOT NULL — 이관확인일
  • docu_cri43 — varchar(20) — 이관테이터키
  • docu_cri44 — varchar(10) — 우선심사여부
  • docu_cri45 — date — NOT NULL — 우선심사신청일
  • docu_cri46 — date — NOT NULL — 우선심사결정일
  • docu_cri47 — date — NOT NULL — 공지예외적용일
  • docu_cri48 — date — NOT NULL — 공지예외증명서류제출일
  • docu_cri49 — date — NOT NULL — 조기공개신청일
  • docu_cri50 — varchar(20) — 조기공개번호
  • docu_cri51 — date — NOT NULL — 공개일
  • docu_cri52 — varchar(20) — 공개번호
  • docu_cri53 — varchar(20) — 공고번호
  • docu_cri54 — date — NOT NULL — 공고일
  • docu_cri55 — date — NOT NULL — 공고결정일
  • docu_cri56 — varchar(10) — 연차관리여부
  • docu_cri57 — date — NOT NULL — 연차(갱신) 관리이관일
  • docu_cri58 — varchar(20) — 사건번호
  • docu_cri59 — date — NOT NULL — 심판청구일
  • … +13

docu_lib

  • docu_idx — int(11) — Primary key — NOT NULL
  • company_code — varchar(20)
  • docu_vals — text — NOT NULL
  • docu_reg_date — datetime — NOT NULL
  • FULLTEXT — KEY

docu_lib3

  • docu_idx — int(11) — Primary key — NOT NULL
  • company_code — varchar(20)
  • docu_vals — text — NOT NULL
  • docu_reg_date — datetime — NOT NULL
  • FULLTEXT — KEY

mshare_content

  • ctn_idx — int(11) — Primary key — NOT NULL — 인덱스값
  • work_code — varchar(100) — 업무코드
  • ctn_id — varchar(50) — 작성자 아이디
  • ctn_document — varchar(6) — 서류분류
  • ctn_body — text — 작업내용
  • ctn_regdate — datetime — NOT NULL — 등록일
  • ctn_upfile_code — varchar(50) — 업로드 파일 코드

mshare_index

  • work_idx — int(11) — Primary key — NOT NULL — 인덱스값
  • work_code — varchar(100) — 업무코드
  • work_order — varchar(40) — 지시자
  • work_refno — varchar(30) — Ref no.
  • work_title — varchar(255) — 업무제목
  • work_document — varchar(6) — 서류분류
  • work_law_enddate — date — NOT NULL — 법적 기한 종료일
  • work_regdate — datetime — NOT NULL — 등록일

mshare_tree

  • dcs_idx — int(11) — Primary key — NOT NULL — 인덱스값
  • ctn_idx — int(11) — work_content idx
  • work_code — varchar(100) — 업무코드
  • dcs_depth — char(1) — NOT NULL — 업무계층 지시를 내릴 시에 표시
  • dcs_order — varchar(40) — 업무지시자
  • dcs_worker — varchar(40) — 업무작업자
  • dcs_request — enum('Y','N') — Y-> 작업 완료 요청
  • dcs_confirm — enum('Y','N') — Y-> 작업 완료 확인
  • dcs_adj_request — enum('Y','N') — Y-> 일정 조정 요청
  • dcs_adj_confirm — enum('Y','N') — Y-> 일정 조정 확인
  • dcs_app_request — enum('Y','N') — Y-> 결재 요청
  • dcs_app_confirm — enum('Y','N') — Y-> 결재완료
  • dcs_progres — enum('WI','AR','AC','WC','AD','AJ','WR') — NOT NULL — WI->진행,AR->결재신청,AC->결재완료, WR-> 작업완료요청 ,WC->작업완료, AD-> 일정조정신청, AJ-> 일정신청완료
  • dcs_enddate — date — NOT NULL — 작업종료일
  • dcs_regdate — datetime — NOT NULL — 등록일
  • dcs_authority — enum('Y','N') — NOT NULL — 작업 완료 권한
  • dcs_completedate — datetime — NOT NULL — 작업 완료일

mshare_uploadfile_info

  • uploadfile_infoidx — int(11) — Primary key — NOT NULL
  • work_upfile_code — varchar(50)
  • fileOrgName — varchar(100)
  • fileSaveName — varchar(100)
  • fileSize — varchar(100)
  • fileType — varchar(100)
  • fileuptype — varchar(50)

outadmin_billoffer

  • billoffer_idx — int(11) — NOT NULL
  • admclient_idx — int(11)
  • project_code — varchar(20)
  • billoffer_papernumber — varchar(50)
  • billoffer_number — varchar(50)
  • billoffer_info — varchar(2000)
  • billoffer_vat — int(11)
  • billoffer_officeprice — int(11)
  • overseas_yn — char(1)
  • mem_id — varchar(250)
  • regdate — varchar(20)
  • billoffer_price — int(11)
  • billoffer_bigo — varchar(2000)
  • billoffer_totalprice — int(11)
  • content_code — varchar(50)
  • overseas_name — varchar(50)
  • overseas_papernumber — varchar(50)
  • overseas_agentprice — int(11)
  • overseas_officeprice — int(11)
  • overseas_totalprice — int(11)
  • overseas_currency1 — varchar(10)
  • tax_yn — char(1)
  • billoffer_stats — varchar(50)
  • balance — int(11)
  • overseas_currency2 — varchar(10)
  • info_type — char(1)
  • confirm_yn — char(1)
  • infront_totalprice — int(11)
  • billoffer_pricecurrency — varchar(10)
  • billoffer_officepricecurrency — varchar(10)
  • abroad_yn — char(1)
  • invoice_date — date — NOT NULL
  • sumprice — int(11)
  • ordernum — int(11)

outgoing_billoffer

  • billoffer_idx — int(11) — NOT NULL
  • admclient_idx — int(11)
  • project_code — varchar(20)
  • billoffer_papernumber — varchar(50)
  • billoffer_number — varchar(50)
  • billoffer_info — varchar(2000)
  • billoffer_vat — int(11)
  • billoffer_officeprice — int(11)
  • overseas_yn — char(1)
  • mem_id — varchar(250)
  • regdate — varchar(20)
  • billoffer_price — int(11)
  • billoffer_bigo — varchar(2000)
  • billoffer_totalprice — int(11)
  • content_code — varchar(50)
  • overseas_name — varchar(50)
  • overseas_papernumber — varchar(50)
  • overseas_agentprice — int(11)
  • overseas_officeprice — int(11)
  • overseas_totalprice — int(11)
  • overseas_currency1 — varchar(10)
  • tax_yn — char(1)
  • billoffer_stats — varchar(50)
  • balance — int(11)
  • overseas_currency2 — varchar(10)
  • info_type — char(1)
  • confirm_yn — char(1)
  • infront_totalprice — int(11)
  • billoffer_pricecurrency — varchar(10)
  • billoffer_officepricecurrency — varchar(10)
  • abroad_yn — char(1)
  • sumprice — int(11)
  • ordernum — int(11)
  • invoice_number — varchar(50)
  • piipref — varchar(50)

outgoing_invoiceidx

  • content_code — varchar(100)
  • invoice_idx — int(11)

sacks_log

  • project_code — varchar(20)
  • project_sacks — varchar(50)
  • mem_id — varchar(50)
  • regdate — varchar(20)

salenpurchase_info

  • salenpurchase_idx — int(11) — Primary key — NOT NULL
  • cinfo_idx — int(11)
  • salenpurchase_date — varchar(20)
  • salenpurchase_memo — varchar(1000)
  • salenpurchase_type — char(1)
  • salenpurchase_price — int(11)
  • salenpurchase_ea — int(11)
  • salenpurchase_totalprice — int(11)
  • salenpurchase_vat — int(11)
  • salenpurchase_totalamount — int(11)
  • regdate — varchar(20)
  • mem_id — varchar(50)
  • deposit_yn — char(1)

taxpaper_info

  • taxpaper_idx — int(11) — Primary key — NOT NULL
  • cinfo_idx — int(11)
  • salenpurchase_idx — int(11)
  • taxpaper_price — int(11)
  • taxpaper_type — char(1)
  • taxpaper_offerdate — varchar(10)
  • mem_id — varchar(50)
  • regdate — varchar(20)
  • taxpaper_stats — char(1)

uploadfile_info

  • uploadfile_infoidx — int(11) — Primary key — NOT NULL
  • content_code — varchar(50)
  • fileOrgName — varchar(100)
  • fileSaveName — varchar(100)
  • fileSize — varchar(100)
  • fileType — varchar(100)
  • fileuptype — varchar(50)
  • mem_id — varchar(50)

work_content

  • ctn_idx — int(11) — Primary key — NOT NULL — 인덱스값
  • work_code — varchar(100) — 업무코드
  • ctn_id — varchar(50) — 작성자 아이디
  • ctn_document — varchar(6) — 서류분류
  • ctn_body — text — 작업내용
  • ctn_regdate — datetime — NOT NULL — 등록일
  • ctn_upfile_code — varchar(50) — 업로드 파일 코드

work_index

  • work_idx — int(11) — Primary key — NOT NULL — 인덱스값
  • work_code — varchar(100) — 업무코드
  • work_order — varchar(40) — 지시자
  • work_refno — varchar(30) — Ref no.
  • work_title — varchar(255) — 업무제목
  • work_document — varchar(6) — 서류분류
  • work_law_enddate — date — NOT NULL — 법적 기한 종료일
  • work_regdate — datetime — NOT NULL — 등록일

work_tree

  • work_idx — int(11) — Primary key — NOT NULL — 인덱스값
  • work_refno — varchar(30) — Ref no.
  • work_title — varchar(255) — 업무제목
  • work_code — varchar(100) — 업무코드
  • work_depth — int(1) — 업무계층
  • work_document — varchar(6) — 서류분류
  • work_indicat — enum('Y','N') — NOT NULL — Y->지시하다, N->지시받은
  • work_order — varchar(40) — 업무지시자
  • work_confirm — enum('Y','N') — Y-> 작업 완료 확인
  • work_progres — enum('P','H','C') — NOT NULL — P->진행,H->보류,C->완료
  • work_main_agent — varchar(40) — 주담당자
  • work_sub_agent — varchar(255) — 보조담당자
  • work_startdate — date — NOT NULL — 작업시작일
  • work_enddate — date — NOT NULL — 작업종료일
  • work_law_startdate — date — NOT NULL — 법적 기한 시작일
  • work_law_enddate — date — NOT NULL — 법적 기한 종료일
  • work_content — text — 작업내용
  • work_regdate — datetime — NOT NULL — 등록일
  • work_completedate — datetime — NOT NULL — 완료일
  • work_upfile_code — varchar(50) — 업로드 파일 코드

work_uploadfile_info

  • uploadfile_infoidx — int(11) — Primary key — NOT NULL
  • work_upfile_code — varchar(50)
  • fileOrgName — varchar(100)
  • fileSaveName — varchar(100)
  • fileSize — varchar(100)
  • fileType — varchar(100)
  • fileuptype — varchar(50)