개인

테이블 (46)

ADJUSTMENT

  • ADJ_NUM — VARCHAR2(10) — 기본 키 — NOT NULL
  • ADJ_SORT — VARCHAR2(10)
  • DEPT_NAME — VARCHAR2(10)
  • EMP_NAME — VARCHAR2(10)
  • BUYER_NAME — VARCHAR2(10)

ADJUSTMENT_ITEM

  • RAW_CODE — VARCHAR2(10) — 외래 키 → RAW.RAW_CODE — NOT NULL
  • PROD_CODE — VARCHAR2(10) — 외래 키 → PRODUCT.PROD_CODE — NOT NULL
  • ADJ_NUM — VARCHAR2(10) — 외래 키 → ADJUSTMENT.ADJ_NUM — NOT NULL
  • ICODE_NAME — VARCHAR2(10)
  • PROD_NAME — VARCHAR2(50)
  • GCODE_INNAME — VARCHAR2(10)
  • UCODE_INNAME — VARCHAR2(10)
  • ADJI_MQTY — NUMBER
  • GCODE_OUTNAME — VARCHAR2(10)
  • UCODE_OUTNAME — VARCHAR2(10)
  • ADJi_QTY — NUMBER
  • ADJI_PRICE — NUMBER
  • ADJI_COST — NUMBER
  • WAR_CODE — VARCHAR2(10) — NOT NULL
  • PROJ_NAME — VARCHAR2(10)

AUTHORITY

  • AUTH_NUM — VARCHAR2(10) — 기본 키 — NOT NULL
  • AUTH_NAME — VARCHAR2(30)

BOM

  • BOM_CODE — VARCHAR2(10) — 기본 키 — NOT NULL
  • PROD_CODE — VARCHAR2(10) — 외래 키 → PRODUCT.PROD_CODE — NOT NULL
  • PROD_ACCOUNT — VARCHAR2(10)
  • PROD_NAME — VARCHAR2(50)
  • GCODE_NAME — VARCHAR2(10)
  • UCODE_NAME — VARCHAR2(10)

BOM_RAW

  • BOM_CODE — VARCHAR2(10) — 외래 키 → BOM.BOM_CODE — NOT NULL
  • RAW_CODE — VARCHAR2(10) — 외래 키 → RAW.RAW_CODE — NOT NULL
  • RAW_NAME — VARCHAR2(50)
  • ICODE_NAME — VARCHAR2(10)
  • GCODE_NAME — VARCHAR2(10)
  • BRAW_NETQTY — NUMBER
  • BRAW_REQUIREQTY — NUMBER
  • BRAW_LOSSRATE — NUMBER
  • BRAW-LEVEL — NUMBER
  • BRAW_REGNUM — NUMBER
  • RAW_ADQINV — NUMBER

BUYER

  • BUYER_CODE — VARCHAR2(10) — 기본 키 — NOT NULL
  • BUYER_NAME — VARCHAR2(50)
  • BUYER_REGNUMBER — NUMBER
  • BUYER_CEO — VARCHAR2(10)
  • BUYER_SORT — VARCHAR2(50)
  • BUYER_WORKTYPE — VARCHAR2(50)
  • BUYER_EVENT — VARCHAR2(50)
  • BUYER_ADD — VARCHAR2(50)
  • BUYER_TEL — NUMBER
  • BUYER_FAX — NUMBER
  • BUYER_PARTNER — VARCHAR2(10)
  • BUYER_DESK — VARCHAR2(50)
  • BUYER_START — DATE
  • BUYER_END — DATE
  • SHIP_CODE — VARCHAR2(10)
  • SHIP_NAME — VARCHAR2(10)
  • SHIP_ADD — VARCHAR2(10)
  • BUYER_RECEIVER — VARCHAR2(10)
  • EMP_LINE — NUMBER
  • EMP_MAIL — NUMBER

