is it possible in an output graphic to mark indexed column names?
This is concerned to a sqlite db.
This is my command line: .\sc.cmd -database $path -infolevel=maximum -portablenames -Gdpi=300 -c=graph -outputfile $outfile
Some Foreign keys in our db are just indexed as there are values possible that don't reference an other table row (such as -1 or 0).
I need these indexed columns maked somehow - mayby with an (i) or just *
Is this possible?
Yes, I could do this, but I will probably add another section to the table diagram. This is because the order of columns in indexes is significant, and a column may be in more than one index. I will find a way to show this on the graph.
Maybe the mark must be numbered, as indexes can reference multiple columns
thanks for the great work! Helps me much!