Doesn't anybody know or have the data dictionary for K1 Database?

I need to find all the PK's and FK's to build better SQL to find all the relationships for the tables.


0 Comments   [ + ] Show Comments


Please log in to comment

Community Chosen Answer


This might help... It's not exactly what you're looking for and from the looks of it from an older version but it helped me out when trying to create all my ticket rules.

Answered 12/09/2014 by: h2opolo25
Red Belt

  • Thats great but its missing the asset tables.
  • Its also missing the PK and FK relationships which is needed to understand tables.
Please log in to comment
you can download Toad for mysql and hook that into your kbox and that will let you explore all the tables in it.

and search google to find many good articles on connecting to the kbox

Answered 12/09/2014 by: SMal.tmcc
Red Belt

  • already connected need the PK and FK relationships
Please log in to comment
Answer this question or Comment on this question for clarity
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja