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 (주소)