Add a new empty table
Only administrators and super-administrators can add a new table to a database.
-
Click on File to go to the backstage section, select Database and click Edit tables of the current database.
-
Click Add to add a new table to the current database. A 3 steps wizard will be opened.
-
Enter the table settings.
-
Connection Connection to the database. Automatically filled.
-
User name Name (for the new table) that will be visible for the end users.
-
Name in database Name (for the new table) that will be used in the MySQL database. This name is predefined and cannot be changed.
-
Record caption The default value is Name but it can be changed to adapt to the content of the table. This record caption field is a field that is present in any table and provides a unique identifier for the user (in contrast with the ID field that is used by the software to uniquely identify any given record). For example, one could use Strains name for a table containing strains or Species name for a table containing species descriptions, etc.
Click Next to go to the next step. -
Provide group's access rights.
Click Check all to provide rights to all groups.Click Next to go to the next step and to complete the wizard.