I have a simple model designed and exported it and set up a database from that.

Now I want to update my model with new tables and references and export this as well and then update my database.

I tried to do that, but when I imported it to my existing schema, it didn't have all columns and references only some of them.

I use MySQL workbench to manage my MySQL database.

Would I need to make a need schema with the new exported model and then migrate the new one to the old one using something like Flyway? Or how would one do this? 

Sorry if this is a very basic question or it is unclear what i am asking. I am rather new to SQL databases. 

It would be nice to be able to show the fields that have indexes and check constraints in the diagram and the exported table, for better overview.

It is possible support computed columns for the next version.

I am unable to generate specific sections of SAML assertions in IBM DataPower while trying to digitally sign a request (Product details: Build: 277257, Firmware: IDG.7.5.1.0). I have the uploaded the public crypto certificate on DataPower but I am unable to configure DataPower to generate the following two sections (The below is the format in which the backend expects the DataPower output):

1.

<ds:KeyInfo>
  <ds:KeyValue>
    <ds:RSAKeyValue>
      <ds:Modulus>xxx</ds:Modulus>
      <ds:Exponent>xxx</ds:Exponent>
    </ds:RSAKeyValue>
  </ds:KeyValue>
</ds:KeyInfo>

2.

<ds:KeyInfo Id="KeyId-xxx">
  <wsse:SecurityTokenReference wsse11:TokenType="http://docs.oasis-open.org/wss/oasis-wss-saml-token-profile-1.1#SAMLV2.0" wsu:Id="xxx" xmlns:wsse11="http://docs.oasis-open.org/wss/oasis-wss-wssecurity-secext-1.1.xsd">
    <wsse:KeyIdentifier ValueType="http://docs.oasis-open.org/wss/oasis-wss-saml-token-profile-1.1#SAMLID">xxx</wsse:KeyIdentifier>
  </wsse:SecurityTokenReference>
</ds:KeyInfo>

Are there any settings on DataPower to generate these header? Or we need to place a custom XSL transform to generate these headers?

is there a way to import a table definition from excel? i.e. i have my columns and data types in an excel spreadsheet already and i want to import them in rather than have to key them all?

When I print my diagram as a PDF, the text in a note:

"SUMMARY: The core of this metadata model includes "data_set"s, different "data_table"s of that data set, and then for each table, the set of "variable"s it contains.  Variables exist independent of data tables, so the same variable definition can apply to multiple tables (over years where a survey remained the same, or across surveys with different names).  For each variable, you can specify a set of valid values.  You can also specify when two variables are related and basic information on how to translate between the two.  In addition, there is space to group data set collections (one of these groupings could be the set of tables included in a production process, for example) and variables independent of ("variable_group") or within ("table_variable_group") a table."

consistently turns into:

SUMMARY: The core of this metadata model includes "data_set"s, different
"data_table"s of that data set, and then for each table, the set of "variable"s it
contains. Variables exist independent tables, so same variable definition can apply
to multiple tables (over years where a survey remained same, or across surveys
with different names). For variable, you specify valid values. You also specify when
two variables are related basic information on how translate between two. In
addition, there is space group collections (one these groupings could be included in
production process, example) ("variable_group") within ("table_variable_group")
table.

Words from the original text are seemingly randomly missing, causing the text to turn into something that sounds like a garbled mess.  Any idea why this would be happening?  Is it something in my text that I might be able to alter to fix?

Thanks,

Jonathan Morgan

Please add support for unsigned and zerofill for the decimal data type.

Thanks

I was invited to a team but i cant join because i get this message, "You cannot join this account because you are a member of another team account." Please help

Nullable foreign key is definitely valid in PostgresSql however, Vertabelo throws a problem in the UI when you make it nullable.