개인
테이블 (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