파이널 프로젝트-글로벌

테이블 (5)

FINANCIAL_RECORD

  • recordNo — NUMBER — 기본 키 — NOT NULL
  • date — DATE — NOT NULL
  • total_sales — NUMBER(12, 2) — NOT NULL
  • total_expenses — NUMBER(12, 2) — NOT NULL
  • profit — NUMBER(12, 2)

ORDER

  • orderNo — NUMBER — 기본 키 — NOT NULL
  • userNo (KeyuserNo) — NUMBER — 외래 키 → USER.userNo — NOT NULL
  • orderDate — DATE
  • totalAmount — NUMBER(12, 2) — NOT NULL
  • status — VARCHAR2(20)

ORDER_DETAIL

  • orderNo (orderNo2) — NUMBER — 외래 키 → ORDER.orderNo — NOT NULL
  • userNo (KeyuserNo) — NUMBER — 외래 키 → ORDER.userNo — NOT NULL
  • orderDetailNo — NUMBER
  • productNo — NUMBER
  • quantity — NUMBER — NOT NULL
  • subtotal — NUMBER(12, 2) — NOT NULL

PRODUCT

  • productNo — NUMBER — 기본 키 — NOT NULL
  • userNo (KeyuserNo) — NUMBER — 외래 키 → USER.userNo — NOT NULL
  • orderNo (orderNo2) — NUMBER — 외래 키 → ORDER_DETAIL.orderNo — NOT NULL
  • userNo (KeyuserNo2) — NUMBER — 외래 키 → ORDER_DETAIL.userNo — NOT NULL
  • name — VARCHAR2(100) — NOT NULL
  • category — VARCHAR2(50)
  • price — NUMBER(10, 2) — NOT NULL
  • stock — NUMBER — NOT NULL
  • description — CLOB
  • image_path — VARCHAR2(255)

USER

  • userNo (KeyuserNo) — NUMBER — 기본 키 — NOT NULL
  • userId — VARCHAR2(50) — NOT NULL
  • username — VARCHAR2(50) — NOT NULL
  • password — VARCHAR2(100) — NOT NULL
  • email — VARCHAR2(100)
  • phone — VARCHAR2(15)
  • role — VARCHAR2(10)