ERP

Tables (36)

bor (작업소요시간)

  • id (키값) — Primary key — NOT NULL
  • code (생산품목코드)
  • name (생산품목)
  • qty (생산수량)
  • work_code (작업코드) — '
  • work_target_code (작업기준품목코드)
  • work_target_name (작업기준품목명)
  • hour (작업시간)

client (거래처)

  • id (키값) — Primary key — NOT NULL
  • company_id (기업아이디) — Foreign key → company.id — NOT NULL
  • code (거래처코드)
  • name (상호(이름))
  • ceo_name (대표자명)
  • business_type (업태)
  • industry (업종)
  • tel (전화)
  • fax (팩스)
  • post_code (우편번호)
  • address (주소)
  • address2 (상세주소)
  • homepage (홈페이지)
  • corporate_reg_no (법인등록번호)
  • company_reg_no (사업자등록번호)
  • vat_reg_no (납세자등록번호)

client_branch_office (거래처 지점)

  • id (키값) — Primary key — NOT NULL
  • client_id (거래처 아이디) — Foreign key → client.id — NOT NULL
  • code (지점 코드)
  • name (지점명)
  • tel (전화)
  • fax (팩스)
  • post_code (우편번호)
  • address (주소)
  • address2 (상세주소)
  • Field

client_grade (고객사 등급)

  • id (키값) — Primary key — NOT NULL
  • client_id (거래처아이디) — Foreign key → client.id — NOT NULL
  • code (코드)
  • name (등급명)
  • priority (우선순위)
  • memo (메모)

client_payment (거래 계좌)

  • id (키값) — Primary key — NOT NULL
  • client_id (거래처아이디) — Foreign key → client.id — NOT NULL
  • code (거래계좌코드)
  • bank_name (은행명)
  • bank_account (계좌번호)
  • bank_holder (예금주)
  • is_master (주거래계좌여부)

company (기업)

  • id (키값) — Primary key — NOT NULL
  • code (코드)
  • name (기업명)

company_credit (기업여신)

  • id (키값) — Primary key — NOT NULL
  • company_id (기업아이디) — Foreign key → company.id — NOT NULL
  • client_id (거래처아이디) — Foreign key → client.id — NOT NULL
  • amount_limit (한도금액)
  • amount_unit (화폐단위)
  • delivery_terms (배송조건)
  • sale_terms (판매조건)
  • credit_rating (신용도)

company_credit_history (기업여신기록)

  • id (키값) — Primary key — NOT NULL
  • company_credit_id (기업여신아이디) — Foreign key → company_credit.id — NOT NULL
  • name (거래명)

company_credit_history_detail (기업여신기록 상세)

  • id (키값) — Primary key — NOT NULL
  • credit_history_id (기업여신기록 아이디) — Foreign key → company_credit_history.id — NOT NULL
  • product_id (품목 아이디) — Foreign key → product.id — NOT NULL
  • id (키값2) — Foreign key → product.group_id — NOT NULL
  • qty (수량)
  • unit_price (단가)
  • total_price (합계금액)

company_credit_repay (기업여신변제)

  • id (키값) — Primary key — NOT NULL
  • credit_his_id (기업여신기록아이디) — Foreign key → company_credit_history.id — NOT NULL
  • repay_amount (변제금액)

company_plant (기업 플랜트)

  • id (키값) — Primary key — NOT NULL
  • company_id (기업아이디) — Foreign key → company.id — NOT NULL
  • name (기업 아이디)

estimate (견적서)

  • id (키값) — Primary key — NOT NULL
  • company_id (기업아이디) — Foreign key → company.id — NOT NULL
  • status (상태)

estimate_item (견적서 상세)

  • id (키값) — Primary key — NOT NULL
  • estimate_id (견적서 아이디) — Foreign key → estimate.id — NOT NULL
  • product_id (품목아이디) — Foreign key → product.id — NOT NULL
  • id (키값2) — Foreign key → product.group_id — NOT NULL
  • unit_price (단가)
  • qty (수량)
  • total_amount (합계금액)

item_export (출고)

  • id (키값) — Primary key — NOT NULL
  • company_id (기업아이디) — Foreign key → company.id — NOT NULL
  • status (상태)

item_income (입고)

  • id (키값) — Primary key — NOT NULL
  • company_id (기업아이디) — Foreign key → company.id — NOT NULL
  • status (상태)

manufacturer (생산지)

  • id (키값) — Primary key — NOT NULL
  • product_id (품목아이디) — Foreign key → product.id — NOT NULL
  • plant_id (플랜트 아이디) — Foreign key → company_plant.id — NOT NULL
  • Field

members (직원)

  • id (키값) — Primary key — NOT NULL
  • company_id (기업아이디) — Foreign key → company.id — NOT NULL
  • user_id (유저아이디) — Foreign key → users.id — NOT NULL
  • is_master (관리자)

process_group (공정그룹)

  • id (키값) — Primary key — NOT NULL
  • name (공정명)

