User-related
Malling_user: Front-end Mall system user, user name, password, etc.
malling_user_delivery_address, the user's harvest address, a user can have multiple harvest addresses
malling_admin_user: User of backend system, no relationship with front end system
malling_admin_role: Role of backend system user, Super Administrator, Administrator, etc.
Malling_admin_user_role: Association of Back-end system users and Roles
Accounting related
malling_account: User's funds account, account number, available Balance, frozen balance, etc.
Malling_account_internal: Internal dedicated account
malling_account_log: Money Change journal, one transaction, two capital changes (the train of thought is still a bit confusing .))
Malling_account_freeze_log: Freezing logs resulting from withdrawals
malling_accoount_trans_log: Transaction log
Malling_recharge: User's recharge record
malling_receive_payment: After the deposit, the bank or the third party pays the return information
Malling_withdraw: User's withdrawal record
Shopping related
malling_goods: Commodity, product number, name, title, price, etc.
malling_goods_category: Classification, classification number, name, higher class number, etc.
Malling_goods_comment: A review of a product, a user who has purchased a productbefore you can comment on this product .
malling_orders: Order, order number, owner, Total Price, payment method, etc.
Malling_orders_item: Order item, an order can have more than one order item, order number, owner, product ID, item quantity, total price, commodity Price
Log Related
Malling_op_log: Operations logs, such as auditing orders
Malling_search_log: Front-end user search for product generation
malling_login_log: User logon log, including front-end and back-end
Other
Malling_sequence: Serial number, used to manually generate account number, order number, etc. have business meaning ID
CSDN2014 Blog Star selection, help Ray vote for it
Http://vote.blog.csdn.net/blogstar2014/details?username=fansunion
Design and implementation of e-commerce system (11): Database design
