BILL
Tables (3)
DC_APLY_CTG_DTL (할인적용카데고리상세)
- DC_ID (Key) — Primary key — NOT NULL
DC_BAS (할인기본)
- DC_ID (할인ID) — VARCHAR2(11) — Primary key — NOT NULL
- DC_NM (할인명) — VARCHAR2(100)
- DC_MTHD_CD (할인방법코드) — VARCHAR2(15)
- DC_APLY_TYPE_CD (할인적용유형코드) — VARCHAR2(4)
- DC_RATE (할인율) — NUMBER(9,6)
- DC_AMT (할인금액) — NUMBER(18,3)
PROD_BAS (상품기본)
- PROD_ID (상품ID) — VARCHAR2(15) — Primary key — NOT NULL
- PROD_NM (상품명) — VARCHAR2(100)
- PROD_TYPE_CD (상품유형코드) — VARCHAR2(4)