tq
Tables (20)
ATTACH
- ATTACH_ID — NUMBER(19) — Primary key — NOT NULL
- DOC_TP — VARCHAR2(30) — NOT NULL
- DOC_ID — NUMBER(19) — NOT NULL
- ORIG_NM — VARCHAR2(255) — NOT NULL
- SAVE_NM — VARCHAR2(255) — NOT NULL
- FILE_PATH — VARCHAR2(1000) — NOT NULL
- FILE_SZ — NUMBER(19) — NOT NULL
- MIME_TP — VARCHAR2(150)
- REG_DT — TIMESTAMP — NOT NULL
EMP
- EMP_ID — NUMBER(19) — Primary key — NOT NULL
- EMP_CD — VARCHAR2(30) — NOT NULL
- EMP_NM — VARCHAR2(100) — NOT NULL
- DEPT_NM — VARCHAR2(100)
- USE_YN — CHAR(1) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
- MOD_DT — TIMESTAMP — NOT NULL
ITEM
- ITEM_ID — NUMBER(19) — Primary key — NOT NULL
- ITEM_CD — VARCHAR2(30) — NOT NULL
- ITEM_NM — VARCHAR2(150) — NOT NULL
- GRP_ID — NUMBER(19) — Foreign key → ITEM_GRP.GRP_ID
- SPEC — VARCHAR2(200)
- BARCODE — VARCHAR2(100)
- UNIT — VARCHAR2(30) — NOT NULL
- IN_PRICE — NUMBER(18,4) — NOT NULL
- OUT_PRICE — NUMBER(18,4) — NOT NULL
- STOCK_YN — CHAR(1) — NOT NULL
- USE_YN — CHAR(1) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
- MOD_DT — TIMESTAMP — NOT NULL
ITEM_GRP
- GRP_ID — NUMBER(19) — Primary key — NOT NULL
- GRP_CD — VARCHAR2(30) — NOT NULL
- GRP_NM — VARCHAR2(100) — NOT NULL
- PARENT_GRP_ID — NUMBER(19) — Foreign key → ITEM_GRP.GRP_ID
- SORT_NO — NUMBER(10) — NOT NULL
- USE_YN — CHAR(1) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
- MOD_DT — TIMESTAMP — NOT NULL
ORD
- ORD_ID — NUMBER(19) — Primary key — NOT NULL
- ORD_NO — VARCHAR2(40) — NOT NULL
- ORD_DT — DATE — NOT NULL
- DUE_DT — DATE
- PARTNER_ID — NUMBER(19) — Foreign key → PARTNER.PARTNER_ID — NOT NULL
- EMP_ID — NUMBER(19) — Foreign key → EMP.EMP_ID
- WH_ID — NUMBER(19) — Foreign key → WH.WH_ID
- QUOTE_ID — NUMBER(19) — Foreign key → QUOTE.QUOTE_ID
- CURR_CD — VARCHAR2(10) — NOT NULL
- EX_RATE — NUMBER(18,6) — NOT NULL
- TRX_TP — VARCHAR2(30)
- PRJ_NM — VARCHAR2(100)
- STATUS — VARCHAR2(30) — NOT NULL
- SUP_AMT — NUMBER(18,2) — NOT NULL
- TAX_AMT — NUMBER(18,2) — NOT NULL
- TOT_AMT — NUMBER(18,2) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
- MOD_DT — TIMESTAMP — NOT NULL
ORD_DTL
- ORD_DTL_ID — NUMBER(19) — Primary key — NOT NULL
- ORD_ID — NUMBER(19) — Foreign key → ORD.ORD_ID — NOT NULL
- QUOTE_DTL_ID — NUMBER(19) — Foreign key → QUOTE_DTL.QUOTE_DTL_ID
- SEQ_NO — NUMBER(10) — NOT NULL
- ITEM_ID — NUMBER(19) — Foreign key → ITEM.ITEM_ID — NOT NULL
- QTY — NUMBER(18,4) — NOT NULL
- UNIT_PRICE — NUMBER(18,4) — NOT NULL
- SUP_AMT — NUMBER(18,2) — NOT NULL
- TAX_AMT — NUMBER(18,2) — NOT NULL
- TOT_AMT — NUMBER(18,2) — NOT NULL
- DUE_DT — DATE
- MEMO — VARCHAR2(500)
PARTNER
- PARTNER_ID — NUMBER(19) — Primary key — NOT NULL
- PARTNER_CD — VARCHAR2(30) — NOT NULL
- PARTNER_NM — VARCHAR2(150) — NOT NULL
- GRP_ID — NUMBER(19) — Foreign key → PARTNER_GRP.GRP_ID
- PARTNER_TP — VARCHAR2(20) — NOT NULL
- BIZ_NO — VARCHAR2(30)
- CEO_NM — VARCHAR2(100)
- TEL — VARCHAR2(30)
- EMAIL — VARCHAR2(200)
- ADDR — VARCHAR2(500)
- EMP_ID — NUMBER(19) — Foreign key → EMP.EMP_ID
- CURR_CD — VARCHAR2(10) — NOT NULL
- USE_YN — CHAR(1) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
- MOD_DT — TIMESTAMP — NOT NULL
PARTNER_GRP
- GRP_ID — NUMBER(19) — Primary key — NOT NULL
- GRP_CD — VARCHAR2(30) — NOT NULL
- GRP_NM — VARCHAR2(100) — NOT NULL
- PARENT_GRP_ID — NUMBER(19) — Foreign key → PARTNER_GRP.GRP_ID
- SORT_NO — NUMBER(10) — NOT NULL
- USE_YN — CHAR(1) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
- MOD_DT — TIMESTAMP — NOT NULL
PAYMENT
- PAY_ID — NUMBER(19) — Primary key — NOT NULL
- SALE_ID — NUMBER(19) — Foreign key → SALE.SALE_ID — NOT NULL
- PAY_TP — VARCHAR2(30) — NOT NULL
- AMT — NUMBER(18,2) — NOT NULL
- MCHT_NO — VARCHAR2(100)
- APRV_NO — VARCHAR2(100)
- STATUS — VARCHAR2(20) — NOT NULL
- APRV_DT — TIMESTAMP
- CXL_DT — TIMESTAMP
- CXL_REASON — VARCHAR2(500)
- REG_DT — TIMESTAMP — NOT NULL
- MOD_DT — TIMESTAMP — NOT NULL
QUOTE
- QUOTE_ID — NUMBER(19) — Primary key — NOT NULL
- QUOTE_NO — VARCHAR2(40) — NOT NULL
- QUOTE_DT — DATE — NOT NULL
- PARTNER_ID — NUMBER(19) — Foreign key → PARTNER.PARTNER_ID — NOT NULL
- EMP_ID — NUMBER(19) — Foreign key → EMP.EMP_ID
- WH_ID — NUMBER(19) — Foreign key → WH.WH_ID
- CURR_CD — VARCHAR2(10) — NOT NULL
- EX_RATE — NUMBER(18,6) — NOT NULL
- TRX_TP — VARCHAR2(30)
- PRJ_NM — VARCHAR2(100)
- STATUS — VARCHAR2(30) — NOT NULL
- SUP_AMT — NUMBER(18,2) — NOT NULL
- TAX_AMT — NUMBER(18,2) — NOT NULL
- TOT_AMT — NUMBER(18,2) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
- MOD_DT — TIMESTAMP — NOT NULL
QUOTE_DTL
- QUOTE_DTL_ID — NUMBER(19) — Primary key — NOT NULL
- QUOTE_ID — NUMBER(19) — Foreign key → QUOTE.QUOTE_ID — NOT NULL
- SEQ_NO — NUMBER(10) — NOT NULL
- ITEM_ID — NUMBER(19) — Foreign key → ITEM.ITEM_ID — NOT NULL
- QTY — NUMBER(18,4) — NOT NULL
- UNIT_PRICE — NUMBER(18,4) — NOT NULL
- SUP_AMT — NUMBER(18,2) — NOT NULL
- TAX_AMT — NUMBER(18,2) — NOT NULL
- TOT_AMT — NUMBER(18,2) — NOT NULL
- MEMO — VARCHAR2(500)
SALE
- SALE_ID — NUMBER(19) — Primary key — NOT NULL
- SALE_NO — VARCHAR2(40) — NOT NULL
- SALE_DT — DATE — NOT NULL
- PARTNER_ID — NUMBER(19) — Foreign key → PARTNER.PARTNER_ID — NOT NULL
- EMP_ID — NUMBER(19) — Foreign key → EMP.EMP_ID
- WH_ID — NUMBER(19) — Foreign key → WH.WH_ID — NOT NULL
- ORD_ID — NUMBER(19) — Foreign key → ORD.ORD_ID
- CURR_CD — VARCHAR2(10) — NOT NULL
- EX_RATE — NUMBER(18,6) — NOT NULL
- TRX_TP — VARCHAR2(30)
- PRJ_NM — VARCHAR2(100)
- STATUS — VARCHAR2(30) — NOT NULL
- ACCT_STATUS — VARCHAR2(30) — NOT NULL
- ADJ_AMT — NUMBER(18,2) — NOT NULL
- SUP_AMT — NUMBER(18,2) — NOT NULL
- TAX_AMT — NUMBER(18,2) — NOT NULL
- TOT_AMT — NUMBER(18,2) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
- MOD_DT — TIMESTAMP — NOT NULL
SALE_DTL
- SALE_DTL_ID — NUMBER(19) — Primary key — NOT NULL
- SALE_ID — NUMBER(19) — Foreign key → SALE.SALE_ID — NOT NULL
- ORD_DTL_ID — NUMBER(19) — Foreign key → ORD_DTL.ORD_DTL_ID
- SEQ_NO — NUMBER(10) — NOT NULL
- ITEM_ID — NUMBER(19) — Foreign key → ITEM.ITEM_ID — NOT NULL
- QTY — NUMBER(18,4) — NOT NULL
- UNIT_PRICE — NUMBER(18,4) — NOT NULL
- DISC_AMT — NUMBER(18,2) — NOT NULL
- SUP_AMT — NUMBER(18,2) — NOT NULL
- TAX_AMT — NUMBER(18,2) — NOT NULL
- TOT_AMT — NUMBER(18,2) — NOT NULL
- LOT_NO — VARCHAR2(100)
- MEMO — VARCHAR2(500)
SHIP
- SHIP_ID — NUMBER(19) — Primary key — NOT NULL
- SHIP_NO — VARCHAR2(40) — NOT NULL
- SHIP_DT — DATE — NOT NULL
- PARTNER_ID — NUMBER(19) — Foreign key → PARTNER.PARTNER_ID — NOT NULL
- EMP_ID — NUMBER(19) — Foreign key → EMP.EMP_ID
- WH_ID — NUMBER(19) — Foreign key → WH.WH_ID — NOT NULL
- PRJ_NM — VARCHAR2(100)
- TEL — VARCHAR2(100)
- ZIP — VARCHAR2(20)
- ADDR — VARCHAR2(500)
- STATUS — VARCHAR2(30) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
- MOD_DT — TIMESTAMP — NOT NULL
SHIP_DTL
- SHIP_DTL_ID — NUMBER(19) — Primary key — NOT NULL
- SHIP_ID — NUMBER(19) — Foreign key → SHIP.SHIP_ID — NOT NULL
- SEQ_NO — NUMBER(10) — NOT NULL
- ITEM_ID — NUMBER(19) — Foreign key → ITEM.ITEM_ID — NOT NULL
- QTY — NUMBER(18,4) — NOT NULL
- MEMO — VARCHAR2(500)
SHIP_REQ
- REQ_ID — NUMBER(19) — Primary key — NOT NULL
- REQ_NO — VARCHAR2(40) — NOT NULL
- REQ_DT — DATE — NOT NULL
- PLAN_DT — DATE
- PARTNER_ID — NUMBER(19) — Foreign key → PARTNER.PARTNER_ID — NOT NULL
- EMP_ID — NUMBER(19) — Foreign key → EMP.EMP_ID
- WH_ID — NUMBER(19) — Foreign key → WH.WH_ID — NOT NULL
- PRJ_NM — VARCHAR2(100)
- TEL — VARCHAR2(100)
- ZIP — VARCHAR2(20)
- ADDR — VARCHAR2(500)
- STATUS — VARCHAR2(30) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
- MOD_DT — TIMESTAMP — NOT NULL
SHIP_REQ_DTL
- REQ_DTL_ID — NUMBER(19) — Primary key — NOT NULL
- REQ_ID — NUMBER(19) — Foreign key → SHIP_REQ.REQ_ID — NOT NULL
- SEQ_NO — NUMBER(10) — NOT NULL
- ITEM_ID — NUMBER(19) — Foreign key → ITEM.ITEM_ID — NOT NULL
- QTY — NUMBER(18,4) — NOT NULL
- MEMO — VARCHAR2(500)
STOCK
- ITEM_ID — NUMBER(19) — Foreign key → ITEM.ITEM_ID — NOT NULL
- WH_ID — NUMBER(19) — Foreign key → WH.WH_ID — NOT NULL
- QTY — NUMBER(18,4) — NOT NULL
- MOD_DT — TIMESTAMP — NOT NULL
WH
- WH_ID — NUMBER(19) — Primary key — NOT NULL
- WH_CD — VARCHAR2(20) — NOT NULL
- WH_NM — VARCHAR2(100) — NOT NULL
- GRP_ID — NUMBER(19) — Foreign key → WH_GRP.GRP_ID
- WH_TP — VARCHAR2(30) — NOT NULL
- USE_YN — CHAR(1) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
- MOD_DT — TIMESTAMP — NOT NULL
WH_GRP
- GRP_ID — NUMBER(19) — Primary key — NOT NULL
- GRP_CD — VARCHAR2(30) — NOT NULL
- GRP_NM — VARCHAR2(100) — NOT NULL
- PARENT_GRP_ID — NUMBER(19) — Foreign key → WH_GRP.GRP_ID
- SORT_NO — NUMBER(10) — NOT NULL
- USE_YN — CHAR(1) — NOT NULL
- REG_DT — TIMESTAMP — NOT NULL
- MOD_DT — TIMESTAMP — NOT NULL