NiceMes
Tables (32)
ACCONTINFO
- ACT_NO — bigint — Primary key — NOT NULL
- CUST_NO — int
- ACT_TYPE — int
- ACT_PRICE — decimal(18,0)
- ACT_VAT — decimal(18,0)
- ACT_BILLTYPE — int
- ACT_DT — datetime
- ACT_USE — smallint
- UPDATE_DT — datetime
- UPDATE_USERNO — int
BUYDINFO
- BUYD_NO — int — Primary key — NOT NULL
- BUY_NO — int
- PDT_NO — int — Foreign key → PRODUCTINOF.PDT_NO
- BUYD_SPEC — nvarchar(50)
- BUYD_COST — decimal(18,0)
- BUYD_QTY — int
- BUYD_PRICE — decimal(18,0)
- BUYD_VAT — decimal(18,0)
- BUYD_USE — smallint
- BUYD_NOTE — nvarchar(200)
- UPDATE_DT — datetime
- UPDATE_USERNO — int
BUYINFO
- BUY_NO — int — Primary key — NOT NULL
- CUST_NO — int — Foreign key → CUSTOMERINFO.CUST_NO — NOT NULL
- BUY_DT — datetime
- BUY_NOTE — nvarchar(200)
COMDINFO
- COMD_NO — int — Primary key — NOT NULL
- COM_NO — int — Foreign key → COMINFO.COM_NO
- COMD_NAME — nvarchar(50)
- COMD_OPT1 — int
- COMD_OPT2 — int
- COMD_OPT3 — nvarchar(50)
- COMD_OPT4 — nvarchar(50)
- COMD_USE — smallint
- COMD_NOTE — nvarchar(200)
COMINFO
- COM_NO — int — Primary key — NOT NULL
- COM_NAME — nvarchar(50)
- COM_USE — smallint
CUSTOMERINFO
- CUST_NO — int — Primary key — NOT NULL
- CUST_NAME — nvarchar(50)
- CUST_GB — int
- CUST_ID — nvarchar(50)
- USER_NO — int
- CUST_LICENSEE — nvarchar(50)
- CUST_BOSSNAME — nvarchar(50)
- CUST_TYPE — nvarchar(50)
- CUST_NATURE — nvarchar(50)
- CUST_ADDR — nvarchar(200)
- CUST_ZIPNO — nvarchar(50)
- CUST_TELLNO — nvarchar(50)
- CUST_FAXNO — nvarchar(50)
- CUST_EMAIL — nvarchar(100)
- CUST_UNITCOSTGB — int
- CUST_COSTRATE — smallint
- CUST_ONLINEID — nvarchar(50)
- CUST_ONLINEPWD — nvarchar(50)
- CUST_NOTE — nvarchar(200)
- UPDATE_DT — datetime
- UPDATE_USERNO — int
- CUST_ONLINEORDERGB — smallint
CUSTOMERMTRCOSTINFO
- MTR_NO — int — Foreign key → MATERIALINFO.MTR_NO — NOT NULL
- CUST_NO — int — Foreign key → CUSTOMERINFO.CUST_NO — NOT NULL
- CUSTMC_COST — decimal(18,0)
- CUSTMC_MINCOST — decimal(18,0)
- CUSTMC_NOTE — nvarchar(200)
- UPDATE_DT — datetime
- UPDATE_USERNO — int
DEFECTIVEINFO
- DFT_NO — bigint — Primary key — NOT NULL
- WORKPRO_NO — bigint — Foreign key → ORDERWORKPROCESSINFO.WORKPRO_NO
- DFT_QTY — int
- DFT_TYPE — smallint
- DFT_DT — datetime
- DFT_NOTE — nvarchar(200)
- UPDATE_DT — datetime
- UPDATE_USERNO — int
- Key — Foreign key → ORDERWORKPROCESSINFO.Key — NOT NULL
EQUIPMENTINFO
- EQM_NO — int — Primary key — NOT NULL
- EQM_NAME — nvarchar(50)
- PRO_NO — int — Foreign key → PROCESSINFO.PRO_NO
- USER_NO — int — Foreign key → USERINFO.USER_NO
- EQM_NOTE — nvarchar(200)
- EQM_USE — smallint
- UPDATE_DT — datetime
- UPDATE_USERNO — int
MATERIALINFO
- MTR_NO — int — Primary key — NOT NULL
- MTR_NAME — nvarchar(50)
- MTR_TYPE — int
- MTR_STANDARDCOST — decimal(18,0)
- MTR_MANUFACTURECOST — decimal(18,0)
- MTR_TOLERANCE — decimal(18,2)
- MTR_NOTE — nvarchar(200)
- MTR_USE — smallint
- UPDATE_DT — datetime
- UPDATE_USERNO — int
MENUGROUPINFO
- MENUG_NO — int — Primary key — NOT NULL
- MENUG_ID — int
- MENU_NO — int — Foreign key → MENUINFO.MENU_NO — NOT NULL
MENUINFO
- MENU_NO — int — Primary key — NOT NULL
- MENU_NAME — nvarchar(50)
- MENU_CAPTION — nvarchar(100)
- MENU_USE — nvarchar(50)
- MENU_NOTE — nvarchar(200)
- MENU_TOPID — nvarchar(50)
- MENU_ID — nvarchar(50)
NOTICECHECKINFO
- NTC_NO — int — Primary key — NOT NULL
- NT_NO — int — Foreign key → NOTICEINFO.NT_NO
- USER_NO — int
- NTC_DT — datetime
NOTICEINFO
- NT_NO — int — Primary key — NOT NULL
- NT_DT — datetime
- USER_ID — int
- NT_CONTENT — nvarchar(1000)
- NT_IMPORTANT — smallint
- NT_USE — smallint
ORDERDINFO
- ORDERD_NO — bigint — Primary key — NOT NULL
- ORDER_NO — bigint — Foreign key → ORDERINFO.ORDER_NO — NOT NULL
- MTR_NO — int — Foreign key → MATERIALINFO.MTR_NO
- ORDERD_HEIGHT — decimal(18,2)
- ORDERD_WIDTH — decimal(18,2)
- ORDERD_LENGTH — decimal(18,2)
- ORDERD_TOLERANCE — decimal(18,2)
- ORDERD_QTY — int
- ORDERD_COST — decimal(18,0)
- ORDERD_TOTALPRICE — decimal(18,0)
- ORDERD_DRAWINGNUM — nvarchar(100)
- ORDERD_NOTE — nvarchar(200)
- UPDATE_DT — datetime
- UPDATE_USERNO — int
ORDERINFO
- ORDER_NO — bigint — Primary key — NOT NULL
- ORDER_NUM — nvarchar(50)
- CUST_NO — int
- ORDER_DT — datetime
- ORDER_TOLLMFT — smallint
- ORDER_PERIODDT — datetime
- ORDER_MFTCOSTGB — int
- ORDER_USE — smallint
- ORDER_NOTE — nvarchar(200)
- UPDATE_DT — datetime
- UPDATE_USERNO — int
ORDERWORKINFO
- WORK_NO — bigint — Primary key — NOT NULL
- ORDERD_NO — bigint — Foreign key → ORDERDINFO.ORDERD_NO
- WORK_DT — datetime
ORDERWORKPROCESSINFO
- WORKPRO_NO — bigint — Primary key — NOT NULL
- Key — Primary key — NOT NULL
- WORKPRO_WORKFINISH — smallint
- WORKPRO_ORDERNO — int — NOT NULL
- WORK_NO — bigint — Foreign key → ORDERWORKINFO.WORK_NO — NOT NULL
- PRO_NO — int — Foreign key → PROCESSINFO.PRO_NO — NOT NULL
- WORKPRO_WORKFINISHDT — datetime
- Field
ORDERWORKRESULTINFO
- OWR_NO — bigint — Primary key — NOT NULL
- WORKPRO_NO — bigint — Foreign key → ORDERWORKPROCESSINFO.WORKPRO_NO
- OWR_QTY — int
- OWR_TYPE — smallint
- OWR_DT — datetime
- OWR_NOTE — nvarchar(200)
- UPDATE_DT — datetime
- UPDATE_USERNO — int
- Key — Foreign key → ORDERWORKPROCESSINFO.Key — NOT NULL
PRIVILEGEINFO
- PRIVIL_NO — int — Primary key — NOT NULL
- USER_NO — int — Foreign key → USERINFO.USER_NO
- MENU_NO — int — Foreign key → MENUINFO.MENU_NO
- UPDATE_DT — datetime
- UPDATE_USERNO — int
PROCESSINFO
- PRO_NO — int — Primary key — NOT NULL
- PRO_NAME — nvarchar(50)
- PRO_ORDERNO — int
- PRO_NOTE — nvarchar(200)
- PRO_USE — smallint
PRODUCTINOF
- PDT_NO — int — Primary key — NOT NULL
- PDT_NAME — nvarchar(50)
- PDT_PRICE — decimal(18,0)
- PDT_NOTE — nvarchar(200)
- UPDATE_DT — datetime
- UPDATE_USERNO — int
RELEASEINFO
- RLS_NO — bigint — Primary key — NOT NULL
- WORKPRO_NO — bigint — Foreign key → ORDERWORKPROCESSINFO.WORKPRO_NO
- RLS_QTY — int
- RLS_DT — datetime
- RLS_SUPPLY — smallint
- RLS_NOTE — nvarchar(200)
- UPDATE_DT — datetime
- UPDATE_USERNO — int
- Key — Foreign key → ORDERWORKPROCESSINFO.Key — NOT NULL
SALESORDERDINFO
- SODD_NO — bigint — Primary key — NOT NULL
- SOD_NO — bigint
- MTR_NO — int
- SODD_HEIGHT — decimal(18,2)
- SODD_WIDTH — decimal(18,2)
- SODD_LENGTH — decimal(18,2)
- SODD_TOLERANCE — decimal(18,2)
- SODD__QTY — int
- SODD_DRAWINGNUM — nvarchar(100)
- SODD_NOTE — nvarchar(200)
- UPDATE_DT — datetime
- UPDATE_USERNO — int
SALESORDERINFO
- SOD_NO — bigint — Primary key — NOT NULL
- CUST_NO — int
- SOD_DT — datetime
- SOD_TOLLMFT — smallint
- SOD_NOTE — nvarchar(200)
- UPDATE_DT — datetime
- UPDATE_USERNO — int
STOCKCHECKINFO
- STKC_NO — bigint — Primary key — NOT NULL
- STKC_DT — datetime
- STKC_REALLYQTY — int
- STKC_NOWQTY — int
- GOOD_CODE — nvarchar(50)
- STKC_NOTE — nvarchar(200)
- UPDATE_DT — datetime
- UPDATE_USERNO — int
STOCKINFO
- STK_NO — bigint — Primary key — NOT NULL
- STK_DT — datetime
- STK_QTY — int
- STK_GB — smallint
- GOOD_CODE — nvarchar(50)
- STK_NOTE — nvarchar(200)
- UPDATE_DT — datetime
- UPDATE_USERNO — int
TAXINVOICEDINFO
- TID_NO — bigint — Primary key — NOT NULL
- TI_NO — bigint — Foreign key → TAXINVOICEINFO.TI_NO
TAXINVOICEINFO
- TI_NO — bigint — Primary key — NOT NULL
- CUST_NO — nvarchar(50)
- TI_SALESTYPE — smallint
- TI_CLAIMTYPE — smallint
- TI_BILLTYPE — smallint
- TI_DT — datetime
- TI_NOTE — nvarchar(200)
- UPDATE_DT — datetime
- UPDATE_USERNO — int
USERINFO
- USER_NO — int — Primary key — NOT NULL
- USER_ID — nvarchar(50)
- USER_PWD — nvarchar(50)
- 사용자명 (USER_NAME) — nvarchar(50)
- USER_CELLPHONE — nvarchar(50)
- USER_USE — smallint
- UPDATE_DT — datetime
- UPDATE_USERNO — int
USERINFO2
- USER_ID — int — Primary key — NOT NULL — 111
- USER_USERID — nvarchar(20)
- USER_PWD — nvarchar(64)
- USER_NAME — nvarchar(20)
- USER_EMAIL — nvarchar(100)
- USER_CELLPHONE — nvarchar(30)
- USER_USE — smallint
Untitled
- code (코드) — int — Primary key — NOT NULL
- Field