fef

테이블 (3)

PROD (Untitled3)

  • key (PROD_ID) — VARCHAR2(10) — 기본 키 — NOT NULL
  • field (PROD_LGU) — char(4) — NOT NULL
  • filed (PROD_BUYER) — char(6) — NOT NULL
  • Field (PROD_NAME) — varchar2(40)
  • Field (PROD_COST) — number(10)
  • Field

Untitled2

  • Key (CART_NO) — char(13) — 기본 키 — NOT NULL
  • Field (CART_MEMBER) — varchar2(15)
  • KEY (MEM_ID) — VARCHAR2(15) — 외래 키 → 회원정보.KEY — NOT NULL

회원정보 (Untitled)

  • KEY (MEM_ID) — VARCHAR2(15) — 기본 키 — NOT NULL
  • Field (MEM_PASS) — varchar2(15)
  • Field2 (MEM_NAME) — varchar2(20)
  • Field3 (MEM_REGNO1) — char(6)
  • Field4 (MEM_REGNO2) — char(7)
  • Field5 (MEM_BIR) — date
  • Field (MEM_ZIP) — char(7)
  • Field2 (MEM_ADD1) — varchar2(100)
  • Field3 (MEM_ADD2) — varchar2(80)
  • Field4 (MEM_HOMETEL) — varchar2(14)
  • Field6 (MEM_COMTEL) — varchar2(14)
  • Field7 (MEM_HP) — varchar2(15)
  • Field8 (MEM_MAIL) — varchar2(60)
  • Field9 (MEM_JOB) — varchar2(40)
  • Field10 (MEM_LIKE) — varchar2(40)
  • Field11 (MEM_MEMORIAL) — varchar2(40)
  • Field12 (MEM_MEMORIALDAY) — date
  • Field13 (MEM_MILEAGE) — number(10)
  • Field (MEM_DELETE) — varchar2(1)