how can i display the table filed description in the mysql data model doc?

Hi,

Let' say I reversed engineered from an existing DB which got data records. I want to add more columns to 1 table. I can only see create and drop script. If i do this, I will lose the data records. Any way I can retain them?

Regards,

Farouk Yew

I want to add sample data to the table I created to be able to simulate real table relationalship.

I did Data Modeling training from Mindmajix.

I am new to working with Data.

So I have a lot of data based on time.

Data row for every 15 mins. Should I compute the data and store data for every 1 hour, 1 day, 1 month on the database?

if I do would this schema be good.

{
   _id: "joe",
   name: "Joe Bookreader",
   time min: [
                {
                  time: "1",
                  steps: "10"
                },
                {
                  time: "2",
                  steps: "4"
                }
              ]
   time day: [
                {
                  time: "1",
                  steps: "30"
                },
                {
                  time: "2",
                  steps: "30"
                }
              ]

 }

If you have any advice on how I can improve my data modeling knowledge with noSQL, I would be really grateful.

When I test the client against my postgres database it connects but always times out trying the sql test. How can I troubleshoot this ?

When I add a reference it always adds a column like: TableName_pkColumnName. I like it better when the FK reference column has the same name as the parent PK column name, so just: pkColumnName. I added the column in the FK reference manually, and it still adds the other. Then I have to delete the extra column, delete the reference and add a new reference, which is kind of a lot of work for every reference.

Any way around this?

Hello , I am new here.

I had to delete my account and then put it for academic one. I am using for academic purposes. I would like to ask you for help. I downloaded my document. It is in .xml but I cannot upload it. Is there anyway?

Hi

I am trying to connect my postgres installed local on my Mac running OSX with the Vertabelo Client software. When I download the Vertabelo Client OSX see it as a text document, so I can not install it. The link to the manual is dead: https://my.vertabelo.com/db-connection#

Hope some one can help.

Thanks

I am looking at creating a group database of 150+ for real estate investments in Peru. I want to know the cost of doing this?

There was a possibility to copy by the shortcut "ctrl+c" but it's gone now. I have to use the context menu option.