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)