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 (상품사진)