mes
테이블 (13)
고객사/ 거래처 테이블 (company)
- company_code (Key) — 기본 키 — NOT NULL
- company_name (Field2)
- company_address (Field3)
- company_tel_number (Field)
- trade_goods (Field4)
- company_manager (Field6)
부자재테이블 (wrap)
- id (Key) — 기본 키 — NOT NULL
- sub_materials_name (Field2)
- sub_materials_amount (Field3)
- company_name (Field)
- id_date (Field4)
- out_date (Field5)
사원테이블 (employee)
- employeeCode (Key) — 기본 키 — NOT NULL
- employeeName (Field2)
- positionName (Field3)
생산계획 테이블 (productionPlan)
- productionPlanCode (Key) — 기본 키 — NOT NULL
- order_Number (Key3) — 외래 키 → 수주테이블.order_Number — NOT NULL
- materials_Name (Field)
- P_startDate (Field3)
- P_endDate (Field4)
- target_Output (Field5)
- now_Output (Field6)
- state (Field7)
설비현황 테이블 (equipment)
- EquipmentCode (Key) — 기본 키 — NOT NULL
- operationRate (Field3)
- ResonNoOp (Field4)
- state (Field2)
- settingDate (Field)
- Equipment_Name (Field5)
수주내용 테이블 (obtaindetail)
- id (Key2) — 기본 키 — NOT NULL
- order_Number (Key) — 외래 키 → 수주테이블.order_Number — NOT NULL
- writer (Field7)
- productName (Field3)
- order_Date (Field2)
- order_Amount (Field)
- state (Field9)
- delivery_Date (Field6)
- company_name (Field4)
수주테이블 (obtainorder)
- order_Number (Key) — 기본 키 — NOT NULL
완제품 재고 테이블 (finishedstock)
- id (Key) — 기본 키 — NOT NULL
- orderNumber (Key2) — 외래 키 → 수주테이블.order_Number — NOT NULL
- materials_Name (Field2)
- amount (Field)
- exp (Field4)
- state (Field7)
- shipment_state (Field3)
운송업체 (carrier)
- carrier_Code (Key) — 기본 키 — NOT NULL
- carrier_Name (Field)
- carrier_PhoneNumber (Field2)
- carrier_Vehicle (Field3)
- carrier_Price (Field4)
- carrier_manager (Field5)
- shipment_Number (Key2) — 외래 키 → 출하 테이블.shipment_Number — NOT NULL
원자재 재고 테이블 (ingredientStock)
- id (Key) — 기본 키 — NOT NULL
- materials_Name (Field2)
- ingredient_Amount (Field6)
- exp (Field4)
- orderNumber (Key2) — 외래 키 → 수주테이블.order_Number — NOT NULL
- company_name (Field9)
- in_date (Field10)
- sub_materials_name (Field11)
- sub_materials_amount (Field12)
- state (Field)
작업지시서 테이블 (workOrderPlan)
- production_Plan_Id (Key) — 기본 키 — NOT NULL
- productionPlanCode (Key2) — 외래 키 → 생산계획 테이블.productionPlanCode — NOT NULL
- order_Number (Key3) — 외래 키 → 수주테이블.order_Number — NOT NULL
- producer (Field)
- processName (Field2)
- P_startDate (Field3)
- P_endDate (Field4)
- target_Output (Field5)
- now_Output (Field6)
- state (Field7)
- materials_Name (Field8)
- operaton_rate (Field9)
- processCode (Field10)
작업현황 테이블 (workPerform)
- id (Key) — 기본 키 — NOT NULL
- productionPlanCode (Key2) — 외래 키 → 생산계획 테이블.productionPlanCode — NOT NULL
- target_Output (Field2)
- now_Output (Field3)
- processName (Field)
- defect_Rate (Field4)
- process_name (Field5)
출하 테이블 (shipment)
- shipment_Number (Key) — 기본 키 — NOT NULL
- order_Number (Key2) — 외래 키 → 수주테이블.order_Number — NOT NULL
- company_name (Field2)
- company_Address (Field10)
- shipment_Amount (Field4)
- productionName (Field5)
- shippingDate (Field6)
- deliveryDate (Field7)
- createdAt (Field)
- state (Field8)