CODE

  • CODE_NUM — VARCHAR2(10) — 기본 키 — NOT NULL
  • CODE_CODE — VARCHAR2(10)
  • CODE_NAME — VARCHAR2(50)

DEPARTMENT

  • DEPT_CODE — VARCHAR2(10) — 기본 키 — NOT NULL
  • DEPT_NAME — VARCHAR2(20)

DIVISION

  • DIV_NUM — NUMBER — 기본 키 — NOT NULL
  • DIV_CODE — VARCHAR2(10) — 기본 키 — NOT NULL
  • DIV_NAME — VARCHAR2(30)
  • DIV_NUM2 — NUMBER — 외래 키 → DIVISION.DIV_NUM — NOT NULL
  • DIV_CODE2 — VARCHAR2(10) — 외래 키 → DIVISION.DIV_CODE — NOT NULL

EMPLOYEE

  • EMP_CODE — VARCHAR2(10) — 기본 키 — NOT NULL
  • DEP_CODE — VARCHAR2(10) — 외래 키 → DEPARTMENT.DEPT_CODE — NOT NULL
  • EMP_DATE — DATE
  • EMP_NAME — VARCHAR2(10)
  • EMP_REG1 — NUMBER
  • EMP_REG2 — NUMBER
  • EMP_ADD — VARCHAR2(50)
  • EMP_LINE — NUMBER
  • EMP_TEL — NUMBER
  • EMP_MAIL — VARCHAR2(50)
  • EMP_RANK — VARCHAR2(10)
  • EMP_FIRE — DATE
  • MEM_ID — VARCHAR2(50)
  • MEM_PASS — VARCHAR2(255)
  • EMP_USE — VARCHAR(255)

ESTIMATE

  • EST_CODE — VARCHAR2(10) — 기본 키 — NOT NULL
  • EST_DATE — DATE
  • BUYER_CODE — VARCHAR2(10)
  • BUYER_NAME — VARCHAR2(50)
  • BUYER_RECEIVER — VARCHAR2(10)
  • DEPT_NAME — VARCHAR2(50)
  • EMP_NAME — VARCHAR2(10)
  • EST_VAT — VARCHAR2(1)
  • EST_RESULT — VARCHAR2(1)
  • EST_FINISH — VARCHAR2(1)

ESTIMATE_PROD

  • EST_CODE — VARCHAR2(10) — 외래 키 → ESTIMATE.EST_CODE — NOT NULL
  • PROD_CODE — VARCHAR2(10) — 외래 키 → PRODUCT.PROD_CODE — NOT NULL
  • ICODE_NAME — VARCHAR2(10)
  • PROD_NAME — VARCHAR2(50)
  • GCODE_NAME — VARCHAR2(10)
  • UCODE_NAME — VARCHAR2(10)
  • EP_DATE — DATE
  • EP_QTY — NUMBER
  • EP_PROJ — VARCHAR2(50)
  • EP_SP — NUMBER
  • EP_VAT — NUMBER
  • EP_SCOST — NUMBER

INCOMING

  • INC_NUM — VARCHAR2(10) — 기본 키 — NOT NULL
  • INC_DATE — DATE — NOT NULL
  • BUYER_CODE — VARCHAR2(10) — NOT NULL
  • BUYER_NAME — VARCHAR2(50) — NOT NULL
  • DEPT_NAME — VARCHAR2(10) — NOT NULL
  • EMP_NAME — VARCHAR2(10) — NOT NULL
  • INC_VAT — VARCHAR2(1)
  • INC_RESULT — VARCHAR2(1)
  • INC_FINISH — VARCHAR2(1)

INCOMING_RAW

  • INC_NUM — VARCHAR2(10) — 외래 키 → INCOMING.INC_NUM — NOT NULL
  • RAW_CODE — VARCHAR2(10) — 외래 키 → RAW.RAW_CODE — NOT NULL
  • RAW_NAME — VARCHAR2(50)
  • GCODE_NAME — VARCHAR2(10)
  • UCODE_NAME — VARCHAR2(10)
  • IR_DATE — DATE
  • IR_QTY — NUMBER
  • WAR_NAME — VARCHAR2(10)
  • IR_UPRICE — NUMBER
  • IR_SP — NUMBER
  • IR_VAT — NUMBER
  • IR_SUMCOST — NUMBER
  • ORD_NUM — VARCHAR2(10)

