제이엠_mesDB
테이블 (36)
AREA
- AREAID — varchar(50) — 기본 키 — NOT NULL
- SHOPID — varchar(50) — NOT NULL
- AREANAME — varchar(100) — NOT NULL
- AREADESC — varchar(200)
- AREATYPE — varchar(50) — NOT NULL
- AREAIUSE — char(1) — NOT NULL
- IGNORE_DUP_KEY — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
AUTHORITY
- AUTHID — varchar(50) — NOT NULL
- AUTHNAME — varchar(100) — NOT NULL
- AUTHDESC — varchar(200)
AUTHORITYMENU
- AUTHID — varchar(50) — 기본 키 — NOT NULL
- MENUID — varchar(50) — 기본 키 — NOT NULL
- ATMNINQY — char(1) — NOT NULL
- AUTHIUSE — varchar(1)
- IGNORE_DUP_KEY — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
CHART_TEST_DB
- NO — int — 기본 키 — NOT NULL
- EVENTTIME — varchar(50)
- D10 — varchar(50)
- D20 — varchar(50)
- D30 — varchar(50)
- D40 — varchar(50)
- D50 — varchar(50)
- D60 — varchar(50)
- D70 — varchar(50)
- D300 — varchar(50)
- D310 — varchar(50)
- D350 — varchar(50)
- D360 — varchar(50)
- D400 — varchar(50)
- IGNORE_DUP_KEY — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
COLUMNCODE
- COLMID — varchar(50) — NOT NULL
- COLMCODE — varchar(50) — NOT NULL
- CMCDNAME — varchar(200) — NOT NULL
- CMCDDESC — varchar(200)
- CMCDIUSE — char(1) — NOT NULL
DAILY_WORK
- WORK_DATE — varchar(10) — 기본 키 — NOT NULL
- WORK_NAME — varchar(10) — 기본 키 — NOT NULL
- FACTORY — varchar(10) — 기본 키 — NOT NULL
- WORK_MEMO — text
- MODIFY_DATE — varchar(10)
- MODIFY_USER — varchar(10)
- USE_USER — varchar(10)
- IGNORE_DUP_KEY — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
EQUIPMENT
- EQPTID — varchar(50) — 기본 키 — NOT NULL
- EQGRID — varchar(50) — NOT NULL
- EQPTNAME — varchar(100) — NOT NULL
- EQPTDESC — varchar(200)
- EQPTTYPE — varchar(50) — NOT NULL
- EQPTIUSE — char(1) — NOT NULL
- AREAID — varchar(50) — NOT NULL
- UDF_FACTORY — varchar(50)
- PROCID — varchar(50)
- PLANT_GUBUN — varchar(10)
- IGNORE_DUP_KEY — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
LOT
- NO — int — NOT NULL
- ORDER_NO — varchar(50)
- LOTID — varchar(50)
- PROCID — varchar(50)
- PROD_ID — varchar(50)
- PROD_NAME — varchar(50)
- PROD_STANDARD — varchar(50)
- PROD_COLOR — varchar(50)
- CUSTOMER — varchar(50)
- CUSTOMER_ID — varchar(50)
- DELIVERY_DATE — varchar(50)
- WIPQTY — int
- LOTTERM — varchar(50)
- LOTDTTM_CR — datetime
- WIPSTAT — varchar(50)
- ELAPSED_TIME — smallint
- PLANDTTM_ST — varchar(50)
- PLANDTTM_ED — varchar(50)
- UDF_ADDR1 — varchar(50)
- UDF_ADDR2 — varchar(50)
- UDF_ADDR3 — varchar(50)
- UDF_ADDR4 — varchar(50)
- UDF_MARKING — varchar(50)
- MTRLID — nvarchar(50)
- MTRL_QTY — nchar(10)
MATERIAL
- MTGRID — varchar(50)
- MTRLID — varchar(50)
- MTRLNAME — varchar(50)
- MTRLDESC — varchar(50)
- MTGRTYPE — varchar(50)
- MTRLIUSE — varchar(50)
- MTRLUNIT — varchar(50)
- UDF_QTY — int
- UDF_MAKER — varchar(50)
- UDF_MODEL — varchar(50)
- UDF_WIDTH — int
- UDF_ETC — varchar(50)
- UDF_PRODNO — varchar(50)
- UDF_MTRLSTATUS — varchar(50)
- UDF_CR_DATE — date
- UDF_CR_QTY — int
- UDF_CR_WEIGHT — int
- UDF_PROD_DATE — varchar(50)
- UDF_PROD_ROW — varchar(50)
- PO_NUM — varchar(50)
- UDF_DATE — datetime
- UDT_INCOME_YN — varchar(10)
- LOTID — varchar(50)
- UDF_MARKING — varchar(50)
- MTRL_QTY — varchar(50)
MATERIALGROUP
- MTGRID — varchar(50) — 기본 키 — NOT NULL
- MTGRNAME — varchar(100) — NOT NULL
- MTGRDESC — varchar(200)
- MTGRIUSE — char(1) — NOT NULL
- AREAID — varchar(50)
- UDF_LOTLINKYN — char(1)
- UDF_IDAUTOALLOC — char(1)
- UDF_WAREHOUSING — char(1)
- UDF_ELECTROLYTE — char(1)
- UDF_UNIT — varchar(10)
- MTGRTYPE — varchar(10)
- UDF_PROCID — varchar(10)
- UDF_TOOLID — varchar(10)
- UDF_EQPTID — varchar(10)
- UDF_EQPTLINKYN — char(1)
- UDF_CHNG_STD — varchar(10)
- UDF_CHNG_TRM — varchar(10)
- UDF_CHNG_UCL — varchar(10)
- UDF_SAFEINVT — varchar(10)
- UDF_PITHICK — varchar(10)
- IGNORE_DUP_KEY — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
MATERIALHISTORY
- CALDATE — date
- MTGRID — varchar(50)
- MTRLID — varchar(50)
- ACTID — varchar(50)
- TOOLSEQ — int
- UDF_QTY — int
- UDF_TO_PROC — varchar(50)
- UDF_TO_EQPT — varchar(50)
- UDF_USERID — varchar(50)
- UDF_WORKTIME — varchar(50)
- PROC_LOTID — varchar(50)
- UDF_WEIGHT — varchar(50)
- UDF_CR_DATE — datetime
MEMBER
- MEMBER — varchar(50)
- D_T — varchar(50)
- Poistion — varchar(50)
- AGE — varchar(50)
- Gender — varchar(50)
MENU
- MENUID — varchar(50) — 기본 키 — NOT NULL
- MENUNAME — varchar(100) — NOT NULL
- MENUDESC — varchar(200)
- MENUID_PR — varchar(50)
- FORMID — varchar(50)
- UDF_TRXCHK — char(1)
- MENUIUSE — char(1)
- UDF_CF_CHK — char(1)
- UDF_FCCL_CHK — char(1)
- MENULEVEL — float
- MENUSEQ — float
- MENUICON — char(10)
- IGNORE_DUP_KEY — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
MESUSER
- USERNAME — varchar(max)
- USERDESC — varchar(max)
- USERPHON — varchar(max)
- MODIFY_YN — varchar(50)
- USERID — varchar(50)
- USERPSWD — varchar(50)
- USERIUSE — varchar(50)
MTGR_TEST
- MTGRID — varchar(50) — 기본 키 — NOT NULL
- MTGRNAME — varchar(50)
- MTGRDESC — varchar(50)
- MTGRIUSE — varchar(50)
- AREAID — varchar(50)
- LOTLINKYN — varchar(50)
- IDAUTOALLOC — varchar(50)
- IGNORE_DUP_KEY — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
ORDER_TEST
- ORDER_NO — varchar(50)
- PROD_ID — varchar(50)
- PROD_NAME — varchar(50)
- WIPQTY — varchar(50)
- CUSTOMER — varchar(50)
- CUSTOMER_ID — varchar(50)
PROCESS
- PROCID — varchar(50) — 기본 키 — NOT NULL
- PCGRID — varchar(50)
- PROCNAME — varchar(100)
- PROCDESC — varchar(200)
- PROCTYPE — varchar(50)
- PROCIUSE — varchar(50)
- AREAID — varchar(50)
- UDF_SEQ — int
- IGNORE_DUP_KEY — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
PROCESSGROUP
- PCGRID — varchar(50) — 기본 키 — NOT NULL
- PCGRNAME — varchar(100) — NOT NULL
- PCGRDESC — varchar(200)
- PCGRIUSE — char(1) — NOT NULL
- IGNORE_DUP_KEY — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
PROCESSTYPE
- PROCTYPE — varchar(50) — 기본 키 — NOT NULL
- PCTYNAME — varchar(100) — NOT NULL
- PCTYDESC — varchar(200)
- PCTYIUSE — char(1) — NOT NULL
- IGNORE_DUP_KEY — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
Product_DATE
- 제품명 — varchar(50)
- 제품코드 — varchar(50)
- 제품용량 — varchar(50)
- 제품위치 — varchar(50)
- 제품사용여부 — varchar(50)
S_PRODUCT
- PRODID — varchar(50) — 기본 키 — NOT NULL
- PRODNAME — varchar(100) — NOT NULL
- PRODDESC — varchar(200)
- P_STANDARD — varchar(100)
- P_COLOR — varchar(100)
- PRODIUSE — char(1) — NOT NULL
- UDF_GOODTYPE — varchar(50) — NOT NULL
- DATE_TIME — varchar(50)
- IGNORE_DUP_KEY — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TAG_TEST
- TAG_ID — varchar(50)
- TAG_NAME — varchar(50)
- TAG_TYPE — varchar(50)
- TAG_USE — varchar(50)
- TAG_GROUP — int
UDT_CODEGROUP
- CODEGRID — varchar(50) — 기본 키 — NOT NULL
- CODETYPE — varchar(50) — 기본 키 — NOT NULL
- CODEGRNAME — varchar(100) — NOT NULL
- CODEGRDESC — varchar(200)
- CODEGRIUSE — char(1) — NOT NULL
- PROCID — varchar(50)
- IGNORE_DUP_KEY — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
UDT_CUSTOMER
- AREAID — varchar(20) — 기본 키 — NOT NULL
- CUSTCODE — varchar(20) — 기본 키 — NOT NULL
- CUSTNAME — varchar(50)
- REP_NAME — varchar(20)
- REGISTER_NO — varchar(20)
- ZIP_CODE — varchar(10)
- ADDRESS — varchar(50)
- USE_FLAG — varchar(1)
- SITE_GUBUN — varchar(10)
- IGNORE_DUP_KEY — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
UDT_INCOMETEST_ITEM
- MTGRID — nvarchar(50)
- ITEMCODE — nvarchar(50)
- ITEMDESC — nvarchar(50)
- ITEMCODEIUSE — nvarchar(50)
- ITEMLSL — float
- ITEMUSL — float
- UNIT — nvarchar(50)
- DISPSEQ — float
- ITEMLCL — float
- ITEMUCL — float
- RESULT — varchar(50)
UDT_INCOMETEST_RESULT
- MTGRID — varchar(50)
- MTRLID — varchar(50)
- ITEMCODE — varchar(50)
- RESULT — varchar(50)
- UPDATED_DATE — varchar(50)
- UPDATED_BY — varchar(50)
UDT_MTGR_TEST
- MTGRID — varchar(50)
- CDATE — varchar(50)
- SEQ — int
UDT_ORDER_LIST
- NO — int — NOT NULL
- ORDER_NO — varchar(50)
- LOTID — varchar(50)
- PROD_ID — varchar(50)
- PROD_NAME — varchar(50)
- PROD_STANDARD — varchar(50)
- PROD_COLOR — varchar(50)
- CUSTOMER — varchar(50)
- CUSTOMER_ID — varchar(50)
- DELIVERY_DATE — varchar(50)
- WIPQTY — int
- UDF_USERID — varchar(50)
- ELAPSED_TIME — smallint
- PLANDTTM_ST — varchar(50)
- PLANDTTM_ED — varchar(50)
- WIPDTTM_ST — varchar(50)
- WIPDTTM_ED — varchar(50)
- LOTTERM — varchar(50)
- WIPDTTM_CR — datetime
- UDF_ADDR1 — varchar(50)
- UDF_ADDR2 — varchar(50)
- UDF_ADDR3 — varchar(50)
- UDF_SUB_OK — varchar(50)
UDT_ORDER_SUB_LIST
- NO — int — NOT NULL
- ORDER_NO — varchar(50)
- LOTID — varchar(50)
- PROD_ID — varchar(50)
- PROD_NAME — varchar(50)
- PROD_STANDARD — varchar(50)
- PROD_COLOR — varchar(50)
- CUSTOMER — varchar(50)
- CUSTOMER_ID — varchar(50)
- DELIVERY_DATE — varchar(50)
- WIPQTY — int
- UDF_USERID — varchar(50)
- ELAPSED_TIME — smallint
- PLANDTTM_ST — varchar(50)
- PLANDTTM_ED — varchar(50)
- WIPDTTM_ST — varchar(50)
- WIPDTTM_ED — varchar(50)
- LOTTERM — varchar(50)
- WIPDTTM_CR — datetime
- UDF_ADDR1 — varchar(50)
- UDF_ADDR2 — varchar(50)
- UDF_ADDR3 — varchar(50)
- UDF_MARKING — varchar(50)
UDT_SEQ
- GUBUN — varchar(50) — NOT NULL
- SEQ — int — NOT NULL
- CDATE — varchar(50)
UDT_WHOUTHISTORY
- NO — int — NOT NULL
- CALDATE — varchar(50)
- CASENO — varchar(50)
- CUSTCODE — varchar(50)
- SHIPLOTID — varchar(50)
- LOTID — varchar(50)
- PROD_ID — varchar(50)
- PROD_NAME — varchar(50)
- PROD_STANDARD — varchar(50)
- PROD_COLOR — varchar(50)
- WHOUTTIME — datetime
- ACTID — varchar(50)
- CUSTOMER — varchar(50)
- CUSTOMER_ID — varchar(50)
- WIPQTY — int
- ORDER_NO — varchar(50)
- UDF_ADDR1 — varchar(50)
- UDF_ADDR2 — varchar(50)
- UDF_ADDR3 — varchar(50)
- UDF_ADDR4 — varchar(50)
- CUSTNAME — varchar(50)
UDT_WHOUTHISTORY_CANCEL_HISTORY
- NO — int — NOT NULL
- CALDATE — varchar(50)
- CASENO — varchar(50)
- CUSTCODE — varchar(50)
- SHIPLOTID — varchar(50)
- LOTID — varchar(50)
- PROD_ID — varchar(50)
- PROD_NAME — varchar(50)
- PROD_STANDARD — varchar(50)
- PROD_COLOR — varchar(50)
- WHOUTTIME — varchar(50)
- ACTID — varchar(50)
- CUSTOMER — varchar(50)
- CUSTOMER_ID — varchar(50)
- WIPQTY — int
- ORDER_NO — varchar(50)
- UDF_ADDR1 — varchar(50)
- UDF_ADDR2 — varchar(50)
- UDF_ADDR3 — varchar(50)
- UDF_ADDR4 — varchar(50)
- CUSTNAME — varchar(50)
UDT_WH_WIP
- NO — int — NOT NULL
- CALDATE — varchar(50)
- CASENO — varchar(50)
- CUSTCODE — varchar(50)
- SHIPLOTID — varchar(50)
- LOTID — varchar(50)
- PROD_ID — varchar(50)
- PROD_NAME — varchar(50)
- PROD_STANDARD — varchar(50)
- PROD_COLOR — varchar(50)
- WHOUTTIME — datetime
- CUSTOMER — varchar(50)
- CUSTOMER_ID — varchar(50)
- WIPQTY — int
- ORDER_NO — varchar(50)
- UDF_ADDR1 — varchar(50)
- UDF_ADDR2 — varchar(50)
- UDF_ADDR3 — varchar(50)
- UDF_ADDR4 — varchar(50)
WIP
- ORDER_NO — varchar(50)
- LOTID — varchar(50)
- PROCID — varchar(50)
- PROD_ID — varchar(50)
- PROD_NAME — varchar(50)
- PROD_STANDARD — varchar(50)
- PROD_COLOR — varchar(50)
- CUSTOMER — varchar(50)
- CUSTOMER_ID — varchar(50)
- DELIVERY_DATE — varchar(50)
- WIPQTY — smallint
- WIPSTAT — varchar(50)
- WIPDTTM — varchar(50)
- NO — int — NOT NULL
- UDF_ADDR1 — varchar(50)
- UDF_ADDR2 — varchar(50)
- UDF_ADDR3 — varchar(50)
- UDF_ADDR4 — varchar(50)
- UDF_ADDR5 — varchar(50)
- WIPDTTM_CR — datetime
- ELAPSED_TIME — smallint
- PLANDTTM_ST — varchar(50)
- PLANDTTM_ED — varchar(50)
WIPHISTORY
- NO — int — NOT NULL
- ORDER_NO — varchar(50)
- LOTID — varchar(50)
- PROCID — varchar(50)
- PROD_ID — varchar(50)
- PROD_NAME — varchar(50)
- PROD_STANDARD — varchar(50)
- PROD_COLOR — varchar(50)
- CUSTOMER — varchar(50)
- CUSTOMER_ID — varchar(50)
- DELIVERY_DATE — varchar(50)
- WIPQTY — varchar(50)
- UDF_USERID — varchar(50)
- WIPDTTM_ST — varchar(50)
- WIPDTTM_ED — varchar(50)
- WIPDTTM_CR — varchar(50)
- ELAPSED_TIME — smallint
- PLANDTTM_ST — varchar(50)
- PLANDTTM_ED — varchar(50)
- UDF_ADDR1 — varchar(50)
- UDF_ADDR2 — varchar(50)
- UDF_ADDR3 — varchar(50)
- UDF_ADDR4 — varchar(50)
sysdiagrams
- diagram_id — int — 기본 키 — NOT NULL
- name — sysname — NOT NULL
- principal_id — int — NOT NULL
- version — int
- definition — varbinary(max)
- IGNORE_DUP_KEY — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
- IGNORE_DUP_KEY — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =