쇼핑몰_영문버전
테이블 (6)
BUYER (Untitled5)
- BUYER_ID (Key) — 기본 키 — NOT NULL
- BUYER_NAME (Field)
- BUYER_BANK (Field2)
- BUYER_BANKNO (Field3)
- BUYER_BANKNAME (Field4)
- BUYER_ZIP (Field5)
- BUYER_ADD1 (Field6)
- BUYER_ADD2 (Field7)
- BUYER_COMTEL (Field8)
- BUYER_FAX (Field9)
- BUYER_MAIL (Field10)
- BUYER_CHARGER (Field11)
- BUYER_TELEXT (Field12)
BUYPROD (Untitled6)
- BUY_DATE (Key) — 기본 키 — NOT NULL
- BUY_PROD (Key2) — 외래 키 → PROD.PROD_ID — NOT NULL
- BUY_QTY (Field2)
- BUY_COST (Field3)
CART (Untitled2)
- CART_NO (Field3) — 기본 키
- CART_PROD (Key3) — 외래 키 → PROD.PROD_ID — NOT NULL
- CART_MEMBER (Key) — 외래 키 → MEMBER.MEM_ID — NOT NULL
- CART_QTY (Field2)
LPROD (Untitled4)
- LPROD_GU (Field) — 기본 키
- LPROD_NM (Field2)
- LPROD_ID (Key) — NOT NULL
MEMBER (Untitled)
- MEM_ID (Key) — 기본 키 — NOT NULL
- MEM_PASS (Field)
- MEM_NAME (Field2)
- MEM_REGNO1 (Field3)
- MEM_REGNO2 (Field4)
- MEM_BIR (Field5)
- MEM_ZIP (Field6)
- MEM_ADD1 (Field7)
- MEM_ADD2 (Field8)
- MEM_HOMETEL (Field9)
- MEM_COMTEL (Field10)
- MEM_HP (Field11)
- MEM_MAIL (Field12)
- MEM_JOB (Field13)
- MEM_LIKE (Field14)
- MEM_MEMORIAL (Field15)
- MEM_MEMORIALDAY (Field16)
- MEM_MILEAGE (Field17)
- MEM_DELETE (Field18)
PROD (Untitled3)
- PROD_ID (Key) — 기본 키 — NOT NULL
- PROD_BUYER (Key2) — 외래 키 → BUYER.BUYER_ID — NOT NULL
- PROD_LGU (Field3) — 외래 키 → LPROD.LPROD_GU
- PROD_NAME (Field)
- PROD_COST (Field4)
- PROD_PRICE (Field5)
- PROD_SALE (Field6)
- PROD_OUTLINE (Field7)
- PROD_DETAIL (Field8)
- PROD_IMG (Field9)
- PROD_TOTALSTOCK (Field10)
- PROD_INSDATE (Field11)
- PROD_PROPERSTOCK (Field12)
- PROD_COLOR (Field14)
- PROD_DELIVERY (Field15)
- PROD_UNIT (Field16)
- PROD_QTYIN (Field17)
- PROD_QTYSALE (Field18)
- PROD_MILEAGE (Field19)