Gordon, The full mapping of all the metadata tables and their interrelationships and how all data tables were created and named and all the syntax around these used to be contained in the Database Reference manual.
I did a quick look at the on-line documentation and it does not seem to have been moved to the on-line documentation. But, Danny is right, there are .sql files for each DB that are put on the system (and left there) after install. They contain the exact SQL that is run for your installation (because that is the file we run the commands from during installation). This is the raw SQL. You have to see what all tables are there and follow the keys to related tables. Or, you could get a Database Reference manual from an older version and get the model and then use the .sql file to see if any details have changed. The overall metadata model has not changed and any update to it is additive so a picture from an older version is still accurate for the main forms and fields and interaction -- only new attributes or new constructs are missing. Doug -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Danny Kellett Sent: Thursday, March 19, 2015 1:08 AM To: arslist@ARSLIST.ORG Subject: Re: Looking for a document Gordon I think there is a .sql file in the bin dir of a Linux install that has the sql. Regards Danny > On 18 Mar 2015, at 23:52, Gordon Frank <gjj...@gmail.com> wrote: > > ** > I know there is a document which has all of the SQL code which is used when > ARSYSTEM is built. > > Does anyone know the document which has this? I can't remember which one it > is. > > Thanks > Gordon Frank > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
