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
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
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.
ASKER
thanx
Perhaps you could use a real data model.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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/
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/
ASKER
ok thanx
i already created the other 2 details tables
i already created the other 2 details tables