Drag-n-drop operations for MySQL Repositories

#	Drag This	To This	With This Connection Type	And This Will Happen

#	Drag This	To This	With This Connection Type	And This Will Happen
M1	Anything from the System Model Panel (or Repository Panel)	Anything in the Repository Panel (or System Model Panel)	Reference	Reference Connection will be created but nothing will be generated
M2	SysML Block	MySQL Database	Model Transform	A new table will be generated in the database with columns corresponding to value properties of the SysML block. A model transform connection will be created between the SysML block and the MySQL table.
M3	MySQL Table	SysML Package	Model Transform	A new SysML block will be generated with value properties corresponding to columns of the MySQL table. A model transform connection will be created between the SysML block and the MySQL table.
M4	SysML Block	MySQL Table	Data Map	A new row will be generated in the table with column values corresponding to the default values of the value properties of the SysML block ONLY IF a model transform connection exists between a parent block (supertype) of the given block and the MySQL table (such as by operations M2 - M3). A data map connection will be created between the SysML block and the MySQL table row.
M5	SysML Block Instance	MySQL Table	Data Map	A new row will be generated in the table with column values corresponding to the slot values of the SysML block instance ONLY IF a model transform connection exists between the classifying block of the instance and the MySQL table (such as by operations M2 – M3). A data map connection will be created between the SysML block instance and the MySQL table row.
M6	MySQL Table Row	SysML package	Data Map	User will be asked to select one of the two options: (1) generate a block instance (default option), or (2) generate a specialized (subtype) block. If the first option is selected, a SysML block instance will be generated with slot values corresponding to the columns values of the given row. This block instance will be an instance of the block that has a model transform connection to the table. If such a block does not exist, then a new block will also be generated with a model transform connection to the MySQL table (same as operation M3). If the second option is selected, a SysML block will be generated with value properties (and default values) corresponding to the columns values of the given row. This block will be a child (subtype) of the block that has a model transform connection to the table. If such a block does not exist, then a new block will also be generated with a model transform connection to the MySQL table (same as operation M3). A data map connection will be created between the SysML block instance (or specialized block) and the MySQL table row.

Creating connections between existing model elements

The drag-n-drop operations listed in the table above generate models. Starting with this release, Syndeia can also create model transform connections between existing model elements without generation. You can then perform a compare and sync operation on these connections to sync the models. The following drag-n-drop operations are available between existing model elements:

SysML Block < -- > MySQL Table (Model Transform)
SysML Block < -- > MySQL Table Row (Data Map)
SysML Block Instance < -- > MySQL Table Row (Data Map)

Additional Notes on SysML and MySQL drag-n-drop operations

Column names in the MySQL table must be alpha numeric (white spaces and underscores are allowed) so that they can be used to generate block value properties.
When generating SysML block / instances from MySQL data, or when synchronizing MySQL > SysML, the following data mapping rules are followed.
When generating MySQL tables and rows from SysML elements, or when synchronizing SysML > MySQL, the following data mapping rules are followed.