mysql - 像淘宝那样的收货地址怎么存入数据库

Question

像淘宝那样选择省市区和详细收货地址后将这些存入数据库，应该如何设计数据表？

Answer 1

Province, city and district correspond to dictionary table
Dictionary type table
id type code name (value is province, city, district, etc.)
Dictionary table
id name dictionary type ID

Address table
id, userID, whether it is the default address, province ID, city ID, district ID, detailed address (may be placed in a large field table)