INSTRUCPROD

  • INST_NUM — VARCHAR2(10) — 기본 키 — NOT NULL
  • INST_DATE — DATE
  • PROD_CODE — VARCHAR2(10)
  • PROD_NAME — VARCHAR2(50)
  • GCODE_NAME — VARCHAR2(10)
  • INST_COMPLETE — DATE
  • INST_LEADQTY — NUMBER
  • DEPT_NAME — VARCHAR2(10)
  • EMP_NAME — VARCHAR2(10)
  • KCODE_NAME — VARCHAR2(10)
  • INST_RESULT — VARCHAR2(1)
  • INST_FINISH — VARCHAR2(1)

MEMBER

  • MEM_CODE — VARCHAR2(10) — 기본 키 — NOT NULL
  • MEM_ID — VARCHAR2(50)
  • MEM_PASS — VARCHAR2(500)
  • MEM_NAME — VARCHAR2(50)
  • MEM_MAIL — VARCHAR2(100)

MEMBER_AUTHORITY

  • AUTH_NUM — VARCHAR2(10) — 외래 키 → AUTHORITY.AUTH_NUM — NOT NULL
  • MEM_CODE — VARCHAR2(10) — 외래 키 → MEMBER.MEM_CODE — NOT NULL

MRELEASE

  • MRE_NUM — VARCHAR2(10) — 기본 키 — NOT NULL
  • MRE_DATE — DATE
  • PROD_CODE — VARCHAR2(10)
  • PROD_NAME — VARCHAR2(50)
  • GCODE_NAME — VARCHAR2(10)
  • BUYER_CODE — VARCHAR2(10)
  • BUYER_NAME — VARCHAR2(50)
  • DEPT_NAME — VARCHAR2(10)
  • EMP_NAME — VARCHAR2(10)

MRELEASE_RAW

  • MRE_NUM — VARCHAR2(10) — 외래 키 → MRELEASE.MRE_NUM — NOT NULL
  • PROD_CODE — VARCHAR2(10) — 외래 키 → RAW.RAW_CODE — NOT NULL
  • ICODE_NAME — VARCHAR2(10)
  • RAW_NAME — VARCHAR2(50)
  • GCODE_NAME — VARCHAR2(10)
  • UCODE_NAME — VARCHAR2(10)
  • MR_QTY — NUMBER
  • WAR_NAME — VARCHAR2(10)
  • PROJ_NAME — VARCHAR2(10)
  • INST_NUM — VARCHAR2(10)

NOTICE

  • NOTI_NUM — VARCHAR2(10) — 기본 키 — NOT NULL
  • NOTI_WRITER — VARCHAR2(10)
  • NOTI_DATE — DATE
  • NOTI_TITLE — VARCHAR2(50)
  • NOTI_CONTENT — VARCHAR2(255)
  • NOTI_HITS — NUMBER

ORDER

  • ORD_NUM — VARCHAR2(10) — 기본 키 — NOT NULL
  • ORD_DATE — DATE
  • BUYER_CODE — VARCHAR2(10)
  • BUYER_NAME — VARCHAR2(50)
  • DEPT_NAME — VARCHAR2(10)
  • EMP_NAME — VARCHAR2(10)
  • ORD_VAT — VARCHAR2(1)
  • ORD_RESULT — VARCHAR2(1)
  • ORD_FINISH — VARCHAR2(1)

