MJ
sample
Tables (26)
TB_AUTH (권한)
- AUTH_CD — NVARCHAR(20) — Primary key — NOT NULL
- AUTH_NAME — NVARCHAR(50)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
- UPDATE_DT — DATETIME
- UPDATE_ID — NVARCHAR(20)
TB_AUTH_PGM (권한상세)
- AUTH_CD — NVARCHAR(20) — Foreign key → TB_AUTH.AUTH_CD — NOT NULL
- PGM_ID — NVARCHAR(20)
TB_Client (거래처)
- C_CODE — NVARCHAR(20) — Primary key — NOT NULL
- C_NAME — NVARCHAR(50)
- C_TYPE — NVARCHAR(20)
- C_TEL — NVARCHAR(20)
- C_FAX — NVARCHAR(20)
- C_ADDRESS — NVARCHAR(200)
- MST_NAME — NVARCHAR(20)
- MST_PHONE — NVARCHAR(20)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_CodeMst (공통코드)
- GROUP_ID — NVARCHAR(20) — Primary key — NOT NULL
- CODE_ID — NVARCHAR(20) — Primary key — NOT NULL
- GROUP_NM — NVARCHAR(50)
- CODE_NM — NVARCHAR(50)
- SEQ — INT
- REF1 — NVARCHAR(30)
- REF2 — NVARCHAR(30)
- REF3 — NVARCHAR(30)
- REF4 — NVARCHAR(30)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
- UPDATE_DT — DATETIME
- UPDATE_ID — NVARCHAR(20)
TB_Defect (불량코드)
- DF_CODE — NVARCHAR(20) — Primary key — NOT NULL
- DF_NAME (DF_NAMEN) — NVARCHAR(50)
- DF_TYPE — NVARCHAR(20)
- REMARK1 — NVARCHAR(200)
- REMARK2 — NVARCHAR(200)
- REMARK3 — NVARCHAR(200)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_Defect_IN (불량내역등록)
- ID — INT — Primary key — NOT NULL
- DF_CODE — NVARCHAR(20) — Foreign key → TB_Defect.DF_CODE — NOT NULL
- DF_DT — DATETIME
- WORK_STATION — NVARCHAR(30)
- QTY — INT
- REMARK1 — NVARCHAR(200)
- REMARK2 — NVARCHAR(200)
- REMARK3 — NVARCHAR(200)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_FIRST_IN_END (초중종등록)
- ID — INT — Primary key — NOT NULL
- ORDER_NO — NVARCHAR(20) — Foreign key → TB_Production_Plan.ORDER_NO — NOT NULL
- Field
- RESULT1 — NVARCHAR(50)
- RESULT2 — NVARCHAR(50)
- RESULT3 — NVARCHAR(50)
- RESULT4 — NVARCHAR(50)
- RESULT5 — NVARCHAR(50)
- CHECK_TIME — DATETIME
- CHECK_DATE — DATETIME
- CHECK_USER — NVARCHAR(20)
- REMARKS — NVARCHAR(200)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
- UPDATE_DT — DATETIME
- UPDATE_ID — NVARCHAR(20)
TB_FIRST_IN_END_SUB (초중종기존)
- FIN_CODE — NVARCHAR(20) — Primary key — NOT NULL
- ID — INT
- P_CODE — NVARCHAR(20) — Foreign key → TB_Product.P_CODE — NOT NULL
- EXAMINATION1 — NVARCHAR(50)
- EXAMINATION2 — NVARCHAR(50)
- EXAMINATION3 — NVARCHAR(50)
- EXAMINATION4 — NVARCHAR(50)
- EXAMINATION5 — NVARCHAR(50)
- EXAMINATION6 — NVARCHAR(50)
- REMARKS — NVARCHAR(200)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
- UPDATE_DT — DATETIME
- UPDATE_ID — NVARCHAR(20)
TB_Metal_Mold (금형정보)
- MM_CODE — NVARCHAR(30) — Primary key — NOT NULL
- MM_NAME — NVARCHAR(50)
- PRESS_QTY — INT
- PRESS_IN_QTY — INT
- C_CODE — NVARCHAR(20) — Foreign key → TB_Client.C_CODE — NOT NULL
- PART_CODE — NVARCHAR(20)
- PART_NAME — NVARCHAR(50)
- PRODUCTION_DT — DATETIME
- GRADE — NVARCHAR(20)
- POSITION — NVARCHAR(20)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_Metal_Mold_Sub (금형기록)
- ID — INT — Primary key — NOT NULL
- MM_CODE — NVARCHAR(30) — Foreign key → TB_Metal_Mold.MM_CODE — NOT NULL
- USE_DT — DATETIME
- PRESS_QTY — INT
- WORKE_CODE — NVARCHAR(20) — Foreign key → TB_WorkerMst.WORKE_CODE — NOT NULL
- WORK_DEVICE — NVARCHAR(20)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_Packge (포장)
- ID — INT — Primary key — NOT NULL
- PKG_CODE (Key) — NVARCHAR(30) — Primary key — NOT NULL
- P_CODE — NVARCHAR(20) — Foreign key → TB_Product.P_CODE — NOT NULL
- P_QTY — INT
- P_STATUS — INT
- WORK_STATION — INT
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_Packge_Sub (포장상세)
- P_BARCODE — NVARCHAR(30) — Primary key — NOT NULL
- PKG_CODE (Key) — NVARCHAR(30) — Foreign key → TB_Packge.PKG_CODE — NOT NULL
- QTY — INT
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_Press (프레스정보)
- ID — INT — Primary key — NOT NULL
- ORDER_NO — NVARCHAR(20) — Foreign key → TB_Production_Plan.ORDER_NO — NOT NULL
- Field
- SLT_BARCODE — NVARCHAR(30) — Foreign key → TB_Slitting.SLT_BARCODE — NOT NULL
- WORK_STATION — INT
- P_CODE — NVARCHAR(20) — Foreign key → TB_Product.P_CODE — NOT NULL
- PRESS_QTY — INT
- WORKE_CODE — NVARCHAR(20) — Foreign key → TB_WorkerMst.WORKE_CODE — NOT NULL
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_Product (제품정보)
- P_CODE — NVARCHAR(20) — Primary key — NOT NULL
- P_NAME — NVARCHAR(50)
- EXPIRYDATE — INT
- ISDELETE — BIT
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
- UPDATE_DT — DATETIME
- UPDATE_ID — NVARCHAR(20)
TB_Product_Warehouse_IN (제품입고)
- ID — INT — Primary key — NOT NULL
- PKG_CODE (Key) — NVARCHAR(30) — Foreign key → TB_Packge.PKG_CODE — NOT NULL
- P_CODE — NVARCHAR(20) — Foreign key → TB_Product.P_CODE — NOT NULL
- POSITION — NVARCHAR(20)
- QTY — INT
- CANCLI_YN — NVARCHAR(5)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
- UPDATE_DT — DATETIME
- UPDATE_ID — NVARCHAR(20)
TB_Product_Warehouse_OUT (제품출고)
- ID — INT — Primary key — NOT NULL
- PKG_CODE (Key) — NVARCHAR(30) — Foreign key → TB_Packge.PKG_CODE — NOT NULL
- P_CODE — NVARCHAR(20) — Foreign key → TB_Product.P_CODE — NOT NULL
- C_CODE — NVARCHAR(20) — Foreign key → TB_Client.C_CODE — NOT NULL
- QTY — INT
- POSITION — NVARCHAR(20)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
- UPDATE_DT — DATETIME
- UPDATE_ID — NVARCHAR(20)
TB_Production_Plan (작업지시)
- ORDER_NO — NVARCHAR(20) — Primary key — NOT NULL
- ORDER_DATE — DATETIME
- ORDER_TYPE — INT
- ORDER_SEQ — INT
- WORKE_CODE — NVARCHAR(20) — Foreign key → TB_WorkerMst.WORKE_CODE — NOT NULL
- P_CODE — NVARCHAR(20) — Foreign key → TB_Product.P_CODE — NOT NULL
- PLAN_QTY — INT
- PROD_CD — NVARCHAR(20)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_Production_Plan_Sub (작업지시상세)
- ORDER_NO — NVARCHAR(20) — Foreign key → TB_Production_Plan.ORDER_NO — NOT NULL
- P_CODE — NVARCHAR(20) — Foreign key → TB_Product.P_CODE — NOT NULL
- QTY — INT
- IN_QTY — INT
- PROD_CD — NVARCHAR(20)
- O_STATUS — INT
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_Raw_Materials (자재정보)
- R_CODE — NVARCHAR(30) — Primary key — NOT NULL
- R_NAME — NVARCHAR(50)
- AMOUNT — INT
- UNIT — NVARCHAR(10)
- EXPIRYDATE — INT
- MINIMUM — INT
- ISDELETE — BIT
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
- UPDATE_DT — DATETIME
- UPDATE_ID — NVARCHAR(20)
TB_Raw_Materials_END (자재마감)
- ID — INT — Primary key — NOT NULL
- END_DT — DATETIME
- R_CODE — NVARCHAR(30) — Foreign key → TB_Raw_Materials.R_CODE — NOT NULL
- POSITION — NVARCHAR(20)
- QTY — INT
- R_BARCODE — NVARCHAR(30)
- CLIENT_CODE — NVARCHAR(30)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
- UPDATE_DT — DATETIME
- UPDATE_ID — NVARCHAR(20)
TB_Raw_Materials_IN (자재입고)
- ID — INT — Primary key — NOT NULL
- R_CODE — NVARCHAR(30) — Foreign key → TB_Raw_Materials.R_CODE — NOT NULL
- POSITION — NVARCHAR(20)
- IN_QTY — INT
- R_BARCODE — NVARCHAR(30)
- CLIENT_CODE — NVARCHAR(30)
- C_CODE — NVARCHAR(20) — Foreign key → TB_Client.C_CODE — NOT NULL
- CANCLI_YN — NVARCHAR(5)
- NOTE1 — NVARCHAR(200)
- NOTE2 — NVARCHAR(200)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
- UPDATE_DT — DATETIME
- UPDATE_ID — NVARCHAR(20)
TB_Raw_Materials_OUT (자재출고)
- ID — INT — Primary key — NOT NULL
- R_CODE — NVARCHAR(30) — Foreign key → TB_Raw_Materials.R_CODE — NOT NULL
- POSITION — NVARCHAR(20)
- OUT_QTY — INT
- R_BARCODE — NVARCHAR(30)
- CLIENT_CODE — NVARCHAR(30)
- CANCLI_YN — NVARCHAR(5)
- FROM_WORKC — NVARCHAR(20)
- NOTE1 — NVARCHAR(200)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
- UPDATE_DT — DATETIME
- UPDATE_ID — NVARCHAR(20)
TB_Slitting (스리팅정보)
- ID — INT — Primary key — NOT NULL
- SLT_BARCODE — NVARCHAR(30) — Primary key — NOT NULL
- ORDER_NO — NVARCHAR(20) — Foreign key → TB_Production_Plan.ORDER_NO — NOT NULL
- SEQ — INT
- SLT_DATE — DATETIME
- R_CODE — NVARCHAR(30) — Foreign key → TB_Raw_Materials.R_CODE — NOT NULL
- WORKE_CODE — NVARCHAR(20) — Foreign key → TB_WorkerMst.WORKE_CODE — NOT NULL
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_UserMaster (사용자)
- USER_ID — NVARCHAR(30) — Primary key — NOT NULL
- SEQ — INT
- USER_Name — NVARCHAR(10)
- USER_PW — NVARCHAR(20)
- DeleteStatus — INT
- Email — NVARCHAR(20)
- Phone — NVARCHAR(20)
- DEPT_CD — NVARCHAR(10)
- GRADE_CD — NVARCHAR(10)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
- UPDATE_DT — DATETIME
- UPDATE_ID — NVARCHAR(20)
- AUTH_CD — NVARCHAR(20) — Foreign key → TB_AUTH.AUTH_CD — NOT NULL
TB_WorkerImage (작업자이미지)
- WORKE_CODE — NVARCHAR(20) — Foreign key → TB_WorkerMst.WORKE_CODE — NOT NULL
- WORKE_IMAGE — IMAGE
TB_WorkerMst (작업자)
- WORKE_CODE — NVARCHAR(20) — Primary key — NOT NULL
- WORKE_NAME — NVARCHAR(20)
- GRADE — NVARCHAR(20)
- ADDRESS — NVARCHAR(200)
- TEL_NUM — NVARCHAR(20)
- PHONE_NUM — NVARCHAR(20)
- DELETESTATUS — BIT
- DEPARTMENT — NVARCHAR(20)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)