로그인
테이블 (3)
로그인 (Untitled)
- id (Key) — varchar2 — 기본 키 — NOT NULL
- userCode (Key2) — int — 기본 키 — NOT NULL
- password (Field) — varchar2
- name (Field2) — varchar2
- address (Field3) — varchar2
- email (Field4) — varchar2
- phoneNum (Field5) — varchar2
- membership (Field6) — varchar2
- point (Field7) — int
상품구매 (Untitled2)
- orderId (Key) — int — 기본 키 — NOT NULL
- address (Field) — varchar2
- p_id (Field2) — varchar2
- userCode (Field3) — int
- point (Field4) — int
장바구니 (Cart)
- p_id (Key) — varchar2 — 기본 키 — NOT NULL
- userCode (Key2) — int — 기본 키 — NOT NULL
- p_price (Field) — int
- p_name (Field2) — varchar2
- p_picture (Field3) — varchar2
- p_exp (Field4) — varchar2
- p_quanity (Field5) — int