D
Tables (5)
CAT
- CCD — VARCHAR2(2) — Primary key — NOT NULL
- CNAME — VARCHAR2(50)
ORDER_DETAIL
- OCD — VARCHAR2(10) — Primary key — NOT NULL
- OSEQ — NUMBER(2) — Primary key — NOT NULL
- PCD — VARCHAR2(4) — NOT NULL
- O_QTY — NUMBER
- P_COST — NUMBER
- IPGO_QTY — NUMBER
ORDER_INFO
- OCD — VARCHAR2(10) — Primary key — NOT NULL
- ODATE — DATE
- OTP — NUMBER
- OSTATE — VARCHAR2(10)
- IPGO_DT — DATE
PRODUCT
- PCD — VARCHAR2(4) — Primary key — NOT NULL
- PNAME — VARCHAR2(50)
- CCD — VARCHAR2(2)
- P_COST — NUMBER
- P_QTY — NUMBER
- PRANKING — CHAR
- PIMG — VARCHAR2(300)
- P_EXPL — VARCHAR2(100)
- USE_YN — VARCHAR2(1)
STOCK
- SYM — DATE — Primary key — NOT NULL
- PCD — VARCHAR2(4) — Primary key — NOT NULL
- BASIC_QTY — NUMBER(10)
- IPGO_QTY — NUMBER(10)
- CHULGO_QTY — NUMBER(10)
- END_QTY — NUMBER(10)