process_item (세부공정)

  • id (키값) — Primary key — NOT NULL
  • process_id (공정아이디) — Foreign key → process_group.id — NOT NULL
  • code (공정코드)
  • name (공정명)
  • srt (순번)
  • time_taken (소요시간)

product (품목)

  • id (키값) — Primary key — NOT NULL
  • company_id (기업아이디) — Foreign key → company.id — NOT NULL
  • division_id (구분명아이디) — Foreign key → product_division.id — NOT NULL
  • group_id (그룹아이디) — Foreign key → product_group.id — NOT NULL
  • code (품목코드)
  • name (품목명)
  • barcode (바코드)
  • sale_price (판매단가)
  • sale_vat (판매단가_부가세포함여부)
  • stock_manage (재고수량관리여부)
  • base_unit (기본단위)
  • gross_weight (총중량)
  • unit_weight (중량단위)
  • net_weight (순중량)
  • volume (부피)
  • unit_volume (부피단위)
  • gr_processing_dt (입고소요일수)

product_division (품목구분)

  • id (키값) — Primary key — NOT NULL
  • title (구분명)

product_group (품목그룹)

  • id (키값) — Primary key — NOT NULL
  • code (코드)
  • name (그룹명)

product_history (품목 기록)

  • id (키값) — Primary key — NOT NULL
  • product_id (품목아이디) — Foreign key → product.id — NOT NULL
  • id (키값2) — Foreign key → product.group_id — NOT NULL
  • qty (수량)
  • increase (증감)
  • status (상태)
  • message (메시지)

product_provider (품목 공급자)

  • id (키값) — Primary key — NOT NULL
  • product_id (품목아이디) — Foreign key → product.id — NOT NULL
  • client_id (거래처아이디) — Foreign key → client.id — NOT NULL
  • purchase_price (구입단가)
  • purchase_vat (구입단가_부가세포함여부)
  • country_origin (원산지)
  • priority (우선순위)

product_qty (품목_수량)

  • id (키값) — Primary key — NOT NULL
  • product_id (품목아이디) — Foreign key → product.id — NOT NULL
  • plant_id (플랜트 아이디) — Foreign key → company_plant.id — NOT NULL
  • storage_id (저장위치 아이디) — Foreign key → storage_location.id — NOT NULL
  • waiting (대기수량)
  • available (가용수량)

production_plan (생산계획)

  • id (키값) — Primary key — NOT NULL
  • product_id (품목아이디) — Foreign key → product.id — NOT NULL
  • process_group_id (공정그룹아이디) — Foreign key → process_group.id — NOT NULL
  • id (키값2) — Foreign key → product.group_id — NOT NULL
  • code (계획코드)
  • result_qty (산출수량)
  • time_taken (소요시간)

production_plan_history (생산계획 기록)

  • id (키값) — Primary key — NOT NULL
  • plan_id (계획아이디) — Foreign key → production_plan.id — NOT NULL
  • id (키값2) — Foreign key → production_plan.id — NOT NULL
  • start_dt (시작일시)
  • end_dt (종료일시)
  • status (상태)
  • message (메시지)

purchase_request (구매요청)

  • id (키값) — Primary key — NOT NULL

raw_material (원재료)

  • id (키값) — Primary key — NOT NULL
  • plan_id (계획아이디) — Foreign key → production_plan.id — NOT NULL
  • product_id (품목아이디) — Foreign key → product.id — NOT NULL
  • id (키값2) — Foreign key → product.group_id — NOT NULL
  • qty (필요수량)

resource (자원)

  • id (키값) — Primary key — NOT NULL
  • code (자원코드)
  • name (자원명)

sales (판매)

  • id (키값) — Primary key — NOT NULL
  • code (품목코드)
  • name (품목명)
  • unit (규격)
  • qty (수량)
  • price (단가)

shipping_document_detail (출하지시서 상세)

  • id (키값) — Primary key — NOT NULL
  • document_id (출하지시서 아이디) — Foreign key → shipping_documents.id — NOT NULL
  • product_id (품목아이디) — Foreign key → product.id — NOT NULL
  • id (키값2) — Foreign key → product.group_id — NOT NULL
  • unit (규격)
  • qty (수량)

shipping_documents (출하지시서)

  • id (키값) — Primary key — NOT NULL
  • company_id (기업아이디) — Foreign key → company.id — NOT NULL
  • client_id (거래처아이디) — Foreign key → client.id — NOT NULL
  • name (출하지시서명)
  • message (메시지)
  • manager (담당자)
  • due_date (출하예정일)

storage_location (저장위치)

  • id (키값) — Primary key — NOT NULL
  • plant_id (플랜트 아이디) — Foreign key → company_plant.id — NOT NULL
  • name (위치명)

users (유저)

  • id (키값) — Primary key — NOT NULL
  • name (이름)
  • email (이메일)
  • password (패스워드)

warehouse (창고)

  • id (키값) — Primary key — NOT NULL
  • company_id (기업아이디) — Foreign key → company.id — NOT NULL
  • name (창고명)
  • address (주소)