재경 변경 전

테이블 (17)

Copy Of MES_DETAILSITEMINFO_TB - 세부 품목정보 관리 테이블(제품) (MDT2)

  • DETAILSITEMINFO_SQ (Key) — INT(11) — 기본 키 — NOT NULL
  • ITEM_SQ (Key2) — INT(11) — 외래 키 → Copy Of MES_ITEMINFO_TB - 품목정보 관리 테이블(제품).ITEM_SQ — NOT NULL
  • LENGTH (Field2) — VARCHAR(30)
  • PRICE_GB (Field3) — VARCHAR(30)
  • UNIT (Field4) — VARCHAR(7)
  • UNIT_GB (Field5) — VARCHAR(30)
  • UNIT_M (Field6) — VARCHAR(30)
  • UNIT_KG (Field7) — VARCHAR(30)
  • MODEL_NM (Field8) — VARCHAR(45)
  • WEIGHT (Field9) — VARCHAR(30)

Copy Of MES_ITEMINFO_TB - 품목정보 관리 테이블(제품) (MIIT2)

  • ITEM_SQ (Key) — INT(11) — 기본 키 — NOT NULL
  • ITEM_NM (Field) — INT(11)
  • ITEM_TYPE (Field2) — INT(11)
  • CUSTOMER_SQ (Field3) — INT(11)
  • STANDARD (Field4) — VARCHAR(30)
  • PRODUCT (Field5) — VARCHAR(10)
  • ASPECT (Field6) — VARCHAR(30)
  • STANDARDUNIT (Field7) — VARCHAR(30)
  • MATERIAL (Field8) — VARCHAR(30)
  • OUTERDIAMETER (Field9) — VARCHAR(30)
  • NTERNALDIAMETER (Field10) — VARCHAR(30)
  • THICKNESS (Field11) — VARCHAR(30)
  • WEIGHT (Field12) — VARCHAR(30)
  • UNITUSE (Field13) — VARCHAR(3)
  • VIGO (Field14) — VARCHAR(50)
  • VERTICAL (Field15) — DOUBLE
  • HORIZONTAL (Field16) — DOUBLE

MES_CUSTOMERINFO_TB - 거래처정보 관리 테이블 (MCT)

  • MES_CUSTOMERINFO_TB (Key) — INT(11) — 기본 키 — NOT NULL
  • CUSTOMER_CD (Field) — INT(11)
  • CUSTOMER_NM (Field2) — VARCHAR(50)
  • CUSTOMER_SN (Field3) — VARCHAR(50)
  • CUSTOMER_TY (Field4) — VARCHAR(20)
  • EVENT (Field5) — VARCHAR(20)
  • PERSONLNCHARGE_NM (Field6) — VARCHAR(20)
  • REPRESENTATIVE_NM (Field7) — VARCHAR(20)
  • FIRST_TRADING_DAY (Field8) — VARCHAR(20)
  • RESIDENT_REGISTRATION_NO (Field9) — VARCHAR(15)
  • BUSINESS_REG_NO (Field10) — VARCHAR(50)
  • CORPORATEG_NO (Field11) — VARCHAR(50)
  • CUSTOMER_TEL (Field12) — VARCHAR(20)
  • FAX_NO (Field13) — VARCHAR(50)
  • POST_NO (Field14) — VARCHAR(50)
  • ADDRESS_W (Field15) — VARCHAR(200)
  • ADDRESS_W2 (Field16) — VARCHAR(200)
  • PAYMENT (Field17) — VARCHAR(20)
  • VAT_GB (Field18) — VARCHAR(20)
  • PUBLICATION (Field19) — VARCHAR(20)
  • CUSTOMER_GB (Field20) — VARCHAR(30)
  • MAIL_E (Field21) — VARCHAR(50)
  • REMARKS (Field22) — VARCHAR(50)
  • REG_DT (Field23) — DATE
  • EOPTAE (Field24) — VARCHAR(50)
  • PERSONINNUMBER (Field25) — VARCHAR(200)

