GAMI
sample
Tables (57)
IB_MAccountAuth (페이지 메뉴얼)
- ACCOUNT — NVARCHAR(20) — Primary key — NOT NULL
- PGM_ID — NVARCHAR(20) — Foreign key → IB_MProgramID.PGM_ID — NOT NULL
- USE_YN — NVARCHAR(20)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
IB_MProgramID (페이지 매뉴얼 명칭)
- PGM_ID — NVARCHAR(20) — Primary key — NOT NULL
- PGM_NAME — NVARCHAR(50)
- Description — NVARCHAR(50)
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_COMPRESSION_COMPLETE (압출완료)
- AC_BARCODE — NVARCHAR(20) — Primary key — NOT NULL
- ORDER_NO — NVARCHAR(20) — Foreign key → TB_Production_Plan.ORDER_NO — NOT NULL
- SEQ — INT
- PRDT_NO — NVARCHAR(20)
- OUT_QTY — INT
- PACKAGE_QTY — INT
- WORK_STATUS — INT
- END_DATE — DATETIME
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_COMPRESSION_MAPPING (압출매핑)
- P_CODE — NVARCHAR(20) — Foreign key → TB_Product.P_CODE — NOT NULL
- R_CODE — NVARCHAR(30) — Foreign key → TB_Raw_Materials.R_CODE — NOT NULL
- QTY — INT
- 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_DATE_TEMPERATURE (창고온도)
- SEQ — INT
- PLCID — NVARCHAR(20)
- TEMP — NVARCHAR(20)
- RH — NVARCHAR(20)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_DEVICE (단말기)
- DEV_CD — NVARCHAR(20) — Primary key — NOT NULL
- SEQ — INT
- DEV_NM — NVARCHAR(20)
- QTY — INT
- BUY_DT — DATETIME
- IN_QTY — INT
- DEV_QTY — INT
- REMARKS — NVARCHAR(20)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_DICE (다이스관리)
- DICE_CODE — NVARCHAR(20) — Primary key — NOT NULL
- DICE_NAME — NVARCHAR(50)
- MAKED_DATE — DATETIME
- MANUFACTURER — NVARCHAR(20)
- WHETHERTOUSE — NVARCHAR(20)
- DISCARDDATE — DATETIME
- IMGNAME — NVARCHAR(20)
- IMG — IMG
- ISDELETE — INT
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_DIVISION (부서코드관리)
- GROUP_CD — NVARCHAR(20) — Primary key — NOT NULL
- SEQ — INT
- GROUP_NM — NVARCHAR(20)
- USE_YN — NVARCHAR(20)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_FACILITIES (장비설비)
- FAC_CD — NVARCHAR(20) — Primary key — NOT NULL
- SEQ — INT
- FAC_NM — NVARCHAR(20)
- MAKING_DT — DATETIME
- MOTION_YN — INT
- FAC_DATE — DATETIME
- USER_NAME — NVARCHAR(20)
- FAC_TIME — DATETIME
- FAC_Remark — NVARCHAR(20)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_FIRST_IN_END (초중종물등록)
- SEQ — INT
- ORDER_NO — NVARCHAR(20)
- CODE_ID — NVARCHAR(20)
- PTDT_ID — NVARCHAR(20)
- RESULT1 — NVARCHAR(200)
- RESULT2 — NVARCHAR(200)
- RESULT3 — NVARCHAR(200)
- RESULT4 — NVARCHAR(200)
- RESULT5 — NVARCHAR(200)
- CHECK_TIME — DATETIME
- CHECK_DATE — DATETIME
- CHECK_USER — NVARCHAR(20)
- REMARKS — NVARCHAR(200)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_FIRST_IN_END_SUB (초중종물검사기준)
- SEQ — INT
- CODE_ID — NVARCHAR(20)
- PTDT_ID — NVARCHAR(20)
- EXAMINATION1 — NVARCHAR(200)
- EXAMINATION2 — NVARCHAR(200)
- EXAMINATION3 — NVARCHAR(200)
- EXAMINATION4 — NVARCHAR(200)
- EXAMINATION5 — NVARCHAR(200)
- EXAMINATION6 — NVARCHAR(200)
- REMARKS — NVARCHAR(200)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_ITEM_PRODUCE_COMPLETED (프레스완료)
- ORDER_NO — NVARCHAR(20) — Foreign key → TB_Production_Plan.ORDER_NO — NOT NULL
- SEQ — INT
- PRDT_NO — NVARCHAR(20)
- PLS_BARCODE — NVARCHAR(20)
- OUT_QTY — INT
- PACKAGE_QTY — INT
- WORK_STATUS — INT
- END_DATE — DATETIME
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_ITEM_PRODUCE_MAPPING (프레스매핑)
- P_CODE — NVARCHAR(20) — Foreign key → TB_Product.P_CODE — NOT NULL
- R_CODE — NVARCHAR(30) — Foreign key → TB_Raw_Materials.R_CODE — NOT NULL
- QTY — INT
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_LL_IN_BARCODE (롤러투입제품)
- BARCODE — NVARCHAR(20) — Primary key — NOT NULL
- ORDER_NO — NVARCHAR(20) — Foreign key → TB_Production_Plan.ORDER_NO — NOT NULL
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_LOW_TEMPERATURE_WAREHOUSE_IN (저온창고입고)
- PRDT_NO — NVARCHAR(20) — Primary key — NOT NULL
- BARCODE_INFO — NVARCHAR(20) — Primary key — NOT NULL
- SEQ — INT
- POSITION — NVARCHAR(20)
- IN_QTY — INT
- IN_DATE — DATETIME
- IN_STATUS — INT
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_LOW_TEMPERATURE_WAREHOUSE_OUT (저온창고출고)
- PRDT_NO — NVARCHAR(20) — Primary key — NOT NULL
- BARCDOE_INFO — NVARCHAR(20) — Primary key — NOT NULL
- SEQ — INT
- POSITION — NVARCHAR(20)
- OUT_QTY — INT
- WORK_STATUS — INT
- OUT_DATE — DATETIME
- OUT_WORKC — NVARCHAR(20)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_LocalizingMst (관리자메뉴다국어)
- KOR_NM — NVARCHAR(20)
- CHN_NM — NVARCHAR(20)
- ENG_NM — NVARCHAR(20)
TB_MALFUNCTION (비가동등록)
- SEQ — INT
- CODE_ID — NVARCHAR(20)
- FAC_CD — NVARCHAR(20)
- MAL_CD — NVARCHAR(20)
- STOP_TIME — INT
- REMARKS — NVARCHAR(200)
- CHECK_USER — NVARCHAR(20)
- CHECK_TIME — DATETIME
- CHECK_DATE — DATETIME
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_MAPPING_RAW_PROD (제품수량매핑)
- PROD_CD — NVARCHAR(20) — Primary key — NOT NULL
- P_CODE — NVARCHAR(20) — Foreign key → TB_Product.P_CODE — NOT NULL
- PRDT_QTY — INT
- PROD_QTY — INT
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_MSDS (MSDS이미지)
- SEQ — INT — Primary key — NOT NULL
- R_CODE — NVARCHAR(30) — Foreign key → TB_Raw_Materials.R_CODE — NOT NULL
- ACCOUNTINGDATE — DATETIME
- FILENAME — NVARCHAR(20)
- IMG — IMG
- ISDELETE — INT
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_POOR_DISUSE (불량페기)
- DISUSEBARCODE — NVARCHAR(20) — Primary key — NOT NULL
- POORBARCODE — NVARCHAR(20) — Foreign key → TB_POOR_LIST.POORBARCODE — NOT NULL
- DISUSEDATE — DATETIME
- DISUSEQTY — INT
- ISDELETE — INT
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_POOR_IN (불량등록기존)
- SEQ — INT — Primary key — NOT NULL
- P_CODE — NVARCHAR(20) — Foreign key → TB_Product.P_CODE — NOT NULL
- POORBARCODE — NVARCHAR(20) — Foreign key → TB_POOR_LIST.POORBARCODE — NOT NULL
- IN_QTY — INT
- POORTEMP1 — NVARCHAR(200)
- POORTEMP2 — NVARCHAR(200)
- POORTEMP3 — NVARCHAR(200)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_POOR_LIST (불량등록)
- POORBARCODE — NVARCHAR(20) — Primary key — NOT NULL
- POORITEMCODE — NVARCHAR(20)
- POORDATE — DATETIME
- LOC — NVARCHAR(20)
- QTY — INT
- POORCODE — NVARCHAR(20)
- NOTE1 — NVARCHAR(200)
- NOTE2 — NVARCHAR(200)
- NOTE3 — NVARCHAR(200)
- ISDELETE — INT
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_POOR_REUSE (불량재사용)
- REUSEBARCODE — NVARCHAR(20) — Primary key — NOT NULL
- POORBARCODE — NVARCHAR(20)
- REUSEDATE — DATETIME
- REUSEQTY — INT
- POSITION — NVARCHAR(20)
- ISDELETE — INT
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_Packing (포장)
- 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_Packing_Detail (포장상세)
- P_BARCODE — NVARCHAR(30) — Primary key — NOT NULL
- PKG_CODE (Key) — NVARCHAR(30) — Foreign key → TB_Packing.PKG_CODE — NOT NULL
- QTY — INT
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_ProcMstConfig (포트관리)
- proc_cd — NVARCHAR(20) — Primary key — NOT NULL
- config_gbn — NVARCHAR(20) — Primary key — NOT NULL
- com_port — NVARCHAR(20)
- BaudRate — INT
- DataBits — INT
- PortNumber — NT
- IP — NVARCHAR(20)
- use_yn — NVARCHAR(20)
- 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_Sub (제품배합내역)
- P_CODE — NVARCHAR(20) — Foreign key → TB_Product.P_CODE — NOT NULL
- R_CODE — NVARCHAR(30) — Foreign key → TB_Raw_Materials.R_CODE — NOT NULL
- QTY — INT
- SCOPE — INT
- SEQ — INT
- NUM — INT
- ISDELETE — INT
- CREATE_DT — DATETIME
- UPDATE_ID — NVARCHAR(20)
TB_Product_Warehouse (제품재고)
- SEQ (Key) — INT — Primary key — NOT NULL
- P_CODE — NVARCHAR(20) — Foreign key → TB_Product.P_CODE — NOT NULL
- PALLET — NVARCHAR(20)
- QTY — INT
- P_STATUS — INT
TB_Product_Warehouse_ORD (출하계획)
- ORDER_OUT — NVARCHAR(20) — Primary key — NOT NULL
- OUT_DATE — DATETIME
- ORDER_TYPE — NVARCHAR(20)
- SEQ — INT
- CLINET_ID — NVARCHAR(20)
- ORD_QTY — INT
- OUT_QTY — INT
- BARCODE — NVARCHAR(20)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_Product_Warehouse_Sub (제품재고구분)
- SEQ — INT
- PRDT_ID — NVARCHAR(20)
- PALLET — NVARCHAR(20)
- PALLET_SUB — NVARCHAR(20)
- CREATE_DT — DATETIME
- CREATE_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_ROLL_COMPLETED (롤러완료)
- ORDER_NO — NVARCHAR(20) — Foreign key → TB_Production_Plan.ORDER_NO — NOT NULL
- SEQ — INT
- LL_BARCODE — NVARCHAR(20)
- BATCH — INT
- QTY — INT
- P_CODE — NVARCHAR(20) — Foreign key → TB_Product.P_CODE — NOT NULL
- OUT_QTY — INT
- IN_QTY — INT
- L_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_Image (자재이미지)
- R_CODE — NVARCHAR(30) — Foreign key → TB_Raw_Materials.R_CODE — NOT NULL
- FILENAME — NVARCHAR(20)
- IMAGE — IMG
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_Raw_Materials_NEW (뉴자재)
- R_CODE — NVARCHAR(30) — Foreign key → TB_Raw_Materials.R_CODE — NOT NULL
- P_CODE — NVARCHAR(20) — Foreign key → TB_Product.P_CODE — NOT NULL
- SEQ — INT
- N_BARCODE — NVARCHAR(20)
- S_BARCODE — NVARCHAR(20)
- QTY — INT
- CLIENT_CODE — NVARCHAR(20)
- N_STATUS — INT
- TIME_LIMIT — INT
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_Raw_Materials_ORD (자재발주)
- ORDER_IN — NVARCHAR(20) — Primary key — NOT NULL
- IN_DATE — DATETIME
- ORD_TYPE — INT
- SEQ — INT
- R_CODE — NVARCHAR(20)
- R_QTY — INT
- BUY_ID — NVARCHAR(20)
- IN_QTY — INT
- BARCODE — NVARCHAR(20)
- CREATE_DT — DATETIME
- CREATE_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_Raw_Materials_Stock (자재재고)
- 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)
- 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_Storage (자재재고상세내역)
- 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_STTEMPERATURE (창고온도실시간)
- CHECK_DT — NVARCHAR(20)
- PLCID — NVARCHAR(20)
- TEMP — NVARCHAR(20)
- RH — NVARCHAR(20)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_SUBDIVISION (자재상세내역)
- P_CODE — NVARCHAR(20) — Foreign key → TB_Product.P_CODE — NOT NULL
- R_CODE — NVARCHAR(30) — Foreign key → TB_Raw_Materials.R_CODE — NOT NULL
- SEQ — INT
- WEIGHT — INT
- SCOPE — INT
- USE_YN — INT
- 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_User_Login_Log (사용자등록로그)
- SEQ — INT
- UserId — NVARCHAR(20)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_User_Page_Log (사용자페이지로그)
- SEQ — INT
- UserId — NVARCHAR(20)
- PageName — NVARCHAR(20)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_WAREHOUSEPLC (PLC번호)
- WAREHOUSENAME — NVARCHAR(20)
- PLCID — NVARCHAR(20)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_WOODENPATTERN (목형관리)
- SEQ — INT — Primary key — NOT NULL
- WOODENPATTERN_CD — NVARCHAR(20) — Primary key — NOT NULL
- WOODENPATTERN_NM — NVARCHAR(20)
- MANUFACTURER — NVARCHAR(20)
- MAKING_DT — DATETIME
- USE_YN — INT
- DISCARDDATE — DATETIME
- ISDELETE — INT
- IMGNAME — NVARCHAR(20)
- IMG — IMG
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_WORKC (고객)
- SEQ — INT — Primary key — NOT NULL
- WORKC_CD — NVARCHAR(20)
- WORKC_NM — NVARCHAR(20)
- ADDRESS — NVARCHAR(200)
- TEL — NVARCHAR(20)
- FAX — NVARCHAR(20)
- BEARER_NAME — NVARCHAR(20)
- BEARER_TEL — NVARCHAR(20)
- BUSINESSLICENSE — NVARCHAR(20)
- USE_YN — INT
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_Weighing_Deploy (배합상세내역)
- WS_BARCODE — NVARCHAR(20)
- R_CODE — NVARCHAR(20)
- QTY — INT
- W_BARCODE — NVARCHAR(20)
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
TB_Weighing_Storage (배합상태)
- ORD_ID — NVARCHAR(20)
- WS_BARCODE — NVARCHAR(20)
- BATCH — INT
- LOT_NO — NVARCHAR(20)
- W_STATUS — INT
- CREATE_DT — DATETIME
- CREATE_ID — NVARCHAR(20)
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)