프로젝트 초안

테이블 (3)

상품 (Product)

  • ProductNumber (num) — number(10) — 기본 키 — NOT NULL
  • ProductName (pdname) — varchar2(20 char)
  • Price (price) — number(7)
  • Inventory (inventory) — number(5)
  • Category (category) — varchar2(30 char)
  • Status (status) — varchar2(20 char)
  • Information (information) — varchar2(50 char)

주문 (Order)

  • OrderNumber (num) — number(10) — 기본 키 — NOT NULL
  • ID (id) — varchar2(20 char) — 외래 키 → 회원정보.ID — NOT NULL
  • ProductNumber (num2) — number(10) — 외래 키 → 상품.ProductNumber — NOT NULL
  • Name (name) — varchar2(15 char)
  • PhoneNumber (phone) — number(11)
  • Address (address) — varchar2(30 char)
  • DelieveryState (state) — varchar2(20 char)
  • OrderQuantity (quantity) — number(3)
  • ProductName (pdname) — varchar2(20 char)
  • Field

회원정보 (UserInformation)

  • ID (id) — varchar2(20 char) — 기본 키 — NOT NULL
  • PassWord (password) — varchar2(20 char)
  • Name (name) — varchar2(15 char)
  • PhoneNumber (phone) — number(11)
  • BirthDate (birthdate) — date
  • Gender (gender) — varchar2(15 char)
  • Address (address) — varchar2(30 char)