Java Open source Fresh e-commerce platform-user table design (source code can be downloaded)

Java Open source Fresh e-commerce platform-user table design (source code can be downloaded)

Note: Since this system belongs to the business-to-business platform, does not design to business-to-consumer architecture.

Role analysis: Buyers and sellers.

Because the buyer and the seller fill in the information is different, need to establish a two-stop table for maintenance, such as: Buyer,seller.

This makes the database decoupled, and neither side changes, but I want to centralize management and some business personalization requirements, and I've added a users table. The table structure is as follows:

Account Unique key, so do a unique key index,

The accuracy of the account is verified by SMS.

According to the type of buyers and sellers, when landing, the use of the users of this table for maintenance

The following stickers: Buyers, Sellers table (this according to their own business can be cut, at least we run on the line is to use this requirement, with the industry and business)

This example briefly explains the design of the table related, this relatively simple, specific some core business, I will explain, in addition to the source can be downloaded in my github.

Learn from each other, make progress together, and do a good job of fresh electricity business.

Java Open source Fresh e-commerce platform-user table design (source code can be downloaded)