Kobayashi, this is the data table I helped you with. I don't know if I can help you.

For general systems, especially sales systems, 18 to 20 Data Tables are required:

1. Item info table; y

2. Customer Information table; y

3. Inventory info table n

4. Administrator information table n

5. Procurement Information table y

6. warehouse receiving table n

7. warehouse receiving and checkout table n

8. warehouse receiving ticket number table n

9. warehouse receiving return table n

10. warehouse receiving return ticket number table n

11. warehouse receiving Return Statement n

12. Sales table y

13. Sales checkout table y

14. Sales Ticket No. Table y

15. Sales return table y

16. Sales return checkout table y

17. Sales return ticket No. Table y

18. supplier information table y

19. Customer Account table y

20. Customer shopping Details table y

Because your system is for sale, some tables here are not needed.

Let me briefly extract some of the necessary information.

1. Customer Information table (ID, customer full name, abbreviation, address, zip code, phone number, contact name, email address)

2. Product Information table (ID, product name, abbreviation, origin, unit, specification, packaging, batch number, approval number, supplier, remarks)

3. purchase information table (Purchase ticket number, product name, manufacturer, specification, packaging, unit, unit price, quantity, amount, purchase date, remarks)

4. Sales table (sales ticket No., product no., product name, abbreviation, origin, specification, packaging, unit, unit price, quantity, amount, customer, sales date, operator, operator, settlement method)

5. Sales checkout form (settlement ticket number, sales ticket number, customer, current settlement, balance, settlement date, operator, handled)

6. Sales Ticket No. Table (sales ticket No., quantity, receivables, real-time receipts, unreceived, customer, sales date, operator, operator, settlement method, whether to settle)

7. Sales return table (return ticket No., product no., product name, abbreviation, origin, specification, packaging, unit, unit price, quantity, amount, customer, return date, operator, handled, settlement method)

8. Sales Return Statement (settlement ticket number, return ticket number, customer, current settlement, balance, settlement date, operator, handled)

9. Sales return ticket No. Table (refund Ticket No., quantity, payable, pay-as-you-go, unpaid, customer, return date, operator, operator, settlement method, whether to settle)

10. supplier information table (supplier ID, full name of supplier, abbreviation, address, zip code, phone number, contact person, bank account, and email address)

11. Customer Account table (customer ID, account opening bank, account balance, customer grade)

12. Customer shopping Details table (customer ID, sales ticket number, product number, product name, abbreviation, origin, specification, packaging, unit, unit price, quantity, amount, customer, sales date)