mall

테이블 (3)

Untitled (등급)

  • Key (Vipid) — VARCHAR — 기본 키 — NOT NULL
  • Field (VipName) — VARCHAR
  • Field (Rate) — INTEGER

Untitled2 (고객배송지)

  • Key (ID) — VARCHAR — 기본 키 — NOT NULL
  • ID (ID2) — VARCHAR — 외래 키 → 고객.ID — NOT NULL
  • Key (Vipid2) — VARCHAR — 외래 키 → 고객.Key — NOT NULL
  • Field (Vipid) — VARCHAR
  • Field (Addr) — VARCHAR
  • Field (AddrDetail) — VARCHAR
  • Field (AddrName) — VARCHAR
  • Field (Zipcode) — INTEGER
  • Field (Name) — VARCHAR
  • Field (TelNo) — VARCHAR

고객

  • ID — VARCHAR — 기본 키 — NOT NULL
  • Key (Vipid2) — VARCHAR — 외래 키 → Untitled.Key — NOT NULL
  • Field (Vipid) — VARCHAR
  • Field2 (NickName) — VARCHAR
  • Field (Name) — VARCHAR
  • Field (Age) — INTEGER
  • Field (Gender) — VARCHAR
  • Field (TelNo) — VARCHAR
  • Field (Addr) — VARCHAR
  • Field (AddrDetail) — VARCHAR
  • Field (ZipCode) — INTEGER