판매관리
테이블 (10)
CATEGORY
- CAT_ID — CHAR(4) — 기본 키 — NOT NULL
- CAT_NAME — VARCHAR2(30)
MEMBERS
- CUST_ID — VARCHAR2(5) — 외래 키 → 고객.CUST_ID — NOT NULL
- CUST_EMAIL — VARCHAR2(50)
- CUST_TEL_NUM — VARCHAR2(30)
- CUST_JOB — VARCHAR2(50)
- CUST_BIR_DATE — DATE
- CUST_MILEAGE — NUMBER(5)
NON_MEMBER
- CUST_ID — VARCHAR2(5) — 외래 키 → 고객.CUST_ID — NOT NULL
ORDERS
- ORDER_ID — VARCHAR2(13) — 기본 키 — NOT NULL
- OEDER_DATE — DATE
- ORDER_AMT — NUMBER(8)
- ORDER_STATUS — VARCHAR2(1)
- CUST_ID — VARCHAR2(5) — NOT NULL
ORDER_PRODUCT
- PID — VARCHAR2(10) — 외래 키 → PRODUCTS.PID — NOT NULL
- ORDER_ID — VARCHAR2(13) — 외래 키 → ORDERS.ORDER_ID — NOT NULL
- ORDER_QTY — NUMBER(4)
PAYMENT
- ORDER_ID2 — VARCHAR2(13) — 외래 키 → ORDERS.ORDER_ID — NOT NULL
- PAY_DATE — DATE
- PAY_AMT — NUMBER(8)
- PAY_MID — CHAR(2) — NOT NULL
PAYMENT_METHOD
- PAY_MID — CHAR(2) — 기본 키 — NOT NULL
- PAY_MNAME — VARCHAR2(50)
PRODUCTS
- PID — VARCHAR2(10) — 기본 키 — NOT NULL
- PNAME — VARCHAR2(50)
- PRICE — NUMBER(8)
- P_STOCK — VARCHAR(255)
- CAT_ID — CHAR(4) — NOT NULL
REFOUND
- ORDER_ID — VARCHAR2(13) — 외래 키 → ORDERS.ORDER_ID — NOT NULL
- RERFOUND_DATE — DATE
- REFOUND_AMT — NUMBER(8)
고객 (CUSTOMERS)
- CUST_ID — VARCHAR2(5) — 기본 키 — NOT NULL
- CUST_NAME — VARCHAR2(50)
- CUST_ZIPCODE — VARCHAR2(7)
- CUST_ADDR1 — VARCHAR2(2000)
- CUST_ADDR2 — VARCHAR2(100)