판매관리

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