Invoice table (database design)

You will need to design tbl_invoice, tbl_order tables (database) and quick working demo of invoice functionality only. An invoice can be linked to one or more orders (In other word, an invoice contain multiple order_id).


**Database Design**

tbl_shop table

- shop_id

- company_name

tbl_order table

- order_id (PK)

- shop_id (FK)

- user_id (FK)

- total

- status

- order_date

- invoice_id (FK)

Order will be stored in the tbl_order. You need to create invoice table that are linked to the tbl_order. Invoice table should contain fields that if I have paid to shop or received commission from the shop and other useful fields. If I make any change in the invoice, it should be logged like a history.

**Working Demo**:

It should generate an invoices for every 2 weeks automatically. Create a working demo of invoice functionality in PHP. Whe updating [url removed, login to view] to 1 (completed). Then it should insert invoice date in the tbl_invoice table only if current month not exist. Example: The invoice should include all the orders (depending on Shop ID) between 01 to 15 and the next invoice 16 to end date of the month.

Note: Im not asking you to create shopping cart, adding product, adding order code. Just invoice functionality.

If there is other better solution to this then let me know please?

Let me know if you have any questions.

Skills: Engineering, MySQL, PHP, Project Management, Software Architecture, Software Testing, Web Hosting, Website Management, Website Testing

See more: database design invoices, product table design, product database design, php id shop, invoices design, design history, commission for product design, invoices/month, invoice, invoice example, design an invoice, database design, create invoice, invoice word, table month php, shopping invoice, database table design, product table, shop shop commission, php create invoice, database updating, database php history, shop database, table management php, can create invoice php

About the Employer:
( 45 reviews ) United Kingdom

Project ID: #3373484

5 freelancers are bidding on average $20 for this job


See private message.

$21.25 USD in 1 day
(72 Reviews)

See private message.

$25.5 USD in 1 day
(18 Reviews)

See private message.

$21.25 USD in 1 day
(16 Reviews)

See private message.

$17 USD in 1 day
(9 Reviews)

See private message.

$12.75 USD in 1 day
(2 Reviews)