재경 변경 전
테이블 (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)