shopping mall

Tables (3)

ADDRESS (Untitled3)

  • customer_id (고객번호) — VARCHAR(225) — Foreign key → customer.customer_id — NOT NULL
  • addr_name (배송지명) — VARCHAR(10)
  • addr (주소) — VARCHAR(225)
  • addr_detail (상세주소) — VARCHAR(225)
  • zipcode (우편번호) — BIGINT(11)
  • recipient_phone (수령인번호) — BIGINT(11)
  • recipient_name (수령인이름) — VARCHAR(10)

VIP (Untitled2)

  • vip_id (등급번호) — BIGINT(11) — Primary key — NOT NULL
  • vipname (등급이름) — VARCHAR(10)
  • rate (할인율) — BIGINT(3)
  • customer_id (고객번호) — VARCHAR(225) — Foreign key → customer.customer_id — NOT NULL

customer (Untitled)

  • customer_id (고객번호) — VARCHAR(225) — Primary key — NOT NULL
  • name (고객이름) — VARCHAR(225)
  • age (고객나이) — BIGINT(11)
  • sex (고객성별) — BOOLEAN
  • vip_id (등급) — BIGINT(11)
  • phone (연락처) — VARCHAR(11)
  • addr (주소) — VARCHAR(225)
  • addr_detail (상세주소) — VARCHAR(225)
  • zipcode (우편번호) — BIGINT(11)