ORDERBOOK

  • ORB_NUM — VARCHAR2(10) — 기본 키 — NOT NULL
  • BUYER_CODE — VARCHAR2(10)
  • BUYER_NAME — VARCHAR2(10)
  • DEPT_NAME — VARCHAR2(50)
  • EMP_NAME — VARCHAR2(10)
  • ORB_VAT — VARCHAR2(1)
  • ORB_RESULT — VARCHAR2(1)
  • ORB_FINISH — VARCHAR2(1)

ORDERBOOK_PROD

  • ORB_NUM — VARCHAR2(10) — 외래 키 → ORDERBOOK.ORB_NUM — NOT NULL
  • PROD_CODE — VARCHAR2(10) — 외래 키 → PRODUCT.PROD_CODE — NOT NULL
  • ICODE_NAME — VARCHAR2(10)
  • PROD_NAME — VARCHAR2(50)
  • GCODE_NAME — VARCHAR2(10)
  • UCODE_NAME — VARCHAR2(10)
  • OP_DATE — DATE
  • OP_QTY — NUMBER
  • OP_UPRICE — NUMBER
  • OP_SP — NUMBER
  • OP_VAT — NUMBER
  • OP_SUMCOST — NUMBER
  • EST_CODE — VARCHAR2(10)

ORDER_RAW

  • ORD_NUM — VARCHAR2(10) — 외래 키 → ORDER.ORD_NUM — NOT NULL
  • RAW_CODE — VARCHAR2(10) — 외래 키 → RAW.RAW_CODE — NOT NULL
  • RAW_NAME — VARCHAR2(50)
  • GCODE_NAME — VARCHAR2(10)
  • UCODE_NAME — VARCHAR2(10)
  • ORR_DATE — DATE
  • ORR_QTY — NUMBER
  • ORR_UPRICE — NUMBER
  • ORR_SP — NUMBER
  • ORR_VAT — NUMBER
  • ORR_SUMCOST — NUMBER
  • PROJ_NAME — VARCHAR2(10)

PRODINSTRUC_RAW

  • INST_NUM — VARCHAR2(10) — 외래 키 → INSTRUCPROD.INST_NUM — NOT NULL
  • PROD_CODE — VARCHAR2(10) — 외래 키 → RAW.RAW_CODE — NOT NULL
  • ICODE_NAME — VARCHAR2(10)
  • RAW_CODE — VARCHAR2(10)
  • RAW_NAME — VARCHAR2(50)
  • GCODE_NAME — VARCHAR2(10)
  • UCODE_NAME — VARCHAR2(10)
  • PR_QTY — NUMBER

PRODUCT

  • PROD_CODE — VARCHAR2(10) — 기본 키 — NOT NULL
  • ICODE_NAME — VARCHAR2(50)
  • PROD_NAME — VARCHAR2(50) — NOT NULL
  • GCODE_NAME — VARCHAR2(10)
  • PROD_QTY — NUMBER
  • LDIV_NAME — VARCHAR2(30)
  • MDIV_NAME — VARCHAR2(30)
  • SDIV_NAME — VARCHAR2(30)
  • UCODE_INNAME — VARCHAR2(10)
  • UCODE_OUTNAME — VARCHAR2(10)
  • PROD_ADQINV — NUMBER
  • PROD_STANCOST — NUMBER
  • PROD_ACTUCOST — NUMBER
  • PROD_PURCHPRICE — NUMBER
  • PROD_SALPRICE — NUMBER
  • PROD_USE — VARCHAR2(1) — NOT NULL
  • PROD_BASEQTY — NUMBER
  • RAW_BASEUCOST — NUMBER
  • RAW_BASECOST — NUMBER
  • RAW_INVQTY — NUMBER
  • RAW_INVUCOST — NUMBER
  • RAW_INVCOST — NUMBER

PRODWARE

  • ARR_NUM — VARCHAR2(10) — 기본 키 — NOT NULL
  • ARR_DATE — DATE
  • BUYER_CODE — VARCHAR2(10)
  • BUYER_NAME — VARCHAR2(50)
  • DEPT_NAME — VARCHAR2(10)
  • EMP_NAME — VARCHAR2(10)

