Link to home
Start Free TrialLog in
Avatar of NiceMan331
NiceMan331

asked on

tables for warehouse management project

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
thanx
whs-management.docx
Avatar of David VanZandt
David VanZandt
Flag of United States of America image

Nothing that my eyes caught, but including an entity relationship diagram would greatly help (next time).  I observe you are not showing any partition usage.
Avatar of NiceMan331
NiceMan331

ASKER

thanx
Perhaps you could use a real data model.
ASKER CERTIFIED SOLUTION
Avatar of Mark Geerlings
Mark Geerlings
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
markgeer
thanx for your advice
1- regarding single details for 3 msters ,
actually when posting PR , user will fill PR_ID In detail table
when poting p data , user must post all , PR_ID & PO_ID in detail table
lastly when posting delviery , user must post all PR_ID,PO_ID,RCV_ID , to link each other
but i have no problem , i will let them 3 details , one detail for each master , same result , but just i want to save creating tables

2-regarding L posting_date & posted_by , those fields will not be null , they should be filled automatically once posting any record , postinf_date will be sysdate by default
and posted_by the user_name
"but just i want to save creating tables" ?  That may turn out to be a very expensive decision!  Deciding how many tables to use should be based on long-term data usage and access.  How much (one-time) set up effort is required by you should not be much of a factor here.

So the posting_date and posted_by fields will be filled in when the records are created?  If that is true, then I see no problems with those fields/
ok thanx
i already created the other 2 details tables