MES_DETAILSITEMINFO_TB - 세부 품목정보 관리 테이블(투입) (MDT)

  • DETAILSITEMINFO_SQ (Key) — INT(11) — 기본 키 — NOT NULL
  • ITEM_SQ (Key2) — INT(11) — 외래 키 → MES_ITEMINFO_TB - 품목정보 관리 테이블(투입).ITEM_SQ — NOT NULL
  • LENGTH (Field2) — VARCHAR(30)
  • PRICE_GB (Field3) — VARCHAR(30)
  • UNIT (Field4) — VARCHAR(7)
  • UNIT_GB (Field5) — VARCHAR(30)
  • UNIT_M (Field6) — VARCHAR(30)
  • UNIT_KG (Field7) — VARCHAR(30)
  • MODEL_NM (Field8) — VARCHAR(45)
  • WEIGHT (Field9) — VARCHAR(30)

MES_FACILITY_TB - 설비정보 관리 테이블 (MFT)

  • FACILITY_SQ (Key) — INT(11) — 기본 키 — NOT NULL
  • FACILITY_PIC (Field) — MEDIUMBLOB
  • MANAGE_NO (Field2) — VARCHAR(30)
  • FACILITY_NM (Field3) — VARCHAR(45)
  • MODEL_NM (Field4) — VARCHAR(45)
  • STANDARD (Field5) — VARCHAR(30)
  • PRODUCTION_CP (Field6) — VARCHAR(30)
  • PURCHASE_DT (Field7) — DATE
  • INSTALLACTION_PL (Field8) — VARCHAR(30)
  • PURCHASE_CP (Field9) — VARCHAR(30)
  • PURCHASE_PR (Field10) — VARCHAR(20)
  • PURCHASE_TEL (Field11) — VARCHAR(15)
  • MANUFACTURE_DT (Field12) — DATE
  • AS_COMPANY (Field13) — VARCHAR(30)
  • AS_MANAGER (Field14) — VARCHAR(30)
  • AS_TEL (Field15) — VARCHAR(15)
  • MEASUREMENTSERVER_PATH (Field16) — VARCHAR(100)
  • MEASUREMENTSERVER_NM (Field17) — VARCHAR(50)
  • PROCESS_SQ (Field18) — INT(11)
  • LINE_NM (Field19) — VARCHAR(30)

MES_ITEMINFO_TB - 품목정보 관리 테이블(투입) (MIIT)

  • ITEM_SQ (Key) — INT(11) — 기본 키 — NOT NULL
  • ITEM_NM (Field) — INT(11)
  • ITEM_TYPE (Field2) — INT(11)
  • CUSTOMER_SQ (Field3) — INT(11)
  • STANDARD (Field4) — VARCHAR(30)
  • PRODUCT (Field5) — VARCHAR(10)
  • ASPECT (Field6) — VARCHAR(30)
  • STANDARDUNIT (Field7) — VARCHAR(30)
  • MATERIAL (Field8) — VARCHAR(30)
  • OUTERDIAMETER (Field9) — VARCHAR(30)
  • NTERNALDIAMETER (Field10) — VARCHAR(30)
  • THICKNESS (Field11) — VARCHAR(30)
  • WEIGHT (Field12) — VARCHAR(30)
  • UNITUSE (Field13) — VARCHAR(3)
  • VIGO (Field14) — VARCHAR(50)
  • VERTICAL (Field15) — DOUBLE
  • HORIZONTAL (Field16) — DOUBLE

