Menu
See the image below, but as part of the table editor, there's column flags such as PK (primary key), NN (not null) and so on. The last one is 'G'
741
Flags are the small icons displayed at the left side of issue rows to mark specific issue states. Structure displays the following flags: Resolved flag means that the issue is in a Done status category. Such issues are considered completed and filtered out by the Unresolved Quick Transformation.
Appendix B Keyboard Shortcuts Modifier in the tables stands for the platform-specific modifier key. This is Command on macOS, Control on other platforms. On macOS, the Alt key is Option.
UQ is for Unique. This can be used to enforce the column to insert only unique value for a specific column.
I have red diamonds as well which means the column is a Foreign Key.
Having looked through some of the Workbench code and the MySQL documentation, it looks like the G column is for Generated Columns.
In the source code, there's the following within the mysql_table_editor_column_page file (line 132 at the time of writing):
model->model().append_check_column(MySQLTableColumnsListBE::IsGenerated, "G", EDITABLE);
Other code in the same area gives the layout consistent with what you're seeing in the visual for PK, NN etc., which is viewable in the source.
112
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
