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