PRODWARE_PRODUCT

  • ARR_NUM — VARCHAR2(10) — 외래 키 → PRODWARE.ARR_NUM — NOT NULL
  • PROD_CODE — VARCHAR2(10) — 외래 키 → PRODUCT.PROD_CODE — NOT NULL
  • ICODE_NAME — VARCHAR2(10)
  • PROD_NAME — VARCHAR2(50)
  • GCODE_NAME — VARCHAR2(10)
  • PP_QTY — NUMBER
  • KCODE_NAME — VARCHAR2(10)
  • WAR_NAME — VARCHAR2(10)
  • PROJ_NAME — VARCHAR2(10)
  • INST_NUM — VARCHAR2(10)
  • PP_BADNUM — NUMBER

PROJECT

  • PROJ_CODE — VARCHAR2(10) — 기본 키 — NOT NULL
  • PROJ_NAME — VARCHAR2(50)
  • PROJ_START — DATE
  • PROJ_END — DATE
  • PROJ_SORT — VARCHAR2(10)
  • PROJ_PURPOSE — VARCHAR2(255)
  • PROJ_CONTENT — VARCHAR2(255)
  • PROJ_BUDGET — NUMBER
  • PROJ_MEMCODE — VARCHAR2(10)
  • PROJ_DEPTCODE — VARCHAR2(10)

PURCHCLOSE

  • PUR_NUM — NUMBER — 기본 키 — NOT NULL
  • BUYER_CODE — VARCHAR2(10) — NOT NULL
  • BUYER_NAME — VARCHAR2(10) — NOT NULL
  • BUYER_RECEIVER — VARCHAR2(10) — NOT NULL
  • DEPT_NAME — VARCHAR2(10) — NOT NULL
  • EMP_NAME — VARCHAR2(10) — NOT NULL
  • PUR_VAT — VARCHAR2(1)

PURCHCLOSE_RAW

  • PUR_NUM — NUMBER — 외래 키 → PURCHCLOSE.PUR_NUM — NOT NULL
  • RAW_CODE — VARCHAR2(10) — 외래 키 → RAW.RAW_CODE — NOT NULL
  • RAW_NAME — VARCHAR(255)
  • GCODE_NAME — VARCHAR2(10)
  • UCODE_NAME — VARCHAR2(10)
  • PCR_QTY — NUMBER
  • PRC_UPRICE — NUMBER
  • PRC_SP — NUMBER
  • PRC_VAT — NUMBER
  • PRC_SUMCOST — NUMBER
  • WAR_NAME — VARCHAR2(10)
  • PROJ_NAME — VARCHAR2(10)
  • INC_NUM — VARCHAR2(10)

RAW

  • RAW_CODE — VARCHAR2(10) — 기본 키 — NOT NULL
  • ICODE_NAME — VARCHAR(255)
  • RAW_NAME — VARCHAR2(50) — NOT NULL
  • GCODE_NAME — VARCHAR2(10)
  • RAW_QTY — NUMBER
  • LDIV_NAME — VARCHAR2(30)
  • MDIV_NAME — VARCHAR2(30)
  • SDIV_NAME — VARCHAR2(30)
  • UCODE_INNAME — VARCHAR2(10)
  • UCODE_OUTNAME — VARCHAR2(10)
  • RAW_ADQINV — NUMBER
  • RAW_STANCOST — NUMBER
  • RAW_ACTUCOST — NUMBER
  • RAW_PURCHPRICE — NUMBER
  • RAW_SALPRICE — NUMBER
  • RAW_USE — VARCHAR2(1) — NOT NULL
  • RAW_BASEQTY — NUMBER
  • RAW_BASEUCOST — NUMBER
  • RAW_BASECOST — NUMBER
  • RAW_INVQTY — NUMBER
  • RAW_INVUCOST — NUMBER
  • RAW_INVCOST — NUMBER

