Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

Mark indexed columns in command=graph

Forum
2014-03-11
2014-03-11
  • Markus Kreth
    Markus Kreth
    2014-03-11

    Hi,
    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?

    Best regards

     
  • Sualeh Fatehi
    Sualeh Fatehi
    2014-03-11

    Markus,

    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.

    Sualeh.

     
  • Markus Kreth
    Markus Kreth
    2014-03-11

    Maybe the mark must be numbered, as indexes can reference multiple columns

    thanks for the great work! Helps me much!