khShoppingMall

Tables (4)

Buy (Untitled4)

  • Field
  • Field2
  • Field3
  • Field4
  • prno (상품번호) — NUMBER(20) — NOT NULL
  • Field5

Manager (Untitled3)

  • Field
  • Field2
  • Field3
  • Field4

Member (Untitled)

  • id (아이디) — VARCHAR2(10) — Primary key — NOT NULL
  • pw (비밀번호) — VARCHAR2(15)
  • address (주소) — VARCHAR2(50)
  • email (이메일) — VARCHAR2(30)
  • phone (핸드폰번호) — VARCHAR2(15)

Product (Untitled2)

  • prno (상품번호) — NUMBER(20) — Primary key — NOT NULL
  • prname (상품명) — VARCHAR2(20) — NOT NULL
  • price (가격) — NUMBER(15) — NOT NULL
  • prpictrue (상품사진)