RELEASE

  • REL_NUM — VARCHAR2(10) — 기본 키 — NOT NULL
  • REL_DATE — DATE
  • BUYER_CODE — VARCHAR2(10)
  • BUYER_NAME — VARCHAR2(50)
  • DEPT_NAME — VARCHAR2(10)
  • EMP_NAME — VARCHAR2(10)
  • REL_VAT — VARCHAR2(1)
  • REL_RESULT — VARCHAR2(1)
  • REL_FINISH — VARCHAR2(1)

RELEASEORDER

  • REO_NUM — VARCHAR2(10) — 기본 키 — NOT NULL
  • REO_DATE — DATE
  • DEPT_CODE — VARCHAR2(10)
  • BUYER_NAME — VARCHAR2(50)
  • DEPT_NAME — VARCHAR2(10)
  • EMP_NAME — VARCHAR2(10)
  • REO_VAT — VARCHAR2(1)
  • REO_RESULT — VARCHAR2(1)
  • REO_FINISH — VARCHAR2(1)

RELEASEORDER_PROD

  • REO_NUM — VARCHAR2(10) — 외래 키 → RELEASEORDER.REO_NUM — NOT NULL
  • PROD_CODE — VARCHAR2(10) — 외래 키 → PRODUCT.PROD_CODE — NOT NULL
  • ICODE_NAME — VARCHAR2(10)
  • PROD_NAME — VARCHAR2(50)
  • GCODE_NAME — VARCHAR2(10)
  • UCODE_NAME — VARCHAR2(10)
  • ROP_DATE — DATE
  • ROP_QTY — NUMBER
  • ROP_UPRICE — NUMBER
  • ROP_SP — NUMBER
  • ROP_VAT — NUMBER
  • ROP_SUMCOST — NUMBER
  • WAR_NAME — VARCHAR2(10)
  • ORB_NUM — VARCHAR2(10)
  • PROJ_NAME — VARCHAR2(10)

RELEASE_PROD

  • REL_NUM — VARCHAR2(10) — 외래 키 → RELEASE.REL_NUM — NOT NULL
  • PROD_CODE — VARCHAR2(10) — 외래 키 → PRODUCT.PROD_CODE — NOT NULL
  • ICODE_NAME — VARCHAR2(10)
  • PROD_NAME — VARCHAR2(50)
  • GCODE_NAME — VARCHAR2(10)
  • UCODE_NAME — VARCHAR2(10)
  • RP_DATE — DATE
  • RP_QTY — NUMBER
  • RP_UPRICE — NUMBER
  • RP_SP — NUMBER
  • RP_VAT — NUMBER
  • RP_SUMCOST — NUMBER
  • WAR_NAME — VARCHAR2(10)
  • PROJ_NAME — VARCHAR2(10)

SALESCLOSE

  • SALC_NUM — VARCHAR2(10) — 기본 키 — NOT NULL
  • SALC_DATE — DATE
  • BUYER_CODE — VARCHAR2(10)
  • BUYER_NAME — VARCHAR2(50)
  • BUYER_RECEIVER — VARCHAR2(10)
  • DEPT_NAME — VARCHAR2(10)
  • EMP_NAME — VARCHAR2(10)
  • SALC_VAT — VARCHAR2(1)

SALESCLOSE_PROD

  • SALC_NUM — VARCHAR2(10) — 외래 키 → SALESCLOSE.SALC_NUM — NOT NULL
  • PROD_CODE — VARCHAR2(10) — 외래 키 → PRODUCT.PROD_CODE — NOT NULL
  • PROD_NAME — VARCHAR2(50)
  • GCODE_NAME — VARCHAR2(10)
  • UCODE_NAME — VARCHAR2(10)
  • SCP_DATE — DATE
  • SCP_QTY — NUMBER
  • SCP_UPRICE — NUMBER
  • SCP_SP — NUMBER
  • SCP_VAT — NUMBER
  • SCP_SUMCOST — NUMBER
  • WAR_NAME — VARCHAR2(10)
  • PROJ_NAME — VARCHAR2(10)
  • REL_NUM — VARCHAR2(10)

