nmg icon indicating copy to clipboard operation
nmg copied to clipboard

MySql Foreign Key Mapping

Open veniamin-r opened this issue 3 years ago • 0 comments

Foreign Key in MySql DB is determined incorrectly. Using a MUL column from the "describe

" query cannot uniquely identify a column as a foreign key because MUL there means "other than primary single or unique single key". So the generator fails, for example, on any unique multiple indices... I modified the code a bit for my own purposes (see Attachment). I don't know how correct it is. In MysqlMetadataReader.cs GetTableDetails function was modified. Reader.zip

veniamin-r avatar Mar 22 '21 01:03 veniamin-r