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)