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)