DB schema redesign

[feiyanzhandui]

Split order info and order status:

Order info and status:

• Order ID(It should be generated automatically by the system)
• Sender name
• Sender phone number
• Address:
  • country
  • city
  • district
  • building/number
  • postcode
• Receiver name
• Receiver phone number
• Address:
  • country
  • city
  • district
  • building/number
  • postcode

DB:
Table1: EndUser
Columns: user_id, name, phone_num, company_name, country, city, district,street, street_number, unit, postcode
Table2: ShippingUser
Columns: user_id, name, phone_num, company_name, country, city, district, street, street_number, unit, postcode
Table3: OrderInfo
columns: order_id, shipping_user_id, sender_id, receiver_id
Table4: OrderStatus
columns: order_id, date, status, location

[feiyanzhandui]

combine all address info to an address