SHIPPING

  • SHIP_CODE — VARCHAR2(10) — 기본 키 — NOT NULL
  • SHIP_NAME — VARCHAR2(50)
  • SHIP_ADD — VARCHAR2(50)

STOCKMOVE

  • STM_NUM — VARCHAR2(10) — 기본 키 — NOT NULL
  • STM_SORT — VARCHAR2(10)
  • OUTWAR_NAME — VARCHAR2(10)
  • INWAR_NAME — VARCHAR2(10)
  • EMP_NAME — VARCHAR2(10)

STOCKMOVE_ITEM

  • STM_NUM — VARCHAR2(10) — 외래 키 → STOCKMOVE.STM_NUM — NOT NULL
  • RAW_CODE — VARCHAR2(10) — 외래 키 → RAW.RAW_CODE — NOT NULL
  • PROD_CODE — VARCHAR2(10) — 외래 키 → PRODUCT.PROD_CODE — NOT NULL
  • ICODE_NAME — VARCHAR2(10)
  • PROD_NAME — VARCHAR2(50)
  • GCODE_INNAME — VARCHAR2(10)
  • UCODE_INNAME — VARCHAR2(10)
  • SI_QTY — NUMBER
  • GCODE_OUTNAME — VARCHAR2(10)
  • UCODE_OUTNAME — VARCHAR2(10)

STOCKVALUATION

  • STV_NUM — VARCHAR2(10) — 기본 키 — NOT NULL
  • STV_START — DATE
  • STV_END — DATE
  • STV_DATE — DATE
  • DEPT_NAME — VARCHAR2(50)
  • EMP_NAME — VARCHAR2(10)
  • STV_CHECK — VARCHAR2(1)
  • Field — VARCHAR(255)

STOCKVALUATION_ITEM

  • SI_NUM — VARCHAR2(10) — 외래 키 → STOCKVALUATION.STV_NUM — NOT NULL
  • RAW_CODE — VARCHAR2(10) — 외래 키 → RAW.RAW_CODE — NOT NULL
  • PROD_CODE — VARCHAR2(10) — 외래 키 → PRODUCT.PROD_CODE — NOT NULL
  • ICODE_NAME — VARCHAR2(10)
  • PROD_NAME — VARCHAR2(50)
  • GCODE_NAME — VARCHAR2(10)
  • UCODE_NAME — VARCHAR2(10)
  • PROD_BASEQTY — NUMBER
  • PROD_BASEUCOST — NUMBER
  • PROD_BASECOST — NUMBER
  • SVI_INQTY — NUMBER
  • SVI_INCOST — NUMBER
  • SVI_OUTQTY — NUMBER
  • SVI_OUTCOST — NUMBER
  • PROD_INVQTY — NUMBER
  • PROD_INVUCOST — NUMBER
  • PROD_INVCOST — NUMBER

WAREHOUSE

  • WAR_CODE — VARCHAR2(10) — 기본 키 — NOT NULL
  • WAR_NAME — VARCHAR2(50)
  • WAR_ADD — VARCHAR2(50)
  • DEPT_NAME — VARCHAR2(50)
  • EMP_NAME — VARCHAR2(10)
  • EMP_LINE — VARCHAR2(10)
  • WAR_CHECK — VARCHAR2(1)

WAREHOUSE_PROD

  • WAR_CODE — VARCHAR2(10) — 외래 키 → WAREHOUSE.WAR_CODE — NOT NULL
  • PROD_CODE — VARCHAR2(10) — 외래 키 → PRODUCT.PROD_CODE — NOT NULL

WAREHOUSE_RAW

  • RAW_CODE — VARCHAR2(10) — 외래 키 → RAW.RAW_CODE — NOT NULL
  • WAR_CODE — VARCHAR2(10) — 외래 키 → WAREHOUSE.WAR_CODE — NOT NULL