MES_POC_TB - POC 테이블 (MPT)

  • POC_SQ (Key) — INT(11) — 기본 키 — NOT NULL
  • POC_SQ (Field43) — int — 외래 키 → MES_PROCESSROUTING_TB - 공정순서.POC_SQ
  • POC_SQ (Field6) — int — 외래 키 → MES_PROCESSROUTING_TB - 공정순서(인발).POC_SQ
  • POC_NO (Field) — VARCHAR(30)
  • RECEIPT_DT (Field2) — DATE
  • INPUT_WHTHR (Field3) — TINYINT(1)
  • PRODUCTION_WHTHR (Field4) — TINYINT(1)
  • OBTAINORDER_SQ (Field5) — INT(11)
  • ITEMCUSTOMERSN_SQ (Key2) — INT(11) — 외래 키 → MES_CUSTOMERINFO_TB - 거래처정보 관리 테이블.MES_CUSTOMERINFO_TB — NOT NULL
  • MUTUAL_DETAILSITEMINFO_SQ (Key4) — INT(11) — 외래 키 → Copy Of MES_DETAILSITEMINFO_TB - 세부 품목정보 관리 테이블(제품).DETAILSITEMINFO_SQ — NOT NULL
  • MUTUAL_QTY (Field8) — DOUBLE
  • INPUTCUSTOMERSN_SQ (Field9) — INT(11)
  • INPUT_DETAILSITEMINFO_SQ (Key3) — INT(11) — 외래 키 → MES_DETAILSITEMINFO_TB - 세부 품목정보 관리 테이블(투입).DETAILSITEMINFO_SQ — NOT NULL
  • INPUT_QTY (Field11) — DOUBLE
  • DUE_DATE (Field12) — DATE
  • UNIQUENESS (Field13) — VARCHAR(500)
  • PRODUCE_DT (Field14) — DATE
  • INPUT_DT (Field15) — DATE
  • PLACE (Field16) — VARCHAR(50)
  • DIVISION (Field17) — VARCHAR(30)
  • OUTER_DMT_TOLERANCE_M (Field18) — FLOAT
  • OUTER_DMT_TOLERANCE_P (Field19) — FLOAT
  • NTRNL_TOLERANCE_M (Field20) — FLOAT
  • NTRNL_TOLERANCE_P (Field21) — FLOAT
  • THK_TOLERANCE_M (Field22) — FLOAT
  • THK_TOLERANCE_P (Field23) — FLOAT
  • POC_DT (Field24) — DATE
  • POC_TM (Field25) — TIME
  • WORKORDER_DT (Field26) — DATE
  • WORK_ST (Field27) — TINYINT(1)
  • FACILITY_SQ (Field28) — INT(11)
  • INPUT_STOCK_SQ (Field29) — INT(11)
  • STOCK_SQ (Field30) — INT(11)
  • PRODUCE_WEIGHT (Field31) — DOUBLE
  • LOSS (Field32) — VARCHAR(10)
  • OUTPOC_NO (Field33) — VARCHAR(30)
  • URGENCY (Field34) — TINYINT(1)
  • ACCEPT_NAME (Field35) — VARCHAR(50)
  • ACCEPT (Field36) — TINYINT(1)
  • CLT_PRODUCTION_WHTHR (Field37) — TINYINT(1)
  • PURCHASE_DT (Field38) — DATE
  • NORMALCUSTOMERSN_SQ (Field39) — INT(11)
  • NORMAL_DETAILSITEMINFO_SQ (Field40) — INT(11)
  • PRINT_WHTHR (Field41) — TINYINT(1)
  • VIGO (Field42) — VARCHAR(45)

MES_PROCESSDETAIL_TB - 공정순서 세부내용 (MPDT2)

  • PROCESSDETAIL_SQ (Key) — INT(11) — 기본 키 — NOT NULL
  • PROCESSROUTING_SQ (Key2) — int — 외래 키 → MES_PROCESSROUTING_TB - 공정순서(인발).PROCESSROUTING_SQ — NOT NULL
  • VIGO (Field2) — VARCHAR(50)
  • DAISEU (Field3) — VARCHAR(50)
  • D (Field4) — VARCHAR(45)
  • PLUG (Field5) — VARCHAR(50)
  • P (Field6) — VARCHAR(45)
  • PROCESSDETAIL_THICK (Field7) — VARCHAR(50)
  • SEQUENCE (Field22) — TINYINT(1) — 외래 키 → MES_PROCESSROUTING_TB - 공정순서(인발).SEQUENCE

