Hi, using DBDesigner4 (http://www.fabforce.net/dbdesigner4/) you can connect to the mysql database and create a ER diagram.
Saludos -- Yery On Tuesday 13 April 2004 10:49, Javier Szyszlican wrote: > Hi Andrew, > > Currently there's no documentation on how the tables interact. > > But for your specific case is this: > > SELECT f.description, f.name, f.default_value, v.value, i.id > FROM interface_types_field_types as ft > INNER JOIN interface_types as it on (ft.id > 1 and ft.id != 20) > INNER JOIN interface_types_fields as f on (f.itype = it.id and f.ftype = > ft.id) > INNER JOIN > interfaces as i on (it.id = i.type) > LEFT OUTER JOIN > interfaces_values as v on (v.interface = i.id and v.field = f.id) > WHERE (i.id = 2096) > ORDER BY f.pos; > > With this example, you will see all the assigned parameters for the > Interface ID 2096. > > This was based on the code included in the interface_values function in > lib/api.interfaces.inc.php (close to the bottom). > > Hope that helps. > > Javier > > On Monday 12 April 2004 22:01, Baker, Andrew (AU) wrote: > > Hello > > > > Is there such thing as a data model for the JFFNMS database as I am > > attempting to link tables via an sql query in order to output the SLA > > data for a given month giving the description of a physical interface > > rather than the physical name (ie serial1 reads "serial link to > > destination name". I have located the description in the table "interface > > values" and the physical interface within the event but am having trouble > > linking them > > > > Help most appreciated > > > > _______________________________________________________________________ > > > > > Andrew Baker Tel: (03) 62101320 > > > Technical Consultant Fax: (03) 62101313 > > > LogicaCMG Mobile: 0401 715 479 > > > Mailto:[EMAIL PROTECTED] > > >http://www.logicacmg.com > > > > This e-mail and any attachment is for authorised use by the intended > > recipient(s) only. It may contain proprietary material, confidential > > information and/or be subject to legal privilege. It should not be > > copied, disclosed to, retained or used by, any other party. If you are > > not an intended recipient then please promptly delete this e-mail and any > > attachment and all copies and inform the sender. Thank you. > > > > > > ------------------------------------------------------- > > This SF.Net email is sponsored by: IBM Linux Tutorials > > Free Linux tutorial presented by Daniel Robbins, President and CEO of > > GenToo technologies. Learn everything from fundamentals to system > > administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click > > _______________________________________________ > > jffnms-users mailing list > > [EMAIL PROTECTED] > > https://lists.sourceforge.net/lists/listinfo/jffnms-users > > ------------------------------------------------------- > This SF.Net email is sponsored by: IBM Linux Tutorials > Free Linux tutorial presented by Daniel Robbins, President and CEO of > GenToo technologies. Learn everything from fundamentals to system > administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click > _______________________________________________ > jffnms-users mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jffnms-users ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ jffnms-users mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jffnms-users
