Thanks, I've downloaded it... and I'll try to make a Data Model for the JFFNMS tables.
Javier --- Yery Tannus <[EMAIL PROTECTED]> wrote: > 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 __________________________________ Do you Yahoo!? Yahoo! Tax Center - File online by April 15th http://taxes.yahoo.com/filing.html ------------------------------------------------------- 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
