210430

테이블 (4)

Copy Of Untitled (CopyOfEC_Basket)

  • Field (Order_No) — VARCHAR2(10) — 기본 키
  • Field (Order_QTY) — NUMBER(3) — NOT NULL
  • Field (Order_date) — DATE
  • Field

Untitled (EC_Member)

  • Field (UserID) — VARCHAR2(10) — 기본 키 — NOT NULL
  • Field (Passwd) — VARCHAR2(10) — NOT NULL
  • Field (Name) — VARCHAR2(10) — NOT NULL
  • Field (Regist_No) — VARCHAR2(14) — NOT NULL
  • Field (Email) — VARCHAR2(20)
  • Field (Telephone) — VARCHAR2(12) — NOT NULL
  • Field (Address) — VARCHAR2(40)
  • Field (Timestamp) — DATE

Untitled (EC_Basket)

  • Field (Order_No) — VARCHAR2(10) — 기본 키
  • Field (Order_ID) — VARCHAR2(10) — 외래 키 → Untitled.Field — NOT NULL
  • 상품코드 (Product_Code) — VARCHAR2(10) — 외래 키 → 상품목록.상품코드 — NOT NULL
  • Field (Order_QTY) — NUMBER(3) — NOT NULL
  • Field (Order_date) — DATE

상품목록 (EC_Product)

  • 상품코드 (Product_Code) — VARCHAR2(10) — 기본 키 — NOT NULL
  • 상품명 (Product_Name) — VARCHAR2(20) — NOT NULL
  • Field (Standard) — VARCHAR2(20)
  • Field (Unit) — VARCHAR2(10)
  • Field (Unit_Price) — NUMBER(7) — NOT NULL
  • Field (Left_QTY) — NUMBER(5)
  • Field (Company) — VARCHAR2(20)
  • Field (ImageName) — VARCHAR2(20)
  • Field (Info) — VARCHAR2(80)
  • Field (Detail_Info) — VARCHAR2(255)