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)