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)