MES_PROCESSDETAIL_TB - 공정순서 세부내용(이전차수 인발) (MPDT3)

  • PROCESSDETAIL_SQ (Key) — INT(11) — 기본 키 — NOT NULL
  • PROCESSROUTING_SQ (Key2) — int — 외래 키 → MES_PROCESSROUTING_TB - 공정순서(이전차수 인발).PROCESSROUTING_SQ — NOT NULL
  • VIGO (Field2) — VARCHAR(50)
  • DAISEU (Field3) — VARCHAR(50)
  • D (Field4) — VARCHAR(45)
  • PLUG (Field5) — VARCHAR(50)
  • P (Field6) — VARCHAR(45)
  • PROCESSDETAIL_THICK (Field7) — VARCHAR(50)
  • SEQUENCE (Field22) — TINYINT(1) — 외래 키 → MES_PROCESSROUTING_TB - 공정순서(인발).SEQUENCE

MES_PROCESSPROCEDURE_TB - 이전 작업순서(공정 지정) (MPRDT)

  • PROCESSPROCEDURE_SQ (Key) — INT(11) — 기본 키 — NOT NULL
  • ORDER_NUMBER (Field) — INT(11) — 기본 키
  • POC_SQ (Field3) — INT(11)
  • PROCESSROUTING_SQ (Field11) — INT(11) — 외래 키 → MES_WORKRECORD_TB - 이전 POC 작업이력(열약, 구부, 절단, 교정검사, 인발 ).PROCESSROUTING_SQ

MES_PROCESSPROCEDURE_TB - 작업순서(공정 지정) (MPRT)

  • PROCESSPROCEDURE_SQ (Key) — INT(11) — 기본 키 — NOT NULL
  • POC_SQ (Key2) — INT(11) — 외래 키 → MES_POC_TB - POC 테이블.POC_SQ — NOT NULL
  • PROCESSROUTING_SQ (Field11) — INT(11) — 외래 키 → MES_WORKRECORD_TB - POC 작업이력(열약, 구부, 절단, 교정검사, 인발 ).PROCESSROUTING_SQ
  • PROCESSROUTING_SQ (Field) — INT(11) — 외래 키 → MES_WORKST_TB - POC 공정 작업 상태.PROCESSROUTING_SQ
  • ORDER_NUMBER (Field4) — INT(11) — 외래 키 → MES_PROCESSPROCEDURE_TB - 이전 작업순서(공정 지정).ORDER_NUMBER

MES_PROCESSROUTING_TB - 공정순서 (MPSRT)

  • PROCESSROUTING_SQ (Key) — int — 기본 키 — NOT NULL
  • POC_SQ (Field) — int — 기본 키
  • SEQUENCE (Field22) — TINYINT(1) — 외래 키 → MES_PROCESSROUTING_TB - 공정순서(인발).SEQUENCE
  • PROCESS_NM (Field3) — VARCHAR(10)
  • SAVE_GB (Field4) — TINYINT(1)

MES_PROCESSROUTING_TB - 공정순서(이전차수 인발) (MPRT3)

  • PROCESSROUTING_SQ (Key) — int — 기본 키 — NOT NULL
  • POC_SQ (Field) — int — 기본 키
  • SEQUENCE (Field22) — TINYINT(1) — 외래 키 → MES_PROCESSROUTING_TB - 공정순서(인발).SEQUENCE
  • PROCESS_NM (Field3) — VARCHAR(10)
  • SAVE_GB (Field4) — TINYINT(1)

MES_PROCESSROUTING_TB - 공정순서(인발) (MPRT2)

  • PROCESSROUTING_SQ (Key) — int — 기본 키 — NOT NULL
  • SEQUENCE (Field2) — TINYINT(1) — 기본 키
  • POC_SQ (Field) — int — 기본 키
  • PROCESS_NM (Field3) — VARCHAR(10)
  • SAVE_GB (Field4) — TINYINT(1)

