One POS software for many customers, design database

[nitiphone2021]

Dear friends.

As I would like to create a software like POS on web application.

my question is:

1. Should I create only one Database for all customers?

2. in case I have only one Database, How can I saperate the customer information? by field or table name?

3. if I have new customer. I need to create new table or information for them?

[Barand]

1. Yes
2. Unique customer id identifies the customer in the data
3. Add new record to customer table

Example

+---------------+
| customer      |
+---------------+
| customer_id   |-------+       +-----------------+                                                +----------------+
| customer_name |       |       |  basket         |                                                |  product       |
| email         |       |       +-----------------+                                                +----------------+
| mobile        |       |       | basket_id       |-------+       +-----------------+      +-------| product_id     |
| etc           |       |       | basket_date     |       |       |  basket_item    |      |       | description    |
+---------------+       +------<| customer_id     |       |       +-----------------+      |       | price          |
                                +-----------------+       |       | item_id         |      |       +----------------+
                                                          +------<| basket_id       |      |
                                                                  | product_id      |>-----+
                                                                  | quantity        |
                                                                  +-----------------+

 

Edited August 11, 2021 by Barand

[nitiphone2021]

Oh, Seem my question is not clear,

I mean I make a POS online software and sell it to many shop, so how can I saperate shop information, shop name, stock, login info....