0

Ninox data schema

How can I get a nice full data schema for my whole database, including tables, fields, relationships, scripts, related references. 

any ideas? 

something like this would be amazing 

https://dataedo.com/samples/html2/AdventureWorks/index.html#/doc/m8t135/adventureworks-database/tables/person-address

20 replies

null
    • Ninox developper
    • Jacques_TUR
    • 2 mths ago
    • Reported - view

    Hello everyone,

    I recently started developing a tool that I intended to integrate into Ninext. Unfortunately, due to a lack of time and financial resources, I can’t complete it at the moment.

    The goal of this tool is to create visual views that highlight the relationships between tables and the dependency links between fields and formulas.

    I would be happy to share more details with those who are interested or who wish to contribute to this project. Your ideas and feedback would also be welcome to improve and bring this initiative to fruition.
     

      • Sean
      • 2 mths ago
      • Reported - view

       

      I don't know how much time I can dedicate to this, but I'm interested.

      • Alan_Cooke
      • 2 mths ago
      • Reported - view

       Not sure how I could be of help but I am here if needed.

      • szormpas
      • 2 mths ago
      • Reported - view

        Hi, 

      Given that I'm not a programmer, I'm happy to help in any way.  How can we donate to the project?

      • Fred
      • 2 mths ago
      • Reported - view

       I’m willing to help.

    • Alan_Cooke
    • 2 mths ago
    • Reported - view

    This is what we need
     

    All drag and drop!  The layout can also be saved.

      • Ninox developper
      • Jacques_TUR
      • 1 mth ago
      • Reported - view

       I had started creating an interface that allows you to drop the tables you want and shows the links between tables in blue, as well as the dependency links of calculation formulas in green, yellow, and red. However, the representation is not yet clear enough. If you have any ideas, I’m open to suggestions.

      • Alan_Cooke
      • 1 mth ago
      • Reported - view

       In Access (Microsoft) they use the infinity symbol on the many side ♾️ and the number 1️⃣ on the one side.  I think that would help a great deal.  They also use straight lines which can be dragged to suit.  The lines do not curve.  To my mind that is also a lot clearer.

      That being said your example above is 200% better than the current data models :-)

      • szormpas
      • 1 mth ago
      • Reported - view

        Hi, I’m with you on that. The arrows are better for being more descriptive, with which table is the "one" and which is the "many" in each relationship.

      • Fred
      • 1 mth ago
      • Reported - view

      I love it!

      Just a couple of thoughts.

      1) with the little square dots in the upper right corner of each table, does that mean we can move the table around?

      2) I like the red lines that show fields being used in formulas. My only thought is that I have some fields that are used all over, over 50 times. I can't imagine what that would look like. Can we have a way to select what kind of links are displayed?

      • Ninox developper
      • Jacques_TUR
      • 1 mth ago
      • Reported - view

       Yes, it is possible to move tables around and display only the ones you want. It's the same for fields, just double-click on them to make them appear or disappear.
       

      For links, I agree that it should be possible to select the type of link you want to display. It would also be nice to be able to select a field and automatically display the entire upstream and/or downstream dependency chain.

      • Ninox developper
      • Jacques_TUR
      • 1 mth ago
      • Reported - view

       It is perfectly possible to do both: arrow AND signs:

       And for lines to be straight or rounded, it can also be a display parameter. (I personally prefer rounded lines 😁).

      • Alan_Cooke
      • 1 mth ago
      • Reported - view

       Rounded or not is a personal preference.  Either way I am easy on that one especially since dragging is an option and what to display in the way of relationship.  Will it be possible to save a layout for later reference.

      • Ppc
      • titanium_fish
      • 1 mth ago
      • Reported - view

       Where and when will i be able to find this ?

      • Ninox developper
      • Jacques_TUR
      • 1 mth ago
      • Reported - view

       You mean an overview system for links between tables for Ninox?

      • Ppc
      • titanium_fish
      • 1 mth ago
      • Reported - view

       Yes I am referring to the screenshots you posted. Is that something live ? 

      • Ninox developper
      • Jacques_TUR
      • 1 mth ago
      • Reported - view

       This is a prototype that is not yet functional. So I haven't shared it yet because it has a lot of bugs. I can't say when I'll be able to improve it and put it online. I still have several whole days of development to do.

      • Ppc
      • titanium_fish
      • 1 mth ago
      • Reported - view

       so all I can say for now it looks really great

    • Ppc
    • titanium_fish
    • 2 mths ago
    • Reported - view

    This would be amazing, I don’t have any clue on code but I would love to be of help, 

    basically it would take besides for the visual effects of it, the rest is very similar to what nintex has already.

    let us know what it takes to get to a level of having proper documentation of Ninox automatically generated!!

    • Alan_Cooke
    • 1 mth ago
    • Reported - view

    I have to say that this kind of tweak makes a HUGE difference to the ease of using Ninox.  Massive improvement and  you need to take a bow!!  Ninox owe you BIG time!

Content aside

  • 1 mth agoLast active
  • 20Replies
  • 208Views
  • 7 Following