로그인

테이블 (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