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)