I need a small database (2 tables) for have an overview
over documents like invoices, quotations and so on.
The logged in web user can see a table with his documents
and - if the document is not a word, pdf and so on - he can
get details: the postions of the document (invoice or quotation ...).
If it is an PDF, word ... he just gets a link to the document folder.
For handling this we need two tables:
document_type (invoice, offer, delivery note, other document,...)
document_file_type (PDF, Word, invoice (db table), offer(db table),...)
document_link (Only for PDF, Word,... -> link to folder)
delivery_date (Only it is an invoice, delivery note ...)
document_printed_name (can be different from the web user)
How it should look like?
-> see the 2 pictures.
What is also importent for me:
The user should be able to search for Name, Date, User, also in combination,
over all columns and 1 specials thing:
If the users searches for a name form the documents overview/table site there should
also appeare the documents as results, where the user is in an documents postition.
So searching for "Robin Meyer" in documents overview as result has to be
"invoice for computer", because position no 3 (see document positions) is combined
to "Robin Meyer".
The database tables are filled from "outside". We do not need an administration