-
I don't think it'd be able to determine an implied relationship for your example. How would it know which was the implied foreign key?
John.
2009-11-30 19:54:47 UTC by johncurrier
-
John,
Use case is ...
- Table1.Staff_Code (nvarchar; PK for Table1)
- Table2.Staff_Code (nvarchar; PK for Table2)
.
Assuming I've not done something incorrectly, I expected SchemaSpy to show a relationship between Table1 and Table2, given Staff_Code was spelled the same in both tables and was the same data type.
Does SchemaSpy pass over this case because they are both PKs?.
2009-11-30 15:30:54 UTC by tdavis2
-
SchemaSpy can determine implied relationships if the column name and type match the column name and type of another table's primary key. The beta also supports Ruby on Rails naming conventions for determining implied relationships.
An alternative approach would be to use the -meta option to explicitly specify table relationships.
John.
2009-11-30 02:28:54 UTC by johncurrier
-
Ah. And I have used SS 4.1.1 as well as the "beta" listed in Post #6.
2009-11-25 20:31:52 UTC by tdavis2
-
Having read the documentation at schemaspy.sourceforge.net, I pose the following stupid question: "Will SchemaSpy deduce the relationships between tables in the absence of primary and foreign keys?" My impression is that it can do so from the metadata.
So far, the Relationships show up only when I run SS against a database with the PK/FK relationships already defined.
I've tried the...
2009-11-25 20:30:27 UTC by tdavis2
-
If you have two tables with the same name that only differ in their case then there's not a lot I can do to help. It would require a significant amount of work to modify the code's behavior based on whether the database preserves and honors case sensitivity. Those implications permeate down through the various file systems as well as into Graphviz.
2009-11-16 17:21:25 UTC by johncurrier
-
I will test your new file asap. It might take some time though, we don't have a zOS based System at hand ourselves, so we have to wait, till a customer can proove its working.
Regards
Christian.
2009-11-13 05:43:21 UTC by criedel
-
Try this google query:
http://www.google.com/search?source=ig&hl=en&rlz=&=&q=%22libocijdbc10.jnilib%3A+no+suitable+image+found%22&aq=f&oq=&aqi=
It points to a Chinese page whose translation implies that you're using a 32bit client with a 64bit server. Could that be the case?
John.
2009-11-13 00:14:13 UTC by johncurrier
-
yes, you discussing this would be most helpful. I have a sneaky suspicion this was caused by some mac os/x update but I've no idea where to look.
thx.
2009-11-12 18:22:56 UTC by jdanilson
-
johncurrier committed revision 558 to the SchemaSpy SVN repository, changing 2 files.
2009-11-12 17:49:02 UTC by johncurrier
