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)