Hello Andy,
Thank for the tip. I have already been to the Association Diagram before posting the discussion. More or less undersand the associations. I also studied the database schema. But still have not idea how the SQL tables are associated with each other.
Basically what I am looking for is the name of the SQL table for command lines, and software resource. I no longer care if the sortware resource contains a package, but it must a sofware release and deliverable.
I found the vsoftwarerelease and vsoftwarecommandline views. What I cannot figure out yet what is the direct or indirect connections between them ?
For SWDPackage and SWDProgram the foreign key is pretty obvious. In 7.1 not that really :)
Thank you.
Tomasz