as per the prior advise of our moderators , please look at the attached file for the description of the project , containing tables definitions
don't worry about the long description ,
the question here is concern only for the table structures ,
is it ok ? , or do you have another suggestions ?
then , if i need any help for functions or the forms , i will open new topic for each