K1 ERD
Tables (74)
t_apply_delivery (출고반영)
- apply_delivery_idx — int(11) — Primary key — NOT NULL
- delivery_idx (delivery_idx2) — int(11) — Foreign key → t_delivery.delivery_idx — NOT NULL
- product_idx (product_idx2) — int(11) — Foreign key → t_product.product_idx — NOT NULL
- warehouse_idx (warehouse_idx2) — int(11) — Foreign key → t_warehouse.warehouse_idx — NOT NULL
- lot_no — varchar(20)
- pkg_amount — int(11)
- pkg_qty — int(11)
- bigo — varchar(1000)
- reg_id — varchar(20)
- reg_date — datetime
- sobun_yn — char(1)
- sobun_qty — int(11)
- lot_fix — char(1)
t_apply_wearing
- apply_wearing_idx — int(11) — Primary key — NOT NULL
- purchase_idx — int(11) — NOT NULL
- wearing_order — int(11)
- wearing_date — datetime
- income_num — varchar(20)
- lot_no — varchar(20)
- pkg_amount — int(11)
- pkg_qty — int(11)
- manu_date — datetime
- valid_date — datetime
- bigo — varchar(1000)
- reg_id — varchar(20)
- reg_date — datetime
- purchase_idx (purchase_idx2) — int(11) — Foreign key → t_purchase.purchase_idx — NOT NULL
t_approval
- APPR_IDX — int(11) — Primary key — NOT NULL
- APPR_STATUS — int(11)
- CUR_ID — varchar(20)
- NEXT_ID — varchar(20)
- APPR_GUBUN — varchar(20)
- APPR_GUBUN_KEY — int(11)
t_approval_leave
- leave_idx — int(11) — Primary key — NOT NULL
- 연차/휴가/조퇴/외출 (leave_type) — int(11) — NOT NULL
- 희망일자 시작일 (leave_date1) — varchar(20)
- 희망일자 종료일 (leave_date2) — varchar(20)
- 기간 (leave_day) — double
- leave_year — int(11)
- 비상연락망 (emergency_contact) — varchar(20)
- leave_bigo — varchar(500)
- reg_date — datetime — NOT NULL
- 부서 (dept_nm) — varchar(20)
- user_id (reg_id) — varchar(20) — Foreign key → t_user.사용자아이디 — NOT NULL
t_approval_letter
- letter_idx — int(11) — Primary key — NOT NULL
- 기안자 (letter_draffer) — varchar(20)
- letter_date — varchar(10)
- appr_req_date — varchar(10)
- appr_buy — varchar(50)
- appr_account — varchar(50)
- total_price — varchar(30)
- reg_id — varchar(20) — NOT NULL
- reg_date — datetime — NOT NULL
t_approval_letter_condition
- letter_cond_val — int(11) — Primary key — NOT NULL
- letter_idx — int(11) — Foreign key → t_approval_letter.letter_idx — NOT NULL
t_approval_letter_content
- letter_content_idx — int(11) — Primary key — NOT NULL
- letter_idx — int(11) — NOT NULL
- letter_content — varchar(300)
- letter_price — int(30)
- letter_bigo — varchar(100)
- letter_gubun — int(11)
- letter_condition — int(11)
- letter_idx (letter_idx2) — int(11) — Foreign key → t_approval_letter.letter_idx — NOT NULL
t_approval_letter_gubun
- letter_idx — int(11) — Primary key — NOT NULL
- letter_gubun_val (1.접대비 2.복리후생비 3.기타) — int(11) — Primary key — NOT NULL
- letter_idx (letter_idx2) — int(11) — Foreign key → t_approval_letter.letter_idx — NOT NULL
- letter_gubun_etc (기타입력) — varchar(10)
t_approval_user
- APPR_IDX — int(11) — Foreign key → t_approval.APPR_IDX — NOT NULL
- 결재자 (user_id) — varchar(20) — Foreign key → t_user.사용자아이디 — NOT NULL
- APPR_STATUS — int(11)
- APPR_DATE — datetime
- EXEC_USER_ID — varchar(20)
t_business_log
- business_log_idx — int(11) — Primary key — NOT NULL
- company_idx — int(11)
- business_log_status — int(11)
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- del_yn — char(1)
- ses_reg_date — datetime
- company_address_idx — int(11)
- company_address_idx (company_address_idx2) — int(11) — Foreign key → t_company_address.company_address_idx — NOT NULL
- company_idx (company_idx2) — int(11) — Foreign key → t_company_address.company_idx — NOT NULL
- company_idx (company_idx22) — int(11) — Foreign key → t_company_address.company_idx — NOT NULL
t_business_log_content
- bsn_con_idx — int(11) — Primary key — NOT NULL
- business_log_product_idx — int(11)
- bsn_type — varchar(20)
- bsn_prg — int(11)
- bsn_con — varchar(8000)
- exp_order_date — varchar(10)
- exp_order_qty — int(11)
- business_log_product_idx (business_log_product_idx2) — int(11) — Foreign key → t_business_log_product.business_log_product_idx — NOT NULL
t_business_log_product
- business_log_product_idx — int(11) — Primary key — NOT NULL
- business_log_idx — int(11)
- product_idx — int(11)
- bra_nm — varchar(100)
- reg_id — varchar(20)
- reg_date — datetime
- product_nm — varchar(50)
- mig_idx — int(11)
- bra_idx — int(11)
- business_log_idx (business_log_idx2) — int(11) — Foreign key → t_business_log.business_log_idx — NOT NULL
t_business_log_psn
- business_log_psn_idx — int(11) — Primary key — NOT NULL
- business_log_idx — int(11)
- psn_id — varchar(20)
- psn_nm — varchar(50)
- psn_posi — varchar(20)
- reg_id — varchar(20)
- reg_date — datetime
- business_log_idx (business_log_idx2) — int(11) — Foreign key → t_business_log.business_log_idx — NOT NULL
t_code
- code — varchar(20) — Primary key — NOT NULL
- code_type — char(4)
- code_nm — varchar(20)
- code_order — int(11)
- reg_date — datetime
- reg_id — varchar(20)
- del_yn — char(1)
t_company
- company_idx — int(11) — Primary key — NOT NULL
- company_nm — varchar(100)
- buy_yn — char(1)
- sell_yn — char(1)
- company_phone — varchar(50)
- company_fax — varchar(20)
- company_num — varchar(50)
- company_nation — varchar(20)
- available_yn — char(1)
- company_bigo — varchar(1000)
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- ses_reg_id — varchar(20)
- ses_udt_id — varchar(20)
- company_region — varchar(20)
- company_gubun — varchar(20)
- company_business — varchar(100)
t_company_address
- company_address_idx — int(11) — Primary key — NOT NULL
- company_idx — int(11) — Primary key — NOT NULL
- company_idx (company_idx2) — int(11) — Foreign key → t_company.company_idx — NOT NULL
- address_nm — varchar(100)
- address — varchar(200)
- represent — char(1)
- reg_id — varchar(20)
- reg_date — datetime
- del_yn — char(1)
t_company_psn
- company_psn_idx — int(11) — Primary key — NOT NULL
- company_idx (company_idx2) — int(11) — Foreign key → t_company.company_idx — NOT NULL
- company_idx — int(11)
- company_psn_nm — varchar(50)
- company_psn_dept — varchar(50)
- company_psn_rank — varchar(50)
- company_psn_phone — varchar(50)
- company_psn_email — varchar(100)
- reg_id — varchar(20)
- reg_date — datetime
- del_yn — char(1)
- psn_represent — char(1)
t_data_file
- data_file_idx — int(11) — Primary key — NOT NULL
- type — char(4)
- material_name — varchar(100)
- available_yn — char(1)
- reg_date — datetime
- reg_id — varchar(20)
- reg_nm — varchar(20)
- ses_reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- del_yn — char(1)
- data_index — int(11)
t_delivery
- delivery_idx — int(11) — Primary key — NOT NULL
- company_from_idx — int(11)
- company_to_idx — int(11)
- delivery_contact — varchar(100)
- company_psn_idx — int(11)
- company_address_idx — int(11)
- due_date — datetime
- reg_date — datetime
- reg_id — varchar(20)
- delivery_status — int(11)
- delivery_bigo — varchar(1000)
- udt_date — datetime
- udt_id — varchar(20)
- del_yn — char(1)
- dvr_no — varchar(20)
- pre_pay — char(1) — NOT NULL
- order_date — datetime
- order_method — varchar(20)
- company_idx — int(11) — Foreign key → t_company.company_idx — NOT NULL
t_equipment_inspection_history (실험장비점검이력)
- inspection_idx — int(11) — Primary key — NOT NULL
- equipment_idx — int(11) — Foreign key → t_experiment_equipment.equipment_idx — NOT NULL
- 점검일시 (inspection_date) — datetime
- 점검내역 (inspection_content) — varchar(8000)
- del_yn — char(1)
t_expect_delivery (납입)
- expect_delivery_idx — int(11) — Primary key — NOT NULL
- product_idx — int(11) — Foreign key → t_product.product_idx — NOT NULL
- delivery_idx — int(11) — Foreign key → t_delivery.delivery_idx — NOT NULL
- warehouse_idx — int(11) — Foreign key → t_warehouse.warehouse_idx — NOT NULL
- lot_no — varchar(20)
- pkg_amount — int(11)
- pkg_qty — int(11)
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- del_yn — char(1)
- sobun_yn — char(1)
- sobun_qty — int(11)
- expect_status — int(11)
- lot_fix — char(1)
- row_order — int(11)
t_expect_wearing (매입등록)
- expect_wearing_idx — int(11) — Primary key — NOT NULL
- purchase_idx — int(11)
- expect_wearing_order — int(11)
- expect_wearing_date — datetime
- income_num — varchar(20)
- lot_no — varchar(20)
- expect_pkg_amount — int(11)
- expect_pkg_qty — int(11)
- reg_id — varchar(20)
- reg_date — datetime
- wearing_status — int(11)
- udt_id — varchar(20)
- udt_date — datetime
- del_yn — char(1)
- expect_status — int(11)
- manu_date — datetime
- valid_date — datetime
- purchase_idx (purchase_idx2) — int(11) — Foreign key → t_purchase.purchase_idx — NOT NULL
t_experiment_equipment (실험장비)
- equipment_idx — int(11) — Primary key — NOT NULL
- 장비명 (equipment_nm) — varchar(100)
- 모델명 (model_nm) — varchar(100)
- 제조원 (manufacturer) — varchar(100)
- 구매일 (purchase_date) — datetime
- 구매비용 (purchase_cost) — int(11)
- 용도 (purpose) — varchar(2000)
- 상태 - 양호/불량 (status) — int(11)
- del_yn — char(1)
- reg_date — datetime
- 판매원 (seller) — varchar(100)
- 등록자 (reg_id) — varchar(20) — Foreign key → t_user.사용자아이디 — NOT NULL
t_experiment_request
- EXPERIMENT_REQUEST_IDX — int(11) — Primary key — NOT NULL
- 의뢰제목 (request_title) — varchar(100)
- 고객사 (company_idx) — int(11)
- 요청일 (request_date) — datetime
- 의뢰종류-가이드처방/미생물시험/분석시험/in-vitro SPF 실험 (request_type) — varchar(45)
- 의뢰품명 (product_idx) — int(11)
- 의뢰목적 (request_subject) — varchar(2000)
- 의뢰비고 (request_bigo) — varchar(1000)
- 실험결과 (experiment_result) — varchar(8000)
- reg_id — varchar(20)
- reg_date — datetime
- 상태 - 접수 / 처리완료 (request_status) — int(11)
- 연구원 (researcher_id) — varchar(20)
- 처리일 (processed_date) — datetime
- 의뢰자 (request_id) — varchar(45)
- udt_id — varchar(45)
- user_id — varchar(20) — Foreign key → t_user.사용자아이디 — NOT NULL
t_file
- file_idx — int(11) — Primary key — NOT NULL
- file_gubun — varchar(20)
- gubun_key — int(11)
- file_name — varchar(200)
- file_path — varchar(200)
- file_size — int(11)
- file_name_dest — varchar(500)
- reg_id — varchar(20)
- reg_date — datetime
- del_yn — char(1)
- stamp — int(11)
- product_file_idx — int(11) — Foreign key → t_product_file.product_file_idx — NOT NULL
- data_file_idx — int(11) — Foreign key → t_data_file.data_file_idx — NOT NULL
- notice_idx — int(11) — Foreign key → t_notice.notice_idx — NOT NULL
t_gift (상품권)
- gift_idx — int(11) — Primary key — NOT NULL
- 신청자 (req_id) — varchar(20)
- 집행일 (exec_date) — varchar(10)
- 신청일 (req_date) — varchar(10)
- del_yn — char(1) — NOT NULL
- reg_id — varchar(20) — NOT NULL
- reg_date — datetime — NOT NULL
t_gift_product (상품권 품목)
- gift_product_idx — int(11) — Primary key — NOT NULL
- gift_idx — int(11) — Foreign key → t_gift.gift_idx — NOT NULL
- 상품권/영화관람권/문화상품권/선물세트/기타 (gift_product_type) — int(11) — NOT NULL
- gift_product_content — varchar(500)
- 입출고 (gift_product_inout) — int(11) — NOT NULL
- 수량 (gift_product_qty) — int(11)
- 거래처 (gift_product_company_idx) — int(11)
- gift_product_bigo — varchar(500)
t_home_brand
- BRA_IDX — int(11) — Primary key — NOT NULL
- 브랜드명 (BRA_NM) — varchar(200)
- 비고 (BRA_BIGO) — varchar(2000)
- DEL_YN — char(1)
- REG_ID — varchar(25)
- REG_DATE — datetime
t_home_pearl_images
- image_idx — int(11) — Primary key — NOT NULL
- 펄 상품 (product_idx) — int(11) — NOT NULL
- 이미지 순서 (image_order) — int(11)
- file_idx — int(11)
- 메인이미지 여부 (main_image) — tinyint(4)
t_home_pearl_product
- PRODUCT_IDX — int(11) — Primary key — NOT NULL
- 상품명 (PRODUCT_NM) — varchar(200)
- 요약 (SUMMARY) — varchar(1000)
- 상세설명1 (DETAIL1) — varchar(2000)
- 상세설명2 (DETAIL2) — varchar(2000)
- DEL_YN — char(1)
- 제품전시순서 (PRODUCT_ORDER) — int(11)
- 상품설명-관리메뉴용 (PRODUCT_INFO) — varchar(1000)
t_home_pearl_req (펄 홈페이지 문의글)
- REQ_IDX — int(11) — Primary key — NOT NULL
- 일반문의/제품문의 (REQ_TYPE) — int(11)
- 문의자 (REQ_NAME) — varchar(300)
- 연락처 (REQ_CONTACT) — varchar(300)
- 문의제목 (REQ_TITLE) — varchar(1000)
- 내용 (REQ_CONTENT) — varchar(3000)
- 문의일시 (REQ_DATE) — datetime
t_home_product
- PRODUCT_IDX — int(11) — Primary key — NOT NULL
- 브랜드 (BRA_IDX) — int(11) — Foreign key → t_home_brand.BRA_IDX — NOT NULL
- 제품명 (PRODUCT_NM) — varchar(200)
- DEL_YN — char(1)
- LEFT_TITLE — varchar(300)
- RIGHT_TITLE — varchar(300)
- 순서 (PRODUCT_ORDER) — int(11)
t_home_product_bottom
- BOTTOM_IDX — int(11) — Primary key — NOT NULL
- PRODUCT_IDX — int(11) — Foreign key → t_home_product.PRODUCT_IDX — NOT NULL
- BOTTOM_INFO1 — varchar(1000)
- BOTTOM_INFO2 — varchar(1000)
- REG_DATE — datetime
t_home_product_top
- TOP_IDX — int(11) — Primary key — NOT NULL
- PRODUCT_IDX — int(11) — Foreign key → t_home_product.PRODUCT_IDX — NOT NULL
- TOP_INFO1 — varchar(1000)
- TOP_INFO2 — varchar(1000)
- REG_DATE — datetime
t_home_req
- REQ_IDX — int(11) — Primary key — NOT NULL
- REQ_TYPE — int(11)
- REQ_NAME — varchar(300)
- REQ_CONTACT — varchar(300)
- REQ_TITLE — varchar(1000)
- REQ_CONTENT — varchar(3000)
- REQ_DATE — datetime
t_import (수입리스트)
- import_idx — int(11) — Primary key — NOT NULL
- 선적지 (shipping_place) — varchar(100)
- 브랜드 (brand_idx) — int(11)
- 발주번호 (purchase_number) — varchar(100)
- 주문번호 (order_number) — varchar(100)
- product_nm — varchar(100)
- 수량 (amount) — int(11)
- 통화 - 원/엔/달러/유로 (income_cost_unit) — varchar(20)
- 단가 (unit_price) — int(11)
- 합계금액 (total_price) — int(11)
- 결제환율 (payment_exchange) — decimal(10,2)
- 결제일 (payment_date) — datetime
- 결제번호 (payment_number) — varchar(100)
- 도착요청일 (arrival_request_date) — datetime
- 관세사 (customs) — varchar(100)
- 통관종목 (customs_clearance) — varchar(100)
- 통관일자 (customs_date) — datetime
- 수입번호 (import_number) — varchar(100)
- 수입원가 (import_cost) — decimal(10,2)
- 입고일자 (receiving_date) — datetime
- bl번호 (bl_number) — varchar(100)
- eta 날짜 (eta) — datetime
- etd 날짜 (etd) — datetime
- etd 내용 (etd_reason) — varchar(1000)
- reg_date — datetime
- reg_id — varchar(45)
- del_yn — varchar(45)
- 창고 (warehouse_idx) — int(11)
- etd 날짜별 기록 (etd_date) — varchar(500)
t_import_lot (수입리스트 - 품목 / lot)
- import_lot_idx — int(11) — Primary key — NOT NULL
- import_idx — int(11) — Foreign key → t_import.import_idx — NOT NULL
- product_idx — int(11) — NOT NULL
- lot_no — varchar(20) — NOT NULL
t_import_purchase (수입리스트 - 매입등록 연동)
- import_idx — int(11) — Foreign key → t_import.import_idx — NOT NULL
- purchase_idx — int(11) — Foreign key → t_purchase.purchase_idx — NOT NULL
t_leave_days
- leave_year — int(11) — Primary key — NOT NULL
- user_id — varchar(20) — Primary key — NOT NULL
- leave_days — double
- reg_id — varchar(20)
- reg_date — datetime
- leave_idx — int(11) — Foreign key → t_approval_leave.leave_idx — NOT NULL
t_market_research
- research_idx — int(11) — Primary key — NOT NULL
- 거래처 (company_idx) — int(11) — Foreign key → t_company.company_idx — NOT NULL
- 품목 (product_idx) — int(11) — Foreign key → t_product.product_idx — NOT NULL
- 구매처 (purchase_at) — varchar(100)
- 사용량 (product_usage) — int(11)
- 가격 (price) — int(11)
- 경쟁제품 (competitive_product) — varchar(100)
- 경쟁제품 구매처 (competitive_purchase_at) — varchar(100)
- 경쟁제품 사용량 (competitive_usage) — int(11)
- 경쟁제품 가격 (competitive_price) — int(11)
- 비고 (research_bigo) — varchar(8000)
- reg_date — datetime
- del_yn — char(1)
- udt_id — varchar(45)
- 등록자 (reg_id) — varchar(20) — Foreign key → t_user.사용자아이디 — NOT NULL
t_market_research_share (시장조사 공유 설정)
- 사용자아이디 (user_id) — varchar(20) — Foreign key → t_user.사용자아이디 — NOT NULL
t_notice
- notice_idx — int(11) — Primary key — NOT NULL
- 공지사항 제목 (notice_title) — varchar(200)
- 공지사항 내용 (notice_content) — varchar(8000)
- 조회수 (view_cnt) — int(11)
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- del_yn — char(1)
- user_id — varchar(20) — Foreign key → t_user.사용자아이디 — NOT NULL
t_partner
- user_id — varchar(20) — Foreign key → t_user.사용자아이디 — NOT NULL
- manu_brand_idx — int(11) — Foreign key → t_product_manu_brand.manu_brand_idx — NOT NULL
t_partner_company
- partner_company_idx — int(11) — Primary key — NOT NULL
- 협력업체 거래처 업체명 (partner_company_nm) — varchar(100)
- 연락처 (partner_company_phone) — varchar(50)
- 팩스 (partner_company_fax) — varchar(20)
- 사업자번호 (partner_company_num) — varchar(50)
- 국가 (partner_company_nation) — varchar(20)
- 유효 여부 (available_yn) — char(1)
- 비고 (partner_company_bigo) — varchar(1000)
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- ses_reg_id — varchar(20)
- ses_udt_id — varchar(20)
- 지역 (partner_company_region) — varchar(20)
- 구분 (partner_company_gubun) — varchar(20)
- 업무 (partner_company_business) — varchar(100)
- user_id — varchar(20) — Foreign key → t_user.사용자아이디 — NOT NULL
t_partner_company_address
- partner_company_address_idx — int(11) — Primary key — NOT NULL
- 협력업체 거래처 주소구분 (partner_address_nm) — varchar(100)
- 협력업체 거래처 주소 (partner_address) — varchar(200)
- 대표주소 여부 (represent) — char(1)
- del_yn — char(1)
- partner_company_idx — int(11) — Foreign key → t_partner_company.partner_company_idx — NOT NULL
t_partner_company_psn
- partner_company_psn_idx — int(11) — Primary key — NOT NULL
- partner_company_idx — int(11) — Foreign key → t_partner_company.partner_company_idx — NOT NULL
- 협력업체 거래처 담당자이름 (partner_company_psn_nm) — varchar(50)
- 협력업체 거래처 담당자소속 (partner_company_psn_dept) — varchar(50)
- 협력업체 거래처 담당자 직위 (partner_company_psn_rank) — varchar(50)
- 휴대폰 (partner_company_psn_phone) — varchar(50)
- 이메일 (partner_company_psn_email) — varchar(100)
- 대표 담당자 여부 (psn_represent) — char(1)
- del_yn — char(1)
t_partner_sales_log
- partner_log_idx — int(11) — Primary key — NOT NULL
- 상태 - 임시저장/저장 (partner_log_status) — int(11)
- 업체명 (company_nm) — varchar(100)
- reg_id — varchar(20)
- reg_date — datetime
- ses_reg_date — datetime
- del_yn — char(1)
t_partner_sales_log_content
- partner_log_content_idx — int(11) — Primary key — NOT NULL
- partner_log_idx — int(11) — Foreign key → t_partner_sales_log.partner_log_idx — NOT NULL
- 업무종류 (bsn_type) — varchar(20)
- 업무내용 (sales_log_content) — varchar(8000)
- 품목명 (product_nm) — varchar(100)
t_partner_sales_log_psn
- partner_log_psn_idx — int(11) — Primary key — NOT NULL
- partner_log_idx — int(11) — Foreign key → t_partner_sales_log.partner_log_idx — NOT NULL
- 담당자명 (psn_nm) — varchar(50)
- 담당자 직급 (psn_posi) — varchar(20)
t_product
- product_idx — int(11) — Primary key — NOT NULL
- product_nm — varchar(100)
- hs_code — varchar(50)
- inci — varchar(200)
- pkg_unit — varchar(20)
- product_bigo — varchar(1000)
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- del_yn — char(1)
- manu_brand_idx — int(11) — Foreign key → t_product_manu_brand.manu_brand_idx — NOT NULL
t_product_company
- prdt_cmp_idx — int(11) — Primary key — NOT NULL
- company_idx — int(11)
- company_nm — varchar(100)
- manu_nm — varchar(100)
- nation_cd — varchar(20)
- lead_time — int(11)
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- del_yn — char(1)
- product_idx — int(11) — Foreign key → t_product.product_idx — NOT NULL
t_product_file
- product_file_idx — int(11) — Primary key — NOT NULL
- product_idx — int(11)
- reg_date — datetime
- manu_brand_idx — int(11)
- material_gubun — varchar(200)
- material_name — varchar(200)
- rev — int(11)
- bigo — varchar(1000)
- reg_id — varchar(20)
- ses_reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- available — char(1)
- product_idx (product_idx2) — int(11) — Foreign key → t_product.product_idx — NOT NULL
- manu_brand_idx (manu_brand_idx2) — int(11) — Foreign key → t_product_manu_brand.manu_brand_idx — NOT NULL
t_product_manu_brand
- manu_brand_idx — int(11) — Primary key — NOT NULL
- bra_nm — varchar(100)
- bigo — varchar(1000)
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(45)
- udt_date — varchar(45)
- del_yn — char(1)
t_purchase
- purchase_idx — int(11) — Primary key — NOT NULL
- product_idx — int(11) — Foreign key → t_product.product_idx — NOT NULL
- company_idx — int(11) — Foreign key → t_company.company_idx — NOT NULL
- warehouse_idx — int(11) — Foreign key → t_warehouse.warehouse_idx — NOT NULL
- purchase_date — datetime
- cost — bigint(19)
- income_cost — bigint(19)
- income_cost_unit — varchar(20)
- total_purchase_qty — bigint(19)
- purchase_bigo — varchar(1000)
- company_psn_idx — int(11)
- brand_idx — int(11)
- reg_date — datetime
- reg_id — varchar(20)
- udt_id — varchar(20)
- udt_date — datetime
- purchase_status — int(11)
- udt_purchase_date — datetime
- udt_total_purchase_qty — bigint(30)
- udt_purchase_bigo — varchar(1000)
- del_yn — char(1)
- prch_no — varchar(20)
t_real_delivery (출고처리)
- real_delivery_idx — int(11) — Primary key — NOT NULL
- delivery_idx (delivery_idx2) — int(11) — Foreign key → t_delivery.delivery_idx — NOT NULL
- product_idx (product_idx2) — int(11) — Foreign key → t_product.product_idx — NOT NULL
- warehouse_idx (warehouse_idx2) — int(11) — Foreign key → t_warehouse.warehouse_idx — NOT NULL
- lot_no — varchar(20)
- 수량 (pkg_amount) — int(11)
- 포장단위 (pkg_qty) — int(11)
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- del_yn — char(1)
- 소분여부 (sobun_yn) — char(1)
- 소분단위 (sobun_qty) — int(11)
- comment — varchar(1000)
- real_status — int(11)
- lot 확정 여부 (lot_fix) — char(1)
t_real_wearing
- real_wearing_idx — int(11) — Primary key — NOT NULL
- expect_wearing_idx — int(11)
- real_wearing_date — datetime
- income_num — varchar(20)
- lot_no — varchar(20)
- real_pkg_amount — int(11)
- real_pkg_qty — int(11)
- manu_date — datetime
- valid_date — datetime
- comment — varchar(1000)
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- del_yn — char(1)
- purchase_idx — int(11)
- real_status — int(11)
- expect_wearing_idx (expect_wearing_idx2) — int(11) — Foreign key → t_expect_wearing.expect_wearing_idx — NOT NULL
t_rental
- rental_idx — int(11) — Primary key — NOT NULL
- company_idx — int(11)
- company_address_idx — int(11)
- company_psn_idx — int(11)
- rental_contact — varchar(100)
- rental_date — datetime
- rental_bigo — varchar(1000)
- del_yn — char(1)
- rental_no — varchar(20)
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- company_idx (company_idx2) — int(11) — Foreign key → t_company.company_idx — NOT NULL
- company_address_idx (company_address_idx2) — int(11) — Foreign key → t_company_address.company_address_idx — NOT NULL
- company_idx (company_idx3) — int(11) — Foreign key → t_company_address.company_idx — NOT NULL
- company_idx (company_idx22) — int(11) — Foreign key → t_company_address.company_idx — NOT NULL
- company_psn_idx (company_psn_idx2) — int(11) — Foreign key → t_company_psn.company_psn_idx — NOT NULL
- company_idx (company_idx23) — int(11) — Foreign key → t_company_psn.company_idx — NOT NULL
t_rental_product
- rental_product_idx — int(11) — Primary key — NOT NULL
- rental_idx — int(11)
- rental_type — int(11)
- product_idx — int(11)
- warehouse_idx — int(11)
- lot_no — varchar(50)
- pkg_amount — int(11)
- pkg_qty — int(11)
- sobun_yn — char(1)
- sobun_qty — int(11)
- rental_idx (rental_idx2) — int(11) — Foreign key → t_rental.rental_idx — NOT NULL
- product_idx (product_idx2) — int(11) — Foreign key → t_product.product_idx — NOT NULL
- warehouse_idx (warehouse_idx2) — int(11) — Foreign key → t_warehouse.warehouse_idx — NOT NULL
t_reports (성적서)
- lot_no — varchar(20) — Foreign key → t_stock.lot_no — NOT NULL
- product_idx — int(11) — Foreign key → t_stock.product_idx — NOT NULL
- warehouse_idx — int(11) — Foreign key → t_stock.warehouse_idx — NOT NULL
- pkg_amount — int(11) — Foreign key → t_stock.pkg_amount — NOT NULL
- file_name — varchar(500)
- file_path — varchar(500)
- file_size — int(11)
- file_name_dest — varchar(500)
- reg_id — varchar(20)
- reg_date — datetime
- del_yn — char(1)
- stamp — int(11)
t_send
- send_idx — int(11) — Primary key — NOT NULL
- send_type — char(4)
- send_content — varchar(1000)
- sales_psnid — varchar(20)
- req_date — datetime
- company_idx — int(11)
- company_psn_idx — int(11)
- company_psn_text — varchar(100)
- proc_id — varchar(20)
- proc_date — datetime
- send_bigo — varchar(1000)
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- mail_yn — char(1)
- del_yn — char(1)
- bra_idx — int(11)
- company_idx (company_idx2) — int(11) — Foreign key → t_company.company_idx — NOT NULL
- company_psn_idx (company_psn_idx2) — int(11) — Foreign key → t_company_psn.company_psn_idx — NOT NULL
- company_idx (company_idx22) — int(11) — Foreign key → t_company_psn.company_idx — NOT NULL
- manu_brand_idx — int(11) — Foreign key → t_product_manu_brand.manu_brand_idx — NOT NULL
- company_psn_idx (company_psn_idx3) — int(11) — Foreign key → t_company_psn.company_psn_idx — NOT NULL
- company_idx (company_idx23) — int(11) — Foreign key → t_company_psn.company_idx — NOT NULL
t_send_etc
- send_etc_idx — int(11) — Primary key — NOT NULL
- support_content — varchar(200)
- sales_psn_nm — varchar(50)
- company_nm — varchar(100)
- company_psn_nm — varchar(50)
- req_date — datetime
- due_date — datetime
- proc_nm — varchar(50)
- proc_date — datetime
- bigo — varchar(1000)
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- del_yn — char(1)
- bra_idx — int(11)
- manu_brand_idx — int(11) — Foreign key → t_product_manu_brand.manu_brand_idx — NOT NULL
t_send_mail
- send_mail_idx — int(11) — Primary key — NOT NULL
- send_idx — int(11) — Foreign key → t_send.send_idx — NOT NULL
- mail_title — varchar(200)
- mail_content — varchar(1000)
- mail_ref — varchar(100)
- send_mail_status — int(11)
- send_id — varchar(20)
- send_date — datetime
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- receiver_email — varchar(100)
- receiver_nm — varchar(50)
- cc_email — varchar(300)
- bcc_email — varchar(300)
t_send_mail_file_history
- lot_no — varchar(50) — Primary key — NOT NULL
- send_mail_idx — int(11) — Foreign key → t_send_mail.send_mail_idx — NOT NULL
- file_idx — int(11) — Foreign key → t_file.file_idx — NOT NULL
t_send_pdf
- send_idx — int(11) — Foreign key → t_send.send_idx — NOT NULL
- pdf_type — int(11)
- send_date — datetime
- receiver_company_nm — varchar(200)
- reference_nm — varchar(50)
- reference_email — varchar(100)
- bigo — varchar(2000)
- order_date — datetime
- release_date — datetime
- tel — varchar(100)
- fax — varchar(100)
- reg_id — varchar(20)
- reg_date — datetime
- estm_cond — varchar(2000)
- pdf_no — varchar(100)
- warehouse_idx — int(11) — Foreign key → t_warehouse.warehouse_idx — NOT NULL
t_send_pdf_product
- send_pdf_product_idx — int(11) — Primary key — NOT NULL
- send_idx — int(11) — Foreign key → t_send.send_idx — NOT NULL
- product_nm — varchar(100)
- standard — varchar(100)
- price — int(20)
- price2 — int(20)
- maker — varchar(100)
- product_bigo — varchar(500)
- reg_id — varchar(20)
- reg_date — datetime
- pack_spc — int(20)
- supply_price — int(20)
- tax_amount — int(20)
t_send_sample
- send_sample_idx — int(11) — Primary key — NOT NULL
- proc_date — datetime
- company_idx — int(11)
- company_psn_idx — int(11)
- company_psn_text — varchar(100)
- send_sample_bigo — varchar(1000)
- company_address_idx — int(11)
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- proc_id — varchar(20)
- req_id — varchar(20)
- del_yn — char(1)
- bra_idx — int(11)
- sample_contact — varchar(50)
- dvr_num — varchar(20)
- product_idx — int(11) — Foreign key → t_product.product_idx — NOT NULL
- manu_brand_idx — int(11) — Foreign key → t_product_manu_brand.manu_brand_idx — NOT NULL
- company_psn_idx (company_psn_idx2) — int(11) — Foreign key → t_company_psn.company_psn_idx — NOT NULL
- company_idx (company_idx2) — int(11) — Foreign key → t_company_psn.company_idx — NOT NULL
- company_address_idx (company_address_idx2) — int(11) — Foreign key → t_company_address.company_address_idx — NOT NULL
- company_idx (company_idx3) — int(11) — Foreign key → t_company_address.company_idx — NOT NULL
- company_idx (company_idx22) — int(11) — Foreign key → t_company_address.company_idx — NOT NULL
t_send_sample_product
- send_sample_product_idx — int(11) — Primary key — NOT NULL
- send_sample_idx — int(11)
- product_idx — int(11)
- product_qty — int(11)
- send_sample_idx (send_sample_idx2) — int(11) — Foreign key → t_send_sample.send_sample_idx — NOT NULL
t_stock
- product_idx — int(11) — Primary key — NOT NULL
- warehouse_idx — int(11) — Primary key — NOT NULL
- pkg_amount — int(11) — Primary key — NOT NULL
- lot_no — varchar(20) — Primary key — NOT NULL
- pkg_qty — int(11)
- manu_date — datetime
- valid_date — datetime
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- 수입번호 (income_num) — varchar(20)
t_stock_process_history
- stock_process_history — int(11) — Primary key — NOT NULL
- type — varchar(10)
- pkg_qty — int(11)
- reason — varchar(300)
- reg_id — varchar(20)
- reg_date — datetime
- product_idx — int(11) — Foreign key → t_stock.product_idx — NOT NULL
- warehouse_idx — int(11) — Foreign key → t_stock.warehouse_idx — NOT NULL
- pkg_amount — int(11) — Foreign key → t_stock.pkg_amount — NOT NULL
- lot_no — varchar(20) — Foreign key → t_stock.lot_no — NOT NULL
- warehouse_idx (warehouse_idx3) — int(11) — Foreign key → t_warehouse.warehouse_idx — NOT NULL
t_training_history
- training_history_idx — int(11) — Primary key — NOT NULL
- 교육주제 (training_subject) — varchar(100)
- 교육기간 (training_institution) — varchar(45)
- 교육시작일 (training_start_date) — datetime
- 교육종료일 (training_end_date) — datetime
- 이수자 (trainee) — varchar(50)
- 종류-시스템/원료/회계/화평법/기타 (training_type) — varchar(20)
- training_contents — varchar(8000)
- del_yn — char(1) — NOT NULL
- reg_date — datetime
- 사용자아이디 (reg_id) — varchar(45) — Foreign key → t_user.사용자아이디 — NOT NULL
t_user
- 사용자아이디 (user_id) — varchar(20) — Primary key — NOT NULL
- 비밀번호 (user_password) — varchar(200)
- user_nm — varchar(50)
- user_phone — varchar(20)
- user_email — varchar(100)
- user_auth — varchar(20)
- 창고권한 (warehouse_idx) — int(11)
- user_status — int(11)
- user_mailsign — varchar(1000)
- 직책 (user_posi) — varchar(20)
- 직급 (user_rank) — varchar(20)
- 소속 (user_dept) — varchar(20)
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- main_apply — int(11)
- main_house — int(11)
- main_valid — int(11)
- main_support — int(11)
- main_support_detail — int(11)
- manu_brand_idx — int(11)
- del_yn — char(1)
- notice_idx — int(11)
- bs_log1 — int(11)
- bs_log2 — int(11)
- main_return_wait — int(11)
- main_return_fin — int(11)
- 영업검색 담당자 조회 (search_yn) — char(1) — NOT NULL
- code — varchar(20) — Foreign key → t_code.code — NOT NULL
- user_id (user_id2) — varchar(20) — Foreign key → t_user.사용자아이디 — NOT NULL
- user_id (user_id3) — varchar(20) — Foreign key → t_user.사용자아이디 — NOT NULL
t_warehouse
- warehouse_idx — int(11) — Primary key — NOT NULL
- warehouse_nm — varchar(20)
- color — varchar(50)
- warehouse_status — char(1)
- warehouse_bigo — varchar(1000)
- address — varchar(200)
- reg_id — varchar(20)
- reg_date — datetime
- udt_id — varchar(20)
- udt_date — datetime
- tell — varchar(20)
t_warehouse_auth
- warehouse_idx — int(11) — Primary key — NOT NULL
- auth_idx — int(11) — Primary key — NOT NULL
- user_id — varchar(20) — Foreign key → t_user.사용자아이디 — NOT NULL
- warehouse_idx (warehouse_idx2) — int(11) — Foreign key → t_warehouse.warehouse_idx — NOT NULL
t_warehouse_checklist
- delivery_idx — int(11) — Primary key — NOT NULL
- warehouse_idx — int(11) — Primary key — NOT NULL
- delivery_idx (delivery_idx2) — int(11) — Foreign key → t_delivery.delivery_idx — NOT NULL
- warehouse_idx (warehouse_idx2) — int(11) — Foreign key → t_warehouse.warehouse_idx — NOT NULL
- broken_check — int(11)
- lot_check — int(11)
- label_check — int(11)
- expiration_check — int(11)
- pass — int(11)