MES_WORKRECORD_TB - POC 작업이력(열약, 구부, 절단, 교정검사, 인발 ) (MWR)

  • WORKRECORD_SQ (Key) — INT(11) — 기본 키 — NOT NULL
  • PROCESSROUTING_SQ (Field11) — INT(11) — 기본 키
  • PROCESSROUTING_SQ (Key2) — INT(11) — 외래 키 → MES_PROCESSROUTING_TB - 공정순서.PROCESSROUTING_SQ — NOT NULL
  • PRDCTHISTORY_SQ (Field2) — INT(11)
  • QTY (Field3) — VARCHAR(50)
  • LENGTH (Field4) — VARCHAR(50)
  • READY_TM (Field5) — VARCHAR(10)
  • WORKEND_TM (Field6) — VARCHAR(10)
  • STOP_TM (Field7) — VARCHAR(10)
  • REPAIR_CM (Field8) — VARCHAR(50)
  • STAFF_NM (Field9) — VARCHAR(20)
  • WORK_DATE (Field10) — TIMESTAMP
  • FACILITY_SQ (Key3) — INT(11) — 외래 키 → MES_FACILITY_TB - 설비정보 관리 테이블.FACILITY_SQ — NOT NULL
  • WORK_RESULT (Field12) — VARCHAR(20)
  • SPEED (Field13) — VARCHAR(20)
  • PROCESS_CNT (Field14) — VARCHAR(20)
  • AUTO_READY_TM (Field15) — VARCHAR(10)
  • AUTO_WORKEND_TM (Field16) — VARCHAR(10)
  • AUTO_STOP_TM (Field17) — VARCHAR(10)
  • PROCESSROUTING_SQ (Field) — INT(11)

MES_WORKRECORD_TB - 이전 POC 작업이력(열약, 구부, 절단, 교정검사, 인발 ) (MWR2)

  • WORKRECORD_SQ (Key) — INT(11) — 기본 키 — NOT NULL
  • PROCESSROUTING_SQ (Field11) — INT(11) — 기본 키
  • PRDCTHISTORY_SQ (Field2) — INT(11)
  • QTY (Field3) — VARCHAR(50)
  • LENGTH (Field4) — VARCHAR(50)
  • READY_TM (Field5) — VARCHAR(10)
  • WORKEND_TM (Field6) — VARCHAR(10)
  • STOP_TM (Field7) — VARCHAR(10)
  • REPAIR_CM (Field8) — VARCHAR(50)
  • STAFF_NM (Field9) — VARCHAR(20)
  • WORK_DATE (Field10) — TIMESTAMP
  • FACILITY_SQ (Field18) — INT(11)
  • WORK_RESULT (Field12) — VARCHAR(20)
  • SPEED (Field13) — VARCHAR(20)
  • PROCESS_CNT (Field14) — VARCHAR(20)
  • AUTO_READY_TM (Field15) — VARCHAR(10)
  • AUTO_WORKEND_TM (Field16) — VARCHAR(10)
  • AUTO_STOP_TM (Field17) — VARCHAR(10)
  • PROCESSROUTING_SQ (Field) — INT(11)

MES_WORKST_TB - POC 공정 작업 상태 (MWST)

  • WORKST_SQ (Key) — INT(11) — 기본 키 — NOT NULL
  • PROCESSROUTING_SQ (Field) — INT(11) — 기본 키
  • WORK_DATE (Field2) — TIMESTAMP
  • STAFF_NM (Field3) — VARCHAR(20)
  • WORK_ST (Field4) — TINYINT(1)
  • STOP_CM (Field5) — VARCHAR(50)
  • FACILITY_SQ (Field6) — INT(11)
  • WORK_TIME (Field7) — INT(11)
  • READY_TIME (Field8) — INT(11)
  • STOP_TIME (Field9) — INT(11)
  • UPDATE_DONE (Field10) — TINYINT(1)