shoppingmall

Tables (3)

Grade (grade)

  • VipID (vip_id) — VARCHAR(20) — Primary key — NOT NULL
  • VipName (vip_name) — VARCHAR(20)
  • Rate (vip_rate) — INTEGER(3)

User (user)

  • ID (id) — VARCHAR(15) — Primary key — NOT NULL
  • VipID (vip_id) — VARCHAR(20) — Foreign key → Grade.VipID — NOT NULL
  • Name (name) — VARCHAR(15)
  • PW (pw) — VARCJAR(30)
  • Age (age) — INTEGER(3)
  • NickName (nickname) — VARCHAR(15)
  • Gender (gender) — VARCHAR(1)
  • Phone1 (phone_first) — VARCHAR(4)
  • Phone2 (phone_second) — VARCHAR(4)
  • Phone3 (phone_thrid) — VARCHAR(4)
  • Address (address) — VARCHAR(200)
  • AddressDetail (address_detail) — VARCHAR(200)
  • AddressNum (address_num) — INTEGER(5)

UserAddr (useraddr)

  • AddrID (addr_id) — INTEGER(30) — Primary key — NOT NULL
  • ID (id2) — VARCHAR(15) — Foreign key → User.ID — NOT NULL
  • VipID (vip_id) — VARCHAR(20) — Foreign key → User.VipID — NOT NULL
  • Address (address) — VARCHAR(200)
  • AddressDetail (address_detail) — VARCHAR(200)
  • AddressNum (address_num) — INTEGER(5)
  • Name (수령인) — VARCHAR(20)
  • Phone1 (수령인 전화번호_first) — VARCHAR(4)
  • Phone2 (수령인 전화번호_second) — VARCHAR(4)
  • Phone3 (수령인 전화번호_thrid) — VARCHAR(4)