쇼